Parameters, direct connectivity and strings that are too long
Posted: Mon 09 Jan 2006 11:23
Hi there,
I'm trying to insert some data using the Direct connectivity method (have not tried others).
I'm assigning a string of length 60 to a parameter for a column of length 20.
Instead of raising an error on INSERT, this actually runs fine and cuts the string down to a length of 20.
This is not what I want -- I want it to return an error!! How else would I know that my data is imported incorrect?
Any idea, comments?
--
Martijn Tonies
Upscene Productions
I'm trying to insert some data using the Direct connectivity method (have not tried others).
I'm assigning a string of length 60 to a parameter for a column of length 20.
Instead of raising an error on INSERT, this actually runs fine and cuts the string down to a length of 20.
This is not what I want -- I want it to return an error!! How else would I know that my data is imported incorrect?
Any idea, comments?
--
Martijn Tonies
Upscene Productions