Re: Newbie question on INSERT command
- From: lyle <lyle.fairfield@xxxxxxxxx>
- Date: Tue, 27 Nov 2007 22:16:25 -0800 (PST)
On Nov 27, 9:56 pm, "Jerry West" <j...@xxxxxxxxxxx> wrote:
I'm using VB6 to create a new record in a Access db. I'm doing so like this:
INSERT INTO Customers (Name Prefix, First Name, Last Name, Name Suffix,
Company, Phone, Email, Address1, Addres2, City, State, Zip, Country) VALUES
('', 'Din W.', 'Cambell', '', '', '1 8055553128', notr...@xxxxxxxxx', '12345
Molkai Drive', '', 'Nowhere', 'SC', '19708', 'USA')
The error I get back indicates a syntax error. I've looked around at some
examples but I don't see where I'm going wrong. Could it be the empty
values?
Any insight much appreciated!
JW
How about Addres2. Did you really spell Address1 and Addres2 so
differently?
How about , notr...@xxxxxxxxx'; clearly we have a single-quote
missing.
But really, it's a stretch for you to ask us to correct your syntax
when you post an example. How can we know if the errors we see are in
the example only, or in the actual code fragment?
The zero length strings may or may not be a problem, depending upon
how your fields are defined. In general, zero length strings can cause
high blood pressure, sweating, and inappropriate muttering I never
allow them.
.
- References:
- Newbie question on INSERT command
- From: Jerry West
- Newbie question on INSERT command
- Prev by Date: Re: Newbie question on INSERT command
- Next by Date: Re: "bare" db1 File
- Previous by thread: Re: Newbie question on INSERT command
- Next by thread: Re: Newbie question on INSERT command
- Index(es):
Relevant Pages
|
