General information
Category:
Coding, syntax and commands
Title:
Using OleDBCommand to Insert VFP records
Hi.
I am having lots of troulbe using Parameters with OleDbCommand and ExecuteNonQuery command. Its coming up with syntax errors at runtime.
Initially I tried the following:
--------------------------------
My String is like:
string sql = "Insert into MyTable (Fielda,Fieldb) Values (@Fielda,@Fieldb)"
and added a parameter for each field.
This always gave a Syntax Error at runtime
I then tried:(After seeing one example)
-------------
string sql = "Insert into MyTable (Fielda,Fieldb) Values (?,?)"
and just added the fields in turn (without the @)
This seemed to work ok.
It would seem that you cannot use Named Paramaters, and they must be strictly in sequence.Can anybody confirm this and also the syntax of the bit in the sql string after the Values.
Are there any examples anywhere of using VFP and OleDBParamater .I've done a search on the net but examples semm to be in short supply.
Regards,
Gerard
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only