On Mon, 12 Aug 2013 10:51 +0100 (BST), "Stephen Hughes" <ri...@cix.co.uk> wrote:
>SQLite Input with validation and lookup >This may be a FAQ, if so please point me in the right direction, but if >not what I am looking for is a BROWSE style INPUT which will:- > - allow me to force UPPER case. > - set MAXIMUM/MINIMUM values. > - LOOKUP and retrieve data from a masterfile. All those are features of a user interface framework, which SQLite is not. SQLite is "only" a database engine, used to store and retrieve data (and very good at that). It will happily serve the storage you need behind such a framework, on top of the actual application data. >For example:- > - enter a Quantity and Product Code >which will automatically:- > - retrieve and display the unit cost. > - retrieve and display the Product description. > - calculate and display the total cost. > > I have done the above using Visual FoxPro but I cannot find > anything with similar functionality for SQLite. You could construct such a user interface framework, and be supported by sqlite features: - column constraints (value range) - table constraints (value range) - reference constraints (foreign keys) - meta data (PRAGMA table_info(), PRAGMA foreign_key_list() - creative use of type names e.g. encode handlers between the parens behind a type name. http://sqlite.org/pragma.html#pragma_table_info http://sqlite.org/pragma.html#pragma_foreign_key_list For requirements you cannot implement using the above, you may need to create additional meta data tables. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
