Re: Inserting an empty field

Posted in 1998

Lee Wan Ling — Thu, 05 Mar 1998 10:00:06 +0700 — source: Informix-list mailing list archive (1991-1998)

Hi Ed Schaefer I'm sorry about having to reply in here but my mail server didn't get your email address right. Anyway, back to my problem. I wasn't inserting a NULL column but an empty string, which I thought is not the same as an empty string. An by specifying that the length of the string is 0, I thought the CLI driver should treat it as inserting an empty string rather than a NULL. I had no problem executing the statement directly: insert into table (column1, column2,...) values ('', '') but I couldn't do it using SQLBindParameter. I wonder. Regards, Wan Ling > Hi: > > I'm no ODBC expert, but you really can't insert a null into a column > designated as a key. If you go look at the database, you probably have > an index defined as no NULLS allowed. > > regards, > > ed > schaefer >