- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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
Views
Replies
Total Likes