Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...I always seem to find what I need in previous threads without starting my own. I have started a couple but that's it..."

Geography

Where in the world do Tek-Tips members come from?
jisoo22 (Programmer)
14 Aug 01 15:41
Hello people!

I have an update page made with Ultradev but it has one little problem.  Whenever I make changes to the record, it gives me an error message sayiing that the field linked to the primary key can't be updated.  I know this cannot be updated so I don't even touch it but the page tries it anyway, even with the same record number.  Is there any way to make the page leave that field alone?  I just want the thing displayed with the record.

Thanks,
Jisoo22
Microbe (Programmer)
27 Aug 01 0:06
WHy not go into the code and delete where it tries to do the update to the primary key field?  

Depending on which version of UD you are using you will have to remove it in either two places (UD4) or one.

Steve Davis
hey.you@hahaha.com.au
http://www.hahaha.com.au

jisoo22 (Programmer)
13 Sep 01 15:18
I'm running UD4, do you know which places have to be deleted?

Thanks,
Jisoo22
Cheech (TechnicalUser)
14 Sep 01 3:35
Post your code.

Live long and make your kids suffer..

trc (MIS)
17 Sep 01 21:32
Also check to see if (1) field names are reserved words (2) the data are matching types (Sumitting as text and field is a data) and (3) the data you are submitting has special characters in it. I jsut had the battle with the reserved word issue and have had the problem of the others. May the force be with you.

************

Caution, dates on calendar are closer then they appear.

Kactus (MIS)
18 Sep 01 0:27
Insead of man-handling your nice, clean Macromedia code why don't you just not include the Primary Key in the record set (passive voice - word grammar checker would get me for that)?  

I believe the MM code only updates the fields you've specified so when you're creating your record set just remove your PK from the list of fields to return.  If you don't want to recreate your record set because you have a bunch of stuff hanging off it or something, you can edit it by double-clicking it under 'server behaviours' (I think that's where it is).  The dialoge box appears and you can remove your PK.

Ta-da!

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close