Posted by --CELKO-- on 07/24/06 12:36

>> project database table contain a table(usergroups) field [sic] name as 'Name'. When I am trying to insert a new record [sic] in (usergoups) table .. <<

>From the error message, you are not inserting into the table that you
think you are. Those columns do not exist, based on your own personal
pseudo-code. It will help if you post real DDL instead. Are you in
the right database? Has the table been altered? Is there a trigger
doing something else?

Columns are not like fields; rows are not like records. Columns are
referenced by name and not by position. In a file system, the program
gives meaning to the fields in a record, so I can write code like READ
(a,b,c) or READ(c,a,b) and load local variables. It will be garbage,
but it will usually run. COBOL programmers had this problem all the
time.

You also need to learn ISO standards. Your date is not in ISO-8601
format, and "name" (of what? Did you mean user_name? group_name?
something else? ) violates ISO-11179 rules.

[Back to original message]