-
hello,
i have a very simple question:
why doesn't this insert execute. I can't seem to find the error
INSERT INTO HOST (HOST, IP, COMPANY, APP, CONTACT, INSERTED)
VALUES (HOUAPPS053, 34.224.101.214, MWK, IPMS, GSMET, 11-15-00)
/
i get message "missing comma" ?? where?
-
Your character strings need to have single quotes around them. I suspect that it is looking at the IP address as a number and getting confused by the multiple periods.
Try this:
INSERT INTO HOST (HOST, IP, COMPANY, APP, CONTACT, INSERTED)
VALUES ('HOUAPPS053', '34.224.101.214', 'MWK', 'IPMS', 'GSMET', '11-15-00');
-
Also you may need to use date function if your date mask
is not MM-DD-YY.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|