March 6, 2010 at 7:24 am
I am trying to delete record form SQL CE 2005 in my program, I am writing the following statement
sSQL = "Delete * from detail where order_no = '" & OrderNumber & "' and Item_no = '" & sDSItemNo & "'"
cmd.CommandText = sSQL
cmd.ExecuteNonQuery()
and I get the folllowing error:
There was an error parsing the query. [ Token line number = 1,Token line offset = 8,Token in error = * ]
Then I ran the query from within the SQL Server Mgmt Studio
Delete * from detail where order_no = '0104524' and item_no = 'BT REPL 2%'
and got the same error as follows
Major Error 0x80040E14, Minor Error 25501
> Delete * from detail where order_no = '0104524' and item_no = 'BT REPL 2%'
There was an error parsing the query. [ Token line number = 1,Token line offset = 8,Token in error = * ]
March 10, 2010 at 1:34 pm
Try This
sSQL = "Delete detail where order_no = '" & OrderNumber & "' and Item_no = '" & sDSItemNo & "'"
cmd.CommandText = sSQL
Thanks,
Neal
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy