Subject Re: [IBO] Two or more tables...
Author Marcelo Machado
I Take out "FOR UPDATE"...

... It continues everything equal.

I follow the steps of "TI_MASTERDETAIL.HLP"
(MasterLinks project in the Samples directory of IB Objects)
This Tutorial/example contains " for update ".


Helen Borrie <helebor@...> wrote:
At 04:19 PM 4/12/2005 -0800, you wrote:
> in the PATOLOGIAtib_query i have:
> _______________________

Take out "FOR UPDATE". This will cause the detail set to be unidirectional
(not scrollable, and opened at BOF)and for the master set to be required to
fetch each row individually. So (after all this terrible confusion), the
reason you don't see any rows is that your master set can't call Fetch in
the scroll event! You need a scrollable dataset for master/detail to work
as designed.

Who told you to use "FOR UPDATE"? IBO itself encapsulates this attribute
in the tib_cursor. Contrary to some people's assumptions, the "FOR UPDATE"
attribute is not some shortcut means to make datasets updatable!

Also, get rid of the practice of using SELECT *. It's a lazy habit that
makes your source code less informative than it ought to be and it also has
some undesirable effects in the interface, under some conditions, that can
be very difficult to track down.

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

[Non-text portions of this message have been removed]