C
cj
I'm using the commandbuilder to generate insert commands for some tables
for me. I provided it the select command "select * from mytable". I've
used this on several tables and it was building the appropriate insert
command correctly. Then I hit a table where it gave me the error:
"Update error: Incorrect syntax near the keyword 'desc'."
I have a good idea what is going wrong as there is a field in this table
named desc but there is no need for the keyword desc in the insert
command. I'd like to see exactly what it is trying to use as an insert
command. I tried setting a breakpoint and then in the command window
typing "? mysqladapter.insetcommand.commandtext" but it comes back with
a value of 'Nothing' How can I see what the insert command is?
Preferably in code so I might modify it at runtime to correct the problem.
for me. I provided it the select command "select * from mytable". I've
used this on several tables and it was building the appropriate insert
command correctly. Then I hit a table where it gave me the error:
"Update error: Incorrect syntax near the keyword 'desc'."
I have a good idea what is going wrong as there is a field in this table
named desc but there is no need for the keyword desc in the insert
command. I'd like to see exactly what it is trying to use as an insert
command. I tried setting a breakpoint and then in the command window
typing "? mysqladapter.insetcommand.commandtext" but it comes back with
a value of 'Nothing' How can I see what the insert command is?
Preferably in code so I might modify it at runtime to correct the problem.