Sqlite3 Master-Detail bug
Original Reporter info from Mantis: leonardorame
-
Reporter name: Leonardo M. Ramé
Original Reporter info from Mantis: leonardorame
- Reporter name: Leonardo M. Ramé
Description:
On method SetDetailFilter of CustomSqliteDS unit, there's the line that follows:
FEffectiveSQL := FSqlFilterTemplate + AFilter;
This line should compose a valid sql select, like "select * from mytable where mykey=1" where "select * from mytable" is FSqlFilterTemplate and "where mykey=1" is AFilter, but FSqlFilterTemplate is allways an empty string, causing an "SQLITE_ERROR - near "where":" exception.
Steps to reproduce:
Please compile and run the attached project.
Mantis conversion info:
- Mantis ID: 19888
- OS: Linux
- OS Build: Ubuntu 11.04
- Build: 18088
- Platform: x86_64
- Version: 2.5.1