Problem: incorrect loading of fields

[#1]

Hi,

i have a problem with loaded fields that do not match what the original database have. For example:

The original database looks like this:

Usr_ID	Usr_Name
080010	John
80010	Tom

But when I do the load, it changes to this:

Usr_ID	Usr_Name
080010	John
080010	Tom

The Usr_ID 80010 doesn't exists anymore, and the Usr_ID 080010 its associated with both John and Tom, which is incorrect.

The code is this simple:

LOAD Usr_ID,

    Usr_Name;

SQL SELECT Usr_ID,Usr_Name

FROM `dbo_Users`;

Thanks in advance.

PS. Sorry for my english, my native language is Spanish

[#2 · Accepted solution]

My guess is use text(Usr_ID).  Maybe QV thinks Usr_ID is a number (which it is) so it takes the leading 0 off which makes them equal to each other.

[#3]

Thank you very much! Problem solved.