Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
1
Web Server - Ask For Help / Re: Updating a Table From a Browse Based on a View
« on: June 09, 2011, 10:57:18 AM »
After some additional debugging, I think I've found the simplest solution:
I embedded the following line in the update procedure in "Processed Code" at the very top:
The problem with the other tips is that they revolved around session variables while the update logic seems to use the value queue to obtain the primary key value... I had to add some code to dump both the session variables and value queues while examining the NetWebServerWorker class to arrive at the fix.
I embedded the following line in the update procedure in "Processed Code" at the very top:
Code: [Select]
p_web.SetValue('CGP:SysIdCGP',p_web.RestoreValue('VGP:SysIdCGP'))
The problem with the other tips is that they revolved around session variables while the update logic seems to use the value queue to obtain the primary key value... I had to add some code to dump both the session variables and value queues while examining the NetWebServerWorker class to arrive at the fix.
2
Web Server - Ask For Help / Re: Updating a Table From a Browse Based on a View
« on: June 08, 2011, 10:49:50 AM »
Perhaps I need to be a bit more specific...
The name of the backend view is VwGroups and is defined in Clarion as a table with the prefix VGP.
The underlying table is called ContactGroups, also defined in Clarion as a table with the prefix CGP.
The primary key in the view is then VGP:SysIdCGP whereas the table is CGP:SysIdCGP.
Somehow, I need to set CGP:SysIdCGP to the value of VGP:SysIdCGP and pass it to the update form instead of VGP:SysIdCGP since it is the proper primary key for the table.
How does one do this?
The name of the backend view is VwGroups and is defined in Clarion as a table with the prefix VGP.
The underlying table is called ContactGroups, also defined in Clarion as a table with the prefix CGP.
The primary key in the view is then VGP:SysIdCGP whereas the table is CGP:SysIdCGP.
Somehow, I need to set CGP:SysIdCGP to the value of VGP:SysIdCGP and pass it to the update form instead of VGP:SysIdCGP since it is the proper primary key for the table.
How does one do this?
3
Web Server - Ask For Help / Updating a Table From a Browse Based on a View
« on: June 06, 2011, 08:36:35 AM »
I have a browse that is from a back-end view that comprises a few columns from a table, (Table1) and some aggregates; let's call it VwBrowse1. The back-end view is non-updatable.
So, when the user clicks on the insert, update, or delete buttons, I need to get it to update the underlying table for the view, (Table1), not the view itself (VwBrowse1). I've looked all over for a way to do this, but can't seem to get it done.
Anyone have any tips for me?
Thanks,
-Brian
So, when the user clicks on the insert, update, or delete buttons, I need to get it to update the underlying table for the view, (Table1), not the view itself (VwBrowse1). I've looked all over for a way to do this, but can't seem to get it done.
Anyone have any tips for me?
Thanks,
-Brian
Pages: [1]