sqlstatement

[kisstene]

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?

[carp]

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');

[sysdba]

Also you may need to use date function if your date mask
is not MM-DD-YY.