Help for SQL query

info at vallemediatime.com info at vallemediatime.com
Wed Jun 15 08:46:24 CDT 2005


Hi list,
I need to optimize this query...

on searchStringBySQL
searchString = member("searchString").text
gCursor = 0
query = "SELECT RecID, * from STUDENTI\
WHERE sF1 = '" & searchString & "'\
OR sF2 = '" & searchString & "'\
OR sF3 = '" & searchString & "'\
-- and so on...
OR sF30 = '" & searchString & "'"

gCursor = gDb.sqlSelect(query, #kServer, #kReadWrite, #kRandom)
if CheckValError() then exit
updateResultGrid()
end

... but I don't know if is possible to insert a repeat loop into query, or
to use some other solution
somebody have a suggestion?
Thanks
Paolo
V4MD 2.0.2 WIN XP-PRO



More information about the Valentina mailing list