J jcredk Member Licensed User Longtime User Sep 24, 2013 #1 Hi all, I searched the forum, but did not find something comparable to what I search. I am working on a program with a workflow to enter data (texts, radio, combo, up/down values, signature, camera ...). As making the application "product-oriented" and focusing several customers, we would like to have the ability to store in the database the forms that are to be entered by the user: One request on the database would provide "the data dictionnary" of the fields to be entered by the end user One request on the database would provide the "view definition", a mapping providing ways a field could be entered One request on the database would provide the default values (when creating a new record) or the previously entered values (if data entry was interrputed and starts again) Of course at the end an update on the database would save the user data entry Do you know something on the forum dealing with this ? Do you think it's reasonnable to implement this with B4A ? Would you have high level advises on the code architecture? OK not a small thing and with large questions but any contribution is welcomed ...! Thanks, @+ Jcredk
Hi all, I searched the forum, but did not find something comparable to what I search. I am working on a program with a workflow to enter data (texts, radio, combo, up/down values, signature, camera ...). As making the application "product-oriented" and focusing several customers, we would like to have the ability to store in the database the forms that are to be entered by the user: One request on the database would provide "the data dictionnary" of the fields to be entered by the end user One request on the database would provide the "view definition", a mapping providing ways a field could be entered One request on the database would provide the default values (when creating a new record) or the previously entered values (if data entry was interrputed and starts again) Of course at the end an update on the database would save the user data entry Do you know something on the forum dealing with this ? Do you think it's reasonnable to implement this with B4A ? Would you have high level advises on the code architecture? OK not a small thing and with large questions but any contribution is welcomed ...! Thanks, @+ Jcredk
D devlei Active Member Licensed User Longtime User Sep 24, 2013 #2 I'm struggling to understand exactly what you want to do, but two questions: Have you checked out the DBUtils functionality? See link here Are you familiar with SQLite? You should be able to handle any type of database functionality (forms, records, queries, tables etc) with it! One tutorial is here . Upvote 0
I'm struggling to understand exactly what you want to do, but two questions: Have you checked out the DBUtils functionality? See link here Are you familiar with SQLite? You should be able to handle any type of database functionality (forms, records, queries, tables etc) with it! One tutorial is here .
klaus Expert Licensed User Longtime User Sep 24, 2013 #3 You should have a look at the User's Guide there you find a more recent SQLite example. Best regards. Upvote 0
You should have a look at the User's Guide there you find a more recent SQLite example. Best regards.
