create unique index AccountNameUnique on AccountTable (UPPER(AccountName))?
I appreciate it if you can provide me some code that would do the check and not move the database-cursor as I may not be doing that correctly.
What's the problem to create an other function to search for the name in the same table?
Also, I do not understand the "[naam]" thing. I have done some searching and cannot finding anything to explain what's is expected.
Quote from: ASerge on March 26, 2017, 04:25:28 pmcreate unique index AccountNameUnique on AccountTable (UPPER(AccountName))?Thanks, but, that scrolls the database off the current "insert/Edit" position.
I created the example in my head and not verified the code.
I appreciate the attempts to help, but I really have no desire to do a full-course in SQL as I am Retired and probably will not use it again for years. I was just trying to emulate what I was used to doing with Win/Delphi/IB/ADO etc.
Where you would have run into the same issue. There is not much difference between Delphi and Freepascal.
Tel me, how should you do it in code if you were using Delphi?
This process will work, I think. I don't know how to "lock" and "unlock" DB or processes in SQLite / Lazarus. But they should not be very difficult.