Memory Form - Another Tip

[charl99]

This is, without a shadow of doubt, the best trick I've learned in all my non-existent NetTalk days.

All my file structures and stuff is pretty complicated.  Almost nothing is a simple update or insert, although I tried that with limited success.

So now I put a Button on the Browse row, and use the Memory Form, In the Pre Update -> End Routine I do something like the following:

do openfiles
get all the related files
p_web.FiletoSessionQueue(all the files)
do closefiles

NetTalk handles the forms and stuff, easily.

and in the ValidateAll Routine

do openfiles
p_web.SessionQueuetoFile(all the files)
Do Inserts, updates, deletes, whatever based on a Session variable on the Form
do closefiles

And on the Browse with the Button that calls the Form, just turn on the Refresh whole Browse after server code runs.

I would have saved myself massive head aches if I knew this before.  I can’t wait for my next complicated task…

Hopefully it will help somebody out there!

Cheers
Charl