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