| Subject | Parameter type: why unknown? |
|---|---|
| Author | Marco Menardi |
| Post date | 2002-11-06T20:39:28Z |
I had a problem with IBO since in queries like this:
Select * from customers where customers.code=(substr(:P_CODE,1,2))
the error "data type unknown" is generated (the same with QuickDesk SQL editor).
I thought was a IBO problem, but Jason told me that it's a Firebird/Interbase one.
What does firebird (the engine I use ;) need to be aware about parameter type? I think that this would ease development much more than, for instance, the planned boolean native type. Is this a feature that will be included in the fore coming 1.5?
Without it I have to manually edit the WHERE clause of the SQL, that is less elegant (performed inside my program) than a plain SQL statement in the query component. In addition, doing so the query is unprepared each time, with a waste of time/resources.
Thanks
Marco Menardi
Select * from customers where customers.code=(substr(:P_CODE,1,2))
the error "data type unknown" is generated (the same with QuickDesk SQL editor).
I thought was a IBO problem, but Jason told me that it's a Firebird/Interbase one.
What does firebird (the engine I use ;) need to be aware about parameter type? I think that this would ease development much more than, for instance, the planned boolean native type. Is this a feature that will be included in the fore coming 1.5?
Without it I have to manually edit the WHERE clause of the SQL, that is less elegant (performed inside my program) than a plain SQL statement in the query component. In addition, doing so the query is unprepared each time, with a waste of time/resources.
Thanks
Marco Menardi