Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thank you very much! Problem solved.