Re: Cursor Adapter in DE Question

2011-10-13 Thread Eurico Chagas Filho
Thanks Ed. > > >> Mark McCasland wrote a CA builder utility and there's a reference to it in >> the downloads section. Unfortunately, it appears to point to a dead link. >> I've found a version on foxite and will submit it to Ed. > >    The file is available no

Re: Cursor Adapter in DE Question

2011-10-13 Thread Ed Leafe
On Oct 13, 2011, at 6:34 AM, Richard Kaye wrote: > Mark McCasland wrote a CA builder utility and there's a reference to it in > the downloads section. Unfortunately, it appears to point to a dead link. > I've found a version on foxite and will submit it to Ed. The file is available now

Re: Cursor Adapter in DE Question

2011-10-13 Thread Ajoy Khaund
Thanks Let me go through it and I will get back to you. It looks wonderful. Ajoy Khaund -- From: "Rafael Copquin" Sent: Thursday, October 13, 2011 5:50 PM To: Subject: Re: Cursor Adapter in DE Question > As requested, below ar

Re: Cursor Adapter in DE Question

2011-10-13 Thread Rafael Copquin
As requested, below are the methods necessary to create a cursor adapter on the fly use thus: thisform.makeadapter('customers','curCustomers',[select * from customers]) As for authentication, I use SQL Server authentication Connect through ODBC local cConnString cConnString=[DRIVER=SQL Serve

RE: Cursor Adapter in DE Question

2011-10-13 Thread Richard Kaye
profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: Wednesday, October 12, 2011 3:17 AM To: profoxt...@leafe.com Subject: RE: Cursor Adapter in DE Question Thanks for the reply. As they say, if we don't try these new things we'll never know how good or

Re: Cursor Adapter in DE Question

2011-10-12 Thread Ajoy Khaund
that I am working with. Thanks Ajoy Khaund akha...@hotmail.com -- From: "Rafael Copquin" Sent: Wednesday, October 12, 2011 7:46 PM To: Subject: Re: Cursor Adapter in DE Question > Running the risk of overkill in this matte

Re: Cursor Adapter in DE Question

2011-10-12 Thread Rafael Copquin
Very true. As a matter of fact it was you that pointed me to that prg some time ago, which I incorporated into my classes. It is really a very useful utility. I wholeheartedly recommend it! Rafael Copquin > > I'll take a moment to again point out that Paul McNett's > MakeUpdatable.prg in the P

Re: Cursor Adapter in DE Question

2011-10-12 Thread MB Software Solutions, LLC
On 10/12/2011 10:16 AM, Rafael Copquin wrote: > Running the risk of overkill in this matter, I use CA's assiduously in > all my apps, but always in code, not the wizard. Even in client/server > situations, CA's are great, simply because you can insert, delete or > modify your CA cursor as any regul

Re: Cursor Adapter in DE Question

2011-10-12 Thread Rafael Copquin
f we don't try these new things we'll > never know how good or bad they are. > > Dave > > > -Original Message- > From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of > Rafael Copquin > Sent: 11 October 2011 17:07 > To: pr

RE: Cursor Adapter in DE Question

2011-10-12 Thread Dave Crozier
don't try these new things we'll never know how good or bad they are. Dave -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Rafael Copquin Sent: 11 October 2011 17:07 To: profox@leafe.com Subject: Re: Cursor Adapter in DE Question

Re: Cursor Adapter in DE Question

2011-10-11 Thread Rafael Copquin
It is a better way of doing things, to do your CA's in code and not in the DE. You have greater control, especially if your select statement involves more than one table. If you use the DE CA you would have to change the select statement manually, because the wizard can only create a select of

Cursor Adapter in DE Question

2011-10-11 Thread Dave Crozier
Not having used cursor adapters very much and wanting to try them as a short cut to make the conversion of a suite of programs into "Client server" I have the following Question. I have a parent table which I can pick up in the cursoradapter modifying the "SelectCmd property and then issuing a