I am trying to get my head around ABMaterial and I see a few posts that talk about ABMGenerator. may I ask how do you get to "Generate" any code with it ? is it a stand alone program ? where do I download it ? does it work like ABMGridBuilder which is in the ABMaterial ? download I am reading Lesson 5 - ABMGenerator (Part A) but I cant seem to understand
ABMGenerator is already included in ABM, so you do not need to download anything extra.
To use it, you must create a new program, where you specify parameters for the data you want to manipulate (CRUD) and (if necessary) for the ABMTable where they will be displayed.
Then, you execute the program and it produces the code, which you then paste to your ABMaterial webapp program.
A good example can be found here: http://prd.one-two.com:51042/demo/HelperGeneratorPage/abmaterial-generator.html (although this link does not have the info about ABMTable definitions).
Attached is one of my programs, which you can use as an example (some strings are in Greek language, but I think that the use of parameters is self explanatory).
sorry for new question, I am following that learning path I can connect to MySQL server but not MariaDB. am I correct that only sqlite3 and MySQL are currently supported ?
sorry for new question, I am following that learning path I can connect to MySQL server but not MariaDB. am I correct that only sqlite3 and MySQL are currently supported ?
My ABMaterial app is connected to a SQL Server database. In the DBM.bas file:
B4X:
Sub InitializeSQLServer(login As String, password As String, poolSize As Int)
' Log("init SQL Server")
UsePool = True
Try
pool.Initialize("com.microsoft.sqlserver.jdbc.SQLServerDriver", "jdbc:sqlserver://10.0.0.10:1433;databaseName=STREAM", login, password)
Catch
Log("Last Pool Init Except: "&LastException.Message)
End Try
' change pool size...
Dim jo As JavaObject = pool
jo.RunMethod("setMaxPoolSize", Array(poolSize))
End Sub
You should make your own Subroutine to initialize the MariaDB (pool.Initialize) using the appropriate driver for MariaDB.