SQLEntity question

[Lawrence Fisher]

Hi all

I have this code which fetches a value from Oracle

BusinessProcess bp = new BusinessProcess();
DynamicSQLEntity sqlEntity;
NumberColumn _total = new NumberColumn();

string _sqlStr = string.Format(@"SELECT SUM(SACH_KOLL_MAM) FROM Msmkim WHERE ASMKTA_SPK = '{0}'",
    _searchInvoiceString);

sqlEntity = new DynamicSQLEntity(IL.Server.Model.DataSources.GAZIT, _sqlStr.Trim());
sqlEntity.Columns.Add(_total);

bp.From = sqlEntity;
bp.ForFirstRow(() =>
{
    _exists = true;
    _totalInvoices.Value = _total.Value;

});

which always returns true which I understand, but the _total is zero. 

If I run the same code in the Oracle SQLDeveloper, the _total returns NULL which is actually what I wanted.

Is there anything I can do?

--

Sincerely

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

[Noam Honig]

set AllowNull to the number column

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/CAJSUFEocHsdU%3DHb7nvC5NniP37BM%3DLHg18aFGn7x-oRGfmmnNQ%40mail.gmail.com.

[Lawrence Fisher]

How?

NumberColumn _total = new NumberColumn();