Export Section Access to QVD

[berndjaegle]

How can I Export Section Access Table to a qvd?

Thnx,

Bernd

[marcus_sommer]

Couldn't you simply use:

store SectionAccess into SectionAccess.qvd (qvd);

- Marcus

[berndjaegle]

was not successful.

[berndjaegle · Accepted solution]

Following works for me:

Create Tmp Table with Section Access Information.

Export table as QVD(!) and reload the QVD with "where 1=1"

tmp_SectionAccess:

LOAD * INLINE [
     ACCESS, USERID, PASSWORD, NTNAME

     ADMIN, admin, 1234, *
     USER, user, , *    

     USER, test, test, MS\SCOTT];

tmp_SectionAccess into TmpSectionAccess.qvd (qvd);

drop Table tmp_SectionAccess ;

SECTION Access;
   LOAD
     ACCESS,
     USERID,
     PASSWORD,
     NTNAME
FROM
Tmp_SectionAccess.qvd (qvd)
WHERE 1=1;