[V4RB] - 2nd vCursor on DB is always Nil

[Ruslan Zasukhin]

On 10/6/05 10:47 PM, "RB User" <fitzbew at nc.rr.com> wrote:

>> Hello RB,
>> 
>> Thursday, October 6, 2005, 1:13:01 AM, you wrote:
>> 
>> RU> Attached is RB2005r3 project using V4RB 2.0.5.
>> 
>> RU> Just click button and step through debugger.  For some reason, 2nd cursor
>> RU> always comes back Nil to me.
>> 
>> Actually  this is a parser bug. I have reported about it to the Mantis
>> self.
>> 
> 
> Yes, I see Mantis ID 0001086.  Thank you, Ivan!
> 
>> So, you are wrong with the first query:
>> strQuery   =   "select   distinct   wxObsDate  from  wxDevData  where
>> location_key = '" + strLocKeyForFile + "' '" _...
>> 
>> 
>> Take a look on this place: "' '". It would be odd quotation here.
>> select distinct wxObsDate from wxDevData where location_key = '000400' 'order
>> by wxObsDat
>> instead of:
>> select distinct wxObsDate from wxDevData where location_key = '000400'
>> order by wxObsDat
>> 
> 
> Yes!  When I remove the extra apostrophe from the FIRST sqlselect, it makes
> the second vCursor run successfully!
> 
> What is weird is, the first query appears to run ok, despite syntax error.
> But you noted that fact in Mantis.
>  
>> BTW you can see the parser results in the FBL_TreeParser.txt log.
> 
> That's not available to me is it?

Not available. This happens only when engine in debug mode.

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