Child Table Browse pointer table.current(2) lost

[Mike Wilson]

I am weary searching and reading with this and need some help, please.

I have a 3 table database
Set tables: Customer 1:M Transactions linked via CustID
Alone table: Balances

My form based on the set contains a Browse for the Transactions child table. A button on the form contains a script that passes through a dialog box to acquire a variable (vperiod) for filtering the Transaction table with the outcome being the Browse will display the table filtered to a specific group of records. The script after the dialog box is this:

Script-A:

   dim vcustid as C
     vcustid = parentform:custid.value
   dim tbl as P
 
   tbl = table.current(2)
   query.filter = "period = "+s_quote(vperiod)   
   query.options = ""
   query.order = ""
   idx = tbl.query_create()
   parentform.resynch()
   tbl.query_detach()

This works GREAT but then fails after I run another script (Script-B) that updates the Balances table. Script-B contains several a5_get_records_in_query() events to the Transactions table so I'm believing what must be happening is that a5_get_records_in_query() is opening one or more instance(s) of the table and the designation in Script-A of tbl = table.current(2) must be getting thrown off.

How do I test for which session of the table the Browse is pointed to (? is_obj())? And/or how can I reset this so the Browse pointer is table. current(2)? Or an alternate approach. Thank you.

Mike W

[Mike Wilson]

Re: Child Table Browse pointer table.current(2) lost

Here is the database, stripped down. Red button on form containd Child table filtering script.

Mike W

[Tim Kiebert]

Re: Child Table Browse pointer table.current(2) lost

Hi MIke,

I had a look and found that the problem had some thing to to with A5_get_records_in_query. When I commented out the two remaing instances of those in the Update balance script then the Button to filter the browse worked. I have no idea why this happens. Like you said the browse filtering button works until the update balances script is run. I used a different aproach in the code that filters the browse as a work around though. It uses the following

Parentform:Tables:Transactions.filter_expression = "period = "+s_quote(vperiod)
Parentform:Tables:Transactions.query()

The cust_id does not need to be included in the filter because the set is taking care of that. With this code I was able to uncomment the Records in query test in the Browse filtering scirpt.

In the file attached is a form I was using to test called 'Main_test'. Have alook at the second Update button where I made a couple of suggestions which you can take or leave.

[Tom Cone Jr]

Re: Child Table Browse pointer table.current(2) lost

Mike, why does your script detach the query immediately after running it? Once it's detached what view of the child table should be displayed?

I took a look at the database and do not see Script-B. What am I missing?

--- tom

[Tim Kiebert]

Re: Child Table Browse pointer table.current(2) lost

Tom, the script B is on the Update Balances Button. Once you press it the red button no longer behaves.

[Mike Wilson]

Re: Child Table Browse pointer table.current(2) lost

Tom,
The reason I have an approach to filtering the child table in my circumstance came from your help in this response to this thread. Thank you!

http://msgboard.alphasoftware.com/al...ad.php?t=63086.

Tim,
Thank you seems insufficient. �Looking� at this certainly expended some brain power and I truly appreciate your efforts! I, as you, have a knowing that the issue lies in the A5_get...., but you were aware of a work around. I will study how the code �If .NOT. exist() operates, but I'm thinking it mustn�t open the table and behave as a5_get record_in query()- (a5griq) I thank you tremendously, as one of my premier table probes has been a5griq and in this instance was a solution that generated other issues.

Best regards,

Mike W

[Tom Cone Jr]

Re: Child Table Browse pointer table.current(2) lost

Mike, the highlighted line was not in my earlier example, and is confusing me. I don't understand why you are releasing the query immediately after running it. I don't understand why you don't repaint (refresh display) after releasing the query.

   tbl = table.current(2)
   query.filter = "period = "+s_quote(vperiod)   
   query.options = ""
   query.order = ""
   idx = tbl.query_create()
   parentform.resynch()
   [COLOR="Red"]tbl.query_detach()[/COLOR]

[Mike Wilson]

Re: Child Table Browse pointer table.current(2) lost

Tom,
Yes, of course you are correct. That was a remnant from the many trials of trying things to break the prior query. In process, I thought at one point the tbl.query_detach() did something positive, so it remained. But that was before I discovered that A5_get_records_in_query()was the culprit. The exactly mechanism of how this manifests the problem is still nebulous.

Mike W