How INSERT numeric from textbox?

[warik]

This is the problem:

I have 2 textbox, lets say name (char) and old (int).

When I want to insert is value to SQL, I have a problem, and it said Operator/operand type mismatch.

I use this code to do that:
INSERT INTO mydata (name,old) VALUES ('"+thisform.name.value+"',"+thisform.old.value+&quot INTO CURSOR mycursor

What should I do?

Thank you in advance

 

[torturedmind]

you have to change any numeric data to string so you can concatenate it with other strings.

... + alltrim(str(thisform.old.value)) + ...

but, is that a valid syntax? in vfp6 it's not.

kilroy

 

[bon011]

or you can use this:
transform(thisform.old.value)

 

[warik]

kilroy & bon011, sorry forgot to tell you that the mydata structure is:

name char(20)
old num(3)


So I cannot use str() at this problem.
Maybe someone could help me?

Thank's in advance

 

[Mike Gagnon]

warik

Have you tried this?
INSERT INTO mydata (name,old) VALUES (thisform.name.value,thisform.old.value) INTO CURSOR mycursor

You shouldn't have to use the quotes, and it shouldn't matter if the values are characters or numeric.
Or am I missing something, are you triying to add them together?


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[warik]

You right Mike,
I have to write all my coe for this problem. I would like to use it at my SQLEXEC function.
This is all code:


NumRows = SQLEXEC(myConnection, "insert into mydata (name,old) values ('"+thisform.name.value+"',"+thisform.old.value+&quot", 'MyCursor2')


Thank's