Search found 16 matches

by Mando
03.08.2015, 11:32
Forum: Firebird
Topic: Chached Updates
Replies: 4
Views: 1905

Re: Chached Updates

Hi again.

Thanks Michal.
I'll try it as soon as possible.


Regards,
Mando.
by Mando
03.08.2015, 10:18
Forum: Firebird
Topic: Chached Updates
Replies: 4
Views: 1905

Re: Chached Updates

Hi:

Thanks for your answer, Michal.

Zeos 7.2 svn 3636. is in beta phase.
Is it safe for production application ??
Is it the same than Zeos 7.2 svn 3637 ??


regards.
by Mando
29.07.2015, 12:25
Forum: Firebird
Topic: Chached Updates
Replies: 4
Views: 1905

Chached Updates

Hi all. I've a grid attached to a zQuery in cahchedUpdates mode. The table has a Key field. I can insert and modify recors without problems, using a button with this code in Click event: with zqP do if UpdatesPending then begin ApplyUpdates; CommitUpdates; Refresh; end; but, if I delete every record...
by Mando
16.11.2012, 23:35
Forum: ZeosLib 7.0 Beta Forum
Topic: Float fileds + Lazaurs + Firebird
Replies: 3
Views: 1974

Ok, Thanks, but SQLdb has not that issue.


Regards.
by Mando
16.11.2012, 21:39
Forum: ZeosLib 7.0 Beta Forum
Topic: Float fileds + Lazaurs + Firebird
Replies: 3
Views: 1974

Float fileds + Lazaurs + Firebird

I've a table with a numeric (decial, float, double ...) field. If I post a value divisible by 10 (10,20,...an so until 90), the liked TDBEdit shows 1,2,...9, in other cases, shows the actualy value 11,21,55,66... If value has 1 or 2 decimals, the control rounds to iinteger (39,4->39 39,6->40->4). if...
by Mando
16.11.2012, 20:39
Forum: Firebird
Topic: [solved] I can't use "DROP TABLE" - Lazaruz - ZEOS
Replies: 11
Views: 3068

OOOOOOHH!!!!!


Thankyou very much!!!.

The problem is solved.....


regards
by Mando
16.11.2012, 18:42
Forum: Firebird
Topic: [solved] I can't use "DROP TABLE" - Lazaruz - ZEOS
Replies: 11
Views: 3068

Hello again: I discovered what is the problem. You mut use the same component (TZQuery) to do all operations. Create, open and drop the table. In my first project, I used Zconnection1.ExecuteDirect to create and to drop a table. This worked fine until the table is opened with a ZQuery component for ...
by Mando
16.11.2012, 14:13
Forum: Firebird
Topic: [solved] I can't use "DROP TABLE" - Lazaruz - ZEOS
Replies: 11
Views: 3068

Hello, thaks for your interest: Your testcase works properly, but try this: with ZQuery2 do begin close; SQL.text:='CREATE TABLE PEPE (FAMILIA CHAR(20), N INTEGER, DB DOUBLE PRECISION, NU NUMERIC(10,4), FL FLOAT)'; execSQL; end; with ZQuery1 do begin SQL.text:='SELECT * FROM PEPE'; open; close; end;...
by Mando
15.11.2012, 19:21
Forum: Firebird
Topic: [solved] I can't use "DROP TABLE" - Lazaruz - ZEOS
Replies: 11
Views: 3068

Hello: I tryed to install svn and I got this errors: Z:\Lazarus\ControlesLazarus\ZEOSDBO-7.0.1-beta - svn\src\dbc\ZDbcIntfs.pas(205,39) Error: Identifier not found "TZControlsCodePage" Z:\Lazarus\ControlesLazarus\ZEOSDBO-7.0.1-beta - svn\src\dbc\ZDbcIntfs.pas(205,50) Error: Identifier not ...
by Mando
15.11.2012, 13:16
Forum: Firebird
Topic: [solved] I can't use "DROP TABLE" - Lazaruz - ZEOS
Replies: 11
Views: 3068

Hi. Thanks for your response. I solved desinstalling version 7.0.1-beta an reinstalling 6.6.7 stable. But I still have this problem: I've a table with a numeric (decial, float, double ...) field. I post into it a value less than 10 with a 2 (or more) decimals (p.e. 5.92) and the value is posted righ...
by Mando
13.11.2012, 17:57
Forum: Firebird
Topic: [solved] I can't use "DROP TABLE" - Lazaruz - ZEOS
Replies: 11
Views: 3068

[solved] I can't use "DROP TABLE" - Lazaruz - ZEOS

Hello: That's my problem: I'm developing an aplication than generates a table according some values wich determine how much columns table should have. The first time I lanuch the process it works properly, but second time, I must drop that table. I close de component (TZQuery) first, but I get this ...
by Mando
24.02.2011, 11:14
Forum: 6.6 - stable
Topic: Lazarus + Zeos + Firebird Query wrong Field.Size
Replies: 0
Views: 517

Lazarus + Zeos + Firebird Query wrong Field.Size

Hi all. I've a Firebird DB wich I handle with an application made in Lazarus with Zeos. When I check the file.size of a string field of a table using a TZQuery, I get the file.size multiplied by 4. I thought it was because the database was in UTF8, but I tried the compoent TZTable and got his true s...
by Mando
29.09.2010, 11:38
Forum: 6.6 - stable
Topic: Handle ONPostError (laz+fb)
Replies: 0
Views: 661

Handle ONPostError (laz+fb)

Hi, I have a FB database. I want to handle errors through OnPostError event message of a ZQuery component in a TDataModule. Is it possible to determine the error?

I want to know the error code to perform an action based on it.


Regards
by Mando
21.09.2010, 01:06
Forum: 6.6 - stable
Topic: Zeos + Lazarus + Firebird - Numbers < 10 with 2 decimals
Replies: 4
Views: 899

Thanks, Guido, for your response. That is not exactly I'm looking for, but is a good porvisional solution. However, this would be the right DisplayFormat: '0.00'. Only one zero in the left side and the required zeros in the right side. Also we can use the format char '#' to specify optionals spaces ...
by Mando
20.09.2010, 12:10
Forum: 6.6 - stable
Topic: Zeos + Lazarus + Firebird - Numbers < 10 with 2 decimals
Replies: 4
Views: 899

Thanks for your response, guidoaerts. But I'm creating several Tztable and query components dinamically, and I don't want to do the fields definition
manually. Is there another way to solve this?


Thanks in advance.