Uniqueness test

[kitship]

Please help,

Can alpha five perform a uniqueness test on an active link mysql table? If yes how do you make it work? been trying to do this but alpha five would still accept duplicate value in a field even though uniqueness test is active.

[GGandhi]

Re: Uniqueness test

hello

i know you said active link mysql table,
why active link table if you are using web interface, if you directly connect lot easier.
also you can check directly using alphadao, lot simpler than you think.
use validation rules and fill in the connection string and the set up
it is simple.
(or you can make the mysql check for uniqueness making that field an indexed field no duplicates allowed.)

[kitship]

Re: Uniqueness test

hello

i know you said active link mysql table,
why active link table if you are using web interface, if you directly connect lot easier.
also you can check directly using alphadao, lot simpler than you think.
use validation rules and fill in the connection string and the set up
it is simple.
(or you can make the mysql check for uniqueness making that field an indexed field no duplicates allowed.)

Ok sorry as I posted on the wrong forum Im using desktop application. I just wonder if uniqueness test works on acive link mysql?

[GGandhi]

Re: Uniqueness test

I do not work with active link tables or desktop so I may not be able to direct you to right method.
but as I said earlier you can ask MySQL to check for uniqueness by defining an index and make the index unique and MySQL will do the checking
for you.

[aburningflame]

Re: Uniqueness test

(or you can make the mysql check for uniqueness making that field an indexed field no duplicates allowed.) +1

If you are using MYSQL Workbench
Right click the Table > Alter Table > Indexes
for the name type UQ_PERSON_MEETING (e.g 1 person per meeting)
Select UNIQUE (instead of INDEX) on the constraint type
On the right check person_id, meeting_id
Click Apply
Click Ok


HAndle Alphas grid serverside event: onSQLExecuteError to catch the error and output a nicer error
if atc(e.errorMessage,"UQ_PERSON_MEETING")
onSQLExecuteError="Person has already been added to this meeting"
end if

If you want to check this on the frontend side of things, and your using a dropdown to select your person, you can use a lookup field with a dynamic filter to filter people who are not currently in this meeting.

In this sense - the database enforces integrity and the frontend doesnt show users that are not allowed to be added to the meeting (Integral and Efficient)
The 2nd step isnt needed, but it is a nice to have - why show users in the dropdown if they are already part of the meeting?

Gluck!

[aburningflame]

Re: Uniqueness test

Ok sorry as I posted on the wrong forum Im using desktop application. I just wonder if uniqueness test works on acive link mysql?

Active Links are just a "middle man" / "broker" for the dbf to mysql table. Why do you have an active link table anywyas? do you have code that uses dbf methods? (record_delete, record_update etc)?
If not, i would delete your active link table and just create a new AlphaDAO COnnection string to the MySQL db and use that.

Anyways a unique constraint enforced at the mysql engine level will be respected because the active link is just going to try to write to the mysql table (as far as i know based on my limited knowledge of how the active links are setup)