Discussion Board for collaboration on QlikView Scripting.
I try to load data from dbf file (FoxPro)
but have 2 problems
1) when loading data from table "filed id problem double" there are filds - id -'customer id' and descr-'customer name'
in sourse table -every thing is ok- every customer has a unic name, but when Ioad data to QlikView with FoxPro driver - something changes
and some customers have the same id (see attached application test id).
2) I when loading data from table 'filed doesn't load sp1279' in QlikView there is no filed sp1279...
see application test field
Go to Solution.
The problem was in field id.
we loaded id '2e2' then the value was loaded to exponetional 2,00E+01 and then transfered to '20',
anothe id had value '20' and QV combunet 2 ids into 1.
so the solution was to load id as text.
see attached file.
If you do a preview of table 'filed doesn't load sp1279', field sp1279 is empty, so the script is working just fine. So where is the problem? Can you please elaborate?
EDIT: Field sp1279 is empty in both tables.
Miguel Angel Baeyens
Comex Grupo Ibérica
if you open dbf table with another viewer, then you will see the filed
we found several ways to solve this problem
1) To create small dbf with another charset that driver understand
2) to reload dbf file to a txt and load data from there- them there is no problem.
but we a still looking for another driver..
what version of visual fox pro (VFP) do you have ?
i'm trying to read .dbf database table of VPF 9 but the odbc driver asking me for .dbc file (
SQL##f - SqlState: S1000, ErrorCode: 171, ErrorMsg: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file d:\vfoxprotest\anagrafe\private.dbc.
SQL select * From `anagrafe.DBF`
I don't have .dbc file but only .dbf, .fpt and .cdx
Can you help me ?