Hello Wayne, IBPhoenix supports the firebird database they don't have a database that is called IBPhoenix. Are you committing your transactions? You need to explicitly call commit to make something explicit in the database. Also when working with databases like Interbase and Firebird you should also start transactions explicitly otherwise you could run the risk of having degraded performance especially in a multi-user system. When you say you want your users to be able to see things immediately how are you displaying data to them? If you are using a grid for browsing then a read committed read only transaction will display committed data to other users. I would suggest you look at obtaining the Firebird book by Helen Borrie and also go to the IBObjects website and look at some of their technical documents as they give you a nice overview of this sort of thing. Also with the group by clause firebird gives a warning if you are not complying with some query snyntaxes. Probably you have an order by clause but you dont have the field that you are order by in your group by clause. Doing this helps the cost based query analyser better understand your query and provides a chance of better performance of your queries. I hope that the above helps. Regards Peter
[Non-text portions of this message have been removed]
