ODBC to DBF files / Filtering Deleted Records

[#1]

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 !

[rbecher]

Hi,

can you post or send an example DBF file?

- Ralf

[#3]

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

[andries_bos]

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...