SQL request in vCursor : "or"

[Olivier]

Le 6 janv. 05, à 11:14, Ruslan Zasukhin a écrit :

> On 1/6/05 12:06 PM, "Olivier" <vidal_olivier at yahoo.fr> wrote:
>
>>> It will be more useful to see the SQL String which you get
>>>     BTW, you can EASY see SQL string you build in the V4RB_Log file.
>>>
>> LOG :
>>
>> Cursor_Ctor...
>> PARAM: instance = 27059408
>> PARAM: inDB = 26180540
>> PARAM: inSQLstr = "SELECT nom FROM personne WHERE corbeille=false and
>> (rep1=1 or rep2=1 or rep3=1 or rep4=1)"
>> PARAM: inCursorLocation = 2
>> PARAM: inCursorType = 2
>> PARAM: inDirection = 2
>>
>> Rep1, Rep2, Rep3, Rep4 are VBYTE.
>
> Aha.
>
> So what happens? Crash ?
yes
> How it notworks?
>
> Does log show any error info ?
no
also the exception not caught.

> What viSQL show if do this query again this db ?
> If viSQL also show problem send me db and we test here

Impossible to open the DB in ViSQL or VStudio.
There is a crash from the opening of the DB.

the DB is empty.

I send you log and DB.

Olivier



>
>