Re: TClientDataSet, TADOTable & "INSERT INTO" SQL error
From: Patrick Ryan (pryan83101_at_aol.com)
Date: 03/13/04
- Next message: Patrick Ryan: "How do I create an .mdb file programmically?"
- Previous message: Brian Bushay TeamB: "Re: Problems saving MemoText (over 255 chars) into ACCESS2000"
- In reply to: Brian Bushay TeamB: "Re: TClientDataSet, TADOTable & "INSERT INTO" SQL error"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 12 Mar 2004 23:47:19 -0600
YOU'RE RIGHT! That was the problem. I had a field in the database (Access)
called Date. That aparently played havoc with the SQL reserved word Date.
This problem was killing me. I had no clue how to fix it. Thanks!
"Brian Bushay TeamB" <BBushay@Nmpls.com> wrote in message
news:g80t40trrp02kcitcbv2r5cl6b66ckdah8@4ax.com...
>
> >I have a form that uses a TClientDataSet component. It links to a
TADOTable
> >via a TDataSetProvider. When I try to ApplyUpdates after doing a
dsInsert, I
> >get an EOleException "Syntax error in INSERT INTO statement".
> >
> >I'm not using any SQL in this operation. If the TClientDataSet talks to
the
> >TADOTable using SQL, fine. But how am I suppose to know what's wrong so I
> >can fix it? Can I view the SQL that is generated?
>
> It isn't easy to view the SQL. If you search around there is a Tprovider
> descendant TlogProvider that exposes the SQL in an OnLog event.
> However you error is probably due to having a fieldname that is also a SQL
> Keyword.
>
>
> --
> Brian Bushay (TeamB)
> Bbushay@NMPLS.com
- Next message: Patrick Ryan: "How do I create an .mdb file programmically?"
- Previous message: Brian Bushay TeamB: "Re: Problems saving MemoText (over 255 chars) into ACCESS2000"
- In reply to: Brian Bushay TeamB: "Re: TClientDataSet, TADOTable & "INSERT INTO" SQL error"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
