Search found 474 matches

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: 11

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: 9
Views: 93

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: 9
Views: 93

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: 9
Views: 93

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: 6

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: 9
Views: 93

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: 9
Views: 93

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: 1001

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: 1001

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: 33

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: 68

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: 452

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: 1199

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
by marsupilami
22.02.2017, 13:58
Forum: ZeosLib 7.1 stable Forum
Topic: ZQuery in transaction
Replies: 5
Views: 63

Re: ZQuery in transaction

You might want to check wether it makes sense to start a transaction in the before post event and commit or roll back it in the after post event. Unfortunately if you have to roll it back you would have to close and open your query, I think. Something alon these lines...

With best regards,

Jan
by marsupilami
16.02.2017, 00:35
Forum: ZeosLib 7.1 stable Forum
Topic: How to Disable inbult Sort?
Replies: 7
Views: 69

Re: How to Disable inbult Sort?

Hello ToodleDoo, But - this didn't happen when I used this almost exact same code in Windows. I have changed over to Ubuntu and Lazarus and re-compiling everything, but that section of code is predominantly unchanged and used to work as expected. Honestly I doubt that you have used Zeos on Windows b...

Go to advanced search