Lawrence Bridger
2016-03-09 12:40:36 UTC
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
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