Boris Herbinière-Sève wrote:

> Incomplete SQL: SELECT r.Id, r.IdParams, r.SagN2, r.SagL2, r.SagN3,

how do you tell sqlite the request? Maybe it's just the terminating
semicolon that's missing:

> $ echo "select * from t1 as tab where tab.domain='dom1'" | sqlite3 test.db
> Incomplete SQL: select * from t1 as tab where tab.domain='dom1'
> $ echo "select * from t1 as tab where tab.domain='dom1';" | sqlite3 test.db
> dom1|jakob
> $ sqlite3 test.db "select * from t1 as tab where tab.domain='dom1'"
> dom1|jakob

Reply via email to