myDs.rowindex = i;
var myQry = "SELECT client_id, client_name, NULL AS myExtraInfo FROM clients"
/** @type {JSDataSet<client_id:Number, client_name:String, myextrainfo:String>} */
var myDs = databaseManager.getDatasetByQuery(etc. etc. etc.)
for(var i = 1; i <= myDs.getMaxRowIndex(); i++) {
myDs.rowindex = i;
application.output(myDs.client_name);
myDs.myextrainfo = 'some additional text'
}
/**
* @param {JSDataSet} _ds
*/
function generateDsJSDoc(_ds) {
var _sName,
_nType,
_sType,
_aColumns = [];
for (var i = 1; i <= _ds.getMaxColumnIndex(); i++) {
_sName = _ds.getColumnName(i).toLowerCase();
_nType = _ds.getColumnType(i);
switch(_nType) {
case JSColumn.TEXT:
_sType = ':String';
break;
case JSColumn.INTEGER:
case JSColumn.NUMBER:
_sType = ':Number';
break;
default:
_sType = ''
}
_aColumns.push(_sName + _sType);
}
var _sDoc = '/** @type {JSDataSet<' + _aColumns.join(',') + '>} */';
application.setClipboardContent(_sDoc);
application.output('JSDoc has been placed in your clipboard:');
application.output(_sDoc);
}
query = "";
query += "SELECT ";
query += " * ";
query += "FROM ";
query += "collection ";
query += "WHERE cmc_thid = ? ";
Dataset = databaseManager.getDataSetByQuery( DB, query, ["45:80006501:AAEC7704"], 1 );
sSQL = "SELECT * FROM collection WHERE \
column1 = ? AND \
column2 = ?";
nick1461658753 wrote:We changed the columnnames to all lowercase, and now it works. So I guess it was a conflict between PG and Servoy in the columnnames.
var query = "SELECT \
* \
FROM \"Collection\" \
WHERE cmc_thid = ? ";
Dataset = databaseManager.getDataSetByQuery( DB, query, ["45:80006501:AAEC7704"], 1 );
Return to Programming with Servoy
Users browsing this forum: No registered users and 3 guests