Just for information (in case anyone is interested), I have now solved this
problem. In a nutshell, ADO does not like trailing semi-colons on queries.
eg.
SELECT * FROM tablename;
will give an 'Insufficient base table information for updating or
refreshing' error, when updating the resulting recordset, but
SELECT * FROM tablename
will not.
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: Dave Page [mailto:dpage@vale-housing.co.uk]
> Sent: 18 October 1999 08:40
> To: 'tbyrnes@helioshealth.com'
> Cc: 'pgsql-interfaces@postgresql.org'
> Subject: RE: [INTERFACES] ODBC: 'Insufficient base table
> information for
> u pdating or refreshing' error with ADO
<SNIP>