Subject Re: applyLocate and apostrophe applylocate limit ? From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Mon, 19 Aug 2024 18:18:28 +0530 Newsgroups dbase.getting-started Attachment(s) Screenshot 2024-08-19 180126.jpg Good Evening Mervyn, > When it comes to the applyLocate() method of an ADOrowset dBASE seems to > be trying to bring some measure of "proper" SQL into the equation and it > will only accept single quotes to delimit literal strings e.g ("CITY = > 'O'Grady'" which, of course, gives an error.  A bit of Googling suggests > that for MariaDB both ("CITY = 'O''Grady') and (CITY = '\'Grady') should > work. Please check the attached screenshot. The option which had the least possibility is working. I had added some more columns to the table to store additional info and then opt in for bulk insert of the pattern. Insert into tableA (column1,column2) select columnA,columnB from Tableb much less hassle and much faster (It was so fast that at one point of time I thought onclick did not function.). Hence this issue was more of academic for me. Regards Akshat On a side note There is one thing that I have failed to understand. Once we have a rowset then the data is in memory. I have tested this by making the query active, disconnecting the data server and checking applylocate() it works. So it should follow dbase standards. If it is following sql standards then "name = 'Angel\'s" should work.