Search found 14 matches
- 19.12.2011, 18:55
- Forum: 6.6 - stable
- Topic: TZSQLProcessor - Error creating trigger
- Replies: 0
- Views: 606
TZSQLProcessor - Error creating trigger
Hi to all, with the TZSQLProcessor I try to create a trigger in a FB 2.1 Database (I'm using Delphi 2007) SET TERM ^ ; CREATE TRIGGER TEST_BI0 FORTEST ACTIVE BEFORE INSERT POSITION 0 AS begin if (new.id is null) then new.id = genera_guid(); end^ SET TERM ; ^ il gives me this error: SQL Error:_ Dynam...
- 20.11.2007, 12:01
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: FB2 & ZL 6.6.2
- Replies: 4
- Views: 1298
- 19.11.2007, 18:00
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: FB2 & ZL 6.6.2
- Replies: 4
- Views: 1298
- 19.11.2007, 12:52
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: FB2 & ZL 6.6.2
- Replies: 4
- Views: 1298
FB2 & ZL 6.6.2
Hi, I'm testing ZL 6.6.2 and Firebird 2.0 with Delphi 2007. I try to explain my problem (sorry for my english) Tab1 had a trigger. this trigger start a Stored procedure that populates Tab2 and Tab3 I insert a record in Tab1, and the SP and I populated with data Tab2 and Tab3. Everything works perfec...
- 16.06.2007, 12:49
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: Trouble while installing ZEOSDBO 6.6.1 beta on Delphi 2007
- Replies: 18
- Views: 4919
- 23.04.2007, 14:38
- Forum: User Contributions
- Topic: [bug_fixed] Delphi 2007 for Win32 Support
- Replies: 11
- Views: 7680
- 23.04.2007, 08:22
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: Trouble while installing ZEOSDBO 6.6.1 beta on Delphi 2007
- Replies: 18
- Views: 4919
- 19.04.2007, 09:19
- Forum: User Contributions
- Topic: [bug_fixed] Delphi 2007 for Win32 Support
- Replies: 11
- Views: 7680
- 02.03.2007, 09:41
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: ZEOSDBO-6.6.0-beta BDS2006 install problem
- Replies: 43
- Views: 20566
- 27.02.2007, 11:07
- Forum: 6.5.1 (alpha) - 6.6.x (beta)
- Topic: ZEOSDBO-6.6.0-beta BDS2006 install problem
- Replies: 43
- Views: 20566
Hi to all, I'm new of BDS2006 and I wanna installa zeosib on it. I read carfully all post and I have this error: Remove ZPropertyEditor, ZUpdateSqlEditor, ZComponentReg. Unit(s) ZPropertyEditor, ZUpdateSqlEditor, ZComponentReg were found in required package ZComponent. This problem may be caused bec...
- 23.10.2006, 13:48
- Forum: 6.1.5
- Topic: TZConnection & Roles
- Replies: 0
- Views: 2490
TZConnection & Roles
Hi to all, I wanna use the roles to manage the users access to the Firebird database. I have to pass the ROLE paramenter to the database during the connection. I thought to insert this row in Properties: role=administrator but it looks like it never exists. Someone knows how do pass the role to the ...
- 07.10.2006, 09:50
- Forum: 6.1.5
- Topic: TZStoredProc error
- Replies: 2
- Views: 3033
- 04.10.2006, 08:50
- Forum: 6.1.5
- Topic: TZStoredProc error
- Replies: 2
- Views: 3033
TZStoredProc error
Hi to all, I'm using ZL 6.1.5 + D6 + FB 1.5. I wrore a Stored Procedure in FB taht work good. I'm useing the TZStoredProc in a DataModule and the first time I use the TZStoredProc component it's all right, but when I try to use it again, I have this error: SQL Error: dynamic SQL error parameter mism...
- 13.09.2006, 09:01
- Forum: 6.1.5
- Topic: AutoGenerateValue
- Replies: 0
- Views: 2493
AutoGenerateValue
Hi to all, I'm new on this list and a new ZeosLib User with Delphi 6 ent. I'm studing ZeosLib 6.1.5 with Firebird 1.5 and I have a little problem. In IBX there is the AutoGenerateValue property that permit to to fetch the automatically-generated values generate by the database. I'm tring to use the ...