Subject | TIMESTAMP as UDF argument |
---|---|
Author | shijak@freemail.org.mk |
Post date | 2001-11-12T23:30:36Z |
hi, i have one problem with udfs
when they take TIMESTAMP as argument.
for example udf returns an integer.
Everything is perfect till i do something like this in C++Builder
Query->SQL->Clear();
Query->SQL->Add("SELECT * FROM T WHERE UDF(:dd) = TABLE.ID");
Query->Prepare(); //Here is thrown exception
Query->ParamByName("dd")->AsDateTime = Date();
Query->Open();
Exception is "Unknown data type SQL error code = -804"
platform: FireBird 0.9-4 Test1 on w2k
when they take TIMESTAMP as argument.
for example udf returns an integer.
Everything is perfect till i do something like this in C++Builder
Query->SQL->Clear();
Query->SQL->Add("SELECT * FROM T WHERE UDF(:dd) = TABLE.ID");
Query->Prepare(); //Here is thrown exception
Query->ParamByName("dd")->AsDateTime = Date();
Query->Open();
Exception is "Unknown data type SQL error code = -804"
platform: FireBird 0.9-4 Test1 on w2k