Re: Foxpro vs SQL Server
From: Ray Majewski (anonymous_at_aol.com)
Date: 06/15/04
- Next message: Craig Berntson: "Re: Foxpro vs SQL Server"
- Previous message: Ray Majewski: "Re: Foxpro vs SQL Server"
- In reply to: Rick Bean: "Re: Foxpro vs SQL Server"
- Next in thread: Anders Altberg: "Re: Foxpro vs SQL Server"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Jun 2004 12:04:31 -0500
Thanks. I should be able to find what I need in there.
"Rick Bean" <rgbean@unrealmelange-inc.com> wrote in message
news:uDK7ivuUEHA.3944@tk2msftngp13.phx.gbl...
Ray,
How about
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/lngAPPEND_PROCEDURES.asp?frame=true -
"APPEND PROCEDURES Command". You'll also want to check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dggrfOLEDBProviderforVisualFoxPro.asp?frame=true -
"OLE DB Provider for Visual FoxPro".
Read
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dglrfUnsupportedVisualFoxProCommandsFunctions.asp?frame=true
for "Unsupported Visual FoxPro Commands and Functions in OLE DB Provider".
<hint> These apply to any Stored Procedure your write!
The latest VFP OLE DB client, is available at
http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en.
While there is a newer one that comes with the VFP 9.0 public beta, it can't
be separately downloaded.
Rick
"Ray Majewski" <anonymous@aol.com> wrote in message
news:u6XppYtUEHA.3336@TK2MSFTNGP11.phx.gbl...
> Thanks. Can you point me to somewhere that shows how to create stored
> procedures in F0xPro?
>
> "Rick Bean" <rgbean@unrealmelange-inc.com> wrote in message
> news:eT2mhPlUEHA.2508@TK2MSFTNGP12.phx.gbl...
> Ray,
> If you setup CR to use ADO, you can use the VFP OLEDB provider to call a
> Stored Procedure in a VFP Database. (VFP ODBC doesn't support SPs.)
>
> Rick
>
> "Ray Majewski" <anonymous@aol.com> wrote in message
> news:enEfqGlUEHA.1652@TK2MSFTNGP09.phx.gbl...
> > I have to create a report in Crystal Reports off of a FoxPro database.
I
> > need to do a SQL UNION between two tables and it can't be done within
> > Crystal. With SQL Server I would create a view or stored procedure and
> base
> > the report off of the view or stored procedure. Is there a way to do
this
> > in FoxPro?
> >
> >
>
>
- Next message: Craig Berntson: "Re: Foxpro vs SQL Server"
- Previous message: Ray Majewski: "Re: Foxpro vs SQL Server"
- In reply to: Rick Bean: "Re: Foxpro vs SQL Server"
- Next in thread: Anders Altberg: "Re: Foxpro vs SQL Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
