ODBC API

[z96andh]

Hi

Can i set in the ODBC driver that a string should delete all trailing spaces?

Best Regards
//Anders

 

[lfoata]

Never seen this done with an ODBC. ODBC means open database connectivity, it is more of a gateway than a language.
You shoul duse SQL or PL/SQL to do what you need.

 

[z96andh]

I have a strange problem...

I am trying to do a INSERT INTO statement. When I try to pass a variable containing ' ' (7 spaces) to a NOT NULL column i get the answer: CANNOT INSERT NULL INTO pointing at the NOT NULL column...

I don't know where to start looking. The variable is REALLY containing ' '...

Regards
//Anders

 

[lfoata]

I dont get why you want to insert all spaces in a not null column. Spaces are pretty close to null in a varchar column.
If you have to insert spaces into that column, you should rethink some part of the data model, and maybe remove the constraint.
If you have to do this as a oneshot deal, you can disable the contraint, run the update and then re-enable the contraint with the exception clause.