Copy the class to your project. Then add a canvas to your window and change the super to the window. Position the canvas on your window. Now comes the trick where you tell the splitter which controls are before and which are after the splitter:
Here the first control would be to the left before the splitter. The 2 other controls are to the right after the splitter. It’s easier to work with the splitters if you have containers so that you don’t have to add dozens of controls to the splitter.
are you sure you need a database?
maybe its easier for you to use object serialization or save/load a Dictionary as json.
meaning you hold the data in memory in some classes with functionality and saving it all in one.
towards Model View Controller.
have also a look for Interface because your app have recurring activities.
[quote=476313:@AndrvanHaren]I watched the Using SQLite in Xojo apps video again to see if it would explain how to connect fields (Colums in the database) to a record, but because there aren’t fields used in this video, I wasn’t able to solve my problem. Is there a video to which someone can post me that shows how this is done? Here is my table and the fields in the UI:
[/quote]
Compared with FileMaker, for Xojo you need to write code to access/edit/store data in the database.
The UI elements out of the box (UI “Fields”) know nothing about the database, records or columns.
In Xojo there are essentially no built in configurable automatic linkages from UI element to the fields in a database record or to a specific record. You need to create that linkage in code yourself using the Xojo Database API. It is not hard but it is another step. That is both a plus and minus.
On the plus side you can make the interactions be exactly how you want them to work.
On the minus side it takes a bit more effort/time to create the links than in product such as FileMaker.
[quote=476337:@Karen Atkocius]Compared with FileMaker, for Xojo you need to write code to access/edit/store data in the database.
The UI elements out of the box (UI “Fields”) know nothing about the database, records or columns.
In Xojo there are essentially no built in configurable automatic linkages from UI element to the fields in a database record or to a specific record. You need to create that linkage in code yourself using the Xojo Database API. It is not hard but it is another step. That is both a plus and minus.
On the plus side you can make the interactions be exactly how you want them to work.
On the minus side it takes a bit more effort/time to create the links than in product such as FileMaker.
-karen[/quote]
Wouldn’t it be a nice improvement to build Filemaker kind of database connecting into Xojo? I am sure lots of new users would be very thankful. All it would take is a single click on a field and the connection is made.
I am searching and studying Xojo now again for a week only to solve this problem after having up on Xojo about one year ago because I wasn’t able to get pass this problem. I am still no step closer to how to do this.
[quote=476377:@AndrvanHaren]Wouldn’t it be a nice improvement to build Filemaker kind of database connecting into Xojo? I am sure lots of new users would be very thankful. All it would take is a single click on a field and the connection is made.
[/quote]
it seems it will be done … in a few years as it is at the end of the list … https://documentation.xojo.com/resources/roadmap.html
