Can you search SQL this way?

[Das Goravani]

Yes, the list is an Omnis list stored in SQLite. The data type you use is LIST when making new columns for an Omnis list.

I realize it may not be a SQL object or searchable.. was just wondering. 

I can always SELECT USING SQL objects, load a list of returned rows, and run down them in Omnis searching the contained lists if need be. 



> On Oct 22, 2021, at 10:36 AM, Phil (OmnisList) via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> Hi Das,
> 
> the string needs quotes...
> field like '%string%'
> 
> A list?
> That is not a SQL object.
> What is that stored as? is it binary? so basically no chance of looking up on that.
> 
> regards
> Phil Potter
> Based in Chester in the UK.
> 
> On 22/10/2021 15:18, Das Goravani wrote:
>> Hello Listers,
>> 
>> I’m wondering about two SQL searches or selects.
>> 
>> One is if you have a large field full of text, and you want to search for a string inside it. Do you use LIKE %sring% ?
>> 
>> And if you have a list, and you want to select on a value in a column, can you do that?
>> 
>> That’s it.
>> 
>> Thanks
>> 
>> Das Goravani
>> _____________________________________________________________
>> Manage your list subscriptions athttp://lists.omnis-dev.com
>> Start a new message ->mailto:omnisdev-en at lists.omnis-dev.com  
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com