Form entry and browse box refresh automatic


#1

Hi,
I just create an invoice form. I choose the insert another record option on message and titles. The scenario is when the record were inserted the browse box of the invoice will refreshed so the record inserted can be shown. I try many ways but still don’t succeed. Hope there’s anyone can help.

Thanks,

Joe


#2

How are you inserting the new record?
If you’re using the standard templates then the browse should update automatically.
If you’re adding the record yourself eg using prop:sql then you’ll need to tell the browse it needs to update.
How you do that will depend upon which template set you’re using ie ABC or Clarion (AKA Legacy)


#3

Dear Graham,
Actually I use the standard template. So from the browse procedure I call the update procedure to insert, update or delete the record on the browse. And I change the way of the entry form of saving the record by changing the option on message and titles of After successful insert into insert another record. So the entry process can continue without exit the form. the question is it possible the browse can be display automatically the record that has been saved without closing the entry form? I need to make a POS system so by those way the user can see the record that has been entry.

thanks,

Joe


#4

:point_up: Like me…

Uncheck “Insert another record” from the form and add that code into following embed.
Browse Window / Run PROCEDURE(USHORT Number,BYTE Request)

IF Number=2 AND ReturnValue=RequestCompleted THEN ! Number 2 is your Form number
! Do whatever you want. ResetSort or Calculate form etc
IF Request=InsertRecord THEN POST(EVENT:Accepted,?Insert). ! Recall subform again
END


#5

Dear SerhatSatir,
Could You tell me more detail? I’ve try but haven’t success yet…
Where should I put those embed?

Thx

Joe


#6

On Browse Window
Window / Run (USHORT Number, BYTE Request) / Priority 8500
IF Number=2 AND ReturnValue=RequestCompleted THEN
DO CalcForm
IF Request=InsertRecord THEN POST(EVENT:Accepted,?Insert).
END

I can fix it for you, if you give me a remote access or send me your source code…


#7

You can find example on Students browse/form working as you wish…
SCHOOL.zip (322.0 KB)


#8

Ok…can you tell me your email address?
thx


#9

Dear Serhat,
My Clarion is 6.3 version. and …I can’t Open the file…

thx


#10

Oh, what a pitty! I don’t have 6.3 no more. Could you give me AnyDesk ID?


#11

there’s no dictionary file too…on the file…


#12

It was original school example. This attachment also has DCT file.
SCHOOL.zip (363.6 KB)


#13

What version of Clarion can open the app?

thx


#14

Clarion v10.0.12799…


#15

can u downgrade the app into 6.3 or 9 so I can open the file?
thx


#16

I did it with SCHOOL.zip (262.0 KB)
Clarion9.1…


#17

Dear Satir,
I Just Install Clarion Ver.10 12799 but still cannot opened. It tells that the app can only open with the ver 11.

Thx


#18

Dear Joe,

I sent screen captures. That would be better for you.
If you have trouble, please give me Anydesk ID for remote connection.

Kind Regards,
Serhat

Application Tree

Browse Embed

Embed Detail

Form


#19

When will you available to remote?


#20

Let’s talk over email. [email protected]