I'm. back again. I have SQL Server 2014 and want to use a basic VFP program
to access data in it. Pretty easy except Ive never done it and its been a
few years since I played around with it. Can someone recommend a good book
that could talk me thru the basics? I had Les Pinter's book but I have put
it away safely never to be seen again.
Thanks people!
Geoff
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/000801d0bb8d$82b4e360$881eaa20$@adam.com.au
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Really? Where have you been, Australia? :-)
On 07/10/2015 11:56 PM, Geoff Flight wrote:
> I'm. back again. I have SQL Server 2014 and want to use a basic VFP program
> to access data in it. Pretty easy except Ive never done it and its been a
> few years since I played around with it. Can someone recommend a good book
> that could talk me thru the basics? I had Les Pinter's book but I have put
> it away safely never to be seen again.
>
> Thanks people!
>
> Geoff
>
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/55A099B4.3080408@verizon.net
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
I can recommend this book, which you can get at www.hentzenwerke.com
Client-Server Applications with Visual FoxPro 6.0 and SQL Server 7.0
Building Client-Server Applications with Visual FoxPro 6.0 and SQL
Server 7.0
by Chuck Urwiler and others
It is a good primer that will teach you the basics on how to use VFP
with SQL Server. And there are a few white papers in the web that you
can consult
Rafael Copquin
El 11/07/2015 a las 0:56, Geoff Flight escribió:
> I'm. back again. I have SQL Server 2014 and want to use a basic VFP program
> to access data in it. Pretty easy except Ive never done it and its been a
> few years since I played around with it. Can someone recommend a good book
> that could talk me thru the basics? I had Les Pinter's book but I have put
> it away safely never to be seen again.
>
> Thanks people!
>
> Geoff
>
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/55A1095A.7030802@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
There's also quite a bit in the VFP9 help file.
Laurie
On 11 July 2015 at 13:17, Rafael Copquin <rcopquin@yahoo.com.ar> wrote:
>
> I can recommend this book, which you can get at www.hentzenwerke.com
> Client-Server Applications with Visual FoxPro 6.0 and SQL Server 7.0
>
>
> Building Client-Server Applications with Visual FoxPro 6.0 and SQL
> Server 7.0
>
> by Chuck Urwiler and others
>
> It is a good primer that will teach you the basics on how to use VFP with
> SQL Server. And there are a few white papers in the web that you can consult
>
> Rafael Copquin
>
>
> El 11/07/2015 a las 0:56, Geoff Flight escribió:
>
>> I'm. back again. I have SQL Server 2014 and want to use a basic VFP
>> program
>> to access data in it. Pretty easy except Ive never done it and its been a
>> few years since I played around with it. Can someone recommend a good
>> book
>> that could talk me thru the basics? I had Les Pinter's book but I have
>> put
>> it away safely never to be seen again.
>>
>> Thanks people!
>>
>> Geoff
>>
>>
>>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAMvTR9fB6oVC-XzxhBzrjMDhKYYJX7DEYHUVryZokqby9oz62g@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
+1.
In the online help: Samples and Walkthroughs -> Walkthroughs -> Walkthrough: Retrieving Data from Different Data Sources
That may be a good place to start...
-K-
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Laurie Alvey
Sent: Monday, July 13, 2015 6:30 AM
To: profoxtech@leafe.com
Subject: Re: SQL Server 2014
There's also quite a bit in the VFP9 help file.
Laurie
On 11 July 2015 at 13:17, Rafael Copquin <rcopquin@yahoo.com.ar> wrote:
>
> I can recommend this book, which you can get at www.hentzenwerke.com
> Client-Server Applications with Visual FoxPro 6.0 and SQL Server 7.0
>
>
> Building Client-Server Applications with Visual FoxPro 6.0 and SQL
> Server 7.0
>
> by Chuck Urwiler and others
>
> It is a good primer that will teach you the basics on how to use VFP
> with SQL Server. And there are a few white papers in the web that you
> can consult
>
> Rafael Copquin
>
>
> El 11/07/2015 a las 0:56, Geoff Flight escribió:
>
>> I'm. back again. I have SQL Server 2014 and want to use a basic VFP
>> program to access data in it. Pretty easy except Ive never done it
>> and its been a few years since I played around with it. Can someone
>> recommend a good book that could talk me thru the basics? I had Les
>> Pinter's book but I have put it away safely never to be seen again.
>>
>> Thanks people!
>>
>> Geoff
>>
>>
>>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAMvTR9fB6oVC-XzxhBzrjMDhKYYJX7DEYHUVryZokqby9oz62g@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Report [OT] Abuse: http://leafe.com/reportAbuse/CAMvTR9fB6oVC-XzxhBzrjMDhKYYJX7DEYHUVryZokqby9oz62g@mail.gmail.com
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/80838F1CA795B14EA1AF48659F35166F1CCA50@DREXCH02.corp.globetax.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Coding is the easy part. The harder part is making the right decision on how you want to connect. With VFP you have lots of options, that's one of the things that makes VFP so powerful.
Here are some considerations you'll have to account for. On how to connect
1. Pass-through (ODBC) - with this option, you'll have to consider if you want to connect to the clients programmatically, or if you wish to set up a data source name (DSN). Pro. Very flexible, very fast and powerful. Con. It can be very labor intensive
2. Remote views, this will require a DBC. Again, you'll have to decide if you want to use the programmatically connection string, or a data source name. Pro. Very easy to use. It takes care of all of your inserts, updates for you, which makes it very convenient. Con. In question is very large, It can become very slow.
3. ADO, is just another way of connecting to the server, it is very outdated, but still works. Pro. Very similar to pass-through with much more restrictions, it returns a data object that you can traverse through to pull specific data you looking for. Con. Can be difficult to work with, requires lots of additional work and if you're working with only one language in this case VFP. It doesn't make sense to use it
3. SQL Server data provider, I really never worked with this because it just seems to me, It is a waste of time. When it comes to actually working with VFP and MS SQL Server. There are some data engines out there where you have only the choice of using the data provider. It is mostly used in the.net world, guessing.
For my money, when it comes to using VFP. I would much rather prefer option 1, the pass-through and handling my connections programmatically. Therefore, do not have to set up any data source names on the client machines, which is a huge timesaver and gives you much more security. In fact, all of your connection string information can be stored in a table.
I genuinely use remote views for quick and dirty stuff. But I have used the remote view on a project with great success, and I do have to admit it really was a timesaver.
There are all kinds of examples online and the VFP help does provide good health and examples.
Be careful, VFP can really spoil you and make life easy for you. When connecting to third-party databases. So if you like me, who jumps back and forth between .net and Visual FoxPro, you start to realize how it is using Visual FoxPro <g>
Cheers,
Claude
Mesquite Information Technologies, LLC.
-----Original Message-----
From: Laurie Alvey [mailto:trukker41@gmail.com]
Sent: Monday, July 13, 2015 3:30 AM
To: ProFox Email List
Subject: Re: SQL Server 2014
There's also quite a bit in the VFP9 help file.
Laurie
On 11 July 2015 at 13:17, Rafael Copquin <rcopquin@yahoo.com.ar> wrote:
>
> I can recommend this book, which you can get at www.hentzenwerke.com
> Client-Server Applications with Visual FoxPro 6.0 and SQL Server 7.0
>
>
> Building Client-Server Applications with Visual FoxPro 6.0 and SQL
> Server 7.0
>
> by Chuck Urwiler and others
>
> It is a good primer that will teach you the basics on how to use VFP
> with SQL Server. And there are a few white papers in the web that you
> can consult
>
> Rafael Copquin
>
>
> El 11/07/2015 a las 0:56, Geoff Flight escribió:
>
>> I'm. back again. I have SQL Server 2014 and want to use a basic VFP
>> program to access data in it. Pretty easy except Ive never done it
>> and its been a few years since I played around with it. Can someone
>> recommend a good book that could talk me thru the basics? I had Les
>> Pinter's book but I have put it away safely never to be seen again.
>>
>> Thanks people!
>>
>> Geoff
>>
>>
>>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/009501d0bd9d$3ee0f630$bca2e290$@mesquiteit.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
On Mon, Jul 13, 2015 at 1:53 PM, Claude nikula <cnikula@mesquiteit.com>
wrote:
> Coding is the easy part. The harder part is making the right decision on
> how you want to connect. With VFP you have lots of options, that's one of
> the things that makes VFP so powerful.
> Here are some considerations you'll have to account for. On how to connect
>
> ----------------
You left a few out. here is the complete list.
http://www.connectionstrings.com/sql-server/
There is a great deal of details in here on what the various opportunities
provide.
Knowing how to manage connections might be a good thing to identify for the
version of SQL you are touching. Learning to close the door on the way out
is a good thing to do, just ask a farmer.
Personally I would follow the standard rules of C/S where you are
responsible for the data you pull as well as what you push back. Fetch
what you need and don't waste bandwidth getting a lot of non needed
columns.
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJidMY+dDLP4dtx+C4D4=B2R4WEOU7U4sGrRaUc=X5A+ZvjUtA@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Remote views are great but with one drawback. If you make them dynamic or generate them on the fly then the database needs to be locked and this can really screw up your system (other users). We have a private personal database that is created per user that you have exclusive access to all the time. Makes it easy, efficient and fast.
Dave
-----Original Message-----
From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Claude nikula
Sent: 13 July 2015 19:54
To: 'ProFox Email List'
Subject: RE: SQL Server 2014
Coding is the easy part. The harder part is making the right decision on how you want to connect. With VFP you have lots of options, that's one of the things that makes VFP so powerful.
Here are some considerations you'll have to account for. On how to connect
1. Pass-through (ODBC) - with this option, you'll have to consider if you want to connect to the clients programmatically, or if you wish to set up a data source name (DSN). Pro. Very flexible, very fast and powerful. Con. It can be very labor intensive
2. Remote views, this will require a DBC. Again, you'll have to decide if you want to use the programmatically connection string, or a data source name. Pro. Very easy to use. It takes care of all of your inserts, updates for you, which makes it very convenient. Con. In question is very large, It can become very slow.
3. ADO, is just another way of connecting to the server, it is very outdated, but still works. Pro. Very similar to pass-through with much more restrictions, it returns a data object that you can traverse through to pull specific data you looking for. Con. Can be difficult to work with, requires lots of additional work and if you're working with only one language in this case VFP. It doesn't make sense to use it
3. SQL Server data provider, I really never worked with this because it just seems to me, It is a waste of time. When it comes to actually working with VFP and MS SQL Server. There are some data engines out there where you have only the choice of using the data provider. It is mostly used in the.net world, guessing.
For my money, when it comes to using VFP. I would much rather prefer option 1, the pass-through and handling my connections programmatically. Therefore, do not have to set up any data source names on the client machines, which is a huge timesaver and gives you much more security. In fact, all of your connection string information can be stored in a table.
I genuinely use remote views for quick and dirty stuff. But I have used the remote view on a project with great success, and I do have to admit it really was a timesaver.
There are all kinds of examples online and the VFP help does provide good health and examples.
Be careful, VFP can really spoil you and make life easy for you. When connecting to third-party databases. So if you like me, who jumps back and forth between .net and Visual FoxPro, you start to realize how it is using Visual FoxPro <g>
Cheers,
Claude
Mesquite Information Technologies, LLC.
-----Original Message-----
From: Laurie Alvey [mailto:trukker41@gmail.com]
Sent: Monday, July 13, 2015 3:30 AM
To: ProFox Email List
Subject: Re: SQL Server 2014
There's also quite a bit in the VFP9 help file.
Laurie
On 11 July 2015 at 13:17, Rafael Copquin <rcopquin@yahoo.com.ar> wrote:
>
> I can recommend this book, which you can get at www.hentzenwerke.com
> Client-Server Applications with Visual FoxPro 6.0 and SQL Server 7.0
>
>
> Building Client-Server Applications with Visual FoxPro 6.0 and SQL
> Server 7.0
>
> by Chuck Urwiler and others
>
> It is a good primer that will teach you the basics on how to use VFP
> with SQL Server. And there are a few white papers in the web that you
> can consult
>
> Rafael Copquin
>
>
> El 11/07/2015 a las 0:56, Geoff Flight escribió:
>
>> I'm. back again. I have SQL Server 2014 and want to use a basic VFP
>> program to access data in it. Pretty easy except Ive never done it
>> and its been a few years since I played around with it. Can someone
>> recommend a good book that could talk me thru the basics? I had Les
>> Pinter's book but I have put it away safely never to be seen again.
>>
>> Thanks people!
>>
>> Geoff
>>
>>
>>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/009501d0bd9d$3ee0f630$bca2e290$@mesquiteit.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/18725B8CD2D5D247873A2BAF401D4AB259794354@EX2010-A-FPL.FPL.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
None of you use cursor adapters? I use them all the time and they are
just great! And do not have any of the drawbacks mentioned about views
Rafael Copquin
El 14/07/2015 a las 5:04, Dave Crozier escribió:
> Remote views are great but with one drawback. If you make them dynamic or generate them on the fly then the database needs to be locked and this can really screw up your system (other users). We have a private personal database that is created per user that you have exclusive access to all the time. Makes it easy, efficient and fast.
>
> Dave
>
>
> -----Original Message-----
> From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Claude nikula
> Sent: 13 July 2015 19:54
> To: 'ProFox Email List'
> Subject: RE: SQL Server 2014
>
> Coding is the easy part. The harder part is making the right decision on how you want to connect. With VFP you have lots of options, that's one of the things that makes VFP so powerful.
> Here are some considerations you'll have to account for. On how to connect
>
> 1. Pass-through (ODBC) - with this option, you'll have to consider if you want to connect to the clients programmatically, or if you wish to set up a data source name (DSN). Pro. Very flexible, very fast and powerful. Con. It can be very labor intensive
>
> 2. Remote views, this will require a DBC. Again, you'll have to decide if you want to use the programmatically connection string, or a data source name. Pro. Very easy to use. It takes care of all of your inserts, updates for you, which makes it very convenient. Con. In question is very large, It can become very slow.
>
> 3. ADO, is just another way of connecting to the server, it is very outdated, but still works. Pro. Very similar to pass-through with much more restrictions, it returns a data object that you can traverse through to pull specific data you looking for. Con. Can be difficult to work with, requires lots of additional work and if you're working with only one language in this case VFP. It doesn't make sense to use it
>
> 3. SQL Server data provider, I really never worked with this because it just seems to me, It is a waste of time. When it comes to actually working with VFP and MS SQL Server. There are some data engines out there where you have only the choice of using the data provider. It is mostly used in the.net world, guessing.
>
> For my money, when it comes to using VFP. I would much rather prefer option 1, the pass-through and handling my connections programmatically. Therefore, do not have to set up any data source names on the client machines, which is a huge timesaver and gives you much more security. In fact, all of your connection string information can be stored in a table.
>
> I genuinely use remote views for quick and dirty stuff. But I have used the remote view on a project with great success, and I do have to admit it really was a timesaver.
>
> There are all kinds of examples online and the VFP help does provide good health and examples.
>
> Be careful, VFP can really spoil you and make life easy for you. When connecting to third-party databases. So if you like me, who jumps back and forth between .net and Visual FoxPro, you start to realize how it is using Visual FoxPro <g>
>
>
> Cheers,
> Claude
> Mesquite Information Technologies, LLC.
>
>
>
>
>
> -----Original Message-----
> From: Laurie Alvey [mailto:trukker41@gmail.com]
> Sent: Monday, July 13, 2015 3:30 AM
> To: ProFox Email List
> Subject: Re: SQL Server 2014
>
> There's also quite a bit in the VFP9 help file.
> Laurie
>
> On 11 July 2015 at 13:17, Rafael Copquin <rcopquin@yahoo.com.ar> wrote:
>
>> I can recommend this book, which you can get at www.hentzenwerke.com
>> Client-Server Applications with Visual FoxPro 6.0 and SQL Server 7.0
>>
>>
>> Building Client-Server Applications with Visual FoxPro 6.0 and SQL
>> Server 7.0
>>
>> by Chuck Urwiler and others
>>
>> It is a good primer that will teach you the basics on how to use VFP
>> with SQL Server. And there are a few white papers in the web that you
>> can consult
>>
>> Rafael Copquin
>>
>>
>> El 11/07/2015 a las 0:56, Geoff Flight escribió:
>>
>>> I'm. back again. I have SQL Server 2014 and want to use a basic VFP
>>> program to access data in it. Pretty easy except Ive never done it
>>> and its been a few years since I played around with it. Can someone
>>> recommend a good book that could talk me thru the basics? I had Les
>>> Pinter's book but I have put it away safely never to be seen again.
>>>
>>> Thanks people!
>>>
>>> Geoff
>>>
>>>
>>>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/55A508D7.8090000@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
None of you use cursor adapters? I use them all the time and they are
just great! And do not have any of the drawbacks mentioned about views
Rafael Copquin
El 14/07/2015 a las 5:04, Dave Crozier escribió:
> Remote views are great but with one drawback. If you make them
dynamic or generate them on the fly then the database needs to be locked
and this can really screw up your system (other users). We have a
private personal database that is created per user that you have
exclusive access to all the time. Makes it easy, efficient and fast. > >
Dave > >
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/55A50A38.8090101@fibertel.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.