Frequently Updating section access

[#1]

Hi.

What is the best practice to update section access frequently?

I need to update user access information at least twice a day. I am using QV 8.5 and was told not to use

partial reload because of its unusual(?) behavior from other users.

I believe it is the best to upgrade to 9.0 and use incremental load but till then, what will be the best way

to deal with it other than reloading all data which will take an hour?

Thanks,

Ryan

[#2]

Hi Ryan,

Have you figured it out?

I tried a partial reload in QV9.0, but it didn't work. See my code below.

Regards,

James.

Section Access;
LOAD
ACCESS,
NTNAME,
COMPANYCODE
RESIDENT AUTO;
// Partial reload section access
REPLACE ONLY
Section Access;
LOAD
ACCESS,
NTNAME,
COMPANYCODE
RESIDENT AUTO;

[disqr_rm]

Why don't you load all the data in intermediate qvw, say datamodel.qvw, and then in your app.qvw you load the section access & binary load from datamodel.qvw?

Binary load should not take an hour to load, so every time you change section access records, just reload the app.qvw.

Would this help?

[#4]

Yes, using a binary load is the only possibility for updating the section access quickly. Thanks!

[#5]

Your can try replace load in section access and load in section application.

[#6]

I dont understand the replace load function, if it is used for you security section, what happens to the other tables???