[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