Code minus 1

[rianeiromiron]

Hi all!!!

I need to retrieve data from a SQL database.
I have already established the connection, and I am able to copy the data in the sql table to one local table, using the following code

ConnStr = 'dsn=MYSQL;uid=myuser;pwd=mypassword'
Handle = SQLStringConnect( ConnStr )
SQLExec ( Handle, "SELECT * FROM MYTABLE" )
COPY TO MYLOCALTABLE

Something strange is happening:

Correct data is the following

PersonalCode Name
10 Peter
11 Erick
12 Travis
13 Elliot


and so on.....

on MYLOCALTABLE I get

PersonalCode Name
9 Peter
10 Erick
11 Travis
12 Elliot


So, the codes I get are the real codes minus 1.

Any ideas on what's going on?

 

[rianeiromiron]

One thing else:

This seems to be affecting only those records whose Code
is greater than 9999. I wonder if it has something to do with the resulting table (the temp sql file created by fox) which length is an integer(4). If that would be the case, meaning, that is what is affecting the 5 digit codes, what would be the method to establish a greater length, (say numeric(10)) in the resulting table????????

 

[Mike Lewis]

Rmiron,

Are these codes stored in strings or numerics?

Can you try doing the SELECT within MySQL? That will tell you whether it is VFP or MySQL that is at fault. (I don't know if MySQL has a console where you can enter commands, like SQL Server has.)

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[rianeiromiron]

Thank you Mike!!!! I feel so stupid. I was using the wrong field. Thanks for your time and response, anyway.

Bye