Insert Statement

twoolums

Perch
Ok got a call from a client that an app I built that runs on win13 all of a sudden is throwing errors. Narrowed it down to a insert statement. Looking at the statemen I can't figure out why it doesn't work it runs fine on a test box just not win13

INSERT INTO tblOfficers (FirstName, LastName, CompanyName, Phone, eMail, position)VALUES('Test Name','Test Last Name','Test Company Name','(515) 555-55555','[email protected]', 1)

I also attached a pic of the db structure

Thanks for the help
 

Attachments

  • untitled.JPG
    untitled.JPG
    15.4 KB · Views: 74
Attachments aren't working for me, but anyway.. what's the error message it's producing? Have you tried accessing the used database from the test box directly to see what happens then?
 
yes forum attachments still don't work, there is something very broken in the vB database, as the fiels are actually on the server :(

I just have not had time to trace it down as it is not a top priority now, and have been working on finding a different location for the server since the softlayer outage so figured I will just let it go until that is finalized.

now as for the error, could it be simple syntax or a - in some content? I know the hyphens and make sql go crazy :)
 
Its a syntax error

Microsoft JET Database Engine error '80040e14'

Syntax error in INSERT INTO statement.


Running the statement manually on the db works fine thats why I'm stuck ?(
 
I tried but nothing stood out like you link. That helped and its fixed now, put the [] around the field names.
 
Back
Top