||Re: select - like
Helen Prior <firstname.lastname@example.org>
||Sat, 01 Oct 2022 09:55:29 -0400
Thank you ever so much for taking the time to answer me - I really do appreciate it
It now works fine.
Mervyn Bick Wrote:
> On 2022/10/01 09:08, Helen Prior wrote:
> > Hi Folks
> > Can anyone help me please?
> > I an trying to create a select 'like' statement
> > Form.DAILYLOG2.sql = [select * from DAILYLOG where Keyevent like '%] + Vkeyevent + [%'] or History like ['%] +Vkeyevent + [%']
> > The first 'Keyevent' works fine but when I try and add History it does not.
> > Could someone please put me on the right track?
> > Regards
> > Helen
> Building commands into strings can be tricky. It's a matter of getting
> the delimiters for the various sections in the correct places. It helps
> to print the string before you try to execute it. Once it works the
> print statement can be deleted.
> Form.DAILYLOG2.sql = [select * from DAILYLOG where Keyevent like '%] +
> Vkeyevent + [%' or History like '%] +Vkeyevent + [%']