2. PHPRunner General questions
  3. Prevent Data Entry
This topic is locked

Prevent Data Entry

 		10/28/2008 8:50:23 PM
PHPRunner General questions
F
 fryon author

Hello,
PHPRunner is awesome, in fact i tried downloading the new version. But I'm not really sure if i can do it with phprunner.
I have 3 tables (table1, table2 and table3)
table1

profile_id

profile

data

time
table2

profile_id

data2

time2
table3

listNo

data3

time3
I would like to prevent duplicates based on THREE FIELDS (profile_id, data, time) in table 1. It means if a person with profile_id=1 will hava data=5 and time=8:00, but will prevent entry of the same values(1, 5 and 8:00). It means, there will be checking of 3 fields before entry.
Is this possible?
Thanks masters.
A
 		alang 10/29/2008

Should be pretty straightforward. You need to add some custom PHP code to the "Before record added" event and check that the particular combination about to be added does not already exist. If it does, then you return false from your event function.
F
 		fryon author 10/30/2008

Should be pretty straightforward. You need to add some custom PHP code to the "Before record added" event and check that the particular combination about to be added does not already exist. If it does, then you return false from your event function.


Thanks, Got any idea how?

thanks
Sergey Kornilov admin 10/30/2008

I recommend you to post your application to Demo Account and contact support team directly supplying your order number.