Ao carregar tabela para taureliusdataset retorna erro "raised exception class EConvertError with message ''null' is not a valid date and time'".

BIZ TMS Aurelius
1

Utilizo delphi 12 e a ultima versão do aurelius.

Segue trecho:

procedure TDAOMobOfflineClass.CarregarADSPessoas(var _ADS: TAureliusDataset; out _ACount: Integer; _AFiltro: TStrings);
var
   ACriteria, AClonedCriteria: TCriteria;
begin
   ACriteria := GetNewManager.CreateCriteria(TPessoa);
   TFiltro.Create(ACriteria, _AFiltro);
   ACriteria.CreateAlias('Cidade', 'Cidade');
   ACriteria.Add(TLinq.Eq('Ativo', 1));
   ACriteria.Add(TLinq.Eq('Status', 0));
   ACriteria.Add(TLinq.Eq('Cliente', 'S'));
   ACriteria.Add(TLinq.Eq('ChaveEmpresa', ObjetosApp.TabelasInd.Clifor));
   if (ObjetosApp.UsuarioEmpLog.Usuario.ChaveReprCHMob > 0) then begin
      ACriteria.CreateAlias('CliforRepr', 'CliforRepr');
      ACriteria.Add(TLinq.Eq('Representante', 'N') or (TLinq.Eq('Representante', 'S') and
         ((TLinq.Eq('ChaveVendedor', ObjetosApp.UsuarioEmpLog.Usuario.ChaveReprCHMob)) or TLinq.Eq('CliforRepr.ChaveVendedor', ObjetosApp.UsuarioEmpLog.Usuario.ChaveReprCHMob))));
   end;
   ACriteria.RemovingDuplicatedEntities;
   AClonedCriteria := ACriteria.Clone;
   _ACount := AClonedCriteria.Select(TProjections.ProjectionList
      .Add(Linq['Chave'].Count.As_('Count'))).UniqueValue['Count'];
   _ADS.Close;
   _ADS.SetSourceCursor(ACriteria.Open);   // <- gera exceção ' is not a valid date and time'
   _ADS.Open;
   _ADS.First;
end;

no trecho : _ADS.SetSourceCursor(ACriteria.Open);
gera a exceção.

meus models estão com o tipo nullable<>

2

What code do you have in TFiltro.Create(ACriteria, _AFiltro)?

What is your mapping class?

What is your database data? Have you tried loading a table with only one record?

What is the database you are using?

What is the call stack when the error occurs?

3

Estou utilizando sqlite.

chamada da pilha:
:77449542 KERNELBASE.RaiseException + 0x62
:002e2c28 StrToDateTime + $34
System.SysUtils.StrToDateTime('null',())
:002e2c28 StrToDateTime + $34
:00c76a8a TSQLiteSQLGenerator.ConvertValue + $E2
:00bb66c1 TAbstractSQLPerformer.ConvertFieldValue + $F5
:00bb70b6 TAbstractSQLPerformer.ReadFieldValue + $42
:00bfecfc TEntityLoader.ReadFieldFromResultset + $C0
:00bfe957 TEntityLoader.LoadSimpleProperties + $B3
:00bfe5be TEntityLoader.LoadObject + $DA
:00bfd9c7 ReadObject + $67
:00c0c3c8 TSelecter.SelectFetch + $DC
:00c4327d TObjectManager.TEngineCursor.Next + $FD
:00e7259e TCursorSource.FetchMore + $3A
:00e69c84 TBaseAureliusDataset.FetchMoreRecords + $54
:00e6a973 TBaseAureliusDataset.InternalGetRecord + $9B
:00e6ab6a TBaseAureliusDataset.GetRecord + $106
:009f3262 TDataSet.GetNextRecord + $7E
:009f3137 TDataSet.UpdateBufferCount + $DF
:009f03ea TDataSet.Open + $A
:00fd8914 TfrmPessoas.CarregarPessoas$ActRec.$0$Body + $38
:0038d1a4 TAnonymousThread.Execute + $8
:002bb1fa ThreadWrapper + $2A
:76bb7ba9 KERNEL32.BaseThreadInitThunk + 0x19
:77bcbdab ntdll.RtlInitializeExceptionChain + 0x6b
:77bcbd2f ntdll.RtlClearBits + 0xbf

parece ser em um campo de datahora mas todos estão mapeados com
nullable<>

4

What code do you have in TFiltro.Create(ACriteria, _AFiltro)?

What is your mapping class?

What is your database data? Have you tried loading a table with only one record?

It looks like the data in your table is not a valid date time.