Binary Loading

[Anonymous]

I have a qvw file with images i would like to use in my application.  Is there a way to load the images only without other tables using  a binary load? Or is there another way around this requirement?

Thanking you in advance.

regards

[maxgro · Accepted solution]

binary load load all tables

if you don't want some of the tables loaded,

after binalry load use

drop tables table1, table2, .....

[#3]

if images is just a table in one of your applications. You can STORE it as QVD file then load this new QVD in your script load statement.

STORE Images into Images.qvd (qvd);

[Anonymous]

Thank you very much, however, i am getting a script error as per the attached.  Please assist further.

Regards.

Chris

[maxgro]

maybe you try to drop a table and that table doesn't exist

binary load .....;

drop Table TableA, TableB, NotExistentTable;

[#6]

There could be just an error in your script, a missed semicolon, or a closing braces etc.

Since it is not giving you table name to drop.

Or, After binary load you might be misspelling table names to be dropped.

They are case sensitive, table names field names should matched exactly.

Comment DROP statement and see what is happening and what are the final table names after Binary Load

[Anonymous]

Many thanks, it worked, i had included invalid tables in the drop statement.

Regards.

[Anonymous]

Many thanks, i had invalid tables in the drop tables statement.

Regards.

Chris

[#9]

Good job ..

I don't get credit 🙂

[Anonymous]

Ok noted