$fetch from SQLite

[Bastiaan Olij]

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
----

Cheers,

Bas

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
http://www.linkedin.com/in/bastiaanolij