Hello all, I have noticed this as well. if you do a "select from non_existing_table" for example and trap the exception with the usual "on e:exception do begin...
This is probably an elementary misunderstanding on my part. I am converting a VCL BDE app to Firebird. All old controls have been converted appropriately in...
... No, it really doesn't do anything. TIBODatabase already has an embedded transaction, which is a TIBOTransaction. Compare this model (which is there for...
... with ... transaction ... model ... TIB_Transaction ... single ... a ... and ... default ... controls, ... don't ... IBODatabase. ... Many thanks - I think....
... If you have the source to 4.6.Bc you can change line 8300 in IBODataset.pas from if ( ErrorMessage.Count > 5 ) then to if ( ErrorMessage.Count > 7 ) then ...
Maybe I worked to long but I have no clue how to solve this ! How can I count (in Firebird SQL) the number of rows returned by this query ? (I need to use this...
... the ... I tried this one already, but on a table with approx. 1000 records it take more then 20 secs. - not really handy .... Seems like Firebird does not...
Hi again, Frank! I don't believe a query on a table with a mere 1000 records to take more than 20 seconds, but your "table" starts with "V_" so I assume it is...
1) The TIBOQuery I'm using has the following items set (I've redacted some of the fields for brevity): RequestLive = true OnMacroSubstitute = (a global routine...
Dear List I've taken the bold step to upgrade from FB1.5.3 to FB2RC4 Now I need to know if my backup-restore module written into my software, using IBO, and...
... Don't use macros to try to define parameters - use the correct syntax, viz. WHERE SESSION_ID = :session_id Architecturally, it's a bad decision in any case...
... It should; but one of the highly important purposes of working with beta software (as Fb 2.0 RC4 is) is to test such things. I'm curious about the...
... syntax, viz. ... provide "static" ... it ... prepared. ... alter ... BeforePost event. I see what you're saying, but the SESSION_ID *is* static. It's set...
... No. But this isn't the same thing. When you use a macro in an SQL statement, you're saying "Every time you process this statement, run the macro in place...
... other ... of) ... re- ... Man ... SQL ... run ... *string* ... that ... for ... that ... anticipate. ... I understand perfectly well what you're saying....
And the winner (not who I expected at all) is: "A call to Q.ClearFields made in the AfterInsert event handler." If I had to guess, I say that the BDE didn't...
... ibobject now ... not ... IBODataset.pas ... I have taken the line of least resistance and put a break at line 8298 of IBODataset.pas. Inspecting...
The problem is that UserExceptIndex isn't initialized. Putting "UserExceptIndex := 0;" above line 8299 fixes the problem. but I have no Idea why SQLCODE = -836...
Hi All, It seems that after I changed server from IB7 to FB2 RC4 IB_Events stopped working. Has anyone tried it. (I have an app that worked on IB7 with...
What properties must i configure to get the fastest as posible IB_Cursor??... the data are just readonly and all the records in the cursor are nedded.. i just...
... What do you mean by "better performance"? Is your routine slow? IB_Cursor fetches each row one-by-one. If "performance" means speed, you are measuring...
i'm implementing an OLAP application, so with a TIB_Cursor i get some data from the DB and fill some non DBAware controls with that information... these are...
... If you have the source code you can check how Jason did it. The reads in SchemaCache.pas (if that is the name, do a search) *should* logically be ...
... Define "slow", and show us some exerpts of your code. Several things may slow things down, if the database has a huge number of tables and fields, then IBO...
because it wants its DataSource to be connected to a TTable descendant. I looked into using TIB_LookupCombo, but *that* doesn't seem compatible with TIBOTable...
Thanx Dany... I was digging in the source code of IBO, and found that Jason use TIB_SchemaCursor in those queries... should i use TIB_SchemaCursor for my query...
... I can see he used a TIB_Dataset (parent of TIB_Cursor). This will have less functionality than TIB_Cursor and would (theoretically) perfor somewhat faster...
... No. They are two distinct series of components. TIBO* components are VCL-control-compatible via TDatasource; TIB_* components are "native IBO" and are...
... No, this is more or less the right way to retrieve a single value or a singleton row. The syntax in the above code isn't quite right, though, you should...
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.
