[firebird-support] When is varchar(10) only 7; arithmetic exception, numeric overflow, or string truncation

2012-08-27 Thread Rick Debay
I have a stored procedure that reads from an external file table. One of the fields is varchar(10) in the stored procedure and char(10) in the file. I am selecting from the stored procedure and inserting in to a table which has a matching varchar(10) COLLATE ISO8859_1 field. If a field is empty (LT

[firebird-support] Firebird Conference 2012, October 26-27, 2012, Luxembourg

2012-08-27 Thread Alexey Kovyazin
Hello All, Firebird Conference 2012 will take place October 26-27, in Luxembourg. Please plan your journey to the main Firebird event of the year! Now we are calling for papers - please send talks' proposals to c...@firebirdsql.org if you'd like to present there. Current sponsors are Sita Softw

[firebird-support] null row

2012-08-27 Thread Mahesh Pratihari
Hi All, Could you please let me know why I am getting one null row while executing the query. [cid:image001.png@01CD8484.000D17E0] I am using the dynamic query like this EXECUTE STATEMENT :QRYSTR INTO :UID,:NAME,:ATTRIBUTETYPE,:ISSINGLETON,:ISAUTOINHERIT,:ISINHERIT