Quoted Strings ...

From Neil Larson: >Since you cant have a quoted string larger than 256 >character, how does one insert/update a string longer than 256 characters? >Also, Does any one have a C function to parse a prepare string and deal >with the single quotes in a single quoted string? >I have written a function to directly insert and update from motif widgets >using dynamic prepares, but need to deal with these little exceptions. Any >help would be appreciated. How about UPDATE tablename set col_name[1,255]="l..o..n..g quoted string (up to 256 chars)", col_name[257,512]="another chunk of quoted string" . . . ** Opinions expressed are my own and not necessarily those of my employer ========================================================================= Barry Toomey Phone +353-1-2822333 AT&T Network Systems Ireland Fax +353-1-2822864 Corke Abbey Avenue, email: bt@irl3b2c.att.comm Bray, uunet: att!irl3b2c!bt Co. Dublin Ireland =========================================================================