Thanks Tom. Using Server Side cursors solves the immediate problem (as long
as I remember not to put a semi colon on then end of the query!).
Unfortunately though, this means that the recordset must be refreshed to
view newly added records which is not the case when using Client Side
cursors with a command type of Table. Anyone got any ideas?
Regards,
Dave.
--
Network & Systems Manager, The Vale Housing Association.
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk (Home of pgAdmin)
Beer can be a permanent solution, but only if you have enough of it!
> -----Original Message-----
> From: Thomas Byrnes [mailto:tbyrnes@helioshealth.com]
> Sent: 15 October 1999 18:13
> To: 'Dave Page'; 'pgsql-interfaces@postgresql.org'
> Subject: RE: [INTERFACES] ODBC: 'Insufficient base table
> information for
> updating or refreshing' error with ADO
>
>
> Dave,
> Are you locking the record set directly with ADO? If
> so, it may just be a
> cursor problem.
>
> Regards,
>
> Tom
>