baseportal | ||
Start | ||
baseportal message board | |
Welcome to the baseportal message board... Please read the FAQ.
|
Selected message: | To the list |
Message from Claus on 4/28 2010, 16:46 +01:00Re: Unique fieldsWell, use my passwordprotection2 (Library)...;) http://baseportal.com/cgi-bin/baseportal.pl?htx=/Claus/adresses2 You ca only modify your own entry try it Name: xfce Passswort: xfce Greetings Claus |
|
All messages from this thread: | To the list |
Message from Lucas on 4/27 2010, 15:20 -06:00 EMail: lparuch@ritehite.com Unique fieldsHow can I make a field unique? I want a user to enter a unique serial number. If a record already exists for that number, I don't want a new record created. Another approach, can I change the ID field number to be a unique number of my choosing instead of a sequentially assigned number? Thanks! |
Message from Claus on 4/28 2010, 10:46 +01:00Re: Unique fields
hth Greetings Claus |
Message from xfce on 4/28 2010, 11:34 +00:00Re: Unique fieldsUnfortunately this no way to make the field unique. Its a workaround which only will work with the template it ist built in. >... can I change the ID field number to be a unique number of my choosing No. |
Message from Claus on 4/28 2010, 15:22 +01:00Re: Unique fieldsa german adage means: "better a Sparrow in your hand, than a dove on the roof"...;) Free translation... Greetings Claus |
Message from xfce on 4/28 2010, 14:54 +00:00Re: Unique fieldsCan't see any sparrow. If you need a safe unique reference your approach is incomplete. In addition their is no solution in your posting to secure the unique reference in case of editing a record. The questioner should know this. |
|
Message from xfce on 4/28 2010, 15:53 +00:00Re: Unique fields? Strange context! |
Message from Lucas on 5/7 2010, 10:35 -06:00 EMail: lparuch@ritehite.com Re: Unique fieldsI'm not very familiar with Perl or variables... How am I supposed to use the code you suggested? This is what I have: Thanks! Lucas
|
Message from xfce on 5/7 2010, 18:49 +00:00Re: Unique fields
{ get "Serial==$_put{Serial}", "Inspection"; if ($_amount_query > 0) { $cmd=""; out "Serial Number Already Exists"; } }
|
Message from Lucas on 5/7 2010, 12:57 -06:00Re: Unique fieldsThanks. That displays the message correctly, but still adds the duplicate record to the database. |
Message from Claus on 5/8 2010, 07:39 +01:00Re: Unique fields
if ($_amount_query > 0) { $cmd=""; out "Serial Number Already Exists"; } }
;) hth Greetings Claus |
Messages from 750 to 900: | To the input form |
> Unique fields from Lucas on 4/27 2010, 15:20 -06:00 Re: Unique fields from Claus on 4/28 2010, 10:46 +01:00 Re: Unique fields from xfce on 4/28 2010, 11:34 +00:00 Re: Unique fields from Claus on 4/28 2010, 15:22 +01:00 Re: Unique fields from xfce on 4/28 2010, 14:54 +00:00 |
Re: Unique fields from Claus on 4/28 2010, 16:46 +01:00 |
Re: Unique fields from xfce on 4/28 2010, 15:53 +00:00 Re: Unique fields from Lucas on 5/7 2010, 10:35 -06:00 Re: Unique fields from xfce on 5/7 2010, 18:49 +00:00 Re: Unique fields from Lucas on 5/7 2010, 12:57 -06:00 Re: Unique fields from Claus on 5/8 2010, 07:39 +01:00 |
<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >> |
© baseportal.com. All rights reserved. Terms of use |