Search found 476 matches

by marsupilami
24.03.2017, 10:22
Forum: ZeosLib 7.2 Betatest Forum
Topic: UncachedGetColumns and numeric/decimal
Replies: 13
Views: 128

Re: UncachedGetColumns and numeric/decimal

Hello Abonic, I had a look into the problem with TFloatField and its precision. First of all TFloatField implements a field for double precision data types. So generally restricting its precision to 7 does't make sense. If we keep mapping NUMERIC and DECIMAL fields to TFloatField and TSingleField, i...
by marsupilami
22.03.2017, 08:51
Forum: ZeosLib 7.2 Betatest Forum
Topic: Error: The call to Setparameterinfo is not executed (Excel,ado on disconnect)
Replies: 1
Views: 15

Re: Error: The call to Setparameterinfo is not executed (Excel,ado on disconnect)

Hello Moneo,

could you maybe provide a small sample application and sample Excel sheet? This way I don't have to create them myself and can start right into debugging the issue.

With best regards,

Jan
by marsupilami
22.03.2017, 08:49
Forum: ZeosLib 7.2 Betatest Forum
Topic: UncachedGetColumns and numeric/decimal
Replies: 13
Views: 128

Re: UncachedGetColumns and numeric/decimal

Hello abonic, we can do it like that. It would help me a lot if you could create tickets on Sourceforge (https://sourceforge.net/p/zeoslib/tickets/). This way I don't have to copy your informaion from the forums to the tiket system. Also it helps to not forget these things. ; ) With best regards, Jan
by marsupilami
21.03.2017, 10:39
Forum: ZeosLib 7.2 Betatest Forum
Topic: UncachedGetColumns and numeric/decimal
Replies: 13
Views: 128

Re: UncachedGetColumns and numeric/decimal

Hello abonic,

the first bug was fixed under Ticket #192. I will start working on the second bug tomorrow.
With best regards,

Jan
by marsupilami
20.03.2017, 15:20
Forum: ZeosLib 7.2 Betatest Forum
Topic: UncachedGetColumns and numeric/decimal
Replies: 13
Views: 128

Re: UncachedGetColumns and numeric/decimal

Hello abonic, I am sorry for the inconvenience. New users need three approved posts to be moved to a group where their posts don't need any approval. I didn't get to do the work until now. But you should be able to post without restrictions now. I have to admit, I couldn't read through your new prop...
by marsupilami
20.03.2017, 15:15
Forum: ZeosLib 7.1 stable Forum
Topic: (Caluclated) "Field XXX cannot be modified" in ZQuery OnCalc event?
Replies: 1
Views: 8

Re: (Caluclated) "Field XXX cannot be modified" in ZQuery OnCalc event?

Hello tomr, this is expected behaviour, if you select the calculated fields in a query like this: select a, b, a+b as c from mytable If your code is like this, and you don't use TZUpdateSQL, then c will be a read only data field. If I understand correctly what you do you need to select the data with...
by marsupilami
14.03.2017, 09:41
Forum: ZeosLib 7.2 Betatest Forum
Topic: UncachedGetColumns and numeric/decimal
Replies: 13
Views: 128

Re: UncachedGetColumns and numeric/decimal

Hello abonic, I suggest to use the following code as the fix. Although it is a bit more lengthy, it makes decisions about the type of a field very clear, I think. // TYPE_NAME case TypeName of 7: case SubTypeName of 1: Result.UpdateString(TableColColumnTypeNameIndex, 'NUMERIC'); 2: Result.UpdateStri...
by marsupilami
13.03.2017, 22:02
Forum: ZeosLib 7.2 Betatest Forum
Topic: UncachedGetColumns and numeric/decimal
Replies: 13
Views: 128

Re: UncachedGetColumns and numeric/decimal

Hello abonic, thank you for the patch. I hit that problem in the past too but decided to not (yet) debug the issue. I will add your patch but curently I have to admint that I will probably modify it because I dislike the way that some things happen in the case statement but not always there because ...
by marsupilami
09.03.2017, 17:41
Forum: ZeosLib 7.2 Betatest Forum
Topic: ZConnection problems connecting to PostgreSQL
Replies: 15
Views: 1017

Re: ZConnection problems connecting to PostgreSQL

Hello JD, hmm - I have a problem here because I think it is something on your computer. For me everything works es expected. My Environment: - Windows 10, 64 Bits - FPC 3.0.2, 32 Bits - Lazarus 1.6.4, compiled from Source - PostgreSQL 9.6.2, 32 Bits, installed from EnterpriseDB installer My properti...
by marsupilami
07.03.2017, 16:11
Forum: ZeosLib 7.2 Betatest Forum
Topic: ZConnection problems connecting to PostgreSQL
Replies: 15
Views: 1017

Re: ZConnection problems connecting to PostgreSQL

Hello jd, I suggest you use the latest Zeos 7.2 from SVN. Even Zeos 7.1.2 RC isn't the current version of Zeos 7.1 anymore. I think, I had the same problem with Zeos 7.1 and fixed it with code like this: ChDir(ExtractFilePath(ZConnection.LibraryLocation)); ZConnection.Connect; Chdir(ExtractFilePath(...
by marsupilami
05.03.2017, 11:16
Forum: MySQL
Topic: Erro loading libmysql.dll
Replies: 0
Views: 35

Re: Erro loading libmysql.dll

Hello Vipeol, usualy this means that you try to load a 64 bits dll into a 32 bits application or the other way around. You can either install a client library that matches your program or you change your program. Under some rare circumstances I had this happen because the dll could not load some oth...
by marsupilami
27.02.2017, 13:20
Forum: ZeosLib 7.2 Betatest Forum
Topic: Error installing in Delphi 7
Replies: 2
Views: 71

Re: Error installing in Delphi 7

Hello tkszeos,

did you remove all the old Zeos DCU files?
With best regards,

Jan
by marsupilami
26.02.2017, 08:32
Forum: ZeosLib 7.1 stable Forum
Topic: ZQuery and Refresh
Replies: 13
Views: 454

Re: ZQuery and Refresh

Hello Andreas,

the problem has been fixed im the current SVN revision of Zeos 7.2.
With best regards,

Jan
by marsupilami
22.02.2017, 14:09
Forum: 6.6 - stable
Topic: TZquery dont works with Multiple Statements
Replies: 17
Views: 1204

Re: TZquery dont works with Multiple Statements

Hello Stevie,

I just checked in your changes for Zeos 7.1. Michael adapted your changes for Zeos 7.2 yesterday evening. So you might want to check out Zeos 7.2 ;)

With best regards,

Jan

Go to advanced search