Search found 7 matches
- 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 ...
- 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...
- 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...
- 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
I attached the example here. sybdb.dll is needed to run this example.
No matter what is the state of DisableZFields
- 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.
It seems that the problem has already been solved
The database column was of type DATE. And DisabledZFields was TRUE.
- 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...
- 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...