Zeoslib Portal

When trying to execute the ExecProc method of a TZConnection I get the following error: "raised exception class ESQLException with message 'SQL Error: invalid statement handle. Error Code -901. Unsuccessful execution caused by system error that does not preclude successful execution of subseque...

cipto_kh, Thanks a million. Althought I did not use the ZStoredProc you were right in the method that I used in addressing the resultset. The Last method takes me to the last entry in the returning resultset. I have kept all code the same but merely changed DbcResultSet.Last to DbcResultSet.IsLast w...

A very silly question and something that I have done which worked and now it seems that I am completely stumped when trying to do the same thing again. On the database I have a stored procedure (FetchRoles) which looks like this: [font=Courier New] PROCEDURE FetchRoles( UserId CHAR(10)) RETURNS( Rol...

Thank you. Will try that and let you know the results. Again, many thanks.

I am trying to raise an exception when the database property of the connection is entered incorrectly. The application uses 2 databases, a test database and a production database. When the database name is entered incorrectly I get an error message (which is correct) but I want to customize the erro...

Hi Rogier21 , I have had a simpler problem and found the following to work each time: Your trigger as you have created it is not complete, complete in the sense that the ID is an integer and you should test for two conditions in the trigger: NULL and ZERO, which are not the same. So alter you condi...

Okay, it took a while but I have answered the question asked myself. Don’t know if anybody else had the problem merely because no responses were received. I know one can work with a table and query but because all my stored procedures are on the server and not the application this is not an option....

Another very silly question (for those being experts in Delphi and SQL) but for a novice a really difficult cookie to solve. Using Zeoslib 6.6.1 and Delphi7 and will set out the problem including source extracts. But my program is this: How to have a TComboBox component populated by the values retur...

Thank you so much for that, I will do that and check the results.

Again, thank you very much

[font=Arial]Me again, I have tried the following using the TZConnection component of ZEOSLIB 6.6.1 and this is regarding my previous post on users and roles. I will elaborate a little further to make things clearer: Database setup (example):[/font] [font=Courier New] CREATE ROLE SALESADMIN; CREATE R...

Hi, Just a question regarding ZEOSLIB. Currently I am using version 6.6.1 and Delphi 7 with Firebird 2.0.1. Having set up the database and defining the specific roles in the database the following question came to mind. Does ZEOS cater for connection to a Firebird database with roles? If not, is the...

Sorry for the post, was not concentrating when I went through the tutorial. Okay, the drag-and-drop works well. The execution was perfect and fast (although the dataset is small).

[font=Arial]Micheal, Firstly and foremost, thank you for the article and example that you have placed in the "Knowledge Base" section in the forum. If not for that article I would still be sitting in complete darkness, again, thank you very much. There are a couple of things that is a myst...

Thanks for the work done already, I only downloaded 6.6.0 (Beta) yesterday and will start working on it very soon (also after work) and if I do find anything weird or can do something wonderful then I will surely post it here. Again, thanks for all that you guys have done, it is more appreciate than...