ADO recordset

TheMSsForum.com: The Microsoft Software Forum

This is a multi-part message in MIME format.

------=_NextPart_000_000E_01C6840F.7BBD7EB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

This is a completely new area for me. I am looking at the Chado spell =
editor, which now has mailmerge - great! However the reply to a query to =
Chado states:

Unfortunately, you have to use an ADO recordset in order to have =
mailmerge work properly.

What I have got in my application is a temporary cursor called CUSTOMER =
from which I want to do the mailmerge.

Could somebody handhold me through the commands I need to issue to get =
an ADO recordset from this.

Many thanks

Stephen
=20

------=_NextPart_000_000E_01C6840F.7BBD7EB0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2900.2873" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>This is a completely new area for me. I =
am looking=20
at the Chado spell editor, which now has mailmerge - great! However the =
reply to=20
a query to Chado states:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV>Unfortunately, you have to use an ADO recordset in order to have =
mailmerge=20
work properly.<BR></DIV>
<DIV><FONT face=3DArial size=3D2>What I have got in my application is=20
a&nbsp;temporary cursor called CUSTOMER from which I want to do the=20
mailmerge.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Could somebody handhold me through the =
commands I=20
need to issue to get an ADO recordset from this.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Many thanks</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_000E_01C6840F.7BBD7EB0--
Top

Re: ADO recordset by AA

AA
Tue May 30 19:57:04 CDT 2006

oConn = CREATEOBJECT("ADODB.Connection")
oConn.ConnectionString = "provider=vfpoledb.1;;
data source=mydb.dbc"
oconn.Open
oRecordSet=oconn.Execute('select * from myTable')

And check out the function SETRESULTSET( ) in Help.
-Anders

"Stephen Ibbs" <stephen@ibbs.org.uk> skrev i meddelandet
news:uAxTZcAhGHA.4284@TK2MSFTNGP05.phx.gbl...
This is a completely new area for me. I am looking at the Chado spell
editor, which now has mailmerge - great! However the reply to a query to
Chado states:

Unfortunately, you have to use an ADO recordset in order to have mailmerge
work properly.

What I have got in my application is a temporary cursor called CUSTOMER from
which I want to do the mailmerge.

Could somebody handhold me through the commands I need to issue to get an
ADO recordset from this.

Many thanks

Stephen



Top

Re: ADO recordset by Stephen

Stephen
Wed May 31 01:04:09 CDT 2006

Many thanks Anders - I'll give it a try.

Stephen

"AA" <A@A> wrote in message news:e5E3Y0EhGHA.1244@TK2MSFTNGP04.phx.gbl...
> oConn = CREATEOBJECT("ADODB.Connection")
> oConn.ConnectionString = "provider=vfpoledb.1;;
> data source=mydb.dbc"
> oconn.Open
> oRecordSet=oconn.Execute('select * from myTable')
>
> And check out the function SETRESULTSET( ) in Help.
> -Anders
>
> "Stephen Ibbs" <stephen@ibbs.org.uk> skrev i meddelandet
> news:uAxTZcAhGHA.4284@TK2MSFTNGP05.phx.gbl...
> This is a completely new area for me. I am looking at the Chado spell
> editor, which now has mailmerge - great! However the reply to a query to
> Chado states:
>
> Unfortunately, you have to use an ADO recordset in order to have mailmerge
> work properly.
>
> What I have got in my application is a temporary cursor called CUSTOMER
> from
> which I want to do the mailmerge.
>
> Could somebody handhold me through the commands I need to issue to get an
> ADO recordset from this.
>
> Many thanks
>
> Stephen
>
>
>


Top

Re: ADO recordset by Stephen

Stephen
Wed May 31 04:27:31 CDT 2006

Thanks very much Anders - I am getting some results and can see how to
proceed.

If I use this in an application for a client, what do I need to include in
the installation?

Sincerely

Stephen


"AA" <A@A> wrote in message news:e5E3Y0EhGHA.1244@TK2MSFTNGP04.phx.gbl...
> oConn = CREATEOBJECT("ADODB.Connection")
> oConn.ConnectionString = "provider=vfpoledb.1;;
> data source=mydb.dbc"
> oconn.Open
> oRecordSet=oconn.Execute('select * from myTable')
>
> And check out the function SETRESULTSET( ) in Help.
> -Anders
>
> "Stephen Ibbs" <stephen@ibbs.org.uk> skrev i meddelandet
> news:uAxTZcAhGHA.4284@TK2MSFTNGP05.phx.gbl...
> This is a completely new area for me. I am looking at the Chado spell
> editor, which now has mailmerge - great! However the reply to a query to
> Chado states:
>
> Unfortunately, you have to use an ADO recordset in order to have mailmerge
> work properly.
>
> What I have got in my application is a temporary cursor called CUSTOMER
> from
> which I want to do the mailmerge.
>
> Could somebody handhold me through the commands I need to issue to get an
> ADO recordset from this.
>
> Many thanks
>
> Stephen
>
>
>


Top

Re: ADO recordset by AA

AA
Wed May 31 05:13:11 CDT 2006

You need to install VFPOLEDB along with the runtimes. VFP's InstallShield
tool can handle it.
Free tables can be opened to by VFPOLEDB, it replaces VFPODBC which hasn't
been updates in VFP6.
The client must have the ADO ActiveX, you can't just assume he does.
Installshield could handle that too.
You can do mailmerge and spell checking with MS Word instantiated as a COM
object in VFP.

-Anders

"Stephen Ibbs" <stephen@datadevelopments.co.uk> skrev i meddelandet
news:O5c2zhJhGHA.4892@TK2MSFTNGP02.phx.gbl...
> Thanks very much Anders - I am getting some results and can see how to
> proceed.
>
> If I use this in an application for a client, what do I need to include in
> the installation?
>
> Sincerely
>
> Stephen
>
>
> "AA" <A@A> wrote in message news:e5E3Y0EhGHA.1244@TK2MSFTNGP04.phx.gbl...
>> oConn = CREATEOBJECT("ADODB.Connection")
>> oConn.ConnectionString = "provider=vfpoledb.1;;
>> data source=mydb.dbc"
>> oconn.Open
>> oRecordSet=oconn.Execute('select * from myTable')
>>
>> And check out the function SETRESULTSET( ) in Help.
>> -Anders
>>
>> "Stephen Ibbs" <stephen@ibbs.org.uk> skrev i meddelandet
>> news:uAxTZcAhGHA.4284@TK2MSFTNGP05.phx.gbl...
>> This is a completely new area for me. I am looking at the Chado spell
>> editor, which now has mailmerge - great! However the reply to a query to
>> Chado states:
>>
>> Unfortunately, you have to use an ADO recordset in order to have
>> mailmerge
>> work properly.
>>
>> What I have got in my application is a temporary cursor called CUSTOMER
>> from
>> which I want to do the mailmerge.
>>
>> Could somebody handhold me through the commands I need to issue to get an
>> ADO recordset from this.
>>
>> Many thanks
>>
>> Stephen
>>
>>
>>
>
>



Top

Re: ADO recordset by Stephen

Stephen
Wed May 31 05:37:09 CDT 2006

Most helpful Anders and much appreciated

Sincerely

Stephen

"AA" <A@A> wrote in message news:eTnhKrJhGHA.2208@TK2MSFTNGP05.phx.gbl...
> You need to install VFPOLEDB along with the runtimes. VFP's InstallShield
> tool can handle it.
> Free tables can be opened to by VFPOLEDB, it replaces VFPODBC which hasn't
> been updates in VFP6.
> The client must have the ADO ActiveX, you can't just assume he does.
> Installshield could handle that too.
> You can do mailmerge and spell checking with MS Word instantiated as a
> COM object in VFP.
>
> -Anders
>
> "Stephen Ibbs" <stephen@datadevelopments.co.uk> skrev i meddelandet
> news:O5c2zhJhGHA.4892@TK2MSFTNGP02.phx.gbl...
>> Thanks very much Anders - I am getting some results and can see how to
>> proceed.
>>
>> If I use this in an application for a client, what do I need to include
>> in
>> the installation?
>>
>> Sincerely
>>
>> Stephen
>>
>>
>> "AA" <A@A> wrote in message news:e5E3Y0EhGHA.1244@TK2MSFTNGP04.phx.gbl...
>>> oConn = CREATEOBJECT("ADODB.Connection")
>>> oConn.ConnectionString = "provider=vfpoledb.1;;
>>> data source=mydb.dbc"
>>> oconn.Open
>>> oRecordSet=oconn.Execute('select * from myTable')
>>>
>>> And check out the function SETRESULTSET( ) in Help.
>>> -Anders
>>>
>>> "Stephen Ibbs" <stephen@ibbs.org.uk> skrev i meddelandet
>>> news:uAxTZcAhGHA.4284@TK2MSFTNGP05.phx.gbl...
>>> This is a completely new area for me. I am looking at the Chado spell
>>> editor, which now has mailmerge - great! However the reply to a query to
>>> Chado states:
>>>
>>> Unfortunately, you have to use an ADO recordset in order to have
>>> mailmerge
>>> work properly.
>>>
>>> What I have got in my application is a temporary cursor called CUSTOMER
>>> from
>>> which I want to do the mailmerge.
>>>
>>> Could somebody handhold me through the commands I need to issue to get
>>> an
>>> ADO recordset from this.
>>>
>>> Many thanks
>>>
>>> Stephen
>>>
>>>
>>>
>>
>>
>
>
>


Top