Hi

Yes I am using VFP 8.0 SP1. The error message I quoted is the one I get if I use the Aerror() after the TableUpdate command to retrieve the error message.

I have not tried a Query yet because I do not have any data in the tables. I created the tables using SPT and now I want to fill them using the cursoradapter. I thought I could open the cursor using the Cursorfill method then append the data from an existing VFP tables effectively importing the data into PostgreSQL.

Simon

>Hi Simon...
>
>
>
>>I have been testing the cursoradapters with PeerDirect PostgreSQL for Windows.
>
>>I have been able to create the tables and open cursors with the cursorfill method. However, when I add data to the cursors and issue TableUpdate(.T.) it returns .T. but the data is not saved in PostgreSQL.
>
>Did you already install the SP1?, lot of corrections about this issue.
>
>>When I check for an error I find the following:
>>ERROR: parser: parse error at or near "desc"
>
>Is it a diffentent problem?, what are your query?, does it works fine with SPT?
>
>
>
>>I also noticed that the boolean data type in PostgreSQL appears as a single character field in the Visual FoxPro cursor when I would have expected a logical field.
>
>Use CursorScheme to improve the field type you want to use.
>
>HTH