Zeoslib Portal

I've used
DelphiDateTimePicker.Time := QRYResult1.FieldByName('MYSQLTimeField').AsDateTime;
and solved the problem.

QRYResult1.FieldByName('MYSQLTimeField').Value is returning null when it should return the '00:00:00' converted to time format Example: DelphiDateTimePicker.Time := QRYResult1.FieldByName('MYSQLTimeField').Value; I'm getting a problem about null value. QRYResult1.FieldByName('MYSQLTimeField').Value ...

Thanks!

DataModule2.QryPesq.Close;

and

DataModule2.Conexao.Disconnect;

solved for me.

- Have you connected to the database? cause exception error in ZDbcMySqlResultSet.pas - Can you send the entire error message, or a print screen ? - If you want to avoid the error, use a try..except construction. I do have a program which connect, run queries and LOTS of things before the Applicati...

program Project1; uses Forms, Unit1 in 'Unit1.pas' {Form1}, Unit2 in 'Unit2.pas' {DataModule2: TDataModule}; {$R *.res} begin Application.Initialize; Application.CreateForm(TForm1, Form1); Application.CreateForm(TDataModule2, DataModule2); DataModule2.QueryPesq.SQL.Clear; DataModule2.QueryPesq.SQL....