Hello

I have a conundrum which I cannot solve and for which I cannot find a solution 
in the archives.

I have a table with a primary key and one other integer field named, say, ABC.  
This field is defined as not null but has a default source value of, say, 0.

I am using an application which uses the ODBC driver above.  I have the option 
to set this field, within the application, to be a null field.  If I do so and 
try and insert a record I get an error message -625 Validation error for column 
ABC, value "***null***" .  I think that the ODBC driver is looking at the DB 
table, determining that the field is defined as not null, and therefore 
produces this error message.

If I set the option to not being a null field, the message I get is -303 
Dynamic SQL Error  SQL error code = -303  conversion error from string "".  
Again I believe that the DB is receiving a message to insert the record but has 
determined that the value is blank rather than NULL.  In this particular 
instance I would like the record to be inserted using the default source value, 
but the error message prevents the update.

I have found a work around in that if I was to purchase Easysoft's ODBC driver 
for Firebird the problem simply disappears, but I do believe that the official 
Firebird ODBC driver should cope with this scenario.

Please can anybody suggest a solution or advise me what I might be doing 
incorrectly to solve this?

Many thanks in advance

Lawrence Bridger


L D Bridger ACA
Managing Director


L D Bridger ACA
Managing Director

________________________________
bridger

Folding Carton Manufacturers

Avenue One
Letchworth
Hertfordshire
SG6 2WP

Telephone 01462 636465
Web www.bridger.co.uk

This e-mail, and any attachment(s), is intended solely for the use of the 
individual(s) to whom it is addressed. It may contain confidential, proprietary 
or legally privileged information, none of which is waived or lost by 
mis-transmission. If you receive this message in error, please delete it and 
all copies of it from your system, destroy any hard copies of it and notify the 
sender. You must not, directly or indirectly, use, disclose, distribute, print 
or copy any part of this message if you are not the intended recipient. Action 
taken, or not taken, in reliance of it, is prohibited and may be unlawful.
Any views or opinions presented are solely those of the author and do not 
represent the views of Bridger Packaging. Any e-mail sent to this sender's 
address might be monitored and/or read by any other employee of Bridger 
Packaging.

Bridger Packaging is a division of T D Bridger Limited
Registered in England No. 366193
Registered office as above
VAT Registration No. GB 196 2240 57
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785111&iu=/4140
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Reply via email to