Form flashes and disappears

[George Corder]

I am using the following code which displays the form in debug mode and the form remains visible, but when I run the code without debugging, the form just flashes and then it is closed and I am back to the starting form. Could you point out the problem please.


tbl=table.current(2)
f=form.load("trans entry")
this_rec=alltrim(str(tbl.recno()))
f:Tables:bonds.filter_expression="recno()="+this_rec
f:Tables:bonds.order_expression=""
f:Tables:bonds.query()
f.resynch()

f.activate()
f.show()
this.enable()
parent.hide()
end

[Shelly Kiefer]

RE: Form flashes and disappears

It looks like you don't want the user to be able to do anything with the original form until they've dealt with the second form? That would be better served with a form.load using the 'dialog' parameter (See the Alpha Five Xbasic Reference Manual, Dialog Boxes chapter). Try this instead:

tbl=table.current(2)
f=form.load("trans entry", "dialog")
this_rec=alltrim(str(tbl.recno()))
f:Tables:bonds.filter_expression="recno()="+this_rec
f:Tables:bonds.order_expression=""
f:Tables:bonds.query()
f.resynch()

f.activate()
f.show() 'with the "dialog" parameter, your script will pause and the 1st form will be inactive until the user closes the 2nd form
f.close() 'you have to close the 2nd form with xbasic here.
end
Shelly

[Tom Cone Jr]

RE: Form flashes and disappears

George,

Looks like you're trying to use a called form to edit a single record in the child table of your current set.

If so, here's an example I've whipped up for you.

Unzip this to a separate folder. Do not mix it with your development work.

-- tom

[JerryBrightbill]

RE: Form flashes and disappears

George

Tom's method is more elegant than using a query, but your query method does work. However, I question the need for the this.enable(). What is "this" referencing? "This" is a relative reference which could be shifting focus back to the parentform. Another possibility is that the query isn't finding a match. This initially seems unlikely since your are obviously searching using a value that exists in the child table, but there are some possibilities. First, is there any filter on the form you are calling? Second, do you have referential integrity turned on for the set? This will lock the child records, which could prevent the query from running correctly.

Frequently, we assume that the problem is always in the script that causes the error, but it can be in anything that is referenced by the script.

Jerry

[George Corder]

RE: Form flashes and disappears

Thank you all for the help and suggestions.

[Michael Humby]

RE: Form flashes and disappears

The last line of your script

parent.hide()

I think this will cause the form to hide itself.

Michael