Updating data from a view with AppM generated application


When creating web-site from a very simple PDM View in Appmodeller,
resulting web pages do not allow updating - although Updateable was
toggled on in the model generation options. I understand that updating
from some Views may be difficult owing to complexity of the code, and
hence may be beyond the software. The test  I tried only included one
table with two fields.

Am I missing something obvious?


Tony Pfitzner

3/2/1998 4:15:06 AM
sybase.powerdesigner.general 9408 articles. 1 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 51

Tony Pfitzner wrote:

> Hi
> When creating web-site from a very simple PDM View in Appmodeller,
> resulting web pages do not allow updating - although Updateable was
> toggled on in the model generation options. I understand that updating
> from some Views may be difficult owing to complexity of the code, and
> hence may be beyond the software. The test  I tried only included one
> table with two fields.
> Am I missing something obvious?
> Regards
> Tony Pfitzner

Hi Tony,

I'm afraid you're not missing anything.  AppModeler for the Web, in its
current release, doesn't allow view updates, regardless of  the
complexity or simplicity of the view.

However, to work around this limitation and allow updates for simple
views (that is, views based on a single table and containing the primary
key), you can create another model containing a table with the same name
as your view and the same definition. Then use this model to generate
Web pages based on your view-table. It's not convenient but it
works...(Of course, don't use this model to generate the database

Howie Friedman

3/6/1998 2:35:18 AM

Similar Artilces:

Updating in Grid-View Data in Dynamically Generated DataSET
I am very new to ASP.NET 2.0 I have TableA (from DB) which is transform into TableB. Columns in TableB is dependant on unique data entered in one of TableA's row. In short, TableB columns are not fixed. I am using GridView (with Auto-generate Fields) and it has ObjectDataSource (ODS1). One of the ODS1 function returns TableB in a dataset that GridView shows. Now I want to enable-edit. Edit requires that I have a update function used by objectDataSource that takes in all the columns used in the dataset. The problem is columns are not fixed. So i cannot write a function. Thus, I rightly get a...

SQL Views
Hello, I've just discoverd the wonderful SQL Views function. So far its working great for displaying data from multiple tables. Now I'm trying to capture the data being displayed and insert or update the data into another table. I've done inserts and updates many times on a static tables but running into a snag on how to code this in a Stored procedure to first execute the View, display the data into a gridview etc... but in the same statement insert or update the View data into a assigned database. Now its gets even more difficult ... I'm using CASE statements in my current...

Cannot Update Using The Grid View, Details View, Or Data List
Ok I've searched and searched and read and read and played with this for hours, now I'm fed up and am bagging anyone with some database experince to help me out on this one, it just seems so simple but its turning out to be so hard....I am working on a very simple user page where they enter some contact information about themselves (eg. Name, Phone, City, Country) At first I just wanted to use a table and in one cell place regular text (eg Name) and in the row beside it place a TextBox then bind that TextBox Entry into a database table but since I have no idea how to do that I figure...

How to make the width of Detail View control consisten when updating, viewing or inserting data?
I have a DetailsView control on my website, and I notice when I edit, insert or simply displaying a record, the width of the fields vary. To make them consisten, I converted all of the fields to templateField, and had to change the 'width' property for each field within each template (ItemTemplate, EditTemplate, InsertTemplate). Is this the best or most efficient way of standardizing the DetailsView field widths? Perhaps there is a way to simply state the width once and all fields within DetailsView will inherit that value?Thanks, for more granular control over your detailview layo...

Updating client data when server data is updated
I am curious if there is a prescribed method(s) of notifying a network client application (written in C++) when changes are made to data residing on the server they are connected to. regards, jeff No there is no prescribed way of doing that since there is not a mechanism in the client/server paradigm that works that way. In some specific situations (in a RDBMs client/server context) one could have connections block on another connection's record lock while ?something? is pending. Then the commit/rollback would effect the 'notification' that an event has occur...

Update not updating data
 Hello,     I'm using VWD 2005 express and I'm having trouble updating a table. I'm using an SQL data source with the following SQL:SELECT Category, FirstName, LastName, Email, ActName, Country, StateProv, City, Description, Phone, Web, City1, City2, City3, City4, City5, City6, AllCities, LowPrice, HighPrice, Per, Nation, InterNation, TravRad, TravMeasure, Active, Intro, UserID, UserName, ActID FROM MainAct WHERE (UserName = @UserName)UPDATE MainAct SET [Category] = @Category,[FirstName] = @FirstName, [LastName] = @LastName, = @Email, [ActName] = @ActName, [C...

update data in detail view
    i have a gridview in aspx page & it cintain hyperlink which nivigate to another page by passing the ID to another aspx page which contain DetailView with quert string that will  be linked to the brevious gridview by the ID when i try to Edit the data in this DetailView and after click update the page referesh but nothing display on it, the Detail View doesn't display so what to do ?  Hi Energyof10, You may forget to rebind DetailsView after updating. You can do this at the end of the event which is fired by clicking updat...

generate scripts for data updates?
Hi, I am wondering if there is a way in SQL Server 2005 to generate scripts for data updates, i.e., after rows are added, deleted, or data has been changed. Thanks in advance.  generate scripts for data updates?can it be more specific?  gregale.NET, implico.de Suppose I have a table in a SQL Server database, I added some rows, and then deleted some rows, and finally modified certain values on some other rows. Is there a way to generate a single script for all these changes by Sql Server (or some 3rd party add-ins) so that I can use this script to apply the exac...

How to reload view after data update
I have a page that let user update information. This page contains a multiview which has 4 views, on page load, I have view1 active. When user click on Update button to complete the update, information is all correct, but my multiview is hidden. How can I make it display the same when it was first loaded? Than you! My page load function is the following:Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim mv2 As MultiView = FormView1.FindControl("MultiView2")Dim vDisplay As View = FormView1.FindControl("ViewDisplay") mv2.S...

viewing reports generated by powerdesigner
We have 2 pc's in the office 1- Windows 98 with Microsoft Office 97 Oops - fat finger problem. We have 2 pc's in the office 1- Windows 98 with Microsoft Office 97 2- Windows 2000 with Microsoft Office 2000 When we view an rtf using Word or view htm from IE, the diagrams are much smaller using pc #2 (Windows 2000). It seems as if the margins are extra wide (another 1/2 inch than pc #1). The same rtf and html is viewed on each pc. On the rtf, we can manually increase the size of the diagram, but we would rather find a setting in windows or office to make the ...

We are currently using PowerDesigner 6 to convert an Informix database to Oracle 8i. We were hopimg to generate some test data by creating a script from the existing Informix database using the dictionary/profile option and the database/generate test data option. Unfortunately the options only seem to allow one column of data to be extracted. If more than one column is selected (e.g. select * in the sql window) then the 2nd and subsequent columns are populated with data from the first column. Is this a bug or is there a work around or is there an alternative product that uses P...

Generating PowerBuilder Applications from Data Model
A few years ago I used a version of PowerDesigner (perhaps AppModeller) to generate a functioning PowerBuilder application directly from a physical data model. It was fine for editing static data. I now have PowerDesigner 9.5.0 and want to do it again for static data. I can't find how to do it in this version of PowerBuilder. Any ideas? The functionality of AppModeler was not carried forward to PD 7, 8 or 9.x. However, using the 9.5.2 release, you are able to generate and reverse engineer PB extended attributes in the PDM. In the OOM, you can now reverse engineer your entire...

Problem while updating data with Grid View
Hey , I am having gridview where I have set select and update command and both are of type stored procedure. Select command works fine but when I try to update the contents of the grid it is giving me following error.Procedure or function UpdateAssetIssued has too many arguments specified. This procedure takes three parameters which I am setting it like this. sqlds1.UpdateCommandType = SqlDataSourceCommandType.StoredProceduresqlds1.UpdateCommand = "UpdateAssetIssued"sqlds1.UpdateParameters.Clear()sqlds1.UpdateParameters.Add("GroupId", System.TypeCode.Int64, AllModules.mGroupID)sqlds1.Upda...

Viewing and updating data
Hi I'm retrieving data from an access database and want to display it on a form.Then I want to be able to change the data and update the database. I'm currently using a Datalist with Textboxes and labels. Are this the correct method or should I use another approach? ThanksMarno Have you thought about DataGrid?Best regards, LesioS Yip Datagrid's the best. ThanksMarno...

Web resources about - Updating data from a view with AppM generated application - sybase.powerdesigner.general

Application - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Pre-Christmas job application rush hits Australian public service
Speed required for pre-Christmas job window opening for public servants. Check out who is hiring.

Cloud application adoption increases 71 percent in 2015
The adoption of cloud applications is soaring, up by 71 percent in the last year according to the results of a new survey. The latest Cloud ...

NASA is accepting astronaut applications, and this quiz will tell you if you qualify
... gone before, then you might want to sign up to be a NASA astronaut. On Dec. 14, for the first time in four years, NASA began accepting applications. ...

MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey, Purchase Applications up 34% YoY
From the MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey Mortgage applications decreased 1.1 percent from one week earlier, ...

German-Based Spirea Promotes Decentralized PV Applications In Uruguay
... Its technical operations specialist, Laurie Lawrence, pointed out that Uruguay [&hellip German-Based Spirea Promotes Decentralized PV Applications ...

ZTE to develop smartphone application processors in house
ZTE has stepped up its efforts to internally develop smartphone chipset solutions, aiming to re-capture the title as one of the top-three smartphone ...

Pre-K Applications Begin Jan 25, a Month Earlier Than Last Year, City Says
The DOE has moved the process up to Jan. 25 on the heels of a similar schedule shift for kindergarten. MANHATTAN — The application period for ...

NASA accepting applications for the position of 'astronaut'
Wanted ads aren't usually newsworthy, unless the company is NASA and the job is "going to space." The US space agency has started recruiting ...

IBM Takes on AT&T Managed Application, Hosting Services
AT&T’s networking, security and mobility solutions coupled with IBM Cloud offers companies a fully managed IT environment.

Resources last updated: 12/22/2015 4:01:14 PM