Eric Boudaillier <[EMAIL PROTECTED]> wrote: > > I started with sqlite 3.2.0. Now I try to use the version 3.2.8,
Why not use 3.3.17? > With sqlite 3.2.0, "arr" contains: > > arr(*) = equipment_type_name io_type_id io_type_name > alarm_if_active > arr(alarm_if_active) = DC1 > arr(equipment_type_name) = CB72_C > arr(io_type_id) = 71 > arr(io_type_name) = DC1 > > With sqlite 3.2.8, "arr" contains: > > arr(*) = equipment_type_name io_type.io_type_id > io_type_name alarm_if_active > arr(alarm_if_active) = DC1 > arr(equipment_type_name) = CB72_C > arr(io_type.io_type_id) = 71 <===== Now has the table in its name > arr(io_type_name) = DC1 > > Is there something wrong in 3.2.8? Or have I to update all the queries? > Version 3.2.8 was so long ago that I do not know what changed. In the future, it would be best if you put an AS clause on each of your result columns to assign a particular name to them. That way you do not depend on the (undocumented) names that SQLite assigns by default. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
