Search found 7 matches

by ash71
15.10.2020, 08:03
Forum: ZeosLib 7.3/8.0 Forum
Topic: I have truble with TZQuery.CachedUpdates := True in my project
Replies: 7
Views: 425

Re: I have truble with TZQuery.CachedUpdates := True in my project

Hi there, Today i reinstalled zeoslib and find that in my cases with Cached Updates all things works perfectly. Thanks. I found that in unit ZFunctionsStrings needs to add Math in unit section, related to compile error in row 282 d[i, j] := Min( Min(d[i-1,j]+1, // deletion d[i,j-1]+1), // insertion ...
by ash71
08.10.2020, 06:51
Forum: ZeosLib 7.3/8.0 Forum
Topic: I have truble with TZQuery.CachedUpdates := True in my project
Replies: 7
Views: 425

Re: I have truble with TZQuery.CachedUpdates := True in my project

hi, I think that all inserted records in cached state before ApplyUpdates must remain Inserted. In my case: 1. the dataset is in cached state; 2. do insert of new record with default values; 3. do post 4. recalculate values (some fields) in dataset with first, edit, supply values, post, next.. to th...
by ash71
06.10.2020, 17:35
Forum: ZeosLib 7.3/8.0 Forum
Topic: I have truble with TZQuery.CachedUpdates := True in my project
Replies: 7
Views: 425

I have truble with TZQuery.CachedUpdates := True in my project

Hello All. Latest Lazarus Win32. freetds or OleDB, msql With ZQuery.CachedUpdates := true; My project crashes when ZQuery.ApplyUpdates with message … "0 recod(s) updated. Only one record should have been updated." In my case i insert new record, then recalculate all records in dataset. Aft...
by ash71
14.09.2020, 18:49
Forum: ZeosLib 7.3/8.0 Forum
Topic: After zeos7.3 last update. Is not valid date format
Replies: 7
Views: 459

Re: After zeos7.3 last update. Is not valid date format

Yes. The problem persist. it seems i get around it with SQL CAST to DATETIME.
I attached the example here. sybdb.dll is needed to run this example.
No matter what is the state of DisableZFields
by ash71
12.09.2020, 18:10
Forum: ZeosLib 7.3/8.0 Forum
Topic: After zeos7.3 last update. Is not valid date format
Replies: 7
Views: 459

Re: After zeos7.3 last update. Is not valid date format

Hello
It seems that the problem has already been solved :)
The database column was of type DATE. And DisabledZFields was TRUE.
by ash71
24.08.2020, 08:15
Forum: ZeosLib 7.3/8.0 Forum
Topic: After zeos7.3 last update. Is not valid date format
Replies: 7
Views: 459

After zeos7.3 last update. Is not valid date format

Hello All. Latest Lazarus Win32. freetds, msql After the last update of zeos, my project crashes with message … "06/01/2020" is not valid date format ?! -->> Do note that 06 is the MONTH and 01 is the DAY of my date function TdmAPPRdbModule.DB_QueryCurMonthValues(fReSync:Boolean=false): Va...
by ash71
16.07.2020, 11:19
Forum: ZeosLib 7.3/8.0 Forum
Topic: ZQuery.Lookup does not return TDateTime value
Replies: 2
Views: 128

ZQuery.Lookup does not return TDateTime value

hello. latest Lazarus win32 with ZeosLib 7.3 and sql server 2014 In my case: varArray := ZQuery.Lookup'('ID', valueID, 'ID;DateAndTime;'); varArray [1] is null; for me I fixed in ZVariant.pas function EncodeVariant(const Value: TZVariant): Variant; added: vtTimeStamp: // MYFIF begin if TryTimeStampT...