Can you search SQL this way?

Andy Hilton andyh at totallybrilliant.com
Fri Oct 22 15:19:19 UTC 2021


You can’t do a sql query to achieve that, in short…..

As you had mentioned, you would either have to return your list into Omnis and use traditional code to go through the list data line by line,

Or do a wholly new sql search as I had mentioned for whatever generated that list to start with (if you know that !) with added additional sql search parameters….

Andy Hilton
Totally Brilliant Software Inc
Phone (US) : (863) 409 4870 
Phone (UK) : 0207 193 8582
Web : www.totallybrilliant.com <http://www.totallybrilliant.com/> 
Helpdesk : http://totallybrilliant.kayako.com
Email : andyh at totallybrilliant.com

> On Oct 22, 2021, at 10:45 AM, Das Goravani <goravanis at gmail.com> wrote:
> 
> 
> I still don’t get it then.
> 
> I have Omnis lists stored in SQLite and would like to query them the way we do in Omnis somehow.
> 
> For example, does row 3 column 2 contain 4835 or does row 5 column 10 equal “Saturn”
> 
> 
> 
>> On Oct 22, 2021, at 10:42 AM, Andy Hilton <andyh at totallybrilliant.com <mailto:andyh at totallybrilliant.com>> wrote:
>> 
>> Das
>> 
>> I think what Phil is meaning is :
>> 
>> You would simply do a new sql search for whatever got you your list to start with, plus the extra addition of a like (note that depending on the database, ‘ilike’ can also be a case insensitive search) for your column search within that…..
>> 
>> Andy Hilton
>> Totally Brilliant Software Inc
>> Phone (US) : (863) 409 4870 
>> Phone (UK) : 0207 193 8582
>> Web : www.totallybrilliant.com <http://www.totallybrilliant.com/> <http://www.totallybrilliant.com/ <http://www.totallybrilliant.com/>> 
>> Helpdesk : http://totallybrilliant.kayako.com
>> Email : andyh at totallybrilliant.com
>> 
>>> 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 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com <http://lists.omnis-dev.com/>
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com <http://lists.omnis-dev.com/>
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com <mailto:omnisdev-en at lists.omnis-dev.com>


More information about the omnisdev-en mailing list