Subject Re: applyLocate and apostrophe applylocate limit ? From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Tue, 20 Aug 2024 14:37:46 +0530 Newsgroups dbase.getting-started Good Afternoon Mervyn, >> Please check the attached screenshot. The option which had the least >> possibility is working. > ...... >> 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. > > As I've said elsewhere, it appears that dBase LLC has tried to bring an > ADOrowset's applyLocate() method more into line with "proper" SQL. > Unlike the applyLocate() for a standard rowset, it will only accept > single quotes as the delimiter for a literal string. > > Using an apostrophe to escape and apostrophe i.e 'Angel''s' is > apparently an ANSI SQL standard and this is what dBase LLC has used. There is always something that I miss. Apparently I should have switched to using sql much earlier than 2017. Regards Akshat