I am trying to form the query for the "Check Login" button when you create a new customer. I tried a rather complicated query which Printed a response based on if the username existed already or not. But OG didn't really seem to care what I responded with. So then I tried a simple query that basically selects the row where USERNAME = <NLogin>. OG ran that query ok, and just responded with the word "OK" no matter if the username existed or not. So what does OG want in order to check to see if I can use that username? Do I just print something back to the screen so that the employee sees 'User already exists'? Or is there something I can give to OG in order for OG to refuse the login. Theorectically, we shouldn't have any logins that aren't already in OG, but people (including me) like to tinker with the databases, and not use the front-end. Thanks in advance -
It's informational only. It's not "checking" for anything specific, it's simply relaying the result to the screen.