in-mem ...getColumnNames() returns a non-existing column

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

in-mem ...getColumnNames() returns a non-existing column

Postby jhilgers » Wed Nov 13, 2019 2:31 pm

Hi all,

I'm using a foundset load trigger to initialize an in-mem datasource with the code below

Code: Select all
function onFoundSetLoad_record_history(inMemName) {
   var ds = databaseManager.createEmptyDataSet(0, datasources.mem.record_history.getColumnNames());
   ds.createDataSource(inMemName);
}


getColumnNames() returns ["_sv_rowid"... as the first column which doesn't exist in the in-mem datasource.

createDataSource(inMemName) then reaises this warning:
WARN com.servoy.j2db.util.Debug - Dataset column names definition does not match inmem table definition for datasource

Any ideas how to get rid of this?

best
Jo

Servoy Version: 2019.9.0.3522
jhilgers
 
Posts: 8
Joined: Wed Nov 13, 2019 2:19 pm
Location: Cologne / Germany

Re: in-mem ...getColumnNames() returns a non-existing column

Postby jcompagner » Fri Nov 22, 2019 12:25 pm

can you create a case for this?
I think the internal generated pks (_svy_rowid) should not be given back there, it really should only give the stuff you give (design time or at runtime)
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8832
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: in-mem ...getColumnNames() returns a non-existing column

Postby jhilgers » Fri Nov 22, 2019 12:58 pm

done: SVY-14405
best / viele Grüße
Jo ~;-)
jhilgers
 
Posts: 8
Joined: Wed Nov 13, 2019 2:19 pm
Location: Cologne / Germany


Return to Programming with Servoy

Who is online

Users browsing this forum: Google [Bot] and 17 guests