Video On Using A Database With Ez-builder Through Ez-dbmulti
Before I start, this video requires some knowledge of MSSQL server. To do what this video shows, you will need an MSSQL server installed on a machine on your network and will have to setup some tables and possibly some User Defined Stored Proceedures (USP's) in MSSQL Server. It also requires that you have EZ-DBMulti installed and working.
With all of that out of the way, some people have asked me what you would use a database for with EZ-Builder in the past. This is a video of an example of why I use databases. All of this could be done in the script engine in EZ-Builder and could be done with text files instead of a database, but here is an example of what I am doing with the database. There are many more examples that could be provided and the possibilities become pretty endless.
I have over 20 years of experience with MSSQL and with programming in multiple languages for many companies. This video makes some assumptions that the person attempting this has the knowledge necessary to do this. If you are not at that point, there are many sources for help and I will do what I can, especially with EZ-DBMulti, but I wont be able to teach you how to query a database or how to setup a USP or MSSQL. I can check your USP to see if there is anything that I see is wrong with it, or your script in EZ-Builder to call EZ-DBMulti.
There are a few relationships that you need to know about when watching this video. David and Tatia are the parents of McKay and Tanner. Tanner is married to Kaitlynn and they have a daughter (a pretty awesome one if I do say so myself) named Rori. The video shows how the robot can change based on who is using the robot because of a username that is supplied.
Let me know if you have any questions and I will do what I can to help you out if you choose to go down this path. It is a pretty fun one and gives you a lot more capabilities of decision making through queries instead of through if statements in scripts. This is also the reason that I cant wait for the cloud option to be enabled in EZ-Builder. I dont know if extensive queries or USP's will be possible with the cloud feature, but if not, you can always use EZ-DBMulti.
Here is the video.