RE: [INTERFACES] ODBC: 'Insufficient base table information for u pdating or refreshing' error with ADO

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(at)vale-housing(dot)co(dot)uk]
> Sent: 18 October 1999 08:40
> To: 'tbyrnes(at)helioshealth(dot)com'
> Cc: 'pgsql-interfaces(at)postgresql(dot)org'
> Subject: RE: [INTERFACES] ODBC: 'Insufficient base table
> information for
> u pdating or refreshing' error with ADO
<SNIP>