Subject | BUG with TIBOQuery (IBO4.2Gc) and Firebird 1.5 (RC1) |
---|---|
Author | fabiano_bonin |
Post date | 2003-04-15T02:24:07Z |
The example below uses the database employee.fdb, shipped with
firebird.
1 - Create a new application in Delphi.
2 - Put a TIBODatabase and TIBOQuery in the form.
3 - Point the TIBODatabase to employee.fdb.
4 - Connect the TIBODatabase
5 - Put this SQL in the TIBOQuery:
insert into sales (
sales_rep,
order_date,
ship_date,
date_needed,
paid,
qty_ordered )
select
:sales_rep,
:order_date,
:ship_date,
:date_needed,
:paid,
:qty_ordered
from
sales
where
cust_no = :cust_no
6 - Prepare the TIBOQuery.
7 - Look at TIBOQuery.Params.
8 - The first parameter 'sales_rep' will be of type 'ftDateTime'
when it should be of type 'ftSmallint'. The parameter 'date_needed'
will be of type 'ftString', when it should be of type 'ftDateTime'.
It appears that the parameter types as shifted one position.
This occurs only when i use a parameter in the WHERE clause.
The example above works fine under Firebird 1.0.2.
I have some urgence in solve this. Do somebody can help?
firebird.
1 - Create a new application in Delphi.
2 - Put a TIBODatabase and TIBOQuery in the form.
3 - Point the TIBODatabase to employee.fdb.
4 - Connect the TIBODatabase
5 - Put this SQL in the TIBOQuery:
insert into sales (
sales_rep,
order_date,
ship_date,
date_needed,
paid,
qty_ordered )
select
:sales_rep,
:order_date,
:ship_date,
:date_needed,
:paid,
:qty_ordered
from
sales
where
cust_no = :cust_no
6 - Prepare the TIBOQuery.
7 - Look at TIBOQuery.Params.
8 - The first parameter 'sales_rep' will be of type 'ftDateTime'
when it should be of type 'ftSmallint'. The parameter 'date_needed'
will be of type 'ftString', when it should be of type 'ftDateTime'.
It appears that the parameter types as shifted one position.
This occurs only when i use a parameter in the WHERE clause.
The example above works fine under Firebird 1.0.2.
I have some urgence in solve this. Do somebody can help?