Dave Crozier wrote:
> Paul,
> You simply need to treat the BizObj as a funnel to pass data back into a VFP
> Cursor. All the Bizobj will do is allow you to disconnect the UI from the
> Dat Access Layer. It doesn't have to be a strictly 1:1 relationship between
> the UI and the BizObj however.
>
> Use the power of VFP and its strength by using a VFP cursor to feed into.
> The only thing you need to be careful of is when you use the data in the
> cursor to make changes before you have refreshed it as the data may well not
> be present in the actual data store. However, this is fairly simple to
> handle as long as you can leave the VFP concept of editing data on the fly
> on the shelf and resort to a more mainframe approach of selecting data then
> retrieving the latest copy of it from the datastore immediately before
> editing it.
>
> Good planning and standardisation of operation makes this a fairly simple
> exercise. The biggest only difficulty I found was having edited the relevant
> data in a form and written it back to the datastore, to return back to the
> VFP grid in exactly the same place (i.e Relative Grid Row number) without
> excessive screen disruption.
I usually did this in the form.Save method:
liKey = MyCursor.iid && save current key
this.grdSample.SaveSource() && code to save the columns so as to requery
without problems and later restore
this.obiz.RequeryCursor("MyCursor")
this.grdSample.RestoreSource()
=seek(liKey,"MyCursor","iid")
this.grdSample.refresh()
Bingo.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
