close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Using Data Bridge can an update form be created that shows existing values? IE a form to update an existing record from a database

Thread began 11/04/2013 6:39 pm by dvolle228412 | Last modified 11/05/2013 11:46 am by Jason Byrnes | 232 views | 3 replies |

dvolle228412

Using Data Bridge can an update form be created that shows existing values? IE a form to update an existing record from a database

When I create a form with data bridge and then click on the form fields I don't get the option to bind the value to a recordset. The net result is that I can't use the tool to create a form that would allow a user to update an existing record.

Sign in to reply to this post

Jason ByrnesWebAssist

If you use the Data Assist wizard and have it create a Results page and an update page, it will be configured for you.

Sign in to reply to this post

dvolle228412

Using the Data Assist Wizard to to an update eliminates the layout of the custom form.

Originally Said By: Jason Byrnes
  If you use the Data Assist wizard and have it create a Results page and an update page, it will be configured for you.  



Problem is that the form was laid out carefully as a custom form, and I was under the impression that I would be able to make this custom layout work for update too, but apparently I was wrong. Using the custom form interface is very manual and labor intensive, and manually binding everything is even worse. I would have thought that the tool should be equally adept at building an update as an insert since there are very similar. I'm quite disappointed by the slow frustrating interface. If I wanted plain vanilla I would use a rad tool on a Microsoft stack and be done in 1/10 of the time. I thought that these tools would let me maintain a greater degree of design control. I would like to strongly suggest that you add an option that would basically clone an update form from an insert form, or better yet let a user select either insert or update for any custom form. All the fields have to be mapped for the insert, so using that information to map to an update should not be overly difficult it seems. (I realize it isn't a tiny job, but it would improve the usability of the tool an order of magnitude!)

Sign in to reply to this post

Jason ByrnesWebAssist

Ok, You did not include that information in the original post. It is certainly possible to use the update on a manually created form, however, it requires that you have an understanding of how the update process works.


with an update page, you would always have a results page so that you can select the record you wish to update.

The results page will pass the records ID as a querystring variable, for example:
update.php?id=12

on the update page, you need to create the recordset and set it to filter the ID column using the ID recordset.

you can then bind the initial value for the form elements to the columns from the recordset.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...