Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I inserted the word REPLACE before the LOAD of a specific table
CATEG_CLI:
Replace LOAD Category as Customer_Category,
capitalize (Description) as Description;
SQL SELECT Category,
Description
FROM "MA_CustomerCtg";
because I want to load it by myself, via a button that I have set as follows:
Action: Reload data
and then I selected PARTIAL RELOADING.
When I press the button, however, I am told that the partial upload failed.
can you tell me, please, where am I wrong or if there is a bug?
thank you.
I have always used an IF/THEN/ELSE clause in my code to wrap my full loads vs my partial reloads. Check out the IsPartialReload() function. That way I can clearly set variables and only load the data I want to for a partial load to avoid any issues and ensure that I only reload the data for the tables I need absolutely latest data from.
thank you. I would, however, need a partial upload via a button. So, when developing the apps, I only load the table data that interests me.
By the way, when scheduling uploads, it's not clear to me how I go from partial to full upload.