FIXED: [V4MD] Null value from SQL query

[Ruslan Zasukhin]

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

> Ok, I've send now a your modify Dir example to Igor,
> but I will remember you that this it's the third time that I get this type
> of error (if not my mistake), in Valentina 1 this it was not never happened.
> Paolo
> 
> 
> ----- Original Message -----
> From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
> To: <valentina at lists.macserve.net>
> Sent: Wednesday, August 31, 2005 8:21 AM
> Subject: Re: [V4MD] Null value from SQL query
> 
> 
>> 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

FIXED

-- 
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]