Hello everyone.
So I have the following code:
Dictionary<int, List<ReportObject>> dict = new Dictionary<int, List<ReportObject>>();
EnvironmentVariable.setEnvId((int)environmentEnum.mll);
string sql = "Select order\_company\_id, order\_btl\_id , zehut, create\_date, time\_stamp, interface, company\_id, company\_name from BAKASHOT\_PIRTY\_MEIDA WHERE PROD IS NULL AND CHARGED = 1";
DataTable dt = GeneralDbExecuterService.executeSqlSelectDataScript(sql);
that takes the query result and inserts it into a datatable, so far so good.
I've recently added a column named update_date and inserted values only where charged=1 ( same as my query above).
somewhy I keep getting null values under update_date although when debugging, and copying the new select statement in my oracle developer, it will show me the update_date with values....... but code NADA .
Im clueless Ive been trying to work it out for the past 3h ;/
any suggestions? something Im missing?
thanks, have a nice day.