Re: SQL Server 2014

2015-07-10 Thread Pete Theisen

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.3080...@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.


Re: SQL Server 2014

2015-07-11 Thread Rafael Copquin


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.7030...@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.


Re: SQL Server 2014

2015-07-13 Thread Laurie Alvey
There's also quite a bit in the VFP9 help file.
Laurie

On 11 July 2015 at 13:17, Rafael Copquin  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-xzxhbzrjmdhkyyjx7deyhuvryzokqby9oz...@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.

RE: SQL Server 2014

2015-07-13 Thread Kurt Wendt
+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-boun...@leafe.com] On Behalf Of Laurie Alvey
Sent: Monday, July 13, 2015 6:30 AM
To: profoxt...@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  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-xzxhbzrjmdhkyyjx7deyhuvryzokqby9oz...@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-xzxhbzrjmdhkyyjx7deyhuvryzokqby9oz...@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/80838f1ca795b14ea1af48659f35166f1cc...@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.

RE: SQL Server 2014

2015-07-13 Thread Claude nikula
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 


Cheers, 
Claude 
Mesquite Information Technologies, LLC. 





-Original Message-
From: Laurie Alvey [mailto:trukke...@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  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.

Re: SQL Server 2014

2015-07-13 Thread Stephen Russell
On Mon, Jul 13, 2015 at 1:53 PM, Claude nikula 
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+zvj...@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.


RE: SQL Server 2014

2015-07-14 Thread Dave Crozier
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-boun...@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 


Cheers,
Claude
Mesquite Information Technologies, LLC. 





-Original Message-
From: Laurie Alvey [mailto:trukke...@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  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 advi

Re: SQL Server 2014

2015-07-14 Thread Rafael Copquin
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-boun...@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 


Cheers,
Claude
Mesquite Information Technologies, LLC.





-Original Message-
From: Laurie Alvey [mailto:trukke...@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  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.8090...@yahoo.com.ar
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. Thi

RE: SQL Server 2014

2015-07-14 Thread José Enrique Llopis
I use cursor adapter on my apps, desktop and Web (Web Connection),  and CA's
work very well.


Pepe Llopis
www.multilinkcrm.com


-Mensaje original-
De: ProFox [mailto:profox-boun...@leafe.com] En nombre de Rafael Copquin
Enviado el: martes, 14 de julio de 2015 15:04
Para: profox@leafe.com
Asunto: Re: SQL Server 2014

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-boun...@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 
>
>
> Cheers,
> Claude
> Mesquite Information Technologies, LLC.
>
>
>
>
>
> -Original Message-
> From: Laurie Alvey [mailto:trukke...@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  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

Re: SQL Server 2014

2015-07-15 Thread AndyHC

@Rafael Copquin
+1 for cursor adapters

___
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/55a6175e.10...@hawthorncottage.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.


Fwd: Re: SQL Server 2014

2015-07-14 Thread Rafael Copquin


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.8090...@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.