Update totals

[John Burke]

Hye guy's here I am again. I've attached my sample. In the operations, the update order totals, doesn't do anything, not even an error msg. Basically what I want to do is update the amount field in the ord-head, with the calc field cust_total, which is on the charges tab of the load sheet add2 form. Through another operation these totals will update the invoice table. When I put the op in design mode and look at the Xbasic code, is there a way to modify the code in that window. tks for help jb

[Stan Mathews]

RE: Update totals

Hi again, no it isn't.

"When I put the op in design mode and look at the Xbasic code, is there a way to modify the code in that window." - No, but you can save the code as a script, modify it on the code tab, and run that script rather than the saved operation.

[John Burke]

RE: Update totals

Hi Stan, thanks for the reply, tried that, still wouldn't run. Did my file not attach when I sent the thread?

[Al Buchholz]

RE: Update totals

John

Your file did not attach.

[John Burke]

RE: Update totals

Here is the file, I already attached to another thread, looks like that thread was deleted. tks Al

[Stan Mathews]

RE: Update totals

Close but not quite.

We need at least one more table, maybe more. The attachment you posted is missing the recvr table. There may be more missing if they are part of the order.set. It is not possible to view the structure of the order.set with one or more tables missing so I can't tell if recvr is the only needed table.

Attaching a screenshot which indicates some of the missing tables (pale icons).

[Stan Mathews]

RE: Update totals

Sorry, the attachment this time.

[John Burke]

RE: Update totals

Thaks Stan, here is the att with only the tables that make up the order.set. jb

[Al Buchholz]

RE: Update totals

John

That's the same file that you sent before........

No more, no less.

[John Burke]

RE: Update totals

Hi Al, have you tired opening the order.set, there's no tables missing that I can see. I'de sent the whole DB but it's too large. Mayble I'll just copy the DB to another directory and delete all the tables that are not connected to the problem. tks jb

[John Burke]

RE: Update totals

Here we go one more time. Copied the DB to another dir and stripped it down. New name is sample disp. Everything should be there now. Please feel free to put ur 2 cents into any direction I may be going astray. tks jb

[Stan Mathews]

RE: Update totals

I changed the "Select records" from "Current Selection of Records" to "All Records" which seems more appropriate in view of the condition you have specified in the update.

The update seems to run fine with that change.

[John Burke]

RE: Update totals

thank you stan, I didn't use the genie to create the update, went directly to create, which doesn't give you a choice of record selection. tks again jb

[John Burke]

RE: Update totals

hey guru's, keeping this thread open will help me a lot. Can someone look at the code for the form Load_sheet_add2 in the fetch event, and then look at the sequences for the invoice orders btn on the form. I need the events to show the dispatch as posted, when the events have run. All the op's work the way they should, but it doesn't put the posted status as .t. Still on my learning curve, think it goes round the moon. tks jb

[Tom Cone Jr]

RE: Update totals

Actually, John, switching to another topic inside the existing thread is not advisable. The new topic is practically invisible to other users. You'll get better exposure limiting each question to a single topic.

-- tom