Hi Aleksey

I will test it today and let you know.

I do have one more question about why PostgreSQL boolean values appear as Character fields in VFP. Do you know how I can get them to appear as logical values in VFP?

Thanks
Simon

P.S. I also think your excellent description of the use of the UpdateNameList should appear in the VFP documentation. Your explanation about the field decoration would be very useful in description of this property.


>Hi Simon,
>
>>What confused me was that the documentation had
>>

>><remote table name>, <remote field name>,
>>

>>
>>I think it should read:
>>

>><remote table name>.<remote field name>,
>>

>>
>
>You are right, there is a mistake in help topic for UpdateNameList property.
>
>>I also do not know exactly where it mentions about the field decoration.
>>
>
>Field name decoration is not a CursorAdapter requirement, it is a backend requirement. For example, [desc] is a SQL key word that can be used in ORDER BY clause. If you want to use it as a field name, PostgreSQL requires to use quotation marks to decorate it. I this scenario, < remote field name > should be decorated field name because decoration is a part of the name and CursorAdapter has no idea whether and how the decoration should be applied (each backend has its own rules).
>
>Were you able to make it work?
>
>Thanks,
>Aleksey.