Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: Steve Dingle
  Where is Steve Dingle?
 Weybridge
 United Kingdom
 Steve Dingle
 Tags
Subject: RE: Data Explorer - oParam.BrowseData (ER?)
Thread ID: 189102 Message ID: 189104 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Sedna
Date: Wednesday, August 13, 2008 12:21:38 PM         
   


> Heya All,
>
> I think this is more of an ER than a question but for browsing ALL connection types (VFP,SQL etc..) there is just the same call in the Menu Manager Script...
>
> oParam.BrowseData()
>
> With VFP data the BrowseData just opens the tables and calls the Browse form, where my goal is to replace the browse form used. Not a big problem for me as my browse form has the logic to open tables etc...
>
> However, if the connection type is a SQL Server, then BrowseData() does a lot more including connecting to the database, creating cursor using SQLEXEC and then calling the browse form.
>
> I was hoping not to have to re-create the code which gathers the connection information, connects to the database, performs the SQLEXEC to get the cursor etc... and just HOOK into the part where the "BROWSE" happens. My main reason, not because I'm lazy (well maybe a little), is that all the stuff is being used and therefore tested much more than I can test.
>
> Anyway, wondering if anyone ( Rick ;-) ) would have any suggestions on if this can be done and if not, if Data Explorer is being enhanced and still worked on I would like to put an ER in for more hooks for this type of stuff
>
> Thanks all,
> Steve Dingle
> http://weblogs.foxite.com/SteveDingle/
> http://www.dsbusinesssolutions.co.uk

Just drag and drop the table from Data Explorer to an empty PRG file and see what happens :-)

-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

ENTIRE THREAD

Data Explorer - oParam.BrowseData (ER?) Posted by Steve Dingle @ 8/13/2008 12:14:30 PM
RE: Data Explorer - oParam.BrowseData (ER?) Posted by Borislav Borissov @ 8/13/2008 12:21:38 PM
RE: Data Explorer - oParam.BrowseData (ER?) Posted by Steve Dingle @ 8/13/2008 12:35:36 PM
RE: Data Explorer - oParam.BrowseData (ER?) Posted by Borislav Borissov @ 8/13/2008 12:44:51 PM
RE: Data Explorer - oParam.BrowseData (ER?) Posted by Steve Dingle @ 8/13/2008 1:01:42 PM
RE: Data Explorer - oParam.BrowseData (ER?) Posted by Rick Schummer @ 8/13/2008 2:52:54 PM
RE: Data Explorer - oParam.BrowseData (ER?) Posted by Steve Dingle @ 8/13/2008 3:49:53 PM