B4J Question ABMaterial CRUD & PostGRESQL

[wangondu]

Hey

Am trying a simple web application whereby my back end is PostGRESQL, Am looking for thread to guide on ABMaterial CRUD

 

[alwaysbusy]

You can use the feedback app as a start. I never worked with PostGRESQL, but if B4J can do it, so can you using ABMaterial. Remember, ABMaterial is just for making the pretty UI, al the rest is done in pure B4J.

 

[wangondu]

thanks @alwaysbusy for your reply . Yesterday i managed to connect to database and perform some select now working on display data on ABMtable

 

[wangondu]

how can i assign variable from ABMinput

 

[alwaysbusy]

You have to first grab the component (see the demo apps). You must get all its parents too to get to the component (e.g. if the parent is a container, you first have to get the container and then the component from that container)

Example for a component added to a page:

Dim myInput AS ABMInput = page.component("myInput")
dim variable as String = myInput.Text

For a table, it is slightly different (untested code as I'm not on my PC right now):

Dim myTable as ABMTable = page.Component("myTable")
Dim myInput as ABMInput
for i = 0 to 10
   myInput = myTable.GetComponent(i, "myInput")    
   dim variable as String = myInput.Text
next

 

[wangondu]

Thanks man i have done its working now

 

[wangondu]

Yester i managed to populate combo with data i queried from PostGRESQL am now asking how can i populate ABMTable using resultset

 

[alwaysbusy]

Look at the code of the feedback app. It does exactly that with e.g. the cases. (I think the method is called LoadCases)

 

[wangondu]

how can i populate postgresql database from ABMTable