SQL Syntax 
Author Message
 SQL Syntax

Can anyone tell me what I did wrong here.

dim db_address as database
dim rec_address as recordset
.
.
.
    db_address.execute "insert into Address"_        'ADDRESS is the
                & "(phone,name,address) values"_        'name of the table
                & "(wk_phone,wk_name,wk_address);"

when the above statement gets execute, I received a syntax error saying
"number of arguments not match".



Sun, 25 Mar 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. SQL-syntax SQL-Server 7.0 / Access 97

2. Update SQL Syntax to Access and SQL Server

3. SQL syntax across SQL Server..Qracle..Access

4. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL Syntax

5. VB6: Oracle 8/SQL Server 2000 compatibility problems using ADO 2.5 and SQL Syntax

6. SQL : migrating an ACCESS SQL syntax to ORACLE syntaxe

7. SQL syntax error - HELP BEFORE I JUMP!

8. Disappearing SQL Syntax

9. Jet SQL syntax Access 2000

10. SQL syntax problem.

11. DELETE sql syntax question

12. SQL syntax

 

 
Powered by phpBB® Forum Software