roeya
Posts: 181
|
Posted: 01/07/2006, 11:09 PM |
|
SQLite support is a welcome addtion and it is better alternative for access mdb files for small projects, however there is a problem:
When I try to select information from more than 2 tables the join systax is wrong:
It should have been something like:
select * from results
left join address on address.id = results.address_id
left join phone on phone.id = results.phone_id
but what I get is something like:
select * from (results
left join address on address.id = results.address_id)
left join phone on phone.id = results.phone_id
And sqlite does not know how to handle it
I have asked support for help but they say they invstigate this problem (from 6/12/2005...)
Anyone has a similiar problem ?
I tried using SQL instead of Table with the grid builder but this caused other problems:
No sorters and No search filter (which seems to be another bug not related to sqlite ), I also tried using views but this caused yet another problems ...
help !!!!
_________________
http://www.infoneto.com/ |
|
|
|