Re: ADO Excel D2007 SQL UPDATE problem
- From: "Sven Pran" <no.direct@xxxxxxxxxxx>
- Date: Mon, 21 Apr 2008 14:58:46 +0200
"Sven Pran" <no.direct@xxxxxxxxxxx> wrote in message news:480c689e@xxxxxxxxxxxxxxxxxxxxxxxxx
"Chris.Cheney" wroteAnd that was it - problem solved
.............
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
Thanks again
Sven
.
- 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
- Re: ADO Excel D2007 SQL UPDATE problem
- From: Sven Pran
- ADO Excel D2007 SQL UPDATE problem
- Prev by Date: Re: ADO Excel D2007 SQL UPDATE problem
- Next by Date: Re: TCPServer & MSSQL & Threads (Newbie Question)
- Previous by thread: Re: ADO Excel D2007 SQL UPDATE problem
- Index(es):