Using barcode scanning to open a turnstile
I am developing a system for a client to open and close their turnstile using the barcoded cards they use. I have been able to scan the barcode into my FM system and get the barcode number. What i need to find out now is how do I tell the turnstile to open or not. The current system they use has the barcode reader send info to a SQL database and that database then tells the turnstile to open or not. How would I do that in FM? Would I have to use Send Event or could I use ExecuteSQL()?
I am also looking into replacing the barcode with a finger print reader but I haven't researched this option fully yet.