I have 1 sqlce table i.e domain list.In this table i have 2 columns i.e domain id,domain name.Domain Id automatically coming.I have to insert values into in this table i used the following query.
INSERT INTO Domain List
(DomainID, DomainName)
VALUES
(1, 'ibm')
But iam getting the following error.
Major Error 0x80040E14, Minor Error 25501
> INSERT INTO Domain List
(DomainID, DomainName)
VALUES
(1, 'dow')
There was an error parsing the query. [ Token line number = 1,Token line offset = 20,Token in error = List ]
Whats the problem.can you please verified.
|
| Author: soniumesh 06 Nov 2009 | Member Level: Gold | Rating:  Points: 2 |
Hi,
You said domainid is automatically coming why you insert domainid?
Second thing never use space in table name.
Regard,
umesh soni
|
| Author: Manick 06 Nov 2009 | Member Level: Gold | Rating: Points: 2 |
As you said domain_id created automatically. So you have to give the domain_name while inserting.
Regards,
Manick
|