Some time ago, I constructed a layer to query a Clipper dBASE. Of course, the user interface wasn't as powerful as SQL but do the work and its use was extremely easy to the profane.
Suppose a dialog-box that let select each -selectable to the user- field in the table. After each selection, is shown a listbox with conditions. Say: EQUAL NOT EQUAL LESS THAT GREATER THAT CONTAINS NOT CONTAINS Etc. Once the selection is made, a box let put the condition -number; date; time, or character string-. Then, a new listbox let select a new condition or terminate the query desing. Say: AND OR END & NO MORE CONDITIONS & PROCEED In the event of a new condition (AND/OR selection), the process goes to the first point. The system let easily handle the date-time fields, and prevent the injection attacs. Perhaps you can start with very simple conditions, and later refine the user interface and the parser who construct the resulting SQL query. HTH. A.J.Millan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
