View Single Post
Old 07-31-2018, 09:48 PM
Marsheng Marsheng is offline
Senior Member
Join Date: Nov 2008
Posts: 314

Sorry I missed the last reply. You are correct to some extent. What I need to do is validate the form on close and double check noone else has added that number.

The numbers are decided by the rider. They have a list of free numbers and choose one to their liking.

Also, why are you literally counting each record one at a time, simply run a Query with a Select Count(*) as Count from yourtable where raceno = :racenoParameter and set racenoParameter to the value you are looking for, Trim(eRaceNo.Text), before you open the query. Now you have the count in your query's Count.asInteger.
I'll look into this as it looks like a good option.

Thanks for your reply.
Reply With Quote