I know this is old thread but we can still load only one table by using the "Add" prefix and followed by "Exit Script" keyword. If you add this script at the beginning of your document script then you can load only one table while not touching the rest of the tables. Ofcourse, you need to run Partial Reload instead of normal/full reload. I would recommend using "Only" qualifier to make sure this piece of script is disregarded during normal reload.
I hope this makes sense.
Cheers - DV
please search QV Help for ADD or REPLACE.
Put one of these functios in front of a LOAD or SQL Select statement and use "Partial Reload":
Main Manue => File => Partial Reload
Now only tables will be loaded with an ADD or REPLACE in front of a LOAD or SELECT statement.
Hope this helps.
You can detect if a partial reload is in progress in the script using IsPartialreload().
For example I use section access to control access to the document and when I want to update it I really dont want to have to reload the data as well.
I achieve this using REPLACE and ADD (note that I also have a hard-coded back door in case of a problem with the access control spreadsheet!):
// The access control spreadsheet is secured and is easier to maintain than an inline table.
// Note that * in other than system fields has no real meaning as 'all'.
REPLACE LOAD SERIAL,
FROM $(vRelPath)Access.xls (biff, embedded labels, table is [$(vDocumentName)$]);
// Ensure Administrator access is always possible in case of a problem with the access control spreadsheet
ADD LOAD * INLINE [
SERIAL, NTNAME, NTDOMAINSID, USERID, PASSWORD, ACCESS
*, *, *, XXXXX, XXXXXXXX, ADMIN
EXIT SCRIPT WHEN IsPartialReload();
// Position any SET/LET of variables here that should not be reset by partial reload
Hello, I try to update the Section Access whit partial reload. The command "replace" doesn't work.
It works perfectly if script runs normally. We use QV 11.
UPPER(ACCESS) as ACCESS,
UPPER(NTNAME) as NTNAME,
TEXT("FIELD") as FIELD;
SQL SELECT *
Don't think you can use Partial Reload in the Section Access Script. I might be wrong but I'm guessing this... I don't see any documentation but you can't use Partial Reload between Section Access and Section Application. Instead why don't have you a QVD builder which generates the Section Access script and you can use partial reload in the QVD builder which does the job.