Help - SQLBindParameter not used for all parameters error

2001-02-08 Thread Li Sze
I have trouble writing a character into the database (the column is declared as char(2) not null) because I figured that if it appends a null at the end of the character data I want to insert (i.e.'A\0'), it would still fit. I bound the parameters first before assigning the data and executing

Re: Help - SQLBindParameter not used for all parameters error

2001-02-08 Thread Miguel Angel Solórzano
At 17:05 08/02/2001 +0800, Li Sze wrote: Hi! If you only need room for 1 character you don't need a column with size 2. The last parameter of SQLBindParameter is a pointer to a buffer for the parameter's length. Then error HY090 means: (DM) The argument ParameterValuePtr was a null pointer,

Re: Help - SQLBindParameter not used for all parameters error

2001-02-08 Thread Li Sze
Thanks for responding. I've changed the column back to size 1. However, if I follow the example from the Microsoft Documentation, that is setting the last parameter to cbValue where cbValue = SQL_NTS, and BufferLength to 0, I get a handling exception error when the last SQLParamData is called.

Re: Help - SQLBindParameter not used for all parameters error

2001-02-08 Thread Miguel Angel Solórzano
At 10:10 09/02/2001 +0800, Li Sze wrote: Hi Li, I will take a look in MyODBC code about the SQLBindParameter and when I will have a reasonable answer I will send you the reply. Regards, Miguel Thanks for responding. I've changed the column back to size 1. However, if I follow the example from