$fetch from SQLite

Bastiaan Olij bastiaan at basenlily.me
Tue Aug 5 05:25:41 EDT 2014

Hi Joshua,

I have the same issue in Postgres. I actually copy my list definition
and then merge lists because I also change the case of columns to get
around the case sensitivity of column names when you use table classes
(what a pain) but in theory the following code should work:
For lvCol from 1 to yourList.$colcount
  set reference lvRef to yourList.$cols.[lvCol]
  if lvRef.$coltype=kCharacter&lvRef.$colsublen=0
    calculate lvRef.$colsublen as 10000000
  end if
end for



On 5/08/14 6:10 PM, Josua Riha wrote:
> Good morning,
> I've noticed that if I $fetch a result set from a SQLite Database into
> an undefined list the columns seem to have the wrong data lengths.
> Since SQLite has no length for the data type "TEXT" omnis sets the
> lenght of the character fields to 0 which makes the fields unusuable.
> It works if I use a schema class for it, but since I want to use a
> dynamic column selection I would prefer not to create one for each
> possible combination of columns.
> Does anyone has an idea to fix that?
> Regards,
> Josua
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com

Kindest Regards,

Bastiaan Olij
e-mail: bastiaan at basenlily.me
web: http://www.basenlily.me
Skype: Mux213

More information about the omnisdev-en mailing list