DynamicSQLEntity - Problem with a single result

[Luca Bach]

Hello, 

I have a simple BusinessProcessBase class with a simple DynamicSQLEntity.

However, when the SQL returns exactly one result, OnLeaveRow() is never called.

Is there a known reason for this, or am I missing something?

public class Foo : BusinessProcessBase
{
DynamicSQLEntity _sql;
public readonly NumberColumn Id = new NumberColumn();

public Foo()
{
_sql = new DynamicSQLEntity(DataSources.XXX, "SELECT ID FROM A WHERE B = 1");
_sql.Columns.Add(Id);
From = _sql;

Columns.Add(Id);
}

public void Run()
{
Execute();
}

protected override void OnLeaveRow()
{
//...
}

protected override void OnEnde()
{
//...
}
}

[Noam Honig]

Hi Luca, this should work - and works ok all over 

Try replacing the sql with "select 1"

that way you're not dependent on your table - to verify the core behavior of it - and it'll work

Noam Honig  

Founder & CEO

www.fireflymigration.com

--
You received this message because you are subscribed to the Google Groups "Migrated By Firefly" group.
To unsubscribe from this group and stop receiving emails from it, send an email to migrated-by-fir...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/migrated-by-firefly/309a3ce0-30dc-40e0-9d6a-1e528bac37c9n%40googlegroups.com.

[Lawrence Fisher]

You can also do ForceLeaveRecord

To view this discussion visit https://groups.google.com/d/msgid/migrated-by-firefly/CAON83%3DdEJHKkZ5UUJmjh%2Bi4x50UPswb%2Br8BLZc78JuxPsmUUOg%40mail.gmail.com.

--

Sincerely

Lawrence Award winning philatelic exhibit Author of "Kill Me Now!" Buy me a coffee please https://stampandstories.blogspot.com My YouTube channel