Subject Stored Procedure Problem
Author Tomy Handaka
Dear all,

I have a 'strange' behaviour on Firebird's stored procedure. I
constructed a query for a report that includes date format as input
parameter, like (simplified):


FROM... WHERE .... between :DATETO and :DATEFROM <==
DATEFROM is smaller than DATETO

If that query is executed using SQLEditor, it works well. But when it
applied into stored procedure, with valid statement, the query return
null result. Then I changed the parameter to 'between :DATEFROM and
:DATETO'. After changed, the stored procedure return the desired result.

Are there any differences on executing PSQL using Stored Procedure?

Best regards,

Tomy Handaka Patria

Software Engineer
+62 361 755 025 (Phone)
+62 361 755 024 (Fax)

This e-mail is for the intended addressee only and is confidential
information. If you have received this transmission in error please
delete and notify the sender. The contents of this e-mail are the
opinion of the writer only and are not endorsed by Mitrais unless
expressly stated otherwise.

[Non-text portions of this message have been removed]