B4J Question Database Data Entry Form...

[vfafou]

Hello!
I'm looking for a way to bind database records data to forms with the capability of moving recordset and show the data into textfields, checkboxes, combos, lists etc...
I'm generally looking for a way to make forms with data binding as quickly as possible!
Where could I search to find these techniques?
I would like to "simulate" the Visual Studio ADO functionality, in order to make some data entry forms.
The database is MariaDB.

Thank you in advance!

P.S.: Please help me! I don't want to go back to Visual Studio!

 

[atiaust]

Hi,

Have a look at this: http://www.rwblinn.de/b4j/b4jhowto/examples/b4jhowtomsaccess.zip

It is for msaccess but can be easily used with other databases.

Also check out http://www.rwblinn.de/b4j/b4jhowto/index.htm Lots of good stuff here.

Hope this helps.

 

[vfafou]

Thank you @atiaust for your response!
Your suggested links have very useful stuff, but still I'm looking for a quick way to bind a recordset to a form and do insert, update and delete and moving to next or previous record directly from the form fields, like Visual Studio!

 

[Erel]

Check this example: https://www.b4x.com/android/forum/threads/propertysheet.50863/#content

It saves the data with B4XSerializator. You can instead write it to a database (you will need to implement it yourself).

 

[vfafou]

Hello Erel!
Thank you for your response!
I would like to ask you the following:
Is it possible to have a list of maps for every database record, and every map value being displayed to the corresponded form field even if it is an object like color picker?
I say list of maps in order to be possible the moving to next or previous records, do changes and update (delete & insert) or insert with the insertmaps method of DBUtils module!

 

[Erel]

No. It works with custom types.