close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Insert record with composite key...

Thread began 10/22/2012 6:29 pm by alnico431299 | Last modified 10/23/2012 5:08 pm by alnico431299 | 695 views | 6 replies |

alnico431299

Insert record with composite key...

I use composite keys often (primary keys composed of two or more columns).

Using the Insert Record behavior, the tool requires a "Save inserted ID in Session".
I tested this and it saves a composite key session value of "0".
This doesn't matter as the composite key is made up of 'known' values.
Thus my point...why require the variable be set if it has no use in some instances?
Right now I am labeling these as NAname (NA as in not applicable)...but they muddy up my interface. I am in the process of wiring up table 5 of over 40...I don't want a mess of unusable variable floating around.

Am I missing something here, or can this requirement be removed...let the developer set the variable if they want it.

Thanks,
Brent

Sign in to reply to this post

Jason ByrnesWebAssist

The ID Session will the tables Primary Key. It uses the mysql_insert_id() function to return the Primary key of the record that was just inserted. It sounds like your tables are not using a primary key, even when using a composite key, it is a good idea to use a primary key also.

Sign in to reply to this post

alnico431299

I probably should have said "compound key" instead of "composite key"...however, same issue...same point.
Creating an auto-increment field in all tables is simply not good design. It is easier, but the integrity of the data will be upheld with the use of composite keys when ever possible.

It make no sense to require the variable if the developer won't use it.

Sign in to reply to this post

Jason ByrnesWebAssist

99.99% of the people using Data Bridge create tables that use an auto increment ID in the table design.

Sign in to reply to this post

alnico431299

Good grief man...shouldn't your software be open to all possibilities? The more modular it is the more powerful it will be.
This is simply, removing the requirement for the variable to be filled out (nothing more, nothing less)...this wouldn't screw anybody up or their legacy code.

I bought this software about a month ago...I am surprised you are not receptive to such a simple fix that furthers the robustness of the product.

Brent

Sign in to reply to this post

Jason ByrnesWebAssist

I will put a feature request through.

Sign in to reply to this post

alnico431299

Thank you!

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...