Mystery Crash II

[Ruslan Zasukhin]

On 6/30/05 7:25 PM, "John W. Miescher" <miescher at bizdata.com> wrote:

Hi John,

>    Dear Ruslan,
> have downloaded fc12 for RB-WIN which seems to work fine for the most part,
> but I still dont understand why
>  
> A="select *,RecID from hist where (hist.mDate >= '"+inDate+"') and (hist.mDate
> <= '"+outDate+"') order by hist.mDate"
> nCursor = mDataBase.SQLselect(A)
>  
> cashes the program without warning, but

What query this produce finally ?

You can see it in V4RB_Log file, or in debugger
   
May be send us small db and this query
 
> A="select * from hist where (mdate >= '"+inDate+"') and (mdate <=
> '"+outDate+"')"
> nCursor = mDataBase.SQLselect(A)
>  
> apparently works.
>  
> mDate is a string field and inDate, outDate are strings of the type
> "2005-06-30"

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