I have tried to follow the Getting Started example of lookups in a TIB_Grid so it will use a LookupCombo for these fields. It just won't work for me. I'm...
... This is an editing mechanism. Is the main dataset live? (RequestLive=True or custom XxxxSQL defined). When the set is live, the combobox should replace...
... I didn't see anything in the Getting Started Guide about setting any datasets "live". I'm just using it as the Guide explains. ... Polling KeyLinks...
... OK, the embedded lookupcombo goes into action when the dataset is "live", i.e. editable. (RequestLive=True for a simple query, or using custom XxxxSQL for...
hi-- i have a copy of IBO 4.2Ha and it was working fine (i use the tIBOQuery, tDataset.... components). I tried downloading and installing the 4.6 Eval Kit. ...
... When did you download this kit? ... Some versions of the installer program have caused problems on some systems... ... Missing or lost... ... Yes, this and...
Hi I have a readonly transaction (tiCommitted) where a query (TIBOQuery) is run (left open) and then the underlying data is changed (additions and deletions)...
Hi Robert, ... Yes IBO does often create SQL to locate the value of the key, which it then tries to locate in its buffers or retrieve from the database....
Thanks for that Geoff Makes perfect sense, I hadn't thought about IBO going to the server for records not in the buffer. The FetchAll didn't fix it but...
... It *will* refresh itself if it is asked to locate something that is not in its buffers. The Read Committed transaction can see changes made by other...
Hi Not really :) we are looking at a maximum of 24 records to return and with just locating in the buffers it shouldn't be a big deal. It is a nice way to...
I have a table created in my early days of Firebird/IBObjects. The software I used to create the database allowed lowercase and unaware of potential pitfalls I...
... This isn't an IBO question...but no, you'll need to recreate the database without the quotes and pump the data into it. FYI, as an example, an object...
... key,foreign key) ... That was the problem. It's kind of strange, since the spaces didn't break anything else until I tried to use the LookupCombo in the...
Rob, ... I cringe too. You should not make important application logic determinations based on subtle nuances of a component set's behavior. Your assumption...
Has anyone by chance converted the telesis packages over to bds2006? I don't really know much about package conversion and I tried but I got a number of...
I have a new evaluation version just on the cusp of being released. If you can hold tight just a bit I'll have it sent out. If you want to trial run it for...
Using TIB_DSQL for a SELECT statement is perfectly acceptable as long as you actually want an error/exception if anything other than a single record only is...
I (desperately) need to change the glyphs on the one TIB_Updatebar I added to my application to match the glyphs on all the other (TMS) Navigators at my...
HI Clive, I just reviewed source for update bar. If you have latest source it should work already. If you don't then Find LoadCustomGlyph procedure and set...
Hi I have a strange problem with TIBOQuery (v 4.6A), when I want to locate a record 1) Select A.NR, A.StartDate, A.ForeignID ... From Table1 A Order by...
Hi All, I try to encrypt/decrypt data in the OnGetText and OnSetText events. Dataset is a TIBOQuery. Dataset.fieldByName('somedata').OnSetText:=scramble; ...
There was a need for custom draw in cell with state in gdFixed. Tracing to the sources I could find that OnDrawCell event of TIB_Grid is only called if cell's...
Hi, I want to maintain a field in a table with the date a record was created or modified. What would be the best way to do this, INSERT and UPDATE triggers? ...
... alter mytable add last_modified timestamp; ... Firebird 1.5 or higher: create trigger all_mytable active before insert or update as begin new.last_modified...