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