Paramete Count get datatype!

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
youruser

Paramete Count get datatype!

Post by youruser » Thu 12 May 2005 05:57

When i user sqlQuery Excute SQL,for example "insert into table (col1,col2) values (:col1, :col2)", set params.parametebyname('col1').value, always say Error:"Unknown data type (11) (D:\Projects\Delphi\Dbx\Source\dbexp.pas, line 859)",when debug,it always return ftUnknow.

Why?
how to do??

Guest

Re: Paramete Count get datatype!

Post by Guest » Thu 12 May 2005 07:34

set SQLQuery1.params.parametebyname('col1').value := SQLQuery2.parametebyname('col1').value .SQLQuery1 and SQLQuery2 link different Connection.target database is Oracle,Source database is Sybase.
thanks

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Thu 12 May 2005 07:51

Do you assing SQLQuery1.params.parametebyname('col1').DataType, SQLQuery1.params.parametebyname('col1').ParamType befor executeion sql? What are these values?
We couldn't reproduce the problem. Please send us complete sample to demonstrate it to DbxOda support address and include script to create server objects. Please specify the version of Oracle server, Oracle client, version of DbxOda that you use.

Post Reply