Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease add your comments to this article.
Please note that you must provide both a name and a valid email address in order
for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!
Back to article list Search Articles Add Comment Printer friendly Direct link 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.
Today is May 4, 2024, 9:14 pm This article has been viewed 35124 times. Google search has resulted in 44 hits on this article since January 25, 2004.
|
|