Hi

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.

When I check for an error I find the following:

ERROR: parser: parse error at or near "desc"

When I created the tables I found that I had to put quotes around the table name and field names. So I am wondering whether this maybe a problem with the way the cursoradapter generates the automatic SQL.

I also had to set the cursoradapter tables property as follows otherwise I was unable to append data to the cursor:

tables=["mytablename"]

Does anyone have any suggestion about how this should be handle? Do I have to create the InsertCmd/DeleteCmd/UpdateCmd manually?

I also noticed that the boolean data type in PostgreSQL appears as a single character field in the VFP cursor when I would have expected a logical field.

Thanks
Simon