Search found 14 matches

by rrricci
06.09.2024, 15:02
Forum: ZeosLib 7.3/8.0 Forum
Topic: Lazarus - TZUpdateSQL not bringing its update fields selected
Replies: 15
Views: 817

Re: Lazarus - TZUpdateSQL not bringing its update fields selected

Just a correction.. Also comment the block:

if ListBox.Items.Count > 0 then
begin
end;

Thanks
Renato Ricci
by rrricci
06.09.2024, 14:57
Forum: ZeosLib 7.3/8.0 Forum
Topic: Lazarus - TZUpdateSQL not bringing its update fields selected
Replies: 15
Views: 817

Re: Lazarus - TZUpdateSQL not bringing its update fields selected

Hello.. I think I found the solution.. Please validade it.. At file ZUpdateSqlEditor.pas in src/component I have commented out the 2 lines below and it worked, cause does not make sense the component set selected(i) = true and later on it set the itemindex equals 0. (will loose the selection right?)...
by rrricci
09.08.2023, 20:59
Forum: ZeosLib 7.3/8.0 Forum
Topic: Lazarus - TZUpdateSQL not bringing its update fields selected
Replies: 15
Views: 817

Re: Lazarus - TZUpdateSQL not bringing its update fields selected

Hello Renato, unfortunately - no. There simply was no time to look at it yet. With best regards, Jan If you would like to, you can give me some tips where to look around in the code and I'll try to fix it, and then I'll post you back the solution. PS: Using Lazarus 2.2.6 / FPC 3.2.2 Thanks. Renato
by rrricci
25.07.2023, 15:40
Forum: ZeosLib 7.3/8.0 Forum
Topic: Lazarus - TZUpdateSQL not bringing its update fields selected
Replies: 15
Views: 817

Re: Lazarus - TZUpdateSQL not bringing its update fields selected

Hi friends.. any news about this bug? Is there any patch?

Thanks

Renato
by rrricci
11.05.2023, 19:54
Forum: ZeosLib 7.3/8.0 Forum
Topic: Lazarus - TZUpdateSQL not bringing its update fields selected
Replies: 15
Views: 817

Re: Lazarus - TZUpdateSQL not bringing its update fields selected

marsupilami wrote: 11.05.2023, 08:41 Hello Renato,

currently this is a known issue that I cannot fix. There are other bugs that have to be fixed first.

With best regards,

Jan
Hello Jan.. Thanks for the feedback.. For now I will keep with the previous version..

Thanks and good luck!
Renato
by rrricci
05.05.2023, 21:48
Forum: ZeosLib 7.3/8.0 Forum
Topic: Lazarus - TZUpdateSQL not bringing its update fields selected
Replies: 15
Views: 817

Lazarus - TZUpdateSQL not bringing its update fields selected

Hello friends, I have notice that on Lazarus 2.2.4 or above, on the TzUpdateSQL component, the existing update fields are not been selectec when we double click the component. Please see attachment. I wonder if this is a new behavior or a simple bug. On my earlier lazarus version all fields were sel...
by rrricci
06.01.2016, 12:31
Forum: ZeosLib 7.2 Forum
Topic: Set Application Name + PostgreSQL (SOLVED)
Replies: 2
Views: 1013

Re: Set Application Name + PostgreSQL

Hi Michal.. Thanks for the help.. I added your suggestion on BeforeConnect and it worked!

Thank you!

Renato
by rrricci
05.01.2016, 20:14
Forum: ZeosLib 7.2 Forum
Topic: Set Application Name + PostgreSQL (SOLVED)
Replies: 2
Views: 1013

Set Application Name + PostgreSQL (SOLVED)

Hello all.. Is there any way to set Application_Name when using PostgreSQL? For exemple: When we connect to PostgreSql and run 'SELECT * FROM pg_stat_activity;' there is a field called application_name.. How to set it? I know that with MSSQL it works..See: http://zeoslib.sourceforge.net/viewtopic.ph...
by rrricci
04.01.2016, 21:20
Forum: ZeosLib 7.2 Forum
Topic: SQL statment at TzUpdatesql is not getting saved when adding new field
Replies: 5
Views: 985

Re: SQL statment at TzUpdatesql is not getting saved when adding new field

Hi Jan..

I am currently using Zeos 7.2.0-beta.. But I noticed this same behavior on past versions too..

Thanks!
Renato Ricci
http://www.singlesistemas.com.br
by rrricci
24.12.2015, 14:02
Forum: ZeosLib 7.2 Forum
Topic: SQL statment at TzUpdatesql is not getting saved when adding new field
Replies: 5
Views: 985

SQL statment at TzUpdatesql is not getting saved when adding new field

Hi.. Since last version, I noticed that when we add a new field at TzQuery and then, we Generate a new SQL Statment at TzUpdateSQL, this new field is not kept when you close IDE.. Even if you save your project. Try to repreduce this steps: 1) Add "select field_a, field_b from test;" to TzQ...
by rrricci
28.10.2014, 01:51
Forum: ZeosLib 7.1 stable Forum
Topic: TField.Size different from db when varchar
Replies: 4
Views: 1080

Re: TField.Size different from db when varchar

Yes, you got it. I was talking about SqlDB. Ok. I understood now.. So I think the only way to control maxlength is set directly to the dbedit field one by one. For those who's having the same problem, may be interesting to read this article: http://forum.lazarus.freepascal.org/index.php/topic,7742.m...
by rrricci
27.10.2014, 02:06
Forum: ZeosLib 7.1 stable Forum
Topic: TField.Size different from db when varchar
Replies: 4
Views: 1080

Re: TField.Size different from db when varchar

Thanks for replying.. Ohh yes! You were trying to align Size and Display properties. Sorry. Correct, I use LCL + UTF8 fields. DB Field Size: varchar(10) TField.Size after import: 40 My question is: most people use to use the Size property to control the maxlength of a DbEdit, and with the current be...
by rrricci
24.10.2014, 02:21
Forum: ZeosLib 7.1 stable Forum
Topic: TField.Size different from db when varchar
Replies: 4
Views: 1080

TField.Size different from db when varchar

Hello all, some time ago, there was a long discussion about this issue, and searching this forum, i found this link http://zeoslib.sourceforge.net/viewtopic.php?f=33&t=3611 where at the last message our friend EgonHugeist gave a solution. However, I would like to know if this solution is valid f...