Index
2014-01-23 14:51 – Desmond Lloyd : VFP9 Forms in a VFP6 application
2014-01-23 15:03 – Rafael Copquin : Re: VFP9 Forms in a VFP6 application
2014-01-23 15:27 – Desmond Lloyd : Re: VFP9 Forms in a VFP6 application
2014-01-23 16:13 – Mike Copeland : Re: VFP9 Forms in a VFP6 application
2014-01-23 16:34 – Richard Kaye : RE: VFP9 Forms in a VFP6 application
2014-01-23 17:02 – Vincent Teachout : Re: VFP9 Forms in a VFP6 application
2014-01-23 19:41 – Ken Dibble : Re: VFP9 Forms in a VFP6 application
2014-01-24 03:39 – Alan Bourke : Re: VFP9 Forms in a VFP6 application
2014-01-24 05:57 – Peter Cushing : Re: VFP9 Forms in a VFP6 application
2014-01-24 05:58 – desmond.lloyd@gmail.com: Re: VFP9 Forms in a VFP6 application
Back to top
VFP9 Forms in a VFP6 application

Author: Desmond Lloyd

Posted: 2014-01-23 14:51:18   Link

Know everyone is going to think I am nuts.... however.

Got this old legacy VFP6 application, my description, it is a hodge-podge

of old 2.6 code, VFP6 forms and reports. All modifications etc. are made

using VFP6.

Was working on a form today and needed a temp table, the old select

whatever from whatever into cursor whatever readwrite would not work. For

grins I took an original VFP6 form and modified under VFP9, including a

select * from into cursor whatever readwrite saved under a different name

and called it from the program and the form runs!

Not exactly sure what I have gained with the exception of readwrite...

Would be interested in any opinions/thoughts.....

Regards,

Desmond

--- 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/CAAJXvaORAD+MTy3sR9GKTS0Px887fwhoPdDD2pe+wKBPMzSKKA@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.

©2014 Desmond Lloyd
Back to top
Re: VFP9 Forms in a VFP6 application

Author: Rafael Copquin

Posted: 2014-01-23 15:03:53   Link

For one thing, you have better sql statements in VFP9. IIRC, you do not

have update sql and so on in VFP6

Then you have cursor adapters, xmladapters, try-catch, etc.

Rafael Copquin

El 23/01/2014 17:51, Desmond Lloyd escribió:

> Know everyone is going to think I am nuts.... however.

>

> Got this old legacy VFP6 application, my description, it is a hodge-podge

> of old 2.6 code, VFP6 forms and reports. All modifications etc. are made

> using VFP6.

>

> Was working on a form today and needed a temp table, the old select

> whatever from whatever into cursor whatever readwrite would not work. For

> grins I took an original VFP6 form and modified under VFP9, including a

> select * from into cursor whatever readwrite saved under a different name

> and called it from the program and the form runs!

>

> Not exactly sure what I have gained with the exception of readwrite...

>

> Would be interested in any opinions/thoughts.....

>

> Regards,

> Desmond

>

>

> --- StripMime Report -- processed MIME parts ---

> multipart/alternative

> text/plain (text body -- kept)

> text/html

> ---

>

[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/52E183B9.6070400@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.

©2014 Rafael Copquin
Back to top
Re: VFP9 Forms in a VFP6 application

Author: Desmond Lloyd

Posted: 2014-01-23 15:27:47   Link

There is no update SQL statements, it's all append blank! 8-)

On 23 January 2014 15:03, Rafael Copquin <rcopquin@fibertel.com.ar> wrote:

> For one thing, you have better sql statements in VFP9. IIRC, you do not

> have update sql and so on in VFP6

> Then you have cursor adapters, xmladapters, try-catch, etc.

> Rafael Copquin

>

>

> El 23/01/2014 17:51, Desmond Lloyd escribió:

>

>> Know everyone is going to think I am nuts.... however.

>>

>> Got this old legacy VFP6 application, my description, it is a

>> hodge-podge

>> of old 2.6 code, VFP6 forms and reports. All modifications etc. are made

>> using VFP6.

>>

>> Was working on a form today and needed a temp table, the old select

>> whatever from whatever into cursor whatever readwrite would not work. For

>> grins I took an original VFP6 form and modified under VFP9, including a

>> select * from into cursor whatever readwrite saved under a different name

>> and called it from the program and the form runs!

>>

>> Not exactly sure what I have gained with the exception of readwrite...

>>

>> Would be interested in any opinions/thoughts.....

>>

>> Regards,

>> Desmond

>>

>>

>> --- StripMime Report -- processed MIME parts ---

>> multipart/alternative

>> text/plain (text body -- kept)

>> text/html

>> ---

>>

[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/CAAJXvaNy1dS_D4UgVj-KoQdQDoprXRvoo5H91FvtXNCdD=kdGg@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.

©2014 Desmond Lloyd
Back to top
Re: VFP9 Forms in a VFP6 application

Author: Mike Copeland

Posted: 2014-01-23 16:13:14   Link

I may be wrong, but I think the readwrite option was not available in

VFP6. As I recall, there was a workaround where you used a VFP function

to get the file name of the cursor, then reopened it again with readwrite.

Mike Copeland

-------- Original Message --------

Subject: VFP9 Forms in a VFP6 application

From: Desmond Lloyd <desmond.lloyd@gmail.com>

To: profoxtech@leafe.com

Date: 1/23/2014 2:51 PM

> Know everyone is going to think I am nuts.... however.

>

> Got this old legacy VFP6 application, my description, it is a hodge-podge

> of old 2.6 code, VFP6 forms and reports. All modifications etc. are made

> using VFP6.

>

> Was working on a form today and needed a temp table, the old select

> whatever from whatever into cursor whatever readwrite would not work. For

> grins I took an original VFP6 form and modified under VFP9, including a

> select * from into cursor whatever readwrite saved under a different name

> and called it from the program and the form runs!

>

> Not exactly sure what I have gained with the exception of readwrite...

>

> Would be interested in any opinions/thoughts.....

>

> Regards,

> Desmond

>

>

> --- StripMime Report -- processed MIME parts ---

> multipart/alternative

> text/plain (text body -- kept)

> text/html

> ---

>

[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/52E193FA.9020807@ggisoft.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.

©2014 Mike Copeland
Back to top
RE: VFP9 Forms in a VFP6 application

Author: Richard Kaye

Posted: 2014-01-23 16:34:50   Link

I can never keep that straight. It's either USE DBF(<alias of cursor>]) AGAIN IN 0 or USE ALIAS()... Or xBase style, use COPY TO... out of the cursor to create a persistent table on disk.

--

rk

-----Original Message-----

From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Mike Copeland

Sent: Thursday, January 23, 2014 5:13 PM

To: profoxtech@leafe.com

Subject: Re: VFP9 Forms in a VFP6 application

I may be wrong, but I think the readwrite option was not available in VFP6. As I recall, there was a workaround where you used a VFP function to get the file name of the cursor, then reopened it again with readwrite.

Mike Copeland

_______________________________________________

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/DF1EEF11E586A64FB54A97F22A8BD04422A33C23B3@ACKBWDDQH1.artfact.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.

©2014 Richard Kaye
Back to top
Re: VFP9 Forms in a VFP6 application

Author: Vincent Teachout

Posted: 2014-01-23 17:02:40   Link

Richard Kaye wrote:

> I can never keep that straight. It's either USE DBF(<alias of cursor>]) AGAIN IN 0 or USE ALIAS()... Or xBase style, use COPY TO... out of the cursor to create a persistent table on disk.

IIRC, it's the first one - use Dbf("mycursor") again in 0 alias NewAlias

_______________________________________________

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/52E19F90.1040600@taconic.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.

©2014 Vincent Teachout
Back to top
Re: VFP9 Forms in a VFP6 application

Author: Ken Dibble

Posted: 2014-01-23 19:41:18   Link

>Got this old legacy VFP6 application, my description, it is a hodge-podge

>of old 2.6 code, VFP6 forms and reports. All modifications etc. are made

>using VFP6.

>

>Was working on a form today and needed a temp table, the old select

>whatever from whatever into cursor whatever readwrite would not work. For

>grins I took an original VFP6 form and modified under VFP9, including a

>select * from into cursor whatever readwrite saved under a different name

>and called it from the program and the form runs!

Well, I think you must not only have modified the VFP 6 form in VFP 9, you

must also be running it in VFP 9, or the READWRITE keyword would not work.

Assuming you continue to use VFP 9, you get a bazillion improvements to

reporting, much expanded SQL capabilities, wayyyy higher limits on memory

issues, variable counts, array sizes, etc., and a whole heckuva lot fewer

serious, crash-inducing, data-and-metadata-corrupting bugs. Plus

Intellisense! Well, almost all of those things are good. :)

Ken Dibble

www.stic-cil.org

_______________________________________________

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/5.2.1.1.1.20140123203733.01bd6d18@POP-Server.stny.rr.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.

©2014 Ken Dibble
Back to top
Re: VFP9 Forms in a VFP6 application

Author: Alan Bourke

Posted: 2014-01-24 03:39:26   Link

VFP9 is also quite a lot faster and the IDE is much better.

_______________________________________________

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/1390556366.5181.74760121.53C26030@webmail.messagingengine.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.

©2014 Alan Bourke
Back to top
Re: VFP9 Forms in a VFP6 application

Author: Peter Cushing

Posted: 2014-01-24 05:57:48   Link

Desmond Lloyd wrote:

> There is no update SQL statements, it's all append blank! 8-)

>

>

Even in VFP6 you did not need to use append blank. Since FP2.6 been

using INSERT INTO <mytable> FROM MEMVAR. For situations where you had

exclusive access (a cursor you just created or when buffering) you could

use append blank but usually tried to avoid it from earlier experiences

with live tables and locking ;-)

Peter

----------------------------------------------------------------

Rajan Imports has changed - we are now Whispering Smith Ltd. For more information see our website at www.whisperingsmith.com

Please update your address book with my new email address: pcushing@whisperingsmith.com

.

This communication is intended for the person or organisation to whom it is addressed. The contents are confidential and may be protected in law. Unauthorised use, copying or

disclosure of any of it may be unlawful. If you have received this message in error, please notify us immediately by telephone or email.

www.whisperingsmith.com

Whispering Smith Ltd

Head Office:61 Great Ducie Street, Manchester M3 1RR. Tel:0161 831 3700 Fax:0161 831 3715

London Office:17-19 Foley Street, London W1W 6DW Tel:0207 299 7960

_______________________________________________

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/52E2553C.8030403@whisperingsmith.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.

©2014 Peter Cushing
Back to top
Re: VFP9 Forms in a VFP6 application

Author: desmond.lloyd@gmail.com

Posted: 2014-01-24 05:58:10   Link

Very, love the ability to list out o

Sent from

From: Alan Bourke

Sent: Friday, January 24, 2014 3:39 AM

To:

pReply To: ProFox Email List

SRe: VFP9 Forms in a VFP6 application

VFP9 is also quit

_________________________Post Messages to: ProFox@leafe.com

SubscriptioOT-free verSeaThis message: h

** All postings, unless explicitly stated other

--- StripMime Report -- processed MIME parts ---

text/html (html body -- converted)

---

_______________________________________________

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/20140124115810.5636238.35478.3332@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.

©2014 desmond.lloyd@gmail.com