Form automatically opens in enter mode

[Victor Rouse]

My form named HospView is based on a 2 table set. I do have scripting language in the OnFetch and OnExit. When I open this form immediately after opening Alpha5, it opens normally in a display mode showing fetch_first record. But, when I close it and open it subsequent times, it automatically opens in an "enter mode"; instead of fetching the first record existing in the set and remaining in a display mode.

I have no scripting on the OnInit script action. Nor on the OnActivate script action.

Anybody have idea of what is going on and how I can fix this?

Victor R.

[Tom Cone Jr]

RE: Form automatically opens in enter mode

Victor, I suggest you open the default form for the set. If records are present in the parent table the default form should open without going into enter mode. If this works correctly, that points to a problem in the scripts in your form.
Something in one of your scripts is causing the form to go into enter mode. Do any of your scripts fetch past the last record in your parent table? -- tom

[Victor Rouse]

RE: Form automatically opens in enter mode

Tom,

Thanks for responding. I reviewed my scripts, but do not see anything that would demand or require the form to automatically open in "enter" mode. But upon opening the form this morning I did find this. In the status bar below I saw the symbol for a query present. Thus, there is no existing records in the query, thus requiring to open into "enter" mode.

I do have a script that runs a query in the OnExit action. Somehow it must be that that query remains active when active or attached to that form when it is reopened again. How do I remove or detach it?

Victor

[Tom Patten]

RE: Form automatically opens in enter mode

Victor,

Try setting the tab order #1 to something other than a field; ie: button, title, etc.

Tom

[Tom Cone Jr]

RE: Form automatically opens in enter mode

Victor,

Yes, you have probably found the culprit. Alpha Five tries hard to 'remember' the last 'view' of your table, so that when you reopen the table, Alpha Five returns you to where you 'left off'. Usually this is of great help. In your case it seems to be causing a problem. If the query returns no matching records the form thinks the table is empty, so it automatically goes into Enter mode.

It seems odd to me that your OnExit script for your form runs a query. Usually, running a query is a preliminary step to other processing or reporting. It's unusual to do this as processing is ending... The simplest solution to your problem may be to not run the query as the form is being closed.

If you will explain more about what you're trying to do in the OnExit script, perhaps other alternatives could be suggested.

-- tom

[Victor Rouse]

RE: Form automatically opens in enter mode

Tom,

In the OnExit script, I am trying to identify those records that have certain logical field value of .t.; mark them; copy them to other files; then go back & delete them. It all works great except that query is applied to that form when reopened later.

I put all this scripting OnExit with the understanding that a person will possibly change that logical field while in this form.

Victor

[Tom Cone Jr]

RE: Form automatically opens in enter mode

Victor,

Ok. After deleting the marked records, have your script reset the active index for the table. Do this by dropping the query from the table using querylistpointer.drop(). Then reset the active index using table.index_primary_put().

-- tom

[JohnZaleski]

RE: Form automatically opens in enter mode

Victor,
Tom's ideas will fix your situation. Are you running this application with simultaneous users? If you are, I would think this could eventually get a little messy. Two users could be exiting at the same time and writing records into your second table at the same time (dupes). Or while one user is deleting records, and the other user is reading the records, you might get some unwanted results.
John