I've never used Visual FoxPro, but I suspect that it allows you to create forms to insert data in to the database.
Sqlite doesn't do that. Sqlite only provides the library to store the data via SQL statements that you execute via sqlite3_prepare()/sqlite3_step() function calls. You are expected to acquire or write your own front end software that will let you enter the data and validate that it is correct. The CHECK constraints are a final, just in case the front end messed up, way to make sure the database doesn't store bad data, but your front end form should validate the data before it sends it to sqlite to store. Perhaps the better question for you to be asking is what software would best meet your needs in creating a form that will interface with sqlite's db back end. And the answer to that probably depends on what language you are using to write your application and what platform it is going to be run on. Hope that helps. David ________________________________ From: Stephen Hughes <ri...@cix.co.uk> <snip> But as I said in my last post I got confused between Visual FoxPto SQL and Visual FoxPro built in programming language. I could certainly achieve what I want by using a spreadsheet, such as LibreOffice Calc, to create a validated and extended temporary file which I could then use to import the relevant validated fields to my "Order items" table in my SQLite database; but this seems to be a rather long-winded and circuitous approach. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
