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??
Paramete Count get datatype!
Re: Paramete Count get datatype!
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
thanks
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.
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.