Re: [SQL2000] insert query
First thing I want to say you that do not use UnderScope in the field of the table.
Use FIRST_NAME AS FirstName same fro the LastName.
And for the problem check your dataset.
Re: [SQL2000] insert query
code or sql suggestions would be more welcome which include detailed explanations
Re: [SQL2000] insert query
It looks like the problem is dataset - I presume this is an object in your code, rather than a table in your database.
You cannot use variables/objects inside (SQL) strings, you need to append the values to the string instead.
I don't use VB.Net, but I assume that what you need is something like this:
Code:
.. VALUES ('" & dataset.LAST_NAME & "', '" & dataset.FIRST_NAME & "', ..