I dont know if this the right forum

[NJDrew]

I dont know if this the right forum to ask this question, so if its not, please let me know. Im trying to run an insert statement and I getting all types of errors. The first one was "missing comma" when there was no missing comma. I then cut the insert down to only the fields that couldn't be null or didn't have a default and I got "column not allowed here" Im doing the insert like this: Insert into orders (FirstName, LastName, Company) Values (John, Smith, 1 Higher Learning); I aslo tried putting single ticks around the values, but it didn't like that either. Is there another way to code the insert statement or mybe Im just not wrteing it correctly. Any help would be greatly appriciated. "Mistakes are the portals of discovery"
James Joyce

 

[DCH]

Try simple quoting the values you wish to insert:
Insert into orders (FirstName, LastName, Company) Values ('John', 'Smith', '1 Higher Learning');