Question for ODBC experts

[Wingamez]

Nice tutorial...but it does not have an answer to my question. It only talks about passing fixed values to DB (I don't have a problem doing that). I had a problem passing a STRING from the Edit Object (solved by using a combination single/double quotes and a "+" sign). And now there is a new problem - passing NUMERICAL values from the Edit Object. No matter what quotes I am using (or no quotes) - I either get SYNTAX ERROR or nothing goes to DB. So, the question is: WHAT IS THE RIGHT SYNTAX I CAN USE TO PASS NUMERICAL VALUE FROM THE EDIT OBJECT TO MS ACCESS DB? See the command: "INSERT INTO TABLE_NAME (PHONE_NUMBER) VALUES (????EDIT VALUE ("PHONE")????)"

[Wingamez]

Nice tutorial...but it does not have an answer to my question. It only talks about passing fixed values to DB (I don't have a problem doing that). I had a problem passing a STRING from the Edit Object (solved by using a combination single/double quotes and a "+" sign). And now there is a new problem - passing NUMERICAL values from the Edit Object. No matter what quotes I am using (or no quotes) - I either get SYNTAX ERROR or nothing goes to DB. So, the question is: WHAT IS THE RIGHT SYNTAX I CAN USE TO PASS NUMERICAL VALUE FROM THE EDIT OBJECT TO MS ACCESS DB? See the command: "INSERT INTO TABLE_NAME (PHONE_NUMBER) VALUES (????EDIT VALUE ("PHONE")????)"

[JasonDarby]

Can you upload an example? That might be easier.

[JasonDarby]

Can you upload an example? That might be easier.

[AndyH]

Most SQL queries will allow you to wrap your data in 'single quotes' like the other example. Have you tried that? Been a while since I used Access.

BTW, a telephone number is usually best stored as text, so you don't loose the starting 0 (a telephone number is not really a number in the sense of 2+3, it's an ID that just happens to be numbers <img src="/center/images/graemlins/wink.gif" alt="" />) but you should also check that the size of your number data type in your database can hold a numeric value as long as a telephone number... maybe it is rejecting it on that?

[AndyH]

Most SQL queries will allow you to wrap your data in 'single quotes' like the other example. Have you tried that? Been a while since I used Access.

BTW, a telephone number is usually best stored as text, so you don't loose the starting 0 (a telephone number is not really a number in the sense of 2+3, it's an ID that just happens to be numbers <img src="/center/images/graemlins/wink.gif" alt="" />) but you should also check that the size of your number data type in your database can hold a numeric value as long as a telephone number... maybe it is rejecting it on that?

[Wingamez]

example is simple:
- make one frame app
- place Edit object in the frame and call it PHONE
- place ODBC object in the frame and set it up for your DB
- create table CUSTOMERS in the DB and make a column PHONE (set it up to be numbers)
- place push button SEND in the frame
in the Event Editor do this: Button SEND clicked? - New Statement + Send SQL Command "INSERT INTO CUSTOMERS (PHONE) VALUES (Edit Value( "Phone" ))" + Get Row. RESULT - Syntax Error in MMF. Remove double quotes around Phone - MMF accepts it but sends nothing to DB. I mean I am trying to send numbers from the Edit Object...should I just send them as a STRING? I am not sure if that makes any difference with DB to have them as text versus numbers.

[Wingamez]

example is simple:
- make one frame app
- place Edit object in the frame and call it PHONE
- place ODBC object in the frame and set it up for your DB
- create table CUSTOMERS in the DB and make a column PHONE (set it up to be numbers)
- place push button SEND in the frame
in the Event Editor do this: Button SEND clicked? - New Statement + Send SQL Command "INSERT INTO CUSTOMERS (PHONE) VALUES (Edit Value( "Phone" ))" + Get Row. RESULT - Syntax Error in MMF. Remove double quotes around Phone - MMF accepts it but sends nothing to DB. I mean I am trying to send numbers from the Edit Object...should I just send them as a STRING? I am not sure if that makes any difference with DB to have them as text versus numbers.

[Harvy]

dude, you can't mix strings and numbers in an expression.
"a" + 3
doesn't make sense to MMF. Just get the string from the edit box instead of a number. It should work fine.

If, for some reason, you ever have to convert a number to a string you must cast it with str$()

[Harvy]

dude, you can't mix strings and numbers in an expression.
"a" + 3
doesn't make sense to MMF. Just get the string from the edit box instead of a number. It should work fine.

If, for some reason, you ever have to convert a number to a string you must cast it with str$()