[V4MD] Null value from SQL query

info at vallemediatime.com info at vallemediatime.com
Wed Aug 31 06:03:34 CDT 2005


Hi Ruslan.
I get <Null> value from this query, (the recCount is correctly)

on scadenzaSoggiorno
gCursor = 0
searchString = value(member("searchString").text)
query = "SELECT * from" && gTableName && "WHERE \
(sF27 > 0) AND (sF27 <= '" & searchString & "') " 

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

recCount = gCursor.recordCount
repeat with i = 1 to RecCount
fields = gCursor.getRecord(i)
put fields
--[ <Null>,  <Null> .... ]
end repeat
end

Paolo, on XP V4MD v2.0.5fc15 


More information about the Valentina mailing list