I have an IDC file which simply populates a database on the SQL server
with the data the user has entered into a form. The problem is that
everytime the IDC file is executed I get the following error message:
[State=21S01][Error=110][Microsoft][ODBC SQL Server Driver][SQL
Server]There are fewer columns in the
INSERT statement than values specified in the VALUES clause. The
number of values in the VALUES clause
must match the number of columns specified in the INSERT statement.
Here is the following IDC file:
Datasource: Web SQL
+INSERT INTO links
+ (name, add1, add2, add3, town, postcode,
+ phone, email, cat, subcat, web)
+ ( '%name%', '%add1%', '%add2%', '%add3%', '%town%',
+ '%phone%', '%email%', '%cat%', '%subcat%', '%web%')
+SELECT * FROM links
+ WHERE id = '%id%'
N.B. you may need to maximize your mail window as to not get confused
with the line breaks.
I can add records when using SQL Enterprize manager
If anyone can help with this problem it would be much appreciated
IT Support Engineer
Tel: +44 (0161)-429-6590
Fax: +44 (0161)-476-6710