I'm wondering if anyone has come up with a way yet to load ADO.NET data into
a read/write BROWSE window.

Thanks ahead for any leads.

Re: VFP and ADO.NET by AA

AA
Wed May 31 04:22:38 CDT 2006

http://www.code-magazine.com/article.aspx?quickid=0301092&page=3
Anders

"Bowman Jeff" <write.to.me@my.address.com> skrev i meddelandet
news:%23DuCHZIhGHA.5104@TK2MSFTNGP04.phx.gbl...
> I'm wondering if anyone has come up with a way yet to load ADO.NET data
> into a read/write BROWSE window.
>
> Thanks ahead for any leads.
>
>



Re: VFP and ADO.NET by Bowman

Bowman
Wed May 31 13:45:08 CDT 2006

Excellent--thanks, Anders! I'll definitely be making use of that.

I suppose it might be asking too much to load it live, though, instead of
importing/exporting?

Am I right in noting that VFP uses only ODBC for remote views, and not
OLEDB?



"AA" <A@A> wrote in message news:O02IGPJhGHA.4304@TK2MSFTNGP05.phx.gbl...
> http://www.code-magazine.com/article.aspx?quickid=0301092&page=3
> Anders
>
> "Bowman Jeff" <write.to.me@my.address.com> skrev i meddelandet
> news:%23DuCHZIhGHA.5104@TK2MSFTNGP04.phx.gbl...
>> I'm wondering if anyone has come up with a way yet to load ADO.NET data
>> into a read/write BROWSE window.
>>
>> Thanks ahead for any leads.
>>
>>
>
>



Re: VFP and ADO.NET by Cindy

Cindy
Wed May 31 16:52:18 CDT 2006

Hi Jeff,

Yes, you can only use ODBC for remote views.

You haven't said which version of FoxPro you are using. Have you tried the
CursorAdapter class which was added to VFP in version 8? It turns an ADO
data source into a cursor.

--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@cindywinegarden.com


"Bowman Jeff" <write.to.me@my.address.com> wrote in message
news:OGXleKOhGHA.2456@TK2MSFTNGP04.phx.gbl...
> Am I right in noting that VFP uses only ODBC for remote views, and not
> OLEDB?



Re: VFP and ADO.NET by Bowman

Bowman
Wed May 31 23:50:08 CDT 2006

Hey, hey! VFP8 it is--I'll definitely have a look at that :-)

Guess I've just been away too long--I've been missing out on hearing about
all the little tidbits like this.

Thanks, Cindy.



"Cindy Winegarden" <cindy@cindywinegarden.com> wrote in message
news:uftnT0PhGHA.3924@TK2MSFTNGP03.phx.gbl...
> Hi Jeff,
>
> Yes, you can only use ODBC for remote views.
>
> You haven't said which version of FoxPro you are using. Have you tried the
> CursorAdapter class which was added to VFP in version 8? It turns an ADO
> data source into a cursor.
>
> --
> Cindy Winegarden MCSD, Microsoft Most Valuable Professional
> cindy@cindywinegarden.com
>
>
> "Bowman Jeff" <write.to.me@my.address.com> wrote in message
> news:OGXleKOhGHA.2456@TK2MSFTNGP04.phx.gbl...
>> Am I right in noting that VFP uses only ODBC for remote views, and not
>> OLEDB?
>
>



Re: VFP and ADO.NET by Bowman

Bowman
Sat Jun 10 20:27:23 CDT 2006

Hi Cindy, I was able to get this to work.

I wasn't able, however, to get the CursorAdapter's BROWSE window to stay
open after it lost focus. The only way I could come up with to do that was
to add the CA to a form's DE and run the form. The utility I ended up with
can be downloaded at my website, http://jeffbowman.com/. It's called
AdoViewer.

Are you aware of any other way to persist the BROWSE window?

Thanks.




"Cindy Winegarden" <cindy@cindywinegarden.com> wrote in message
news:uftnT0PhGHA.3924@TK2MSFTNGP03.phx.gbl...
> Hi Jeff,
>
> Yes, you can only use ODBC for remote views.
>
> You haven't said which version of FoxPro you are using. Have you tried the
> CursorAdapter class which was added to VFP in version 8? It turns an ADO
> data source into a cursor.
>
> --
> Cindy Winegarden MCSD, Microsoft Most Valuable Professional
> cindy@cindywinegarden.com
>
>
> "Bowman Jeff" <write.to.me@my.address.com> wrote in message
> news:OGXleKOhGHA.2456@TK2MSFTNGP04.phx.gbl...
>> Am I right in noting that VFP uses only ODBC for remote views, and not
>> OLEDB?
>
>



Re: VFP and ADO.NET by Bernhard

Bernhard
Sun Jun 11 07:02:43 CDT 2006

Hi Jeff,

> Are you aware of any other way to persist the BROWSE window?
BROWSE ... NOWAIT

Regards
Bernhard Sander

Re: VFP and ADO.NET by Bowman

Bowman
Sun Jun 11 13:18:14 CDT 2006

Hi Bernhard, thanks for your reply.

NOWAIT only works when the CA is run as a member of a form's DE--when it's
used in a standalone class in a .PRG the BROWSE window only flashes for a
moment before disappearing.

That's what I encountered in my initial testing, anyway, which is why I
built AdoViewer--do you have some code you could ship that demonstrates
otherwise?

Thanks.



"Bernhard Sander" <fuchs@individsoft.de> wrote in message
news:%23lamz7UjGHA.4276@TK2MSFTNGP03.phx.gbl...
> Hi Jeff,
>
>> Are you aware of any other way to persist the BROWSE window?
> BROWSE ... NOWAIT
>
> Regards
> Bernhard Sander