topic ODBC to DBF files / Filtering Deleted Records in QlikView

ODBC to DBF files / Filtering Deleted Records

Mon, 19 Mar 2012 13:04:03 GMT

Hello !

I'm loading records from DBF tables, using the LOAD statement such as the example below :

EDITORAS:

LOAD

EDITORA AS EDITORA_KEY

,NOMFAN

,RAZSOC

,ENDEDI

,COMEDI

,BAIEDI

,CIDEDI

,UFEDIT

,CEPEDI

,DDDEDI

,TELEDI

,RAMEDI

,CONEDI

,RECNO() AS RECNO_DER_EDITORAS;

SQL SELECT

FROM ARQEDI.DBF;

The problem is that this table, ARQEDI.DBF, has DELETED records. On DBF table, deleted records are logically marked as deleted , but they remain on the database upon it's reorganization (PACK).

How do I filter those records during the LOAD process ?

Thanks !

ODBC to DBF files / Filtering Deleted Records

rbecher — Mon, 19 Mar 2012 13:49:45 GMT

Hi,

can you post or send an example DBF file?

- Ralf

ODBC to DBF files / Filtering Deleted Records

Mon, 19 Mar 2012 14:18:35 GMT

Hi !

I have found the answer myself here !

The problem is a ODBC configuration. There's a check box there inside which configures if you load deleted records or not :

Thanks for you answer !

I did a simple kit scenario, outside the original app, and while messing with the ODBC I found the answer.

I could publish on this forum this test kit, however not found the "upload" button for a .ZIP file (or a .QVW). Has this been disabled ? I pretty much miss that simple thing. Also miss the "CODE" font style...

But thanks anyway for your support !

See ya !

Shou

Re: ODBC to DBF files / Filtering Deleted Records

andries_bos — Mon, 11 Nov 2013 15:44:54 GMT

This option (load delected records) is standard turned on on my qlikview Windows 64 bit server but standard turned off on my windows 7 64bit client pc.

Jose, your suggestion helped me to solve this...