Set focus on repeating section row in Xbasic while looping through rows

[coleresources]

Re: Set focus on repeating section row in Xbasic while looping through rows

Really cool!

[mikeallenbrown]

Re: Set focus on repeating section row in Xbasic while looping through rows

whoa! ....that's some code!! I think i was going cross eyed about half way down.

[kingcarol]

Re: Set focus on repeating section row in Xbasic while looping through rows

You think my code makes YOU cross eyed, Mike.... I'm not sure I have eyes to cross anymore...

[TheSmitchell]

Re: Set focus on repeating section row in Xbasic while looping through rows

Actually, I thought it was very well formatted and easy to read. It would have taken me a lot longer to find your issue if it wasn't so nicely typed. :D

[GGandhi]

Re: Set focus on repeating section row in Xbasic while looping through rows

I am happy to that you solved your problem and the code is very nicely written and I understand what you are doing, but I have a silly question.
when you start off after selecting the customer you go to the server and fetch all the bills etc and when all the fields are filled you go back to the server to see if it is over the budget to fill a warning and asking them to skip or go ahead submit anyway, for a third time to reach the server.
why is it not possible to get all the information about the customer at the first call itself and then do the math in the dialog without a server call and put up the alert box and popup window and then submit or cancel the bill payment? is that not possible in your scenario?
looks to me, you are constantly calling the server!

[kingcarol]

Re: Set focus on repeating section row in Xbasic while looping through rows

Ghandi, when the vendor is first selected in drop dow box, i use Fill to get info about the vendor,...insurance expirations, waivers outstanding, defaults for bill, 1099 staus and more, but until the user enters the bill info a bill, I don't know what job and cost code user will enter. Checking over budget has nothing to do with vendor. I have to gather info from a budget table, change orders table, and actual costs table to determine if the bill entered will be over budget. Then I do check PUrchase Orders issued to vendor for the job to see if bill will go over POs issued. I also check for Change Orders for the job and cost code because they might need to do something different with the job markup percent for that. Users often enter several lines for different jobs and cost codes for one vendor. I was calling back to check for overages as user made changes on each line so decided to limit that by checking for overages only once when user clicks Submit. Job costing and posting all the double entry accounting in home building industry is quite complex and just requires a lot of callback. This was attempt to cut down on them in this heavily used part of the program.

[GGandhi]

Re: Set focus on repeating section row in Xbasic while looping through rows

ok, now I see. it is lot of checking to do.
makes sense.
(all accounting systems are double entry, single entry systems, the Ferengi way, are prone to errors in mild manner of speaking. )

[kingcarol]

Re: Set focus on repeating section row in Xbasic while looping through rows

I don't know why I mentioned double entry accounting. I guess because I don't get to just submit records to a table. I have to use Xbasic to append one side of records and then the accounting offset of the record. Referring to how much callback is required due to things like that...

[kingcarol]

Re: Set focus on repeating section row in Xbasic while looping through rows

never mind... deleted

[Tim Kiebert]

Re: Set focus on repeating section row in Xbasic while looping through rows

ok, now I see. it is lot of checking to do.
makes sense.
(all accounting systems are double entry, single entry systems, the Ferengi way, are prone to errors in mild manner of speaking. )