Stuck on native database functions

[Bob Sneidar]

Okay I found out what I did wrong. The array variable needs to be enclosed in quotes. I remember now some time in the past looking at that and saying, "Why are their quotes around the array variable? That won't work!" So I removed them and subsequently shot myself in the foot. 

For the record, having a parameter that can be either a string or an array, and then having to enclose the name of the array in quotes to keep the handler from confusing it as a string, strikes me as a really odd way to do things. But hey, it is what it is. 

Bob S


> On Jul 7, 2021, at 09:52 , Mark Smith via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Yes, using the numeric placeholders will do that for you. 
> 
>> On Jul 7, 2021, at 4:43 PM, Terence Heaford via use-livecode <use-livecode at lists.runrev.com> wrote:
>> 
>> It also seems to do the escaping for you as it handled text containing commas in the description
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode