Avatar

Level 1

Managed to advance a bit but it seems to be a database query issue :

-I  set a MySQL connection to a database (test successful)

-I want to get "table_1" content displayed (from the database)

-> Using the following sentence from you example :

xfa.sourceSet.DataConnection.nodes.item(1).query.setAttribute("text", "commandType");

xfa.sourceSet.DataConnection.nodes.item(1).query.select.nodes.item(0).value = "Select * From table_1";

then trying to connect :

Error occurs on the connection part :

// Need this try catch when user types invalid search criterion.

var sOpen = "";

try {

oDB.open();

oDB.first();

} catch (e) {

sOpen = "failed";

// Reset the item line fields.

oSubform.resolveNode("PartNumber").rawValue = "";

oSubform.resolveNode("Description").rawValue = "";

}

Where I have no result from the query ...

Any idea ?

Settha