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 ".


Marcelo




Helen Borrie <helebor@...> wrote:
At 04:19 PM 4/12/2005 -0800, you wrote:

>
> in the PATOLOGIAtib_query i have:
>
> SELECT *
>FROM PATOLOGIA
>FOR UPDATE
> _______________________

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.

Helen
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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