🚀 go-pugleaf

"bmkiss" <bmkiss67@cablespeed.com> wrote in message 
news:421e146a$1@newsgroups.borland.com...
> I'm trying to convert from BDE to ADO.  I don't know much about ADO so I
> hope this isn't completely stupid.  The chunk of code below doesn't work. 
> I
> get the following error stepping thru the code.
>
> ---------------------------
>
> Debugger Exception Notification
>
> ---------------------------
>
> Project COBB.exe raised exception class EOleException with message
> 'Application uses a value of the wrong type for the current operation'.
> Process stopped. Use Step or Run to continue.
>
> ---------------------------
>
> OK   Help
>
> ---------------------------
>
>
>
>  ADOqSuggestions->Close();
>
>  ADOqSuggestions->SQL->Clear();
>
>  ADOqSuggestions->SQL->Add("Insert into Suggestions
> values(:name,:phone,:email,:sub,");
>
>  ADOqSuggestions->SQL->Add(":sug,:compname,:time,:status,:ccr)");
>
-- snip --
First, always provide the column names in the SQL statement.  They might not 
actually be in the order you think they are.  And, in general, it's safer. 
For example:

INSERT INTO Foo (a, b, c) VALUES (:a, :b, :c)

Give that a try.

- Arnie