ABC: Updating a Table in Form when browsing a SQL view 1998-10-24 -- Jerry Norman Newsgroups: topspeed.products.c4
>Is there any way to browse one file but have the form update another?
I've done this in ABC. Here's what you will need to do.
1. Pass the highlighted View record's primary key as a parameter from the
browse to the update procedure.
2. In the update procedure (which has the file rather than the view in the
"Update record on disk"), after files are opened embed something like this:
MyF:MyFileId = MyPassedViewId
Access:MyFile.Fetch(MyF:PrimaryKey)
>Is there any way to browse one file but have the form update another?
>
>Specifically I am trying to browse an SQL Anywhere view but update the
>physical table. I was able to do this in 2.003 but it looks pretty nasty
>in ABC.
>
>I wanted to browse the physical file and relate the view to it to pick up
>some of the SQL Anywhere fields that I need (sum(amount)) but C4 gives an
>Invalid Page Fault in C4ODBX.DLL when it tries to go to the form.
>
>This is a cash receipts application. I want the user to enter an amount
>in the header record and allocate it to detail records. SA is totalling
>the detail records in the view. This is the "official" cash receipt. I
>want to be able to show the entered amount and allocated amount on the
>browse and have a tab showing all of the records where the amounts don't
>equal. If you have another angle to approach this from I'm open to
>suggestions.
Printed May 4, 2024, 8:48 pm This article has been viewed/printed 35123 times. Google search has resulted in 44 hits on this article since January 25, 2004. |