Re: Visual Basic Front End

["John Taylor" <jtaylor@xxxxxxxxxxxx>]

Steve/Frank,

> for example, the cae ado driver does not support the "seek" method.  This
> means you cant chain to a rcd in a file like ado code that is pointed to
an
> sql server or access database file.  You have to use the CAE bookmark
> support which does provide a seek method. it returns a RRN. The, in my
> opinion,  intentionally limited IBM CAE ADO provider can read a rcd by
RRN.
> So to seek, your code has to bookmark chain, then ado read by RRN. A VB
> class can be written to encapsulate all of this.  It is just a lot of
extra
> work.

I would caution against using the bookmark functionality if you can avoid
it. CAE 5.1 provides an updated ADO provider with Seek support. As usual,
installing the new release broke my existing (bookmark) code, and that's
when IBM support sent me the following:

> John, it looks like development have found the problem area.
> They are asking if you can use a different mechanism for seek support.
> use the integrated index (i.e. ADO seek method).
>
> They created a test fix for your present setup which is attached for the
> current release but the support for the index object will be dropped in
the
> next release,(R520) hence the recommendation to use the Integrated index.
> I will attach the test fix for you to check out but can you get back to us
> on the circumvention they recommend. I'll add the developers comments here
> as well.

>  Development prefers not to fix this (close PERM).
>  A circumvention is to use
>  the ADO seek support instead.  The index object is being deprecated (it
>  was created only because early versions of ADO had no seek support) and
>  support for the index object will be dropped in the next release.  Also,
>  the problem does seem to only occur with MDAC 2.6 - not 2.5 which is
>  what R510 CAE tested and shipped for.  Please explain this to the
>  customer and ask them if changing their application to use ADO
>  seek support is an acceptable resolution. Let us know their reply.
>  Thanks.


Hope this saves you some grief in the long run.


Regards,

John Taylor