|
| |
|
|
williamg
Posts: 20
Joined: 6/26/2003
Status: offline
 |
Database Validation --Experts HELP - 7/20/2004 13:26:51
I have created a Frontpage database and used the Spooky Diet to make all changes, everything seems to be working correct.
However I did set my Access Database with a Primary Key and I said no to Duplicates, but the Form still submits with no error. It pretends to Sumbit but the newest record added doesn'y really get added. (Confused Yet?)
Bascially I want to know how to get an error message went a user submits a record with the same Primary Key.
Like I said the background is working because it will not add the record, but if gives the user no error. It acts as if it is submitting
PLEASE HELP! I know there is some code to enter but where!!!!
Thanks in Advance
|
|
|
|
westy
Posts: 54
From: UK
Status: offline
|
RE: Database Validation --Experts HELP - 7/20/2004 17:58:25
Hi
does it never post a new entry?
does the primary key "auto generate", or does the user have to create it?
Are u using the FP wizzards or ASP directly?
Dave
_____________________________
WESTY
| |
|
|
|
edmund
Posts: 63
Joined: 2/3/2004
Status: offline
|
RE: Database Validation --Experts HELP - 7/21/2004 3:26:59
I seem to have the same problem, I also did the same procedure... placed the code on diet.
I did mine using FPW and set the primary key to No duplicates. the primary key in my table is user generated.
Hope someone could help...
| |
|
|
|
edmund
Posts: 63
Joined: 2/3/2004
Status: offline
|
RE: Database Validation --Experts HELP - 7/21/2004 4:43:22
quote:
to display records from this database
Hello Spooky,
yes, I can see the records inside the tables and can display them as well
| |
|
|
|
edmund
Posts: 63
Joined: 2/3/2004
Status: offline
|
RE: Database Validation --Experts HELP - 7/21/2004 4:52:40
No, I did not use any reserved words or special characters.. the fields I used was emp_no, Question_1....Question_31, supervisor and the rest of the fields are the FP generated ones.
| |
|
|
|
williamg
Posts: 20
Joined: 6/26/2003
Status: offline
|
RE: Database Validation --Experts HELP - 7/21/2004 8:39:25
quote:
ORIGINAL: westy
Hi
does it never post a new entry?
does the primary key "auto generate", or does the user have to create it?
Are u using the FP wizzards or ASP directly?
Dave
quote:
does the primary key "auto generate", or does the user have to create it?
Are u using the FP wizzards or ASP directly?
New Entries are created No Problem! The Primary Keyt was autogenerated in Access as 'ID' however I changed it to reflect my primary key.
I used FP Wizard to Create all ASP then used the Spooky Diet to edit.
Thanks for the reply
| |
|
|
|
williamg
Posts: 20
Joined: 6/26/2003
Status: offline
|
RE: Database Validation --Experts HELP - 7/21/2004 8:42:10
quote:
ORIGINAL: Spooky
Are you able to display records from this database
Yes I have a Database Search to pull up a Record Matching the Primary Key
Everything in the code end is working, I just a looking to create a message when a user enters a already used Primary Key.
On duplictes it allows entries with the same Primary but it never records in database. User goes directly to the Form Confirmation when they submit a duplicate
Thanks for the response.
| |
|
|
|
williamg
Posts: 20
Joined: 6/26/2003
Status: offline
|
RE: Database Validation --Experts HELP - 7/21/2004 8:44:25
Is was wondering it a Validation Text in the Access Database itself will help?
Also I am not using any Reserves, but I do have over 80 Fields in the form. I don't think that will effect my issue thought.
| |
|
|
|
Koen
Posts: 11
Joined: 6/23/2004
Status: offline
|
RE: Database Validation --Experts HELP - 7/21/2004 10:45:22
I am not a pro, but I guess that you have to "loop" through the Primary Key. If the Primary Key = Entered Value you can do a response.write or a response.redirect.
But again....I am not a pro.
Kind regards,
Koen
| |
|
|
|
williamg
Posts: 20
Joined: 6/26/2003
Status: offline
|
RE: Database Validation --Experts HELP - 7/21/2004 14:44:49
Once Frontpage created all the Forms I found the Access Database in the FPDB folder the changed the Primary Key from 'ID' to My Primary Key
It works fine, I mean it does not allow duplicates but on duplicates enter do not get prompted with " Entry already exists" I want ot recieve that message on dupicates
HELP! I can paste some code but I don't know what to paste!
| |
|
|
|
edmund
Posts: 63
Joined: 2/3/2004
Status: offline
|
RE: Database Validation --Experts HELP - 7/22/2004 21:20:10
quote:
I want ot recieve that message on dupicates
Hi,
I kinda found a solution to make the error message appear, you can try this solution from Microsoft.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;314440
To work around this problem, follow these steps:
1. Open the Fpdbform.inc file located in the _fpclass folder.
2. Locate the FP_DumpError(strErrorUrl, strMsg) function.
3. Remove the line that looks like this:
"On Error Resume Next"
4. Save and close the file.
It'll display an error "Cannot update database".. but you can edit the FP ASP component on top of the page by replacing the error message.
Hope it helps.
< Message edited by edmund -- 7/23/2004 1:54:49 >
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 