Posted by prabhukumarasamy on 07/24/06 05:36

Now i m working in a existing project. I have to do some updations. In
that project database table contain a table(usergroups) field name as
'Name'. When i am trying to insert a new record in (usergoups) table
like as follows'


insert into UserGroups(Name,modusr,moddt) values ('sam',131,'7/23/2006
10:02:13 PM')


The response ll come as follows,


Invalid column name 'FirstName'.Invalid column name 'LastName'.

The usergroups table structure is as follows,


UserGroupId int 4 (PK field)
Name varchar 50
modusr int 4
moddt datetime 8


Plz tell the correct insert query to add records for the above
table....


Thanks in advance

[Back to original message]