Subject Re: select - like
From Mervyn Bick <invalid@invalid.invalid>
Date Sat, 1 Oct 2022 09:38:10 +0200
Newsgroups dbase.getting-started

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 + [%']

Mervyn