Cancelling new record entry on embedded browse

[Tom Cone Jr]

Re: Cancelling new record entry on embedded browse

John, it sounds like your script is sending Alpha to lala land. It's time to post a sample of your database here, with instructions for us to follow to see the behavior you're describing. I have to tell you in advance that your form design is the likely culprit. Data entry in Alpha Five is done in tables, not in sets. It's very likely that if you use the default form for your set you won't have the same issues.

[johngtatp]

Re: Cancelling new record entry on embedded browse

True, the resnum is the link field, however, it does not fill in nor is any other record created except within the table in which the data is entered. After a record is created if I view the individual table, the resnum field is indeed blank. If I try to manipulate the data in that table, not in the set form, I can change anything and nothing happens. If I try to create a record in that table, it will not let me leave the record without canceling it. I cannot save it, but I cannot navigate away from the record either, it is quite strange.

[Tom Cone Jr]

Re: Cancelling new record entry on embedded browse

John,

Is the "resnum" field the "link" field in your child table?

If so, remember that your set based form will autofill that field when you begin data entry into any field of the linked table. So, it won't ever be blank.

-- tom

[Ted Giles]

Re: Cancelling new record entry on embedded browse

The Help format suggests that the syntax is
if isblank("t.resnum") then
Is appropriate.
You are testing the content of the Field, not the value.

[johngtatp]

Re: Cancelling new record entry on embedded browse

I have a form based on a set. The top table is a dummy table with a date. There is a one to many browse on the form. There are many fields also on the form from various one to one linked tables as well. If I enter any data in one of the fields from a child record, a record is created in that child table. I tried, as a test, in the child table to use both of the two examples above in the cansaverecord event in the field rules.

Using:
t=this.Table_Get()
if t.resnum<=0 then
this.cancel()
end if

does not stop a record entry if I use a pull down or text box. If I try to edit a field it still does not stop it as I jump from field to field. If I try to close the form, then I get an error:
Property not found
t.resnum subelement not found.

If I try:
dim t as p
t = table.current()
if isblank(t.resnum) then
cancel()
end if

Nothing seems affected in the form based on the set. If I open up just the table itself and attempt to change a record with a blank resnum field I get:

it tells be that isblank (t.resnum) that the argument is the incorrect data type.

I am a bit frustrated here, if anyone has and idea, that would be great.

[Ted Giles]

Re: Cancelling new record entry on embedded browse

Well I'm taking my laptop to work next week, and have V9 and v10 loaded, so gimme a shout if you want to.

[enstorms]

Re: Cancelling new record entry on embedded browse

Sorry Ted. Just now found your reply. The way I sorted it was to just upgrade the app to ver. 10.5. I feel the browse issues with ver. 9 are just too non-reliable to deal with at this time.
Now I'm having an issue with the 10.5 browse, but is just too sporadic to get anyone to test.
Ernie

[Ted Giles]

Re: Cancelling new record entry on embedded browse

Have you got it sorted Ernie? I'm back home and developing a software robotics test management suite as fast as my fingers can press the keys!
Give me a shout if you are still struggling.

[enstorms]

Re: Cancelling new record entry on embedded browse

Ted,
I think I had topparent.commit() on the button that moved to next form. I've moved on to adding records to a browse with a form. I thought once you moved off the browse record, it was automatically saved/committed, therefore making my first sentence un-needed. It's still a mystery to me.
Ernie

[Ted Giles]

Re: Cancelling new record entry on embedded browse

Don't know whether this is covered or not Earnie, but I've added a "Save Record" when moving away from Browses and more importantly, Memo fields. Its easy to lose the data if you don't.

Don't understand why the field rules requiring data doesn't work though.

Thanks for the info Tom. I bet a few don't know about the field "padding".

[enstorms]

Re: Cancelling new record entry on embedded browse

Tim,
Thanks for the idea. I'll put that in my code bank. I can see where it would work if I went directly to the "Next" button, but if I pressed the up key to go to the previous record, it would still enter the blank record. However, I think my code prevents moving off the record to another record with the up/down keys. So only two options, press the Esc key or something other than on the browse itself. Would be nice to be able to code in a pressed Esc key. I think that would solve this whole issue.
Thanks again for taking a look.
Ernie

[Tom Cone Jr]

Re: Cancelling new record entry on embedded browse

Thanks, Tim. Good idea.

[Tim Kiebert]

Re: Cancelling new record entry on embedded browse

tested the following code placed on the CanDepart event of the browse in v9 using your sample and it seems to do what you want.

t=this.Table_Get()
if alltrim(t.stk_class) = "" .and. alltrim(t.notes) = ""  then
    this.cancel()
end if

[Tom Cone Jr]

Re: Cancelling new record entry on embedded browse

Ernie, my preferred solution for this kind of situation is to force the user to cancel or save any pending edits before shifting to a new form. This is made more difficult when one uses a browse object for data entry. I've begun using browses for navigation and display. But then use table based forms when entering or editing a record.

[enstorms]

Re: Cancelling new record entry on embedded browse

Tom,
I thought yours might have been done in v10 since the icon was red. Wasn't sure if it would be different or not. I had thought about your solution, but had read a post in my searching where someone steered away from doing that, so thought I'd see if I could find other options. Guess not with v9.
Really do appreciate your help, as always.
Ernie