Hi-- I thought I'd share our findings incase someone else finds themselves in a similar position. As far as I can tell, QR and IBO/FB all work perfect...
This problem cropped up with a user DB. We're running Firebird 2.1, with an application written in Delphi, using IBObjects as the interface. A table in the...
Hi I donīt understand the behaviour of a TIB_ComboBox in a Grid. I have a Integer Field with a fixed range of values e.g. 1 2 3 and I want to display "one"...
... Yes: although this is NOT an IBO question. Never resolve a limbo transaction by dropping the table! Limbo status is perfectly "normal" where you have...
I tracked down the problem to the procedure TIB_CustomGrid.GetCellDisplayText( I replaced this function with an older version. (I found an 4.2Ib Version on my...
I am not sure this should be a limitation. Looks more like a bug in IBO to me. It looks like it should be easy enough to fix. Can you work around it for now? ...
Kevin, ... I don't think I have a property that controls this aspect. We would have to get in the source code and enhance things a bit. You might look at it...
... I have not encountered this kind of problem before. You probably should seek for help on the Firebird support forums. Let us know what you figure out. ...
... Thank you for the suggestion, I checked it and it is set to false. What I wrote in my original post was done in a clean test project, with nothing but a...
... Hi Jason, that feature is only asked for by one customer so I guess I can tell them to be patient until this gets sorted out. Do you want me to upload my...
You should also add in the OnGetText event to supply the display text conversion for when the in-line control is not showing in the cell. Jason ... From:...
Kevin, ... Thanks! Things are coming together. I have been able to sell the property I've been struggling with. It was a lot of work putting that all...
GREAT! I think the community will be greatly relieved to hear this. _____ From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of...
The error seems to come from IB_Components, TIB_BDataset.SysPrepareSQL Procedure. It gets to the "if SQL.Count=0 then" statement and executes the error...
Just make sure the SQL.Text doesn't contain just some Blanks, LF's , LF /CR's or cobination of the same, else you get the same error. SQL.Text = Trim(Sql.Text)...
Hi, Is there a way to use IBObjects to extract the table names from a SQL statment. For example, if a user provided the following string : (Completely made up...
... The SQL property of a dataset is a stringlist, not a string. What's happening at this point is that IBO checks whether the stringlist has any strings: it...
Sam, ... Yes. It's in the TIB_Row object. Look at the RelationNames[] property of the Fields[] property of your query. (My spelling could be off.) HTH, Jason...
Helen, I have never had any trouble assigning a string to the SQL.Text property of any kind of dataset component, or indeed to any kind of string list. ...
Markus, ... It seems that your AV might be not to do with the blobnode at all, but come from calling Create on an undeclared stream object. See how this goes...
Hi Helen, ... (select * from rdb$database isn't exactly the ideal "set" to work with, though, since it can only be one row!!) my code was just an example to...
Thanks Jason, Is it possible to access the relationNames information if the query is invalid ? For example if some of the tables mentioned in the query don't...
... You can try this: uses IB_Parse; // - if the SQL statement doesn't specify an alias for a table then RelAliasList // will contain the relation name as...
... You can answer this question yourself. Clue: if you succeed in preparing a query, you get all the information back. If you fail, you get an exception. ...
Thanks for the help Helen and Markus. I need to take any SQL statement and extract from it all of the table names, as a stringlist perhaps. Irrespective of the...