Hi, 1. When I prepare a select statement for later execution, may I use a question mark instead of a table and later "bind" different table names with the same cxonstruct according rto some condition? for example, sqlite3_prepare_v2(db, "select * from ? where.....",...); 2. In "order by" clause may I use a column which is part of the table but nor part of the result? select com1, col2 from tbl order by col1, col3; col3 is part of the table but not of the result. Thanks, Rafi.
- [sqlite] 2 questions concerning select statement Rafi Cohen
- [sqlite] Re: 2 questions concerning select statement Igor Tandetnik
- [sqlite] data type problem qinligeng
- [sqlite] Re: data type problem Igor Tandetnik
- Re: [sqlite] data type problem drh
- Re: [sqlite] data type problem Dennis Cote
- Re: [sqlite] data type problem qinligeng
- Re: [sqlite] data type problem Dennis Cote
- Re: [sqlite] data type problem Dennis Cote
- Re: [sqlite] data type problem Kees Nuyt
- Re: [sqlite] data type problem qinligeng