AOA ... i am getting this error while inserting values into table....
like:
insert into Gl_Transaction values(001,001,0010010010006,'Furniture',103 ,'Opening Balance on 01-02-2013', '2013-02-01', 0000000026,' JV', 20000.00, 0.00 ,NULL, NULL, NULL ,12300)
insert into Gl_Transaction values(001,001,0010010010006,'Furniture',103 ,'Opening Balance on 01-02-2013', '2013-02-01', 0000000026,' JV', 0.00, 20000.00 ,NULL, NULL, NULL ,12300)
i already set identity of table on but did not work.
like:
set identity_insert gl_Transaction On
insert into Gl_Transaction values(001,001,0010010010006,'Furniture',103 ,'Opening Balance on 01-02-2013', '2013-02-01', 0000000026,' JV', 20000.00, 0.00 ,NULL, NULL, NULL ,12300)
insert into Gl_Transaction values(001,001,0010010010006,'Furniture',103 ,'Opening Balance on 01-02-2013', '2013-02-01', 0000000026,' JV', 0.00, 20000.00 ,NULL, NULL, NULL ,12300)
set identity_insert gl_Transaction Off
what can i do?? :(