The documentation examples at 3.1.6.1 have two variations:

Insert into TABLE (COL, …) values (COL*,…);     which works where the values match the pattern of columns specified

Insert into TABLE values (COL,…);     which seems not to work

Is this a typo in the documentation or have I committed a syntax error?

Also, I have syntax question about something I have not tried out.  If I have a column I use for Last Name, how could I insert ‘O’Connell’ as the field is delimited with single quotes?

TIA

Zoltan Tomory

zoltan.tomory@mobot.org