You are right, Steve. It needs the double quote mark. After I use the double quote mark, an error message is:
ERROR: ExecAppend: Fail to add null value in not null attribute ... which is right since I don't have non-null value to non-null field yet. I, however, didn't use double quote mark when I created the table at all. Now, I need to figure out how to add double quote mark in Java code query string. v. 6/14/2002 6:12:18 AM, Stephan Szabo <[EMAIL PROTECTED]> wrote: >On Thu, 13 Jun 2002, Vernon Wu wrote: > >> >> Command: >> >> Insert into profile (userid, haveChildren)values('id98', 'No'); > >You presumably used double quotes when creating the column, so >you need to use them to refer to the column from that point on: > >insert into profile(userid, "haveChildren") ... > > > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly