>Does Foxpro has sql query editor, like sql query analyzer in sql server.
>
>Please i have some difficulty, i am working on VB with foxpro database.
>
>I have a simple query:
>Insert into ocrdata(id,tiffile,ocdata,created_dt) Values(4322,'demdemorecv10','
>SIEMENS - Imnsit Team rueno nico',{9/7/2004})
>
>On the visual basic side it is not giving no errors at all but when i open the table it is not inserting the record to table.
>
>I just want to fire the same query on the visual foxpro directly to see if i get any error, But i don't know how i can open the sql query editor in foxpro.
>
>Thank you very much.
Type directly in command window and press [enter].
Your problem might be simply you're sending nulls from VB and there are fields that do not accept null values. You might miss that running from a VFP environment. "Set null off" first in VB.
PS: Also do not pass ambigious date - use {^YYYY/MM/DD} format.
Cetin