I've nothing useful to say about handling nulls, but when it comes to
building strings of values I have come to enjoy the makestring argument of
the array class with a parm of 'l'. Probably not everyone's cup of tea,
but I have found it useful when building queries on the fly.
You prepare for your query like this...
cols = .array~new
vals = .array~new
.. add columns and data like this ...
cols~append('col1')
vals~append(encapsulate(col1))
...and finally render your query like this...
stmt = "INSERT INTO table ("cols~makearray('l',',')")
value("vals~makearray('l',',')");"
Jon
On 21 June 2012 22:52, Jeremy Nicoll - ml sourceforge <
[email protected]> wrote:
> Mark Miesfeld <[email protected]> wrote:
>
> > I'm just saying I think its place is in the application, or a higher
> level
> > class that uses .ooSQLite.
>
> I think the same.
>
>
> > Not sure if you know that you could use this syntax in ooRexx, or that
> you
> > would like it:
>
> > stmt ||= encapsulate(col1) || ","
>
> Didn't know; not sure if I like it...
>
>
> --
> Jeremy Nicoll - my opinions are my own
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Oorexx-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/oorexx-devel
>
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Oorexx-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/oorexx-devel
