fetching empty results sets.

[ellipe]

When a SELECT statement fetch an empty result set the function onDataHandler will halt at this point, same thing happens when doing an UPDATE/INSERT.

command.onDataHandler = function( data ) {
		if( Array.isArray( data ) === false  ) {
			if( this.errors ) {
				this.completed = true;
				this.onCompleteHandler( this.errors, null, null );
			} 

[Vieper]

Yea I stumbled upon the same problem. I think following fix should work (Line 233):

command.onDataHandler = function( data ) {
		if( Array.isArray( data ) == false  ) {
			if( this.errors || this.result.rows.length >= this.result.rowCount) {
				this.completed = true;
				this.onCompleteHandler( this.errors, null, null );
			}

[ellipe]

Hey @Vieper,
Thanks for the reply, i managed to fix it a while ago.
By the way, are you using it in a production environment ? Which version of 4D do you have ?

[Vieper]

Hey @ellipe,
yes I'm using it in a production environment to import data of a software that uses this database. Im not sure but I think its 4D v15.