[V4MD] Null value from SQL query

[Ruslan Zasukhin]

On 8/31/05 7:03 AM, "info at vallemediatime.com" <info at vallemediatime.com>
wrote:

> 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

Igor, please check this ASAP.

Paolo, if you can send something to Igor to reproduce


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]