Double value insert into DB

**burrug** · 08-13-2008, 08:54 AM

Hello,

I am trying to insert some values into my database. This database contains a table which has 2 fields in it with data-type 'double'.

Now I am trying to insert my numeric value (with 3 decimals) into this double-field with the following:

Please Login or Register  to view this content.

As you can see I am converting the numeric value from the cell to a double value and then insert it in my database.

I get the following query-string;

INSERT INTO arprsw (artcode,crdnr,datum,user_id,verkp_verp,inkp_verp) VALUES ('1012.0290',' 570','2008-08-13','JOOP',-1,3,85)

As you can see the variabel 'ldbLinkp_verp' contains the value '3,85' which makes the database see this as 2 values.
By this I get the following error which I just can't seem to resolve;
"Insert value does not match column list"

Can anybody help me with this issue?

**royUK** · 08-13-2008, 08:59 AM

Not sure because I use . as decimal separator, maybe

Please Login or Register  to view this content.

**burrug** · 08-13-2008, 09:52 AM

No That gave the same ugly output

When I input the numer with a . instead of a comma the db also gives an error.

Besides, these querymethods also don't work

;

INSERT INTO arprsw (inkp_verp) VALUES (3,25)
INSERT INTO arprsw (inkp_verp) VALUES ('3,25')
INSERT INTO arprsw (inkp_verp) VALUES ("3,25")
INSERT INTO arprsw (inkp_verp) VALUES (`3,25`)
INSERT INTO arprsw (inkp_verp) VALUES (3.25)
INSERT INTO arprsw (inkp_verp) VALUES ('3.25')
INSERT INTO arprsw (inkp_verp) VALUES ("3.25")
INSERT INTO arprsw (inkp_verp) VALUES (`3.25`)

**burrug** · 08-15-2008, 02:29 AM

Could it be that there may be a function which is supposed to be used within the query? I already went out looking for it but I couldn't found anything.

Can somebody please help me?