Working with Aurelius

[Zelaya_Omar]

Hi,

I'm having an issue when accesing NullAble field from a Aurelis Entity.(Invalid Class TypeCast).

Any hint how to work with Nullable fields in scipt?

Thanks in advance,

Omar Zelaya

Script Code:
...
DBUsuarios := Manager.Find(TUSUARIO2)
.OrderBy('SITUACION')
.OrderBy('CODIGO')
.List;
for i := 0 to DBUsuarios.Count - 1 do
begin
DBUsuario := DBUsuarios.Items[i];
Usuario.ID := DBUsuario.ID;
Usuario.Codigo := DBUsuario.CODIGO;
Usuario.Nombre := DBUsuario.NOMBRE; <- Exception
end;
....

[Zelaya_Omar]

Hi,

One more question.

Any hint how can I convert the following delphi code to Aurelius script:

var
Results: TObjectList;
...
Results := Manager.Find
.Select(TProjections.ProjectionList
.Add(TProjections.Count('ID').As_('CantLicencias'))
.Add(TProjections.Sum('VALOR').As_('ValorLicencias')))
.Add(TExpression.Eq('ID_USUARIO', AIdUsuario))
.Add(TExpression.Eq('SITUACION', 'A'))
.ListValues;

Thanks in advace,

Omar Zelaya

[wlandgraf (Wagner Landgraf)]

Maybe this can help?

Tscripter pseudo-classes and Aurelius

Aurelius can't work (yet) with "classes" created at runtime. We are working on that, but it's not available. We do have a non-published code that integrated Aurelius and Scripter, here is a draft, attached. Use it at your own risk. But this is to integrate Scripter with existing Aurelius classes, only. Aurelius.Scripter.zip (5.8 KB)

[Zelaya_Omar]

Hi,

Thanks, I have figured out working with the projection, But still not find out about the Nullable fields(I'm allready using the Aurelius.Scripter.pas file).

Thanks in advance,

Omar Zelaya

[wlandgraf (Wagner Landgraf)]

The provided unit already handles nullable properties in Aurelius entities.
Did you check it, did you try it, if yes, do you have a specific reproducible case that we should analyze?