Subject Re: applyLocate and apostrophe applylocate limit ? From Mervyn Bick <invalid@invalid.invalid> Date Mon, 19 Aug 2024 19:32:28 +0200 Newsgroups dbase.getting-started On 2024/08/19 14:48, Akshat Kapoor wrote: > 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. Mervyn. Mervyn.