Worked like a charm!
Thanks Heidi
Thanks Heidi
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Quote from: jerolimov on February 11, 2009, 01:06:15 pm
...
In both lines the single quote (') around the value colum (around 1.0000 and 1.1036) must be removed.
Instead of:
INSERT INTO currencies VALUES (currencies_seq.nextval,'US Dollar','USD','$','','.',',','2','1.0000', sysdate);
INSERT INTO currencies VALUES (currencies_seq.nextval,'Euro','EUR','','EUR','.',',','2','1.1036', sysdate);
It must be:
INSERT INTO currencies VALUES (currencies_seq.nextval,'US Dollar','USD','$','','.',',','2',1.0000, sysdate);
INSERT INTO currencies VALUES (currencies_seq.nextval,'Euro','EUR','','EUR','.',',','2',1.1036, sysdate);