Search found 26 matches
- 08.05.2024, 08:58
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: ZMemTable does not support the ftCurrency type
- Replies: 4
- Views: 136
Re: ZMemTable does not support the ftCurrency type
It works as it should, it seems. Thank you. I have already opted for ftBcd in my application. The attempt with ftCurrency was just a quick prototype. I absolutely agree that this field type (with a very misleading name) should be avoided, but I think it's good for ZEOS to support it now, even if it'...
- 01.05.2024, 15:52
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: ZMemTable does not support the ftCurrency type
- Replies: 4
- Views: 136
ZMemTable does not support the ftCurrency type
Steps to reproduce problem: ZMemTable1.Active := False; ZMemTable1.FieldDefs.Clear; ZMemTable1.FieldDefs.Add('price', ftCurrency); ZMemTable1.Open; // <- Error: ZMemTable1: Type mismatch for field 'price', expecting: Blob actual: Currency. I think the error is in: TZAbstractRODataset.GetFieldClass(F...
- 01.06.2023, 10:17
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: OleDb and MS Access
- Replies: 9
- Views: 762
Re: OleDb and MS Access
The same sequence is present in 'ZDbcOleDBStatement.pas' in one more place. I guess that line should be corrected in the same way. The problem is that I cannot create a situation where that part of the code would be executed. Unfortunately, autonumber for Access still doesn't work. The problem with...
- 31.05.2023, 19:44
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: OleDb and MS Access
- Replies: 9
- Views: 762
Re: OleDb and MS Access
I think I found a solution to the bug with negative integer values. unit ZDbcOleDBStatement; ... procedure TZOleDBPreparedStatement.InternalBindSInt(Index: Integer; SQLType: TZSQLType; Value: NativeInt); ... // PDBLENGTH(PAnsiChar(fDBParams.pData)+Bind.obLength)^ := L shl 1 + Byte(Ord(Negative)); //...
- 31.05.2023, 16:11
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: OleDb and MS Access
- Replies: 9
- Views: 762
Re: OleDb and MS Access
With ADO everything works, but it would be nice to have the performance improvement offered by OleDB.
OleDB ado table open 0.025 0.648 table scan 0.889 4.012 sql select 0.866 1.183 sql insert 1.523 2.321
- 31.05.2023, 11:06
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: OleDb and MS Access
- Replies: 9
- Views: 762
Re: OleDb and MS Access
After additional testing, a new problem: it is not possible to write negative values in SHORT and LONG integer fields. For example, if I try to write -5 in the SHORT field, the parameter that ZEOS will pass is '-'. The last character seems to have been cut off. ZTable1.AppendRecord([2, -5]); ZSQLMon...
- 30.05.2023, 12:26
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: OleDb and MS Access
- Replies: 9
- Views: 762
Re: OleDb and MS Access BIT(Boolean) data type
Correction: BIT fields work correctly. I mistakenly used one of the reserved words as a field name in the test. On the other hand, I don't know why this is a problem given that the 'IdentifierQuoteString' value is correctly set to '[]'. EDIT: Of all the reserved words, I hit exactly one that is not ...
- 29.05.2023, 09:58
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: OleDb and MS Access
- Replies: 9
- Views: 762
OleDb and MS Access
The OleDb protocol does not support writing of BIT(Boolean) and DATETIME fields to the MS Access MDB from dataset controls. The problem with the DATETIME field can be solved by adding the following line to the code: ZConnection1.Properties.Add('DatetimeWriteFormat=YYYY-MM-DD HH:NN:SS'); Is there som...
- 15.05.2020, 09:13
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: 'Wrong DeRegisterOpenUnCachedLob beahvior'
- Replies: 3
- Views: 180
Re: 'Wrong DeRegisterOpenUnCachedLob beahvior'
I don't know about rev. 6528 but in latest rev. 6530 the problem seems to be solved.
- 12.05.2020, 17:44
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: 'Wrong DeRegisterOpenUnCachedLob beahvior'
- Replies: 3
- Views: 180
'Wrong DeRegisterOpenUnCachedLob beahvior'
There is a problem (which was not in the revisions from just a few days ago) with transactions and blob fields in Firebird. When the code below is run, this is an error: Debugger Exception Notification --------------------------- Project Project1.exe raised exception class EAssertionFailed with mess...
- 12.05.2020, 10:32
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: How to add an item to database keyword list
- Replies: 6
- Views: 362
Re: How to add an item to database keyword list
Tested with r6516 and it now works ok. Thank you.
- 11.05.2020, 14:00
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: ZTable/ZQuery with persistent fields broken
- Replies: 6
- Views: 281
Re: ZTable/ZQuery with persistent fields broken
I am happy to confirm that the issue seems to have been resolved in rev. 6507.
- 11.05.2020, 13:55
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: Correct query causes error with Zeos
- Replies: 4
- Views: 197
Re: Correct query causes error with Zeos
As far as I can see, the problem has already been solved in r6507.
Great job.
Great job.
- 11.05.2020, 13:31
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: How to add an item to database keyword list
- Replies: 6
- Views: 362
Re: How to add an item to database keyword list
Added reserved words include changes from version 5.1 to 8, so it's wrong to include them only if the latest version of MySQL is detected. It is not "starting with v8", it's "up to v8". Besides, there is MariaDb and its versions. As things stand now (r6507), 'OVER' (the keyword t...
- 10.05.2020, 18:54
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: How to add an item to database keyword list
- Replies: 6
- Views: 362
Re: How to add an item to database keyword list
I don't use SVN and it's too much work for me to install it now and re-learn the forgotten so here's the change that needs to be made in src\dbc\ZDbcMySqlMetadata.pas: function TZMySQLDatabaseInfo.GetSQLKeywords: string; begin Result := 'AUTO_INCREMENT,BINARY,BLOB,ENUM,INFILE,LOAD,MEDIUMINT,OPTION,'...