Thanks to everyone for you replies. I have been wanting to get off of BDE for some time but have been unable to devote the time required to a mass conversion....
Hi all, my reported TIB_Connection.SchemaCache problem with Firebird 2.0 is easy to fix. The failing system table queries are in IB_Schema.pas: procedure...
Hello to all, I need to reduce the size of some TIB_ComboBox and I'm not getting success. Nothing happen if I alter the height property, or if I use ...
I don't understand what events I can register and use with IB Events. My challenge is that when one user modifies a record in a particular table, I need to...
... The one's you create ;) You need to create triggers in the database which detect exactly what changes you want the 'world' to know about ( it does not...
... It's not very weird. It simply means that the client has lost its connection to the server. ... No statement has been assigned to the dataset at this...
Thanks for the reply. I looked into the firebird log file and it was indeed a firebird server crash. I was running a test program that runs in a loop - insert...
Thanks Helen, this didn't solve the matter, cause setting this property like that, the arrow disapear and it can be a little confused to the user... No matter,...
Hi,
I have a complex OnPrepareSQL event, which is generating a longer "where" statement depending on a number of radioboxes, tEdits and checkboxes on a...
... But you have changed the 'content' of the query SQL, so you HAVE to 're-open' the query. Prepare will only speed things up if you are THEN using parameters...
Hi All, I have a simple DB grid attached to a TIBO Query/TIBO Database. The TIBO_DB is set to autocommit. The idea is simply that the 'operator' enters rows of...
... Are you using Autocommit? and/or an ORDER BY clause in your SQL? What's the CommitAction of the dataset? ... Adding new records to the end of a set should...
I have a TIB_Grid linked to a TIB_DataSource (DataSet is a TIB_Query). I can append a record through the grid, but if I try to append a second one it's not...
... The ... down ... the ... Yes, am using autocommit. Also using an Order By clause plus a WHERE to link this query to a master query through the DataSource...
Lester,
okay, than my way to close and reopen the query is the way to go.
Thanks for your help.
G.
Am 3 Oct 2005 um 13:26 hat Lester Caine geschrieben:
>...
Thanks for the encouragement! I have to admit I'm spending time getting the Trustware stuff automated and organized as it has been nagging me for years to do...
I'm just playing around with the onprepareSQL events of IBOquery and IB_query. Am I right, that both are firing during the form create event (which is also...
my c++ is not good enough, and my delphi is simply poor, so I am unable to translate from the CBuilder help file on this subject, which has a Delphi example,...
not that i'm in any way qualified to offer help to others, but i encountered a somewhat similar problem and solved it with using the invalidate method...even...
... Yes, if you make the datasets active during FormCreate. This isn't good client/server practice anyway, and is a relic of the BDE and Paradox. ... Yes....
... When you move off the first inserted record, Post is called. This is the first moment that anything is submitted to the database. If the Post fails, you...
Anyone know? When you InvalidateSQL, I think that all manually (programmatically) added SQLWhereItems are cleared. You don't have to clear the items separately...
Hi Alan, ... No, after InvalidateSQL the SQLWhereItems are empty; you can just start adding in the OnPrepareSQL handler. (Actually, I don't know _when_ they...
hello, I'm new to IBO and have converted my first project from BDE. Now I have a problem with empty string (or 0) values. My procedure "DatasetToCDS" to copy...
Helen,
thanks for your reply. I'm activating the queries while formshow, where everything is set correctly (parameters, added where clauses).
I've found the...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
