Re: Updating with null terminated stings in Pro*C

Dexter P. Bradshaw [CS] (dpbradsh_at_bluebox.uwaterloo.ca) wrote:
: Whenever I try to do an update or insert on a fixed length character column
: with a null terminated string I get the errror: "column too long". How
: do I overcome this problem?
 

: Dex

Make sure you set both parts of the VARCHAR variable...

strvar.arr[ i ] = \0;
strvar.len = strlen( strvar.arr );

then try the UPDATE etc.

Randy

--

_/_/_/_/  _/     _/  _/      _/  _/_/_/  _/_/_/_/   _/_/_/    _/_/_/
_/        _/_/   _/   _/     _/    _/    _/    _/  _/    _/  _/    _/
_/_/_/    _/ _/  _/    _/   _/     _/    _/_/_/    _/        _/    _/
_/        _/  _/ _/     _/ _/      _/    _/        _/        _/    _/
_/_/_/_/  _/   _/_/      /_/     _/_/_/  _/         _/_/_/   _/_/_/
=====================================================================
    Randy DeWoolfson  -  ergo sum    :-)        envipco_at_cais.com
 or Ron Frederick     -  ergo ?      (8P
---------------------------------------------------------------------
#include <StandardDisclaimerOnOpinions>  // Null if file not found.
=====================================================================