I appreciate the input and plan to make this standard practice when I use IBObjects from now on. But, is there somewhere I can read up on general discussions of how to approach the designs using best practices.įor example, earlier today Helen explained that I should be using a TIB_DSQL object for getting counts, instead of using the TIBOQuery object. I have the help files that came with my IBObject purchase, and I have used the help directly on the IBObjects web site.

I have been 'shooting from the hip' using IBObjects with limited docs. In 2009 Micro Focus acquired Borland, and continues to support the needs of software teams who must rapidly adapt to the increasing volume and velocity of evolving business requirements. (Although I suspect there is a good practices way of doing things) Founded in 1983, Borland has helped thousands of organizations improve and automate their software development capabilities. Select the desired user and click Open, the User Properties dialog will be displayed. I did shuffle the Prepare and Unprepare statements around, but it did not seem to make a difference. The FOCUS system requires PCC software version 6.28 or later. Once I activated all stations I started getting the counts I was expecting. Firebird SQL Server is distributed free of charge and has no license restrictions. There exist Firebird distribution packages for Windows, Linux, Unix, Solaris, MacOS, 32- and 64-bit architecture.

I feel a little silly, but there was really only one station activated in each case. Firebird SQL Server is a database server based on InterBase 6.0. It was the second condition in the WHERE clause: 'ActivateStation' = 1.

Interbase 6 open edition 6.0.2.0