Adding new row fails with INSERT INTO

K

Klic

I use SQL View to test SQL Statements before I use them in my VB code.

What I want to do is add a row to an existing table:
Table Name: Client
Field 1: AccountNumber (Numeric)
Field 2: ClientName (Text)
Field 3: Address1 (Text)
Field 4: Address2 (Text)
Field 5: Address3 (Text)
Field 6: ContactNumber (Text)

The following SQL works fine from within code (when " are replaced with "");

INSERT INTO Client ( AccountNumber, ClientName, Address1, Address2,
Address3, ContactNumber )
VALUES (123456, "Test Client", "Addr 1", "A2", "A3", "01302 781423");

but will not work from the SQL View panel - instead I get the 'Select
Source' dialog.


(Here is the code that works from within my VB)

strSQL = "INSERT INTO Client ( AccountNumber, ClientName, Address1,
Address2, Address3, ContactNumber ) " & _
"VALUES (123456, ""Test Client"", ""Addr 1"", ""A2"",
""A3"", ""01302 781423"");"

Set rcsClient = gcnxPPP.Execute(strSQL)
Set rcsClient = Nothing


I would be grateful if someone can tell me why the 'Select Source' dialog
appears, and how (if it's possible) I can use the SQL View to run


thanks,

Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increment field by 1 on insert Query 2
UPDATE of Parent table does not work when child records exist 0
Help with code to hide/unhide text box and label? 3
Populating textbox with more than one row of text 2
Populating Address fields in form 3
Creating unique identifier in query 1
Adding New records in multiple tables 3
insert into table 1

Top