Hi Fernando! Since around 1965, every person living in Norway has been given a unique 11-digit number at birth or immigration (abbreviated Fnr). The system for...
(Sorry for the last post, caught someone elses Subject line) Hi, This Query used to work perfect with firebird 1.5, now it doesnt with 2.0. Even if the field...
... It should be Update Ord_Head set Amount=:Amount Where OrderNum=:OrderNum /* and Amount <> :Amount */ Use qualifiers when they are needed, i.e., when the...
I dont see the difference between.. Amount and Ord_Head.Amount Isnt it the same thing? ... From: Helen Borrie To: IBObjects@yahoogroups.com Sent: Tuesday,...
... It's not automatically valid in a single-table statement if you are passing it to the old version of the IBO parser. As a reality check you can put a...
Hi I've wrote about it once. Methods First/Last fire events in that order: BeforePost->BeforeScroll but all other scrolling methods like Previos/Next, clicking...
Hi, IBO-experts, we have a problem with IBO when using columnarrays with params in TIB_DSQL. The complete source of a test is uploaded to this Yahoo-Group to: ...
As a short-term work around perhaps you could pass the values for the array as individual items into a stored procedure and then have the stored procedure plug...
Dear All, I have recently been trying to use IBObjects to the create a small project. The following query generates a 'Multiple Errors in Singleton Fetch'...
... Some clients built with older versions of IBO might process this statement without exceptions, even though it isn't valid SQL. I dare say the same is true...
Hello everyone, We are encountering behavior which was not expected after a failed attempt to drop a table. When an exception occurs during a "drop table", it...
... Yes ... Rollback the transaction that has excepted. Basically, 1. Never NEVER try to mix DDL and DML in the same transaction 2. Separate each DDL...
Hi, I can get the selected bookmarked records, but how do I go about physically bookmarking a record programatically. Lets say for explanation purposes: I want...
Hello Adrian, You can do it like this: If IB_Query1.Locate(NameId,.[]) then IB_Query1.Selected[IB_Query1.RowNum] := True; My example for inverse seelection: ...
Thanks Ramil ! Hello Adrian, You can do it like this: If IB_Query1.Locate(NameId,.[]) then IB_Query1.Selected[IB_Query1.RowNum] := True; My example for inverse...
Hi I have an SQL which i run on a FB DB using a TIBOQuery. The Query has a Datasource attached which an TADOQuery connects to. The TADOQuery has an Insert...
... Well, the place to start would be to look at the code where you pick up the text from the current IBODataset row to pass it to the ADOQuery parameter. Of...
Hi Helen ... There is no code ! The IBOQuery result fields have the same as the parameters in the TADOQuery. The TADOQuery is set to use the TIBOQuery as the...
Hi Helen ... There is no code copying between the two! The IBOQuery result fields have the same as the parameters in the TADOQuery. The TADOQuery is set to...
Hello Robert, I can not reproduce your situation. I have added the field "Stock0015" to the IBO sample database MASTER (IBO\Samples\TDataset\Filters): ALTER...
If possibly applicable, by default, IBO returns a ftString if StrLen <= 255, else a ftMemo. This can be overridden in IB_Session.pas ... From: "Ramil"...
Hi Ramil I am using version 4.8.6 I try your code below in mine (I hadn't thought of testing it that way, thanks) and make sure it does trigger. I will get...
Hi Changing that to 4096 fixes the problem for me ! However what impact will this have on all the other applications I develop? What are the side effects?...
Hi It definitely fails. Hans's solution fixes the problem. I suspect in your sample data you need a record with some data in the field, then some NUll...
It is workable by assigning say specific sizes to your ftMemo fields, like 4999, 5999, 6999 and modify the test where the IB_Session variable is used to return...
Hi Hans Actually I cant in this case because the fields are actually user defined sizes (up to 4096) we have a screen where they can create 'custom' storage...
The ftString size override was put in place around 10/02/2003 // Version information IB_VERSION_MAJOR = '4'; IB_VERSION_MINOR = '2'; IB_VERSION_BUILD = 'I'; ...
Hi, I had installed firebird 2.0.3, then uninstalled it. Then I had installed firebird version 1.5.0.4306. The installation was complete successfully, and 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.
