Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
binary load load all tables
if you don't want some of the tables loaded,
after binalry load use
drop tables table1, table2, .....
binary load load all tables
if you don't want some of the tables loaded,
after binalry load use
drop tables table1, table2, .....
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);
Thank you very much, however, i am getting a script error as per the attached. Please assist further.
Regards.
Chris
maybe you try to drop a table and that table doesn't exist
binary load .....;
drop Table TableA, TableB, NotExistentTable;
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
Many thanks, it worked, i had included invalid tables in the drop statement.
Regards.
Many thanks, i had invalid tables in the drop tables statement.
Regards.
Chris
Good job ..
I don't get credit 🙂
Ok noted