Re: ADO Excel D2007 SQL UPDATE problem
- From: "Sven Pran" <no.direct@xxxxxxxxxxx>
- Date: Mon, 21 Apr 2008 12:12:44 +0200
"Chris.Cheney" wrote
..............
Delphi help: "ADODataSet is not capable of issuing Data Manipulation
Language (DML) SQL statements that do not return result sets (like DELETE,
INSERT, and UPDATE). For this use a component like TADOCommand or
TADOQuery."
Thanks!
I now discover that I actually used TADOCommand in my previous application manipulating an Access database a similar way!
regards Sven
.
- Follow-Ups:
- Re: ADO Excel D2007 SQL UPDATE problem
- From: Sven Pran
- Re: ADO Excel D2007 SQL UPDATE problem
- References:
- ADO Excel D2007 SQL UPDATE problem
- From: Sven Pran
- Re: ADO Excel D2007 SQL UPDATE problem
- From: Sven Pran
- Re: ADO Excel D2007 SQL UPDATE problem
- From: Chris.Cheney
- ADO Excel D2007 SQL UPDATE problem
- Prev by Date: Re: ADO Excel D2007 SQL UPDATE problem
- Next by Date: Re: ADO Excel D2007 SQL UPDATE problem
- Previous by thread: Re: ADO Excel D2007 SQL UPDATE problem
- Next by thread: Re: ADO Excel D2007 SQL UPDATE problem
- Index(es):