Zeoslib Portal

I'm running Delphi 10.4 and this only happens with ZQuery. This does not happen with the FireDAC query or any other query. I also often use the RxMemoryTable, and this effect does not occur there either. Something is misaligned when setting "DisplayFormat". Does the ZQuery look for the fir...

I have a strange effect. If the ZQuery is opened and the display format is set for a DateTime field and the DateTime field is empty in the first record, the focus in the DBgrid is drawn incorrectly. The internal data record pointer was probably changed by "DisplayFormat" ? See attachement ...

Hello Jan

Yes, now there are no more access violations when changing the WLAN. Everything perfect.

Thanks
Norbert

Hello jan

Yes, that fits, if I deleted "pfInUpdate" from the ProviderFlags, the field is not taken into account in the update.

Thanks
Norbert

First => ZQuery.GetFieldNames()

No, that's the same error, I wrote the process upside down.
I'll try the new version later.

Norbert

Hello Jan that only partially helps. "Zquery.Open" now comes with ZConn.OnLost :D The first error (Error1.jpg) still occurs at exactly this point (See attachement) ... ZDbcOleDBStatement.pas procedure TZAbstractOleDBStatement.ClearCallResultCache; Line 547: for I := 0 to FCallResultCache.C...

If I fetch an SQL command from a view and it contains a field that cannot be changed (from another table), it works fine for ZQuery.Edit and ZQuery.Post. An error occurs (from MS-SQLserver) with ZQuery.Insert and ZQuery.Post because the field must not be modified with. Can I remove the field from th...

I get the Error1, in the error handling, when ZQuery.Open. Error2 also appears later. cause in the source text ... ZAbstractRODataset.pas function TZAbstractRODataset.CreateResultSet(const SQL: string; MaxRows: Integer): IZResultSet; Line 3516 else Result := Statement.ExecuteQueryPrepared; ZAbstract...

I tried to see what you do but this file seems to not be based on a recent version of Zeos 8? In Zeos 8 Egonhugeist introduced the OnLost event on the TZConnection. This allows Zeos to handle everything necessary (close datasets, free ressources where necessary) and then gives you the chance to rec...

There is a small error in the current sources.
When compiling without ZParam ...

raise EZSQLException.Create(SInvalidVarByteArray);

must not be used in the Line 1917 from ZDatasetUtils.pas

use => EZDatabaseError.Create()

Norbert

Hello Jan While you're at it, I have one more bug that I've tried to build myself - but I'm not sure if it's 100% accurate. If the program runs on a laptop with WLAN and the ZConnection is always open (which makes sense) and you carry the laptop around the company and change the WLAN or you plug in/...

Hello Jan

Yes, that solves the problem.
I installed [r7829] and the error no longer occurs in the test program and in the correct large program.

great!!!

Norbert

I work with Delphi 10.4 and Zeos 8.0 beta (without ZParam) on Windows 10. Up to version 1903 everything works fine. Now the clients have Win10 version 21H2 on it. In the case of SQL select with larger amounts of data, an access violation (stack overflow) occurs with ZQuery.Close, ZQuery.Free or ZQue...

Hi Michael

When I set the date format to DD.MM.YYYY, the QuickReport-Designer also works with the current Zeos8 version (with DISABLE_ZPARAM), because internally the date is passed to the parameters as text.

so everything ok
Norbert

oh yes the properties on the Zconn
sometimes you need food for thought

OK, thanks

Norbert