[Firebird-odbc-devel] Firebird ODBC + Acrobat + JavaScript

[Mike M. <ma...@st...>]

Hello,

has anyone used JavaScript in PDF-Forms with the ODBC driver?

I can?t retrieve any values from the database.

This is my JavaScript code:

console.show();
console.clear();

var aList = ADBC.getDataSourceList();
for (var i = 0; i < aList.length; i++) {
console.println(aList[i].name);
console.println(aList[i].description);
}

try {
var sqlCon = ADBC.newConnection("db");

if (sqlCon == null)
throw "Connection failed";
} catch(e) {
console.println(e);
}

var stmt = sqlCon.newStatement();
stmt.execute("select g.gemeindename, g.gemeindehausnr,
g.gemeindeplz, g.gemeindeort from gemeinde g");

stmt.nextRow();

var row = stmt.getRow();

console.println("Gemeindename: " + row.GEMEINDENAME.value);
console.println("Gemeindehausnr: " + row.GEMEINDEHAUSNR.value);
console.println("Gemeindeort: " + row.GEMEINDEORT.value);

this.getField("gemeinde").value = row.GEMEINDENAME.value;
this.getField("gemeindeshausnr").value = row.GEMEINDEHAUSNR.value;
this.getField("gemeindeort").value = row.GEMEINDEORT.value;

Thanks for your help,

Mike