RE: Fun with .Net DLLs

[Darren]

Richard it is relatively simple. 

Done it many times but not for a while - I'll hunt down my notes and get
something to you. Essentially it is making the .Net assembly com visible and
then it is easy to use in VFP.

I'll do that this evening.

Cheers


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Wednesday, 5 April 2023 1:37 AM
To: profoxt...@leafe.com
Subject: RE: Fun with .Net DLLs

Thanks, Alan, much appreciated.

I was just going through the various build options. The 32 bit thing will be
a the top of the checklist.

I thought there was a magic way to connect the debugger to an external
process (e.g. VFP). There's some stuff in Doug's white paper on how to do
that but I'm just at the beginning of this journey.

--

rk

From: ProfoxTech  On Behalf Of Alan Bourke
Sent: Tuesday, April 4, 2023 10:36 AM
To: profoxt...@leafe.com
Subject: Re: Fun with .Net DLLs

Richard
I assume you created a project of type 'Class Library'. No you can't debug
those, you need to host it in some other sort of exectuable project. To
debug that you either need to add another project of a type that is
executable to your solution (like a Windows Forms, WPF or Console
application) and reference the output from the first project in that, so you
can test it. You need to right-click on that project in Solution Explorer
and select 'Set As Startup Project'.

Normally I would recommend to test it on the .NET side you actually use a
proper testing framework like MSTest or NUnit. However what you're trying to
really needs to be checked visually so that's probably overkill initially.

Did you make the relevant methods COM-visible, i.e. like:

[ComVisible(true)]
[Guid("8C019E76-59BE-43A6-9DD9-66F7C9CAE67B")]
[ProgId("MyApp.ExcelConvert")]
[ClassInterface(ClassInterfaceType.AutoDual)]
[ComSourceInterfaces(typeof(IExcelConvertEvents))]
public class ExcelConvertHelper
{
...
}

I must confess I've never gotten the wwDotNetBridge registration-free COM to
work. I've always had to add an installer project in .NET and just make
users install and register the assembly.

Don't forget you have to build it as 32-bit to use it from VFP.

--
Alan Bourke
alanpbourke (at) fastmail (dot) fm

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/014c01d96769$b379c7f0$1a6d57d0$@ozemail.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.

RE: Howdy Folks

[Darren]

I implemented this functionality a while back but did it with event binding
to windows messaging on the directory - looking for new files (if I recall
correctly). I found it to be much more reliable than timers and much more
responsive. When the file is dropped in the directory the app knows about it
almost immediately rather than waiting for the timer to come to the party.

Just a thought.



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Virgil
Bierschwale
Sent: Wednesday, 16 November 2022 9:48 PM
To: profoxt...@leafe.com
Subject: Re: Howdy Folks

thanks, that is probably what I will end up doing.
just amazes me that I can't find the original tool.
oh well, I noticed a lot of the old foxpro resource sites I used to use are
no longer in existence.


On Tue, Nov 15, 2022 at 5:21 PM Paul H. Tarver  wrote:

> I did something similar back in VFP6 where I added a VFP timer object to
> the
> main page and then we set the interval to 3-5 minutes (I can't really
> remember exactly how long) and the timer method would fire and check to
see
> if a "SHUTDOWN" file  was found and if so, it would display a message to
> the
> user with a 90 second countdown to give them time to close the
application.
> If they didn't respond, the shutdown message form would request a Save
> method on the parent form to save whatever was open at the time and then
it
> would close the application. I also checked for the existence of the
> "SHUTDOWN" file when starting the application and if found, it would
> provide
> a user message and then shut down.
>
> The coding for that is old and antiquated so I'll not embarrass myself by
> posting. But the logic was pretty much as stated. I guess my point is I
> just
> used the native VFP timer object to trigger the automated shutdown
> everything.
>
> Paul H. Tarver
> Tarver Program Consultants, Inc.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Virgil
> Bierschwale
> Sent: Tuesday, November 15, 2022 2:26 PM
> To: profoxt...@leafe.com
> Subject: Howdy Folks
>
> Been a long time.
> I'm back maintaining a foxpro system
> Back in the 90's I used a utility that would allow me to put a text file
> named shutdown.txt in the root folder and it would force all users out.
> Been googling and can't find it anymore.
> Any of you remember it?
>
> Looking for a way to kick users out so I can reindex when necessary.
>
> Thanks,
>
> Virgil
>
>
> --- 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: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/015701d8f9aa$b1218470$13648d50$@ozemail.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.

RE: A better way to create directories?

[Darren]

Creating director one folder at a time gives the results you desire.

e.g.   Following gives desired results.

mkd("C:\tES\xyZ")

PROCEDURE mkd(vPath as String)

  FOR n = 2 TO OCCURS("\",vPath)  
MD(SUBSTR(vPath,1,ATC("\", vPath, n)))
  ENDFOR   
  
  MD   
  
ENDPROC

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Newton
Sent: Wednesday, 1 June 2022 8:44 AM
To: profoxt...@leafe.com
Subject: Re: A better way to create directories?

Same here - Win10 64 bit

On 31/05/2022 23:41, AndyHC wrote:
> Nope! - I had a C:\Temp dir already and it created C:\Temp\XyZ -
> I also tried  MKDIR "C:\TempXyZ"  and that also worked.
>
>Win10 64 bit
>
> On 31-May-22 11:17 PM, Paul Newton wrote:
>> Andy
>>
>> On my system
>>
>> MkDir "C:\Test1\Test2"
>>
>> Creates the folders in lowercase (test1 and test2).  Any ideas?
>>
>> Paul
>>
>> On 31/05/2022 23:07, AndyHC wrote:
>>> MKDIR "C:\Temp\XyZ"
>>
>>
>> --- 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: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/00af01d87542$3320ab60$99620220$@ozemail.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.

RE: Sava as from IE application object or Web Browser control

[Darren]

Most things are achievable.

If no provision through the API then use windows api find window, controls on 
that form (hwnd), send messages to get desired results etc. etc.

A bit of work but it'll work fine.   E.g. Had a look at the Firefox "Save As" 
dialogue just now and everything is accessible and exposed.

It'd be simply a matter of setting text in an Edit control and a ComboBox and 
Clicking on a Button. All done with messages. 

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Newton
Sent: Monday, 30 May 2022 3:12 AM
To: profoxt...@leafe.com
Subject: Sava as from IE application object or Web Browser control

Hi all

I want to programmatically save the current web page (which was loaded 
from an MHTML file):

I want to specify the name and location for the file to be saved and be 
able to specify "Save as Webpage, complete".  Having Google researched, 
I do not believe this is possible.  Can anybody prove me wrong?

The only approach I can think of is ExecWB(4,n) where n is 0, 1 or 2.  
If it cannot be done without user interaction, I would like that 
interaction to be as minimal as possible (e.g. putting the folder 
location in the clipboard so that the user can at least paste it into 
the save as dialog would help, as would being able to at least specify 
the file name).  I can't find a way for the SaveAs dialog to default to 
Webpage, complete.

Many thanks

Paul Newton

--- 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: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/01d87421$4d3d5ec0$e7b81c40$@ozemail.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.

RE: [NF]Help desk and language skills

[Darren]

- There's an easy answer: speak to them in their native tongue.

Not so sure about that - My native tongue is English and there are plenty of
Scottish (to name but one country) whose native tongue is English and for
the life of me I often struggle to understand them.

But I take the point !!!

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe
Sent: Sunday, 9 January 2022 5:32 AM
To: profoxt...@leafe.com
Subject: Re: [NF]Help desk and language skills

On Jan 8, 2022, at 06:17, Man-wai Chang  wrote:
> 
> The problem is out-sourcing and down-sizing, the lowest price won,
> which meant lower language skills and less smart. That help desk
> person might be following a stupid A.I. the stupid way as well. :)
> 
> "Global village" meant you need to deal with people whose mother
> tongue was not English, as well as different accents.
> 
> On Sat, Jan 8, 2022 at 9:28 AM MB Software Solutions, LLC
>  wrote:
>> 
>> My IT guy says he's been dealing with several
>> not-very-good-at-all-speaking-English persons and it seems like each
>> time he has to start over...their communication skills are abysmal.
>> 
>> Don't you love this global village?

There's an easy answer: speak to them in their native tongue. 

Oh, wait - you mean you only speak English? 


-- Ed Leafe







[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/005501d804cf$0cfb8060$26f28120$@ozemail.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.

RE: SweetPotatosoftware.com

[Darren]

Seems to be geo blocked. From AUS no connection - using a USA based VPN 
straight in.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John Weller
Sent: Wednesday, 25 August 2021 1:52 AM
To: profoxt...@leafe.com
Subject: RE: SweetPotatosoftware.com

Same problem.

John

John Weller
07976 393631
> Maybe your browser isn't switching over to the https version automatically.
> Try explicitly going to https://www.sweetpotatosoftware.com/
> 
> Eric
> 
> On Tue, Aug 24, 2021 at 9:42 AM John Weller  wrote:
> 
> > I've just tried and timed out.  I wonder if it is an issue contacting
> > it from UK?
> >
> > John
> >
> > John Weller
> > 07976 393631
> >
> > > -Original Message-
> > > From: ProfoxTech  On Behalf Of Vince
> > > Teachout
> > > Sent: 24 August 2021 13:31
> > > To: profoxt...@leafe.com
> > > Subject: Re: SweetPotatosoftware.com
> > >
> > > Went right in, no problem.  It looks nice. I wonder if he updated it?
> > >
> > >
> > > On 08/24/21 7:25 AM, Dave Crozier wrote:
> > > > Is anyone else having difficulty trying to access Craig’s site?
> > > >
> > > > http://sweetpotatosoftware.com
> > > >
> > > > Is it still live?
> > > >



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/01c701d79931$2860d1c0$79227540$@ozemail.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.

RE: does Refox work in windows 10?

[Darren]

I have refox 12


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Michael
Savage
Sent: Friday, 10 April 2020 7:33 AM
To: profoxt...@leafe.com
Subject: Re: does Refox work in windows 10?

what version? mine is v8

On Thu, Apr 9, 2020 at 5:20 PM Mike  wrote:

> It has for me.
>
> Mike
>
> Michael Savage wrote:
> > just wondering.im retired so i was wondering how i did some things
> > Mike
> >
> >
> > --- 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: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/003101d60eb6$e71b96b0$b552c410$@ozemail.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.

RE: does Refox work in windows 10?

[Darren]

Me also.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike
Sent: Friday, 10 April 2020 7:21 AM
To: profoxt...@leafe.com
Subject: Re: does Refox work in windows 10?

It has for me.

Mike

Michael Savage wrote:
> just wondering.im retired so i was wondering how i did some things
> Mike
>
>
> --- 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: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/003001d60eb5$51961cb0$f4c25610$@ozemail.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.

RE: [NF] X# Bandol 2.2 released to the public

[Darren]

+1

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Koen
Piller
Sent: Tuesday, 17 December 2019 9:19 PM
To: profoxt...@leafe.com
Subject: Re: [NF] X# Bandol 2.2 released to the public

John,

I would appreciate if you would stop hitchhike your messages on other
forums.
I have now received for the third time a message that a new version is
launched, I strongly advise you to open a mailservice dedicated to X# and
leave Foxite, Level Extreme, ProFox, TekTips (did I forget one) alone.
Thanks,

Koen

Op di 17 dec. 2019 om 02:33 schreef Johan Nel :

> Hi All,
>
> Just a short note that the latest X# Bandol 2.2 was also released into
> the public domain.
>
> https://xsharp.info
>
> Johan Nel
> George, South Africa.
>
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/01d5b4cd$e17f0130$a47d0390$@ozemail.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.

RE: Using XML String as part of query in SQL Server

[Darren]

Thanks Frank - sorry I just now saw your first reply. Was out.

Good to see you got it working. 

Cheers


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank
Cazabon
Sent: Wednesday, 27 November 2019 10:16 AM
To: profoxt...@leafe.com
Subject: RE: Using XML String as part of query in SQL Server

I got it doing it like this:

SELECT iMemoNumber, DAGREEMENTDATE
FROM Agreements
 WHERE iMemoNumber IN (
 SELECT imemo = x.Rec.query('./imemonumber').value('.','integer') --
xmlArray.value('@imemonumber ','integer') 
 FROM @Array.nodes('/VFPData/c_agreements') AS x(Rec) --
TEMPTABLE(xmlArray)
 )

Thanks for the help

On 26 November 2019 18:32:12 GMT-04:00, Frank Cazabon
 wrote:
>Thanks Darren,
>
>I'm not getting anything returned and don't understand the syntax yet
>to be sure how to fix your example.
>
>I've tried this:
>
>declare @array xml = 'standalone="yes"?>
>http://www.w3.org/2001/XMLSchema-instance; 
>xsi:noNamespaceSchemaLocation="mySchema.xsd">
> 
> 17153
> 
> 
> 2
> 
> 
> 3
> 
> 
> 4
> 
> 
> 5
> 
>'
>/*
>SELECT iMemoNumber  
>FROM Agreements
> WHERE iMemoNumber IN (
> */
> SELECT xmlArray.value('@imemonumber ','integer') 
> FROM @Array.nodes('/c_agreements/imemonumber') AS TEMPTABLE(xmlArray)
> --)
>
>And get nothing returned.
>
>If I change it to this (add in VFPData):
>
>SELECT xmlArray.value('@imemonumber ','integer') 
>FROM @Array.nodes('/VFPData/c_agreements/imemonumber') AS
>TEMPTABLE(xmlArray)
>
>I get 5 rows back but they are all null.
>
>Any ideas what's wrong?
>
>On 26 November 2019 15:58:39 GMT-04:00, Darren 
>wrote:
>>Not tested but something similar to ...
>>
>>CREATE PROCEDURE [dbo].[spFindByXML]
>>  (
>>  @Array xml
>>  )
>>AS
>>
>>SET NOCOUNT ON;
>>--
>>SELECT iMemoNumber, AgreementDate, Amount 
>>FROM Agreements WHERE iMemoNumber IN (SELECT
>>xmlArray.value('@imemonumber ','integer') FROM
>>@Array.nodes('/c_agreements/imemonumber') AS TEMPTABLE(xmlArray))
>>--
>>SET NOCOUNT OFF;
>>
>>-Original Message-
>>From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
>>Frank Cazabon
>>Sent: Wednesday, 27 November 2019 5:16 AM
>>To: profoxt...@leafe.com
>>Subject: Using XML String as part of query in SQL Server
>>
>>Hi,
>>
>>I need to write an SQL Server Stored Procedure or just a simple SELECT
>
>>Query that accepts an XML string which is basically a list of IDs that
>>I 
>>want to use to filter data from a table.
>>
>>Example XML (created using CURSORTOXML):
>>
>>
>>http://www.w3.org/2001/XMLSchema-instance; 
>>xsi:noNamespaceSchemaLocation="mySchema.xsd">
>> 
>> 1
>> 
>> 
>> 2
>> 
>> 
>> 3
>> 
>> 
>> 4
>> 
>> 
>> 5
>> 
>>
>>
>>I then need to:
>>
>>SELECT iMemoNumber, AgreementDate, Amount
>>
>>FROM Agreements
>>
>>WHERE iMemoNumber IN (<>)
>>
>>
>>Or maybe
>>
>>SELECT iMemoNumber, AGreementDate, Amount
>>
>>FROM Agreements
>>
>>INNER JOIN << my XML data on the iMemoNumber >>
>>
>>
>>My Google search terms have failed to produce what I am looking for.
>>
>>Anybody have the solution?
>>
>>-- 
>>
>>Frank.
>>
>>Frank Cazabon
>>
>>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/001201d5a4ba$756ce200$6046a600$@ozemail.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.

RE: Using XML String as part of query in SQL Server

[Darren]

Not tested but something similar to ...

CREATE PROCEDURE [dbo].[spFindByXML]
(
@Array xml
)
AS

SET NOCOUNT ON;
--
SELECT iMemoNumber, AgreementDate, Amount 
  FROM Agreements WHERE iMemoNumber IN (SELECT xmlArray.value('@imemonumber 
','integer') FROM @Array.nodes('/c_agreements/imemonumber') AS 
TEMPTABLE(xmlArray))
--
SET NOCOUNT OFF;

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Frank 
Cazabon
Sent: Wednesday, 27 November 2019 5:16 AM
To: profoxt...@leafe.com
Subject: Using XML String as part of query in SQL Server

Hi,

I need to write an SQL Server Stored Procedure or just a simple SELECT 
Query that accepts an XML string which is basically a list of IDs that I 
want to use to filter data from a table.

Example XML (created using CURSORTOXML):


http://www.w3.org/2001/XMLSchema-instance; 
xsi:noNamespaceSchemaLocation="mySchema.xsd">
 
 1
 
 
 2
 
 
 3
 
 
 4
 
 
 5
 


I then need to:

SELECT iMemoNumber, AgreementDate, Amount

FROM Agreements

WHERE iMemoNumber IN (<>)


Or maybe

SELECT iMemoNumber, AGreementDate, Amount

FROM Agreements

INNER JOIN << my XML data on the iMemoNumber >>


My Google search terms have failed to produce what I am looking for.

Anybody have the solution?

-- 

Frank.

Frank Cazabon


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/003801d5a493$e5db4d00$b191e700$@ozemail.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.

RE: Class has disappeared from class library

[Darren]

If not and the class has gone then Refox might be your friend.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Darren
Sent: Tuesday, 16 July 2019 6:51 PM
To: profoxt...@leafe.com
Subject: RE: Class has disappeared from class library

Does that include records marked for deletion ?

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul
Newton
Sent: Tuesday, 16 July 2019 6:46 PM
To: profoxt...@leafe.com
Subject: RE: Class has disappeared from class library

Hi Darren

I tried that - the VCX contains just one record and the only fields
populated are PLATFORM, UNIQUEID and RESERVED1 - not looking promising

-Original Message-
From: ProfoxTech  On Behalf Of Darren
Sent: 16 July 2019 09:36
To: profoxt...@leafe.com
Subject: RE: Class has disappeared from class library

Sent by an external sender
--

Open the VCX as a DBF - browse and you'll likely see multiple definitions
for the class in question. The solution I adopted in these instances was to
simply delete all the records pertaining to the latest entry of that class,
pack and then all should be sweet. The downside is that the latest changes
will be lost.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul
Newton
Sent: Tuesday, 16 July 2019 6:30 PM
To: profoxt...@leafe.com
Subject: Class has disappeared from class library

I posted this yesterday but it never got through so am trying again ...



Hi all



I had a visual class library containing one class.  This morning something
has happened which is of great concern - the class library (VCX/VCT) is
still there but it is empty - the class it contained has vanished.  Is there
any way it might be lurking in a temporary file somewhere?  Any idea what
might have happened?  All suggestions gratefully received.



Many thanks



Paul Newton



--- 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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/017001d53bb4$f6c7a9d0$e456fd70$@ozemail.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.

RE: Class has disappeared from class library

[Darren]

Does that include records marked for deletion ?

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul
Newton
Sent: Tuesday, 16 July 2019 6:46 PM
To: profoxt...@leafe.com
Subject: RE: Class has disappeared from class library

Hi Darren

I tried that - the VCX contains just one record and the only fields
populated are PLATFORM, UNIQUEID and RESERVED1 - not looking promising

-Original Message-
From: ProfoxTech  On Behalf Of Darren
Sent: 16 July 2019 09:36
To: profoxt...@leafe.com
Subject: RE: Class has disappeared from class library

Sent by an external sender
--

Open the VCX as a DBF - browse and you'll likely see multiple definitions
for the class in question. The solution I adopted in these instances was to
simply delete all the records pertaining to the latest entry of that class,
pack and then all should be sweet. The downside is that the latest changes
will be lost.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul
Newton
Sent: Tuesday, 16 July 2019 6:30 PM
To: profoxt...@leafe.com
Subject: Class has disappeared from class library

I posted this yesterday but it never got through so am trying again ...



Hi all



I had a visual class library containing one class.  This morning something
has happened which is of great concern - the class library (VCX/VCT) is
still there but it is empty - the class it contained has vanished.  Is there
any way it might be lurking in a temporary file somewhere?  Any idea what
might have happened?  All suggestions gratefully received.



Many thanks



Paul Newton



--- 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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/016f01d53bb3$8b9dff70$a2d9fe50$@ozemail.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.

RE: Class has disappeared from class library

[Darren]

Open the VCX as a DBF - browse and you'll likely see multiple definitions
for the class in question. The solution I adopted in these instances was to
simply delete all the records pertaining to the latest entry of that class,
pack and then all should be sweet. The downside is that the latest changes
will be lost.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul
Newton
Sent: Tuesday, 16 July 2019 6:30 PM
To: profoxt...@leafe.com
Subject: Class has disappeared from class library

I posted this yesterday but it never got through so am trying again ...



Hi all



I had a visual class library containing one class.  This morning something
has happened which is of great concern - the class library (VCX/VCT) is
still there but it is empty - the class it contained has vanished.  Is there
any way it might be lurking in a temporary file somewhere?  Any idea what
might have happened?  All suggestions gratefully received.



Many thanks



Paul Newton



--- 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: https://leafe.com/archives
This message: 
https://leafe.com/archives/byMID/016801d53bb1$8b4d0b30$a1e72190$@ozemail.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.

RE: AW: Custom Scrollbar

[Darren]

Been watching this thread and decided to pipe in - I have to observe that I 
have done some pretty tricky stuff with the VFP grid. Granted some not so 
straight forward but subclass columns and headers etc. and you can go for 
broke. Not found anything that can’t be done with the VFP grid. Not to say it 
can do everything but I'm yet to find what that is. Spend a bit of time (a few 
hours) and enlightened you will be.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Koen Piller
Sent: Monday, 7 January 2019 11:44 PM
To: profoxt...@leafe.com
Subject: Re: AW: Custom Scrollbar

Gene
The native VFP grid can handle datahandling perfectly. Please explain why
you differ on opinion
Koen

Op ma 7 jan. 2019 om 12:19 schreef Fernando D. Bozzo 

> Hi Gene,
>
> About this:
>
> >"One of the things that Grid is supposedly not for is data
> entry"
>
> I don't agree. Not sure about the complexity of what you need to do, but if
> you used FoxPro before VFP, you could remember that before the grid
> component was the BROWSE command with many parameters that allowed many
> validations and options for row/column, and that many validations and
> options where made exactly for that purpose, for data entry. Most of them
> have no sense for other purpose than data entry.
>
> One of my first programming challenges was to do a component exactly as you
> need it to (I'm talking about dBase III+ era), and could do it, but the
> problem was that performed horribly, too slow to navigate records and
> columns.
> I think that you could face the same problem. Do not forget that you have
> to control each and every aspect of the component, as:
>
> - Scrolling left/right controlling start and end columns
> - Scrolling top/bottom controlling start and end rows
> - Controlling the data you load/unload, because you can't load a millon
> records in memory, and this forces you to control dinamically the loading
> of a new bunch of records in the direction you are navigating, and
> unloading records from the other side
> - Controlling every key for navigation and other needed purposes
> - Controlling the visualization of each aspect of your info (think on
> Autosizing columns, pre-programmed sizes, combination of both, assuring
> that you show columns correctly and fluently ,etc)
> - More things you may ancounter
>
> Obviously I'm thinking in a component that can be used for any table, and
> not just for one special table, because the programming effort to do this
> type of component is too high to do it for just one table.
>
> Don't know if you already said this because I didn't follow the entire
> thread, but:
> What type of validation do you need, and what is the problem you are facing
> that can't be handled with the grid?
>
> And more importantly: Is really a grid what you need? why can't you use an
> input form with navigation keys that scrolls data in background?
>
> Best Regards!
>
>
> El lun., 7 ene. 2019 a las 6:20, Gene Wirchenko ()
> escribió:
>
> > At 08:13 2019-01-06,  wrote:
> > > >> I want to create my own grid
> > >
> > >WHY, just WHY?
> >
> >   Because the VFP grid does not work.
> >
> > >Haven't yet found a problem for which I would need a homegrown grid.
> > >What can't you do in VFP's native grid, in combination with the
> excellent
> > >container hierarchy which you could add into any / every column of a
> grid?
> >
> >   Full validation of a row.
> >
> >   I came close, but it required a lot of kludges and an innocent
> > change in one place could blow it up.
> >
> > >Build a set of controls, save them as class, add that class to the
> Column,
> > >change Column.CurrentControl to point to that class, set Column.Sparse
> to
> > >.F. and presto, you can do any complicated setup and stil have the
> > benefits
> > >of VFP's native gridspeed.
> >
> >   I wish.
> >
> >   One of the things that Grid is supposedly not for is data
> > entry.  I need a grid that can handle that.
> >
> > Sincerely,
> >
> > Gene Wirchenko
> >
> >
[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/005f01d4a6da$f268e8f0$d73abad0$@ozemail.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.

RE: REINSTALL FOX PRO 9

[Darren]

Don't actually need to install anything for any of the VFP versions to
function AFAIK.  Just copy the relevant files and go for it.

That said - possibly better integrated with an install.

But for sure zero reliance on VS and each version of VFP has zero dependence
on any prior version and not impacted by any future version - as in co-exist
perfectly fine.  At least that has been my experience.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt @
Gmail
Sent: Tuesday, 11 December 2018 3:00 PM
To: profoxt...@leafe.com
Subject: Re: REINSTALL FOX PRO 9

Tracy - sounds like Gary tried VFP6 to then do VFP9 - but, seems - VFP6 
won't install!

Gary - what does it insist on VS - just to install VFP6? I never 
installed VS in order to install VFP. Although - I haven't touched a 
VFP6 install in Many Moons! And, on my personal PC & laptop - I don't 
even use Win10 - still w/Win7 & 8.

-K-

On 12/10/2018 7:16 PM, Tracy Pearson wrote:
> I've not needed to install an older version of FoxPro to install the
FoxPro 9 upgrade on Windows 10.
>
> HTH,
> Tracy
>
> On December 10, 2018 10:13:20 PM EST, GARY  JEURINK
 wrote:
>> Help, my computer running win 10 and foxpr 9 crashed. I paid a fortune
>> to
>> recover the old c-drive. Now a new computer won't let be load visual
>> studio
>> to load fox pro 6 and then later fox pro 9.  Gary Jeurink. huge ap that
>> runs
>> my handi-cap system.
>>
>>
>>
>> --- 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/00ea01d49112$4a718720$df549560$@ozemail.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.

RE: recno() function in t-sql

[Darren]

Have a look at   SELECT ROW_NUMBER()  OVER(.) AS Recnbr,x,y,z

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael
Copquin
Sent: Thursday, 5 July 2018 5:30 AM
To: profoxt...@leafe.com
Subject: recno() function in t-sql

What is the equivalent of therecno() function in t-sql

I need to fill a column called recnbr with the record number of each line

In VFP it would be:

update mytable set recnbr = recno()

But since there is no recno() function in t-sql, what would be a
replacement?

TIA

Rafael Copquin


--- 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/002701d413d5$a891b470$f9b51d50$@ozemail.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.

RE: BitDefender Doesn't Play Well With VFP

[Darren]

Just tried  GENDBC - copied a database and files to location away from dev
(different drive). Ran the GENDBC from the command window without parameters
and selected Database and Target prg at the subsequent prompts. Worked as
expected. Have the prg,  fxp and krt files - no corruption of the DBC.
Currently using Bitdefender Total Security 2018.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul H.
Tarver
Sent: Wednesday, 6 December 2017 2:35 AM
To: profoxt...@leafe.com
Subject: BitDefender Doesn't Play Well With VFP

Just wanted to throw this out and see if anyone is running into something
similar. 

 

I have been wanting to find a new AV tool for my system and have been
testing BitDefender for the last few weeks. I started with the free version
and upgraded to the paid version after I realized the free version didn't
let me exclude processes or files or folders. 

 

However, since I've upgraded, I found that there is apparently something
BitDefender doesn't like about some of the stuff Foxpro does during
compilation (it crashes before completion and throws an error about unable
to write to the path). Alternatively, when I run my modified GENDBC.prg to
create a dbcbuilder file used by my applications, not only does it crash it
trashes the DBC file being processed. 

 

I've tried excluding VFP6 and VFP9 processes and I've tried excluding files
to no avail. The only solution is to go into BitDefender and turn it off for
15 minutes or so and then I can complete the GENDBC or compilation process
without any problems. 

 

So here's my questions:

 

1)  Is there something I need to do different with BitDefender to make
be more friendly to VFP?

2)  Should I just dump Bitdefender and go with a different AV tool? If
so, what's the recommended tool.

 

Thanks!

 

Paul H. Tarver
  p...@tpcqpc.com

 

 



--- 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/005b01d36dea$53a2cf30$fae86d90$@ozemail.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.

RE: BitDefender Doesn't Play Well With VFP

[Darren]

I've been using the Bitdefender for maybe 4 years now with zero issue re
VFP. The only fox related issue is with Refox, which I use rarely, and that
was getting blocked. Added an exception in the "Advanced Threat Defense"
module and sweet from there.

 
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul H.
Tarver
Sent: Wednesday, 6 December 2017 2:35 AM
To: profoxt...@leafe.com
Subject: BitDefender Doesn't Play Well With VFP

Just wanted to throw this out and see if anyone is running into something
similar. 

 

I have been wanting to find a new AV tool for my system and have been
testing BitDefender for the last few weeks. I started with the free version
and upgraded to the paid version after I realized the free version didn't
let me exclude processes or files or folders. 

 

However, since I've upgraded, I found that there is apparently something
BitDefender doesn't like about some of the stuff Foxpro does during
compilation (it crashes before completion and throws an error about unable
to write to the path). Alternatively, when I run my modified GENDBC.prg to
create a dbcbuilder file used by my applications, not only does it crash it
trashes the DBC file being processed. 

 

I've tried excluding VFP6 and VFP9 processes and I've tried excluding files
to no avail. The only solution is to go into BitDefender and turn it off for
15 minutes or so and then I can complete the GENDBC or compilation process
without any problems. 

 

So here's my questions:

 

1)  Is there something I need to do different with BitDefender to make
be more friendly to VFP?

2)  Should I just dump Bitdefender and go with a different AV tool? If
so, what's the recommended tool.

 

Thanks!

 

Paul H. Tarver
  p...@tpcqpc.com

 

 



--- 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/005701d36de7$b3fe3250$1bfa96f0$@ozemail.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.

RE: VFP, Authorize.net

[Darren]

The rule is simple. VFP can do anything !!!

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike McCann
Sent: Friday, 27 October 2017 7:59 AM
To: profoxt...@leafe.com
Subject: RE: VFP, Authorize.net

We have used Rick Strahl's West-Wind Web Tools for years to do HTTP POST using 
HTTP and HTTPS, both to web sites and web services.  We call an in-house 
written C# Windows authentication utility from VFP.  A little work but very 
do-able from VFP. 

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen 
Russell
Sent: Thursday, October 26, 2017 3:33 PM
To: profoxt...@leafe.com
Subject: Re: VFP, Authorize.net

I will say yes and no.  Getting the data, collections in this case, from VFP to 
post there may be difficult.  you are posting in an httppost situation.

>From a PHP pov there are objects being created.   new
AnetAPI\TransactionRequestType(); you should be able to do that easily.
You then stuff it.  Still easy.  It is the defining the catching object to 
receive the response.  That is where I think you are going to find the 
difficulty.


// Create a TransactionRequestType object and add the previous objects to it
$transactionRequestType = new AnetAPI\TransactionRequestType();
$transactionRequestType->setTransactionType("authCaptureTransaction");
$transactionRequestType->setAmount($amount);
$transactionRequestType->setOrder($order);
$transactionRequestType->setPayment($paymentOne);
$transactionRequestType->setBillTo($customerAddress);
$transactionRequestType->setCustomer($customerData);

$transactionRequestType->addToTransactionSettings($duplicateWindowSetting);
$transactionRequestType->addToUserFields($merchantDefinedField1);
$transactionRequestType->addToUserFields($merchantDefinedField2);

// Assemble the complete transaction request
$request = new AnetAPI\CreateTransactionRequest();
$request->setMerchantAuthentication($merchantAuthentication);
$request->setRefId($refId);
$request->setTransactionRequest($transactionRequestType);

// Create the controller and get the response
$controller = new AnetController\CreateTransactionController($request);
$response =
$controller->executeWithApiResponse(\net\authorize\api\constants\ANetEnvironment::SANDBOX);


if ($response != null) {
// Check to see if the API request was successfully received and acted 
upon
if ($response->getMessages()->getResultCode() ==
\SampleCode\Constants::RESPONSE_OK) {
// Since the API request was successful, l

On Thu, Oct 26, 2017 at 2:42 PM, Vince Teachout  wrote:

> A friend of mine sent the following question, and I don't know the 
> answer.  Does anyone know off the top of their head?
>
>
> "I have a VFP question if you do not mind.  I have a client with an 
> old custom app in VFP 7 and 9.  They process credit cards using Authorize.net.
> Authorize.net is pushing everyone to a new API and I am tasked with 
> migrating the client’s apps so they can use this new API ( 
> https://developer.authorize.net/api/reference/index.html).  Currently 
> they use HTTP Posts to send in the CC info.
>
> Anyway, my question is this.  Authorize offers a development kit and 
> example code using C#.  Therefore it should be .Net compliant and 
> wouldn’t that mean I could use the same in a VFP application?"
>
[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/006001d34e9d$b1d53b90$157fb2b0$@ozemail.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.

RE: VFP, Authorize.net

[Darren]

Seems to me like it is ultimately XML or JSON posted and JSON back. If that is 
what it is then it is easy enough to handle. If I am missing something then it 
could be a different story.

Personally I'd skip all that C# stuff and look at the examples they give in the 
"TRY IT" tabs. But then again my web experience is fairly limited.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Vince 
Teachout
Sent: Friday, 27 October 2017 6:43 AM
To: profoxt...@leafe.com
Subject: VFP, Authorize.net

A friend of mine sent the following question, and I don't know the answer.  
Does anyone know off the top of their head?


"I have a VFP question if you do not mind.  I have a client with an old 
custom app in VFP 7 and 9.  They process credit cards using 
Authorize.net.  Authorize.net is pushing everyone to a new API and I am 
tasked with migrating the client’s apps so they can use this new API 
(https://developer.authorize.net/api/reference/index.html).  Currently 
they use HTTP Posts to send in the CC info.

Anyway, my question is this.  Authorize offers a development kit and 
example code using C#.  Therefore it should be .Net compliant and 
wouldn’t that mean I could use the same in a VFP application?"

[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/004f01d34e9b$b33f8be0$19bea3a0$@ozemail.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.

RE: Refox?

[Darren]

Richard

Happy to help.

Cheers

Darren



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Wednesday, 25 October 2017 2:54 AM
To: profoxt...@leafe.com
Subject: FW: Refox?

Hi Profoxers,

I have a long-time client who pinged me about running some ancient FXPs
through Refox. I never had a copy but thought I'd see if someone here on the
list would be kind enough to assist. If so, please let me know.

TIA

--

rk

From: Paul Blank
Sent: Tuesday, October 24, 2017 10:57 AM
To: Richard Kaye <rk...@invaluable.com>
Subject: Refox?

Hi Richard,

Happy warm fall!

Any chance you guys have refox lying around?

Have a few old foxpro-dos modules to decompile...

Cheers,

Paul




--- 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/005a01d34cfd$ff9666c0$fec33440$@ozemail.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.

RE: [NF] learn more about what you hate so much.

[Darren]

+1

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Hemans
Sent: Saturday, 7 October 2017 9:37 AM
To: profoxt...@leafe.com
Subject: Re: [NF] learn more about what you hate so much.

"I don't know about you, but I'm pretty sure Microsoft "forked" Foxpro 
developers."
Yes, and I definitely will never forgive them for that!

On Sat, Oct 7, 2017 at 8:50 AM, Paul H. Tarver  wrote:

> I don't know about you, but I'm pretty sure Microsoft "forked" Foxpro 
> developers.
> [Sorry but I couldn’t resist, it's FRIDAY!]
>
> Paul H. Tarver
> Email: p...@tpcqpc.com
>
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
> Paul Hemans
> Sent: Friday, October 06, 2017 4:38 PM
> To: profoxt...@leafe.com
> Subject: Re: [NF] learn more about what you hate so much.
>
> Being open source guarantees that it can be forked and that we don't 
> end up in the dead end that VFP became. But there are other options 
> for strongly typed JS available. It is just that being associated with 
> MS means that it has stronger support, whereas other open source 
> projects can simply dry up.
>
> On Sat, Oct 7, 2017 at 2:43 AM, Thierry Nivelet 
> 
> wrote:
>
> > developed and promoted by Microsoft, and widely considered as part 
> > of the MS ecosystem even if it's technically open source.
> >
> > perceptions weigh more than facts, I can testify.
> >
> > Thierry Nivelet
> > FoxInCloud
> > Give your VFP app a second life in the cloud http://foxincloud.com/
> >
> > Le 06/10/2017 à 16:55, Alan Bourke a écrit :
> >
> >> On Fri, 6 Oct 2017, at 03:14 PM, Thierry Nivelet wrote:
> >>
> >> Typescript is Microsoft;
> >>>
> >>
> >> It's also open source, and only one of a range of similar tools.
> >>
> >>
> >
[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/00e601d33f0f$36160b30$a2422190$@ozemail.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.

RE: [NF] learn more about what you hate so much.

[Darren]

I know of a bank that spent upwards of 30M trying to port a VFP app, that had 
been developed over 15+ years with a group of developers,  to .NET - all got 
dumped. 30M+ wasted. Back to using VFP for now. Not suggesting it can't be done 
but in this case an extreme amount of business logic in the app and the task is 
mammoth.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kevin Cully
Sent: Friday, 6 October 2017 6:44 AM
To: profoxt...@leafe.com
Subject: Re: [NF] learn more about what you hate so much.

I worked for a company that produced Real Estate software for the commercial 
side of things.  We had a national client that said they were leaving our 
product to develop a new .NET solution with another company.

They returned after 1.5 years and after spending $2.1M.  They started asking us 
for enhancements again. Ouch.

I'm figure throwing away a working system *may* work, but most likely it's an 
expensive lesson to someone.


On 10/05/2017 01:25 PM, Bill Anderson wrote:
> Kevin,
>
> At our user group we were told by a Microsoft representative (well known to
> the Fox community) that Dell was throwing away all their internal
> applications **sight unseen** to rewrite them in the beta version of .NET
> 1.0.
>
> I wonder how that turned out?
>
> Bill Anderson
>
>>> For 20 years now, Microsoft has been telling me that I've been developing
> with an inferior tool and that .NET is better.  Is it ready now?<<
>
> On Thu, Oct 5, 2017 at 6:45 AM, Kevin Cully 
> wrote:
>
>> For 20 years now, Microsoft has been telling me that I've been developing
>> with an inferior tool and that .NET is better.  Is it ready now?
>>
>> I think I'll stick with Foxpro and now Xojo for developing business
>> solutions.
>>
>> I don't hate .NET.  I'm just going to continue to ignore it.
>>
>>
>> On 10/04/2017 11:01 AM, Stephen Russell wrote:
>>
>>> This is the 2017 .NET Conference Keynote
>>>
>>> https://www.youtube.com/watch?v=yecu4g5JYB8
>>>
>>> It has morphed from the .NET you all hated so much 15 years ago.  They
>>> show
>>> working in Chrome and not Bing.
>>>
>>> the beginning goes over NuGet if you are unfamiliar with posting packages
>>> to it.
>>>
>>>
[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/007f01d33e22$ca0790e0$5e16b2a0$@ozemail.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.

RE: SQL Error

[Darren]

Maybe try .. between(cwkt.trndat, ctwc.validfr, ctwc.validto)  . yes I know
- better not to use but maybe worth a try.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene
Wirchenko
Sent: Tuesday, 8 August 2017 10:36 AM
To: profoxt...@leafe.com
Subject: SQL Error

Hello:

  The following statement throws "SQL: Error correlating fields.":

select *;
from cwkt;
where;
 funccode="TW" and trndate>={^2017.07.01} and;
 exists;
  (;
  select .t. from ctwc;
  where;
   cwkt.clcode=ctwc.clcode and cwkt.wccode=ctwc.wccode and;
   cwkt.trndate between ctwc.validfr and ctwc.validto;
  );
order by clcode,wonbr,trndate

 This statement works:

select *;
from cwkt;
where;
 funccode="TW" and trndate>={^2017.07.01} and;
 exists;
  (;
  select .t. from ctwc;
  where;
   cwkt.clcode=ctwc.clcode and cwkt.wccode=ctwc.wccode and;
   cwkt.trndate>=ctwc.validfr and cwkt.trndate<=ctwc.validto;
  );
order by clcode,wonbr,trndate

  The only difference is the second line of the nested select's where
expression.  The first uses between, and the second uses >= and <=.

  What am I missing?

Sincerely,

Gene Wirchenko


[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/005001d30fdf$ebf286e0$c3d794a0$@ozemail.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.

RE: GETFILE() Returns Empty String in Some Cases

[Darren]

Personally I use this approach ...

STORE m.variable|obj.property|table.fieldname to variable.   Fully qualify
everything / always. Easier to debug as well.

Additional to results below ... STORE/ = | with/without m. |  with/ without
table open.

No Table Open   x=y 0.1320
No Table Open   STORE y to x0.0870
No Table Open   x=m.y   0.1328
No Table Open   STORE m.y to x  0.0879
Table Open  x=y 0.2081
Table Open  STORE y to x0.1644
Table Open  x=m.y   0.1326
Table Open  STORE m.y to x  0.0879

No Table Open   STORE y to x0.0870
No Table Open   STORE m.y to x  0.0879
Table Open  STORE m.y to x  0.0879
No Table Open   x=y 0.1320
Table Open  x=m.y   0.1326
No Table Open   x=m.y   0.1328
Table Open  STORE y to x0.1644
Table Open  x=y 0.2081



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul H.
Tarver
Sent: Wednesday, 2 August 2017 6:32 AM
To: profoxt...@leafe.com
Subject: RE: GETFILE() Returns Empty String in Some Cases

That was a really interesting article so I took the example, expanded it to
include an object property and ran the test on my system. 

Here are my results:
-
y=1
nsec=SECONDS()
FOR i = 1 to 100
* x=y   && Results: 0.377
* x=m.y && Results: 0.151
* x=fld255  && Results: 0.328
* x=test.fld255 && Results: 0.201
* x=objSession.nValue   && Results: 0.377
ENDFOR
?SECONDS()-nsec
-

Most of my work is done moving data through temporary cursors and I ALWAYS
reference fields with the table.field method shown in the fourth test. I
also often use object properties to store static variables. While it looks
like I'm getting the best results using table.field access; I'm not getting
any performance advantage using object properties or by not using the m.
prefix. The good news is now I know if I'm going to do a LOT of iterations
with memory variables, there are  some performance gains to be picked up by
simply using the m. notation. I think I may keep these results in mind when
I'm doing refactoring on my function library!

This has been quite the learning experience and I really appreciate Ken for
sharing that article! It also proves that no matter how long you've been
programming in ANY language there is always something new you can pick up.
Thanks!

Paul H. Tarver
Tarver Program Consultants, Inc.
Email: p...@tpcqpc.com 



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken
Dibble
Sent: Tuesday, August 01, 2017 1:30 PM
To: profoxt...@leafe.com
Subject: RE: GETFILE() Returns Empty String in Some Cases

I remember!! It was Calvin Hsia! Here's the blog article:

https://blogs.msdn.microsoft.com/calvin_hsia/2004/12/14/foxpro-performance-t
ip-field-name-lookup-for-tables/

Ken

>On 2017-08-01 10:00, Ken Dibble wrote:
>>A member of the VFP Team (I can't remember his name; he was the guy 
>>who "took out the slow parts" from various subsystems for VFP 8 and 9) 
>>wrote a blog article explaining that without the M. prefix, the system 
>>MUST compare every variable referenced to every field in the current 
>>work area every time the variable is accessed to determine whether the 
>>variable is a field name. He said that if the current work area 
>>contains a large number of fields, and the same variable is used over 
>>a large number of iterations in a tight loop, using the M. prefix 
>>makes a considerable difference in speed. He showed test results to 
>>demonstrate this.
>>I do a LOT of array iteration. So I began using the M. prefix for 
>>variables inside high-iteration tight loops. I noticed a slight speed 
>>increase.
>>However, I find the M. prefix ugly and distracting. I used it 
>>yesterday as a quick fix to demonstrate what the problem was. I will 
>>probably eventually rename the variable.
>>Ken
>
>
>Very interesting...thanks for sharing that!
>
[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/003401d30ca7$333d6650$99b832f0$@ozemail.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.

RE: SET DECIMALS Gotcha

[Darren]

It makes a difference to the calculated value  Only difference between
two functions below is one sets decimal to 2 and other to 16. The 16 version
produces expected results.

? DectoBase36_2(2176782335), DectoBase36(2176782335), "Expecting ZZ"  &&
Returns "10", "ZZ"
? DectoBase36_2(2176782334), DectoBase36(2176782334), "Expecting ZY"  &&
Returns "10", "ZY"

lnVal = 2176782335
SET DECIMALS TO 2
? INT(LOG(m.lnVal) / LOG(36)), "Expecting 5"  && Returns 6

SET DECIMALS TO 16
? INT(LOG(m.lnVal) / LOG(36)), "Expecting 5" && Returns 5


FUNCTION DectoBase36

  LPARAMETERS vnVal
  
  LOCAL lnDecimals, lnPwr, lcString, lnMult, lnInt

  STORE "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ" TO lcValues

  lndecimals = SET("DECIMALS")
  SET DECIMALS TO 16

  lnPwr= INT(LOG(m.vnVal) / LOG(36))
  lcString = ""

  FOR ln = m.lnPwr TO 0 STEP -1

lnMult = 36^m.ln
lnInt  = INT(m.vnVal / m.lnMult)
vnVal  = m.vnVal -(m.lnInt * lnMult)

lcString = m.lcString + SUBSTR(m.lcValues, m.lnInt + 1, 1)

  ENDFOR 

  SET DECIMALS TO m.lndecimals

  RETURN lcString

ENDFUNC

FUNCTION DectoBase36_2

  LPARAMETERS vnVal
  
  LOCAL lnDecimals, lnPwr, lcString, lnMult, lnInt

  STORE "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ" TO lcValues

  lndecimals = SET("DECIMALS")
  SET DECIMALS TO 2

  lnPwr= INT(LOG(m.vnVal) / LOG(36))
  lcString = ""

  FOR ln = m.lnPwr TO 0 STEP -1

lnMult = 36^m.ln
lnInt  = INT(m.vnVal / m.lnMult)
vnVal  = m.vnVal -(m.lnInt * lnMult)

lcString = m.lcString + SUBSTR(m.lcValues, m.lnInt + 1, 1)

  ENDFOR 

  SET DECIMALS TO m.lndecimals

  RETURN lcString

ENDFUNC

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Monday, 31 July 2017 10:05 PM
To: profoxt...@leafe.com
Subject: Re: SET DECIMALS Gotcha

>
>  I have just been bitten by SET DECIMALS.  (Is there really any 
> use for this besides making programming just a bit more difficult?)
>

There may have been, when it was invented in the dBASE days. I believe it
does not affect values, only their display.

>  I have a table with values to four decimal places.  I use 
>   transform(thevalue,"99.")  to create the 
> string representation.  With SET DECIMALS set to its default
> value, a value of 0.0123 is converted to " 0.0100" which loses two
> digits of precision.

What if you multiplied the number by 10^4? Would the precision still be
there, only not displayed?

>  I had this problem with another data item that had more than two 
> decimal places.  I wrote a special function to handle it by setting 
> SET DECIMALS to the number of decimal places I needed, doing the 
> transform(), and setting SET DECIMALS back to the default.

>  Why did I do that?

That is probably the crux of the matter.

> BUT also, because I
> really do not understand the point of SET DECIMALS.
>

Is there someplace you could look it up? A reference guide of some sort?


--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

[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/011f01d309fa$69f69cc0$3de3d640$@ozemail.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.

RE: "An IF | ELSE | ENDIF statement is missing"

[Darren]

Yep I know - but with the && the syntax colouring in the editor makes it a
whole lot easier to read. 

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of AndyHC
Sent: Sunday, 16 July 2017 10:27 PM
To: profoxt...@leafe.com
Subject: Re: "An IF | ELSE | ENDIF statement is missing"

you don't need the comment markers - this works just fine:
x=1
IF x=1
WAIT WINDOW 'true'
ENDIF x=1


Darren wrote:
...
With terminating comments...
> ...
>  IF NOT BETWEEN(HOUR(DATETIME()), 1, 15)  && 01:00:00 to 14:59:59
>
>=messagebox(
>
>  ENDIF && NOT BETWEEN(HOUR(DATETIME()), 1, 15)  && 01:00:00 to
14:59:59
>  
>

[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/011001d2fe30$340dca50$9c295ef0$@ozemail.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.

RE: "An IF | ELSE | ENDIF statement is missing"

[Darren]

No not at all.  Only one place - the function adds the comments so one can
more easily work out what issues with branching and matching keywords. Then
another function magically removes them.  Regular expressions being your
friend in this case.


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene
Wirchenko
Sent: Friday, 14 July 2017 2:42 PM
To: profoxt...@leafe.com
Subject: RE: "An IF | ELSE | ENDIF statement is missing"

At 06:59 2017-07-13, "Darren" <fox...@ozemail.com.au> wrote:
>And another tool I have which helps is to add comments to the end of 
>the terminating commands  - e.g. ENDIF, ENDFOR, ENDDO, EXIT etc. which 
>help to identify the branch / loop.

  I dislike the clutter intensely, and if the condition changes, there
are then two places to change.

[snip]

>... With terminating comments...
>
>   DO WHILE .T.
>
> *- Operate between 1am and 3pm local sydney time
> IF NOT BETWEEN(HOUR(DATETIME()), 1, 15)  && 01:00:00 to 14:59:59
>
>   =messagebox("This function is designed to run between 1am and 
>3pm local time (Sydney)" + CHR(13) + CHR(13) + ;
> "The program will now terminate", 48, "Outside of times of 
>operation", 1)
>
>   EXIT && DO WHILE .T.
>
> ENDIF && NOT BETWEEN(HOUR(DATETIME()), 1, 15)  && 01:00:00 to 
> 14:59:59
>
> SELECT w_bnTrack
> SCAN FOR rssAvailable
>
>   *- Check if this track has runs today.
>   SELECT w_usdRace
>   LOCATE FOR track_code = w_bnTrack.livetkcode
>   IF NOT FOUND()
> SELECT w_bnTrack
> LOOP
>   ENDIF && NOT FOUND()

  If you really need this to keep your nesting straight, you have too
much nesting.

[snip]

Sincerely,

Gene Wirchenko


[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/001601d2fc5b$d53c5490$7fb4fdb0$@ozemail.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.

RE: "An IF | ELSE | ENDIF statement is missing"

[Darren]

I could do that - not right now though - just on midnight here and about to
hit the hay. 

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Thursday, 13 July 2017 11:57 PM
To: profoxt...@leafe.com
Subject: RE: "An IF | ELSE | ENDIF statement is missing"

On 2017-07-13 09:50, Darren wrote:
> I wrote something ages ago to deal with that type of thing. Basically 
> renders to HTML and puts the matched branching statements into div 
> blocks which were collapsible. Made it easy to find the issue.
> 
> Yes been there !!



You should upload that to the ProFox downloads page for the community's
benefit!  ;-)

https://leafe.com/dls/vfp

[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/001c01d2fbe0$bd56bcb0$38043610$@ozemail.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.

RE: "An IF | ELSE | ENDIF statement is missing"

[Darren]

And another tool I have which helps is to add comments to the end of the
terminating commands  - e.g. ENDIF, ENDFOR, ENDDO, EXIT etc. which help to
identify the branch / loop.

Viz.

Without terminating comments...

  DO WHILE .T.
  
*- Operate between 1am and 3pm local sydney time
IF NOT BETWEEN(HOUR(DATETIME()), 1, 15)  && 01:00:00 to 14:59:59
  
  =messagebox("This function is designed to run between 1am and 3pm
local time (Sydney)" + CHR(13) + CHR(13) + ;
"The program will now terminate", 48, "Outside of times of
operation", 1)
  
  EXIT
  
ENDIF

SELECT w_bnTrack
SCAN FOR rssAvailable

  *- Check if this track has runs today. 
  SELECT w_usdRace
  LOCATE FOR track_code = w_bnTrack.livetkcode
  IF NOT FOUND()
SELECT w_bnTrack
LOOP
  ENDIF



... With terminating comments...

  DO WHILE .T.
  
*- Operate between 1am and 3pm local sydney time
IF NOT BETWEEN(HOUR(DATETIME()), 1, 15)  && 01:00:00 to 14:59:59
  
  =messagebox("This function is designed to run between 1am and 3pm
local time (Sydney)" + CHR(13) + CHR(13) + ;
"The program will now terminate", 48, "Outside of times of
operation", 1)
  
  EXIT && DO WHILE .T.
  
ENDIF && NOT BETWEEN(HOUR(DATETIME()), 1, 15)  && 01:00:00 to 14:59:59

SELECT w_bnTrack
SCAN FOR rssAvailable

  *- Check if this track has runs today. 
  SELECT w_usdRace
  LOCATE FOR track_code = w_bnTrack.livetkcode
  IF NOT FOUND()
SELECT w_bnTrack
LOOP
  ENDIF && NOT FOUND()





-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Thursday, 13 July 2017 11:41 PM
To: profoxt...@leafe.com
Subject: "An IF | ELSE | ENDIF statement is missing"

Don't you hate it when you have a super long one-time conversion program,
add some new 1-time crap over time, and then all of the sudden when ready to
run you get this error message, AND CAN'T SEE WHERE THIS MISSING/ERRANT
STRUCTURE IS?

I'd be surprised if we haven't all been there at some point in our dev
lives.

It pays to take the time and do good modular design instead of this
way-too-long PRG run on crap.  hahaha


[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/001801d2fbe0$3ecd3e50$bc67baf0$@ozemail.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.

RE: "An IF | ELSE | ENDIF statement is missing"

[Darren]

I wrote something ages ago to deal with that type of thing. Basically
renders to HTML and puts the matched branching statements into div blocks
which were collapsible. Made it easy to find the issue. 

Yes been there !!

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Thursday, 13 July 2017 11:41 PM
To: profoxt...@leafe.com
Subject: "An IF | ELSE | ENDIF statement is missing"

Don't you hate it when you have a super long one-time conversion program,
add some new 1-time crap over time, and then all of the sudden when ready to
run you get this error message, AND CAN'T SEE WHERE THIS MISSING/ERRANT
STRUCTURE IS?

I'd be surprised if we haven't all been there at some point in our dev
lives.

It pays to take the time and do good modular design instead of this
way-too-long PRG run on crap.  hahaha


[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/001501d2fbdf$0b673e40$2235bac0$@ozemail.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.

RE: web Ticket system online (FoxInCloud?)

[Darren]

Another option ... 
https://freshdesk.com/


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Thursday, 22 June 2017 12:31 PM
To: profoxt...@leafe.com
Subject: Re: web Ticket system online (FoxInCloud?)

On 2017-06-21 17:08, Alan Bourke wrote:
> Surely unless this has particular niche requirements it is a problem 
> that has been comprehensively solved already  by existing  cloud 
> services like Zendesk?


Yeah, that's my thought too.  Surely this already exists (and is
affordable).  I had forgotten about Spiceworks.  Will check out that and
ZenDesk too.  Thanks!

[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/008201d2eb00$963ea160$c2bbe420$@ozemail.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.

RE: For the Fox developer

[Darren]

Awesome !!

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ed Leafe
Sent: Monday, 19 June 2017 1:56 AM
To: profoxt...@leafe.com
Subject: For the Fox developer

Gotta start your day off the right way, with plenty of hot coffee in this
mug: https://goo.gl/w2DAsf


-- Ed Leafe







--- StripMime Report -- processed MIME parts --- multipart/signed
  text/plain (text body -- kept)
  application/pgp-signature
---

[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/001b01d2e85a$aebfed00$0c3fc700$@ozemail.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.

RE: How to tell between Win8 and Win10 using Fox commands?

[Darren]

The plot thickens ...

https://msdn.microsoft.com/en-us/library/windows/desktop/ms724439(v=vs.85).a
spx

>From that link ...

With the release of Windows 8.1, the behavior of the GetVersion API has
changed in the value it will return for the operating system version. The
value returned by the GetVersion function now depends on how the application
is manifested.

https://msdn.microsoft.com/en-us/library/windows/desktop/ms724429(v=vs.85).a
spx

To obtain the full version number for the operating system, call the
GetFileVersionInfo function on one of the system DLLs, such as Kernel32.dll,
then call VerQueryValue to obtain the
\\StringFileInfoProductVersion subblock of the file
version information.

>From that I tried 

oFSO = CREATEOBJECT("scripting.filesystemobject")
? oFso.GetFileVersion("C:\Windows\System32\kernel32.Dll")

On Win 7 Ultimate x64 machine I get  "6.1.7601.19018" returned.

VFP :   OS(3)  6  | OS(4)  1 |  OS(5)  7601   so seems to line up fairly
well.

Give it a go on WIN 10 - be interested to see if  it works.



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Wednesday, 24 May 2017 3:38 PM
To: profoxt...@leafe.com
Subject: RE: How to tell between Win8 and Win10 using Fox commands?

On 2017-05-23 20:05, Darren wrote:
> I don't have Windows 10 but try this ...
> http://www.news2news.com/vfp/?example=22=29
> 
> Be good to know if that works OK on 10 also - don't see why it 
> shouldn't.


Yes but it looks as though 8 and 10 are reporting the same per the Fox Wiki.
I'll try your link Thursday and report back.

[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/015401d2d461$04892a20$0d9b7e60$@ozemail.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.

RE: How to tell between Win8 and Win10 using Fox commands?

[Darren]

I don't have Windows 10 but try this ...
http://www.news2news.com/vfp/?example=22=29

Be good to know if that works OK on 10 also - don't see why it shouldn't.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Wednesday, 24 May 2017 8:16 AM
To: profoxt...@leafe.com
Subject: How to tell between Win8 and Win10 using Fox commands?

I'm tracking the operating system used by my app.  According to
http://fox.wikis.com/wc.dll?Wiki~VFPFunctionOS~Wiki, it looks like you can't
tell between Windows 8 and Windows 10.

Ideas???  tia!
--Mike


[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/009601d2d421$7ea641c0$7bf2c540$@ozemail.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.

RE: Running Multiple Instances of VFP 9

[Darren]

It is a great feature for doing multiuser testing.  Run multiple instances
on same machine - functionally (for most purposes) the same as multiple
users hitting same data.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt at
VR-FX
Sent: Saturday, 13 May 2017 6:00 AM
To: profoxt...@leafe.com
Subject: Re: Running Multiple Instances of VFP 9

Darren - Exactly.

Paul - as RK said - and I do it ALL the Time - actually - right now I have 2
instances open.

For the Hell of it - try this.

Go to the Windows Start menu - find VFP - right click on it and Run as Admin
- and see if THAT allows for another VFP session to run! The only reason I
know about the Admin option is because Projects I have to compile - that
have VCX's in them - they REQUIRE me to run VFP in Admin mode...

-K-


On 5/12/2017 3:33 PM, Darren wrote:
> One limitation is you can't modify the same project in different instances
> of VFP dev environment simultaneously. VFP opens project excl.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
Richard
> Kaye
> Sent: Saturday, 13 May 2017 5:21 AM
> To: profoxt...@leafe.com
> Subject: RE: Running Multiple Instances of VFP 9
>
> Sure. I do it all the time. It should just work unless you have your
> environment setup with some dependencies on exclusive access.
>
> --
>
> rk
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul
H.
> Tarver
> Sent: Friday, May 12, 2017 3:19 PM
> To: profoxt...@leafe.com
> Subject: Running Multiple Instances of VFP 9
>
> Does anyone know if there is a way to run multiple instances of the VFP
> development environment on the same computer. I run into this need from
time
> to time, but I've not taken a lot of time to research it.
>
> I know I can run multiple instances of a compiled VFP program, but every
> time I try to open multiple VFP projects, it simply brings the existing
dev
> window forward and opens each project within the same development
> environment.
>
> Short of running virtual machines, is this even possible?
>
> Paul H. Tarver
> Tarver Program Consultants, Inc.
>   <mailto:p...@tpcqpc.com> p...@tpcqpc.com
>
[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/003701d2cb5e$8fb369f0$af1a3dd0$@ozemail.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.

RE: Running Multiple Instances of VFP 9

[Darren]

One limitation is you can't modify the same project in different instances
of VFP dev environment simultaneously. VFP opens project excl.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Saturday, 13 May 2017 5:21 AM
To: profoxt...@leafe.com
Subject: RE: Running Multiple Instances of VFP 9

Sure. I do it all the time. It should just work unless you have your
environment setup with some dependencies on exclusive access.

--

rk

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul H.
Tarver
Sent: Friday, May 12, 2017 3:19 PM
To: profoxt...@leafe.com
Subject: Running Multiple Instances of VFP 9

Does anyone know if there is a way to run multiple instances of the VFP
development environment on the same computer. I run into this need from time
to time, but I've not taken a lot of time to research it. 

I know I can run multiple instances of a compiled VFP program, but every
time I try to open multiple VFP projects, it simply brings the existing dev
window forward and opens each project within the same development
environment.

Short of running virtual machines, is this even possible?

Paul H. Tarver
Tarver Program Consultants, Inc. 
  p...@tpcqpc.com

[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/003301d2cb56$a18a5830$e49f0890$@ozemail.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.

RE: [NF] Friday Afternoon Discussion: Passwords

[Darren]

Now it's me, O'Reilly, and the NIST +2

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of AndyHC
Sent: Saturday, 6 May 2017 4:44 PM
To: profoxt...@leafe.com
Subject: Re: [NF] Friday Afternoon Discussion: Passwords

On 05-May-17 11:35 PM, Ken Dibble wrote:
> Now it's me, O'Reilly, and the NIST
Now it's me, O'Reilly, and the NIST +1

[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/00e401d2c640$a4ee8f70$eecbae50$@ozemail.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.

RE: Reading & Extracting Data From PDF Files

[Darren]

It's all that font data and positional information that cause the grief.  I
have spent a fair bit of time on PDF's with varying degrees of success.
Comes down to how they were created in the first place. I have always found
that I can consistently retrieve data from PDFs created by any given source
but the rules applied to that PDF do not transport well to other PDF's.

There are a lot of PDFTOTEXT type tools out there. Those that I have
explored mostly do a "pretty good job" of extracting text but none is
perfect and all require varying degrees of manipulation post conversion to
extract the data.

None have proven consistent in extracting the text and retaining layout
(insofar as layout can be retained between different fonts).

All that said I still think it should be possible to take the positional
data and font metrics and resolve that such that text is extracted and
layout retained. Not a simple exercise but for an entity focused on the task
achievable (I would have thought).

In the end though - if you can avoid them - then that is best approach.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Sunday, 30 April 2017 6:39 AM
To: profoxt...@leafe.com
Subject: Re: Reading & Extracting Data From PDF Files

In my limited experience, PDF is trouble. PDF is essential a printer output
file, in PostScript, encapsulated as document. There's lots of info about
fonts, geometry and there are letters placed in specific places, not
necessarily in the order you think, depending on the application that
generated the print image, and the printer drivers used. It doesn't help
that there are lots of different PDF standards ("I love standards, that's
why I have so many!") and extensions to do things like provide
accessiblility or to slim it down for web and visual presentation (vs.
High-resolution for print pre-press).

Recently, I was trying to copy one of my articles out of a PDF, and I found
that the two snaked columns that appeared to you and me meant nothing to the
PDF. Highlighting the text got line one of column one, then line one of
column two, all the way down. Pretty frustrating.

There are some smart applications out there. Monarch was advertised years
ago

Here's an SO question, with some possiblities:


On Fri, Apr 28, 2017 at 11:19 AM, Paul H. Tarver  wrote:
> Original Thread: Getting count of rows in a text file -- best approach?
>
> A couple of times I've heard people mention reading in PDF files using 
> FileToStr and I want to know more about reading and extracting data 
> from PDF files. I do a lot of data conversion and interface work with 
> lots of file formats, but I've not been very successful at importing 
> and extracting data from PDF reports. Obviously a scanned image saved 
> as a PDF would have to be ocr'd first, but is there is a reliable way 
> to extract data from PDF reports and if so, how? I'm sure I don't know 
> all the ends and outs of the PDF format, but when I try, I seem to get 
> a strange mix of formatting details and data combined in a random way.
>
> Am I being thick here or is there really a way that I can get any PDF 
> file from any client and then successfully extract the data elements 
> from that format?
>
> I'm prepared to be thought of as stupid but be gentle! :)
>
> Paul H. Tarver
> Tarver Program Consultants, Inc.
> Email: p...@tpcqpc.com
>
>
>
> -Original Message-
> From: Brant E. Layton [mailto:d...@futureone.com]
> Sent: Wednesday, April 26, 2017 3:17 PM
> To: profoxt...@leafe.com
> Subject: RE: Getting count of rows in a text file -- best approach?
>
> |My experience was moving PDF files in and out of SQLServer tables - 
> |found an
> abrupt truncation at the 16,777,184 mark...
>
> Brant Layton|
> |480.964.1316|
> On 4/26/2017 12:57 PM, profoxtech-requ...@leafe.com wrote:
>> RE: Getting count of rows in a text file -- best approach?
>
>
>
> --- 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/008201d2c130$b0742b80$115c8280$@ozemail.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.

RE: Getting count of rows in a text file -- best approach?

[Darren]

Laurie

For me my goto has been C++ and FLL whenever I want something more performant 
and I have always been a huge fan using the Windows API and all it has to offer 
as well as other extensions that the fox is so good at consuming. 

Recently I have been getting more familiar with .NET (and I do like it to be 
honest) so I thought  here's an opportunity to do something quickly using the 
resources and .NET and work out how to get that to work with VFP. So for me it 
wasn’t about counting lines but rather about how to get to use .NET in VFP (and 
I am aware of things like wwwDotNetBridge but I wanted to get a bit of a more 
in depth understanding of what is going on, hence the approach I took.)

I think the original post was to ascertain the best way to do it with large 
files. It grew from there.

Cheers





-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Laurie Alvey
Sent: Saturday, 29 April 2017 8:51 PM
To: profoxt...@leafe.com
Subject: Re: Getting count of rows in a text file -- best approach?

Hi All,

This is all very ingenious, but I am curious to know why you would want to know 
the number of lines.

Laurie

On 29 April 2017 at 01:20, Darren <fox...@ozemail.com.au> wrote:

> Gianni
>
> The approach I took for .NET was ...  (And this is the first time I 
> have done this so was a bit of a learning exercise) Again   very 
> likely better ways to achieve this.
>
> Create a .NET DLL and use in VFP.
>
> Primary reference here:  http://www.tek-tips.com/faqs.cfm?fid=3836  
> (bit out of date)
>
> 1.  Using Visual Studio .NET create a C# Class Library project – named
> Utilities
> 2.  Add reference to “System.EnterpriseServices”
> 3.  Code the Class e.g.
> using System;
> using System.Text;
> using System.Linq;
> using System.Runtime.InteropServices;
> using System.Collections.Generic;
> using System.Threading.Tasks;
>
> namespace Utilities {
> public class FileInfo :  System.EnterpriseServices.ServicedComponent {
> public Int32 LineCount(String FilePath)
> {
> int count = System.IO.File.ReadLines(FilePath).Count() ;
> return count;
> }
> }
> }
>
> 4.  Create key pair (To sign the assembly).  In my case I used (from
> an Admin command window):
>
> CD “c:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin>”
> sn -k Utilities.SNK
>
> Returned:
>
> Microsoft (R) .NET Framework Strong Name Utility  Version 3.5.30729.1 
> Copyright (c) Microsoft Corporation.  All rights reserved.
>
> Key pair written to Utilities.SNK
>
> 5.  Copy the SNK file to the DLL build directory.
>
> 6.  Edit Assembly.cs file.
>
> Change the entry [assembly: ComVisible(false)] to [assembly:
> ComVisible(true)]
>
> Ignore the [assembly: AssemblyKeyFile("")] step in Craig’s tip.  
> Instead add the SNK file in the “Signing” section per step 7.
> 7.  Under properties of the project select “Signing”
> •   Check “Sign the assembly”
> •   Type in the “Key File name:” in this case Utilities.SNK
> •   I de-selected “Protect my key file with a password” – too many to
> remember already.
> 8.  Build the Solution in Visual Studio
>
> 9.  Register the assembly. (from Admin command prompt)
>
> CD “C:\Windows\Microsoft.NET\Framework\v4.0.30319”
> regasm.exe 
> D:\VFP9\apps\c#\Utilities\Utilities\bin\Release\Utilities.dll
> /tlb /nologo /codebase
>
> Returned:
> Types registered successfully
> Assembly exported to 'D:\VFP9\apps\c#\Utilities\Utilities\bin\Release\
> Utilities.tlb’,
> and the type library was registered successfully
>
> C:\Windows\Microsoft.NET\Framework\v4.0.30319>
>
> 10. Then to use it in VFP ..
>
> oUtil = CREATEOBJECT("Utilities.FileInfo")
> nLines = oUtil.LineCount()
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
> Gianni Turri
> Sent: Saturday, 29 April 2017 2:24 AM
> To: profoxt...@leafe.com
> Subject: Re: Getting count of rows in a text file -- best approach?
>
> Test file of 1.67 GB correctly managed by FSO but not by VFP9 SP2 that 
> gives Error 43 (There is not enough memory to complete this operation).
>
> Test file of 5.31 GB correctly managed by FSO but not by VFP9 SP2 that 
> gives Error 1103 (Invalid seek offset).
>
> FSO method counts chr(10) / LF characters.
>
> alines() by default counts the occurrences of chr(10) plus the 
> occurrences of chr(13) minus the occurrences of chr(13) + chr(10)
>
> Please tell us more about the FLL and the code you used!
>
> Gianni
>
> On Sat, 29 Apr 2017 01:15:06 +1000, "Darren" <fox...@ozemail.com.au>
> 

RE: Getting count of rows in a text file -- best approach?

[Darren]

Gianni

The approach I took for .NET was ...  (And this is the first time I have done 
this so was a bit of a learning exercise) Again   very likely better ways 
to achieve this.

Create a .NET DLL and use in VFP.
 
Primary reference here:  http://www.tek-tips.com/faqs.cfm?fid=3836  (bit out of 
date)
 
1.  Using Visual Studio .NET create a C# Class Library project – named 
Utilities
2.  Add reference to “System.EnterpriseServices”  
3.  Code the Class e.g.
using System;
using System.Text;
using System.Linq;
using System.Runtime.InteropServices;
using System.Collections.Generic;
using System.Threading.Tasks;
 
namespace Utilities {
public class FileInfo :  System.EnterpriseServices.ServicedComponent {
public Int32 LineCount(String FilePath)
{
int count = System.IO.File.ReadLines(FilePath).Count() ;
return count;
}
}
}  
 
4.  Create key pair (To sign the assembly).  In my case I used (from an 
Admin command window): 
 
CD “c:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin>”
sn -k Utilities.SNK
 
Returned:
 
Microsoft (R) .NET Framework Strong Name Utility  Version 3.5.30729.1
Copyright (c) Microsoft Corporation.  All rights reserved.
 
Key pair written to Utilities.SNK
 
5.  Copy the SNK file to the DLL build directory.
 
6.  Edit Assembly.cs file. 
 
Change the entry [assembly: ComVisible(false)] to [assembly: ComVisible(true)]
 
Ignore the [assembly: AssemblyKeyFile("")] step in Craig’s tip.  Instead add 
the SNK file in the “Signing” section per step 7.   
7.  Under properties of the project select “Signing”
•   Check “Sign the assembly”
•   Type in the “Key File name:” in this case Utilities.SNK
•   I de-selected “Protect my key file with a password” – too many to 
remember already.
8.  Build the Solution in Visual Studio
 
9.  Register the assembly. (from Admin command prompt)
 
CD “C:\Windows\Microsoft.NET\Framework\v4.0.30319”
regasm.exe D:\VFP9\apps\c#\Utilities\Utilities\bin\Release\Utilities.dll /tlb 
/nologo /codebase
 
Returned:
Types registered successfully
Assembly exported to 
'D:\VFP9\apps\c#\Utilities\Utilities\bin\Release\Utilities.tlb’, 
and the type library was registered successfully
 
C:\Windows\Microsoft.NET\Framework\v4.0.30319>
 
10. Then to use it in VFP ..
 
oUtil = CREATEOBJECT("Utilities.FileInfo")
nLines = oUtil.LineCount()

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gianni Turri
Sent: Saturday, 29 April 2017 2:24 AM
To: profoxt...@leafe.com
Subject: Re: Getting count of rows in a text file -- best approach?

Test file of 1.67 GB correctly managed by FSO but not by VFP9 SP2 that gives 
Error 43 (There is not enough memory to complete this operation).

Test file of 5.31 GB correctly managed by FSO but not by VFP9 SP2 that gives 
Error 1103 (Invalid seek offset).

FSO method counts chr(10) / LF characters.

alines() by default counts the occurrences of chr(10) plus the occurrences of 
chr(13) minus the occurrences of chr(13) + chr(10)

Please tell us more about the FLL and the code you used!

Gianni

On Sat, 29 Apr 2017 01:15:06 +1000, "Darren" <fox...@ozemail.com.au> wrote:

Many ways to do this.  I've compared 3.

With a text file 350Mb | 5.3Million lines . Each method reported same # of 
lines.

Timing done with high resolution timers so reasonably accurate. ...

1. C++ FLL  0.4064 seconds  
2. C# .NET  1.2779 seconds :  Tip on how to do this is at 
http://www.tek-tips.com/faqs.cfm?fid=3836
3. FSO  7.3874 seconds :  (using OpenTextFile etc.)

With a text file 2.6GB file. |  42 Million lines.  FSO died - reported no lines 
and finished in 0.0002 seconds - other two methods reported accurately.

1. C++ FLL  3.2426 seconds  
2. C# .NET  10.0600 seconds
3. FSO  0.0002 seconds :  FAILED 

So I'd guess if you are doing many of these and time is an issue then perhaps a 
FLL approach might be beneficial.  Certainly if file is large enough (probably 
hits the 2Gb limit in VFP) then FSO is not an option.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gianni Turri
Sent: Friday, 28 April 2017 11:39 PM
To: profoxt...@leafe.com
Subject: Re: Getting count of rows in a text file -- best approach?

Ok.

Anyway this is the slower method:

loFSO = createobject("Scripting.FileSystemObject")

loFile = loFSO.OpenTextFile(m.filename, 1)

do while ! loFile.AtEndOfStream()
loFile.SkipLine()
enddo

? loFile.Line -1

Gianni

On Fri, 28 Apr 2017 15:29:48 +0200, "Fernando D. Bozzo" <fdbo...@gmail.com> 
wrote:

>Forget my comment, I've tested it and works beautifully :)
>
>2017-04-28 15:24 GMT+02:00 Fernando D. Bozzo <fdbo...@gmail.com>:
>
>> Gianni, you skipped something very important, the part that skip the 
>> lines so the Line property is upda

RE: Getting count of rows in a text file -- best approach?

[Darren]

Sure

 

The FLL ... code is below.  (And I am in no way fluent with C++ or FLL's so
may be much better ways ..)  

 

You 'll need a few other components but if you chase up how to create an FLL
then you'll have it sorted.

 

Once below is built into FLL it can be used directly in VFP.

Viz. SET library to ". fll"   |   lnLines =
FllGetFileLineCount()

 

 

void GetFileLineCount(ParamBlk *parm)

 

{

   

   #define p0 (parm->p[0].val) 

 

   ((char *)_HandToPtr(p0.ev_handle))[p0.ev_length] = '\0';

   

   char *srcFileName = (char *)_HandToPtr(p0.ev_handle) ; 

 

FILE *istream = fopen(srcFileName, "rb");

   

if (istream == 0)

   {

  _RetInt(-1, 10);

   }

   

int numLines = 0;

   

const int len = 8192;

 

char buf[8192];

   

do

 

{

 

if( feof(istream))

  {

 break;

  }

 

int nBytesRead = fread(buf, 1, len, istream);

 

if(nBytesRead <= 0)

  {

  break;

  }

 

  for(int i = 0; i < nBytesRead; i++)

  {

if(buf[i] == '\n')

  numLines++;

   }

   

} while(1);

 

fclose(istream);

 

   _RetInt(numLines, 10);



}

 

FoxInfo vfpUtilFLLInfo[] = 

{

   {"FllGetFileLineCount",  (FPFI) GetFileLineCount, 1, "C"}

};

 

 

#ifdef __cplusplus

extern "C"

#endif

   FoxTable _FoxTable = {

  (FoxTable *)0, sizeof(vfpUtilFLLInfo)/sizeof(FoxInfo),
vfpUtilFLLInfo

};

 

 

 

 

 

 

 

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gianni
Turri
Sent: Saturday, 29 April 2017 2:24 AM
To: profoxt...@leafe.com
Subject: Re: Getting count of rows in a text file -- best approach?

 

Test file of 1.67 GB correctly managed by FSO but not by VFP9 SP2 that gives
Error 43 (There is not enough memory to complete this operation).

 

Test file of 5.31 GB correctly managed by FSO but not by VFP9 SP2 that gives
Error 1103 (Invalid seek offset).

 

FSO method counts chr(10) / LF characters.

 

alines() by default counts the occurrences of chr(10) plus the occurrences
of chr(13) minus the occurrences of chr(13) + chr(10)

 

Please tell us more about the FLL and the code you used!

 

Gianni

 

On Sat, 29 Apr 2017 01:15:06 +1000, "Darren" <
<mailto:fox...@ozemail.com.au> fox...@ozemail.com.au> wrote:

 

Many ways to do this.  I've compared 3.

 

With a text file 350Mb | 5.3Million lines . Each method reported same # of
lines.

 

Timing done with high resolution timers so reasonably accurate. ...

 

1. C++ FLL0.4064 seconds  

2. C# .NET1.2779 seconds :  Tip on how to do this is at
<http://www.tek-tips.com/faqs.cfm?fid=3836>
http://www.tek-tips.com/faqs.cfm?fid=3836

3. FSO  7.3874 seconds :  (using OpenTextFile etc.)

 

With a text file 2.6GB file. |  42 Million lines.  FSO died - reported no
lines and finished in 0.0002 seconds - other two methods reported
accurately.

 

1. C++ FLL3.2426 seconds  

2. C# .NET10.0600 seconds

3. FSO  0.0002 seconds :  FAILED 

 

So I'd guess if you are doing many of these and time is an issue then
perhaps a FLL approach might be beneficial.  Certainly if file is large
enough (probably hits the 2Gb limit in VFP) then FSO is not an option.

 

-Original Message-

From: ProfoxTech [ <mailto:profoxtech-boun...@leafe.com>
mailto:profoxtech-boun...@leafe.com] On Behalf Of Gianni Turri

Sent: Friday, 28 April 2017 11:39 PM

To:  <mailto:profoxt...@leafe.com> profoxt...@leafe.com

Subject: Re: Getting count of rows in a text file -- best approach?

 

Ok.

 

Anyway this is the slower method:

 

loFSO = createobject("Scripting.FileSystemObject")

 

loFile = loFSO.OpenTextFile(m.filename, 1)

 

do while ! loFile.AtEndOfStream()

loFile.SkipLine()

enddo

 

? loFile.Line -1

 

Gianni

 

On Fri, 28 Apr 2017 15:29:48 +0200, "Fernando D. Bozzo" <
<mailto:fdbo...@gmail.com> fdbo...@gmail.com> wrote:

 

>Forget my comment, I've tested it and works beautifully :)

> 

>2017-04-28 15:24 GMT+02:00 Fernando D. Bozzo < <mailto:fdbo...@gmail.com>
fdbo...@gmail.com>:

> 

>> Gianni, you skipped something very important, the part that skip the 

>> lines so the Line property is updated:

>> 

>> 'Skip lines one by one Do While txsInput.AtEndOfStream <> True

>> txsInput.SkipLine ' or strTemp = txsInput.ReadLineLoop

>> 

>> 2017-04-28 15:08 GMT+02:00 Gianni Turri < <mailto:gianni...@gmail.com>
gianni...@gmail.com>:

>> 

>>> On Thu, 27 Apr 2017 17:12:49 +0200, "Fernando D. Bozzo" < 

>>>

RE: Getting count of rows in a text file -- best approach?

[Darren]

Update to below.

Using FSO doesn't crash - I missed the parameters  ...  8,.F.)  but it is
somewhat slower.  

59.3775 seconds using the OpenTextFile(, 8, .F.)  approach and
164.4686 seconds using the AtEndOfStream() | SkipLine approach. 

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Darren
Sent: Saturday, 29 April 2017 1:15 AM
To: profoxt...@leafe.com
Subject: RE: Getting count of rows in a text file -- best approach?

Many ways to do this.  I've compared 3.

With a text file 350Mb | 5.3Million lines . Each method reported same # of
lines.

Timing done with high resolution timers so reasonably accurate. ...

1. C++ FLL  0.4064 seconds  
2. C# .NET  1.2779 seconds :  Tip on how to do this is at
http://www.tek-tips.com/faqs.cfm?fid=3836
3. FSO  7.3874 seconds :  (using OpenTextFile etc.)

With a text file 2.6GB file. |  42 Million lines.  FSO died - reported no
lines and finished in 0.0002 seconds - other two methods reported
accurately.

1. C++ FLL  3.2426 seconds  
2. C# .NET  10.0600 seconds
3. FSO  0.0002 seconds :  FAILED 

So I'd guess if you are doing many of these and time is an issue then
perhaps a FLL approach might be beneficial.  Certainly if file is large
enough (probably hits the 2Gb limit in VFP) then FSO is not an option.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gianni
Turri
Sent: Friday, 28 April 2017 11:39 PM
To: profoxt...@leafe.com
Subject: Re: Getting count of rows in a text file -- best approach?

Ok.

Anyway this is the slower method:

loFSO = createobject("Scripting.FileSystemObject")

loFile = loFSO.OpenTextFile(m.filename, 1)

do while ! loFile.AtEndOfStream()
loFile.SkipLine()
enddo

? loFile.Line -1

Gianni

On Fri, 28 Apr 2017 15:29:48 +0200, "Fernando D. Bozzo" <fdbo...@gmail.com>
wrote:

>Forget my comment, I've tested it and works beautifully :)
>
>2017-04-28 15:24 GMT+02:00 Fernando D. Bozzo <fdbo...@gmail.com>:
>
>> Gianni, you skipped something very important, the part that skip the 
>> lines so the Line property is updated:
>>
>> 'Skip lines one by one Do While txsInput.AtEndOfStream <> True
>> txsInput.SkipLine ' or strTemp = txsInput.ReadLineLoop
>>
>> 2017-04-28 15:08 GMT+02:00 Gianni Turri <gianni...@gmail.com>:
>>
>>> On Thu, 27 Apr 2017 17:12:49 +0200, "Fernando D. Bozzo" < 
>>> fdbo...@gmail.com> wrote:
>>>
>>> >Hi Mike:
>>> >
>>> >A very fast method is using the FileSystemObject:
>>> >
>>> >loFSO = CREATEOBJECT("Scripting.FileSystemObject")
>>> >loFile1 = loFSO.OpenTextFile(lcArchivo1, 1)
>>> >
>>> >Look at the syntax on Microsoft web site for the read method.
>>> >It does not have the limitation of VFP's fread/fgets
>>>
>>> loFSO = createobject("Scripting.FileSystemObject")
>>>
>>> loFile = loFSO.OpenTextFile(m.filename, 8, .f.) ? loFile.Line -1
>>>
>>> This method overcome VFP memory / file size limits.
>>>
>>> Source:
>>> http://stackoverflow.com/questions/7416553/function-to-count-number-
>>> of-lines-in-a-text-file

[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/002a01d2c038$01e76850$05b638f0$@ozemail.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.

RE: Reading & Extracting Data From PDF Files

[Darren]

I too would be keen to know of a "Reliable" way to get text etc. out of a
PDF file. I'd have to think that it stands to reason the thing appears
formatted so have to wonder how hard it can be. To date my experience has
been poor at best so I'm with you Paul. I have had some limited luck with a
couple do the PDF to Text offerings out there. Another that I found produced
pretty good results is the utility that comes with Beyond compare - can't
think of the name of it ATM but it hides in one of the BC directories.

If there was a good reliable solution I'd be happy to part with a good sum
for it as it would be of great use.  

A reasonably priced tool to convert RTF would be handy as well.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul H.
Tarver
Sent: Saturday, 29 April 2017 1:19 AM
To: profoxt...@leafe.com
Subject: Reading & Extracting Data From PDF Files

Original Thread: Getting count of rows in a text file -- best approach?

A couple of times I've heard people mention reading in PDF files using
FileToStr and I want to know more about reading and extracting data from PDF
files. I do a lot of data conversion and interface work with lots of file
formats, but I've not been very successful at importing and extracting data
from PDF reports. Obviously a scanned image saved as a PDF would have to be
ocr'd first, but is there is a reliable way to extract data from PDF reports
and if so, how? I'm sure I don't know all the ends and outs of the PDF
format, but when I try, I seem to get a strange mix of formatting details
and data combined in a random way. 

Am I being thick here or is there really a way that I can get any PDF file
from any client and then successfully extract the data elements from that
format? 

I'm prepared to be thought of as stupid but be gentle! :)

Paul H. Tarver
Tarver Program Consultants, Inc.
Email: p...@tpcqpc.com 



-Original Message-
From: Brant E. Layton [mailto:d...@futureone.com]
Sent: Wednesday, April 26, 2017 3:17 PM
To: profoxt...@leafe.com
Subject: RE: Getting count of rows in a text file -- best approach?

|My experience was moving PDF files in and out of SQLServer tables - 
|found an
abrupt truncation at the 16,777,184 mark...

Brant Layton|
|480.964.1316|
On 4/26/2017 12:57 PM, profoxtech-requ...@leafe.com wrote:
> RE: Getting count of rows in a text file -- best approach?



--- 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/002601d2c035$d45f9800$7d1ec800$@ozemail.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.

RE: Getting count of rows in a text file -- best approach?

[Darren]

Many ways to do this.  I've compared 3.

With a text file 350Mb | 5.3Million lines . Each method reported same # of
lines.

Timing done with high resolution timers so reasonably accurate. ...

1. C++ FLL  0.4064 seconds  
2. C# .NET  1.2779 seconds :  Tip on how to do this is at
http://www.tek-tips.com/faqs.cfm?fid=3836
3. FSO  7.3874 seconds :  (using OpenTextFile etc.)

With a text file 2.6GB file. |  42 Million lines.  FSO died - reported no
lines and finished in 0.0002 seconds - other two methods reported
accurately.

1. C++ FLL  3.2426 seconds  
2. C# .NET  10.0600 seconds
3. FSO  0.0002 seconds :  FAILED 

So I'd guess if you are doing many of these and time is an issue then
perhaps a FLL approach might be beneficial.  Certainly if file is large
enough (probably hits the 2Gb limit in VFP) then FSO is not an option.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gianni
Turri
Sent: Friday, 28 April 2017 11:39 PM
To: profoxt...@leafe.com
Subject: Re: Getting count of rows in a text file -- best approach?

Ok.

Anyway this is the slower method:

loFSO = createobject("Scripting.FileSystemObject")

loFile = loFSO.OpenTextFile(m.filename, 1)

do while ! loFile.AtEndOfStream()
loFile.SkipLine()
enddo

? loFile.Line -1

Gianni

On Fri, 28 Apr 2017 15:29:48 +0200, "Fernando D. Bozzo" 
wrote:

>Forget my comment, I've tested it and works beautifully :)
>
>2017-04-28 15:24 GMT+02:00 Fernando D. Bozzo :
>
>> Gianni, you skipped something very important, the part that skip the 
>> lines so the Line property is updated:
>>
>> 'Skip lines one by one Do While txsInput.AtEndOfStream <> True
>> txsInput.SkipLine ' or strTemp = txsInput.ReadLineLoop
>>
>> 2017-04-28 15:08 GMT+02:00 Gianni Turri :
>>
>>> On Thu, 27 Apr 2017 17:12:49 +0200, "Fernando D. Bozzo" < 
>>> fdbo...@gmail.com> wrote:
>>>
>>> >Hi Mike:
>>> >
>>> >A very fast method is using the FileSystemObject:
>>> >
>>> >loFSO = CREATEOBJECT("Scripting.FileSystemObject")
>>> >loFile1 = loFSO.OpenTextFile(lcArchivo1, 1)
>>> >
>>> >Look at the syntax on Microsoft web site for the read method.
>>> >It does not have the limitation of VFP's fread/fgets
>>>
>>> loFSO = createobject("Scripting.FileSystemObject")
>>>
>>> loFile = loFSO.OpenTextFile(m.filename, 8, .f.) ? loFile.Line -1
>>>
>>> This method overcome VFP memory / file size limits.
>>>
>>> Source:
>>> http://stackoverflow.com/questions/7416553/function-to-count-number-
>>> of-lines-in-a-text-file

[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/002501d2c032$3900feb0$ab02fc10$@ozemail.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.

RE: Easy way to get UNC from drive mapping?

[Darren]

This might be of use ... 

Note:  The variable "rcUncFileName" is the mapped drive path .. goes into
the GetUncPath function and is returned by reference as the UNC path for
that mapped name - hence the name seems odd.

 DECLARE INTEGER WNetGetConnection IN WIN32API ;
STRING  @lpLocalPath,  ;
STRING  @lpBuffer,  ;
INTEGER @lpBufferSize


*- Returns -1 if fails.
lnStatus = getuncpath(@rcUncFileName)



GetUNCPath ...

LPARAMETERS rcmappedpath, vnbuffersize

* set up some variables so the appropriate call can be made
LOCAL lclocalpath, lcbuffer, lnbuffersize, lnresult, lcstructurestring,
lcreturnvalue
LOCAL lcdrive, lcpath, lcMachinename

STORE -1 TO lnResult
STORE "" TO lclocalpath, lcbuffer, lnbuffersize, lnresult,
lcstructurestring, lcreturnvalue, lcdrive, lcpath

IF VARTYPE(m.rcmappedpath) = "C"

* split up the passed path to get just the drive
* just take the first two characters - we'll put it all back
together later. If the first two characters
* are not a valid drive, that's OK. The error value returned from
the function call will handle it.
* case statement ensures we don't get the "cannot access beyond end
of string" error
DO CASE
  CASE LEN(m.rcmappedpath) > 2
lcdrive = LEFT(m.rcmappedpath, 2)
lcpath  = SUBSTR(m.rcmappedpath, 3)
  CASE LEN(m.rcmappedpath) <= 2
lcdrive = m.rcmappedpath
lcpath = ""
ENDCASE

* set to +1 to allow for the null terminator
lnbuffersize = IIF(VARTYPE(m.vnBufferSize) = "N", m.vnbuffersize,
500) + 1
lclocalpath  = m.lcdrive
lcbuffer = SPACE(m.lnbuffersize)

* now call the dll
lnresult = WNetGetConnection(@lclocalpath, @lcbuffer, @lnbuffersize)


*---
---
*- WNetGetConnection return codes

*---
---
*-   -1 Mapped path (parameter) is not character
*-0 Success
*-   50 The dwInfoLevel parameter was set to 0x0001
(UNIVERSAL_NAME_INFO_LEVEL)
*-  but the network provider does not support UNC  names.
This function is not supported by any of the network providers.
*-  234 The buffer pointed to by lpBuffer is too small.
*-  The function sets the variable pointed to by lpBufferSize to
the required buffer size.
*- 1200 The string pointed to by lpLocalPath is invalid.
*- 1201 There is no current connection to the remote device, but
there is a remembered (persistent) connection to it.
*- 1203 None of the providers recognized this local name as having a
connection.
*-  However, the network is not available for at least
one provider to whom the connection may belong.
*- 1208 A network-specific error occurred. Use the WNetGetLastError
function to obtain a description of the error.
*- 1222 There is no network present.
*- 2250 The device specified by lpLocalPath is not redirected.  

*---
---

DO CASE
  CASE INLIST(m.lnresult, 0, 1201)
  
*- string translated successfully
lcstructurestring = ALLTRIM(m.lcbuffer)
rcmappedpath  = LOWER(LEFT(m.lcstructurestring, AT(CHR(0),
m.lcstructurestring) - 1) + m.lcpath)

*- Local drives to not translate correctly to UNC with this
function. The code below corrects the string to have the
*- machineid included as part of the UNC path.
IF ATC(":", m.rcmappedpath) = 2
  lcMachinename = LOWER(GETWORDNUM(SYS(0), 1, "#"))
  rcmappedpath  = "\\" + RTRIM(m.lcMachinename) + "\" +
LEFT(m.rcmappedpath, 1) + "$" + SUBSTR(m.rcmappedpath, 3)
ENDIF

  CASE m.lnresult = 234
*- The buffer pointed to by lcbuffer is too small.
lnresult= getuncpath(@rcmappedpath, m.lnbuffersize + 100)

  CASE m.lnresult = 2250

  *- Is this a local drive ?
  IF ATC(":", m.rcmappedpath) = 2 AND spDIRECTORY(LEFT(m.rcmappedpath,
2), 1)

  lcMachinename = LOWER(GETWORDNUM(SYS(0), 1, "#"))
  rcmappedpath  = "\\" + RTRIM(m.lcMachinename) + "\" +
LEFT(m.rcmappedpath, 1) + "$" + SUBSTR(m.rcmappedpath, 3)

*- Set this to be a valid drive so return value indicates this is a
drive with UNC mapping.
lnresult  = 0

ENDIF

ENDCASE

ENDIF

RETURN m.lnResult






-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Tuesday, 11 April 2017 8:11 AM
To: profoxt...@leafe.com
Subject: Re: Easy way to 

RE: Zooming fonts in FoxPro IDE code windows

[Darren]

+1

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Wednesday, 4 January 2017 10:22 AM
To: profoxt...@leafe.com
Subject: RE: Zooming fonts in FoxPro IDE code windows

Nice. 

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Tuesday, January 03, 2017 4:36 PM
To: profoxt...@leafe.com
Subject: Zooming fonts in FoxPro IDE code windows

Matt has a pretty cool little hack with accompanying video:

http://mattslay.com/zooming-the-font-size-in-foxpro-ide-code-windows/


-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

[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/001801d26619$e3ed4900$abc7db00$@ozemail.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.

RE: [NF] Qarbon Viewletbuilder, TechSmith Camtasia, others? ...for presentation demos

[Darren]

I use Camtasia and also Snagit.  Both good.

Snagit is limited to 15fps but that is more than good enough for most
things. Not as full featured (in video) as Camtasia but a viable alternate
and comes with the benefit of being an excellent screen capture product.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Wednesday, 23 November 2016 10:19 AM
To: profoxt...@leafe.com
Subject: RE: [NF] Qarbon Viewletbuilder, TechSmith Camtasia, others? ...for
presentation demos

On 2016-11-22 18:12, Richard Kaye wrote:
> I used Camtasia a long time ago (v3.something) but my memories of it 
> was that it was easy to use.
> 


I get the impression Camtasia is more popular, but that could just their
marketing in action.

[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/008101d24519$bac4bc00$304e3400$@ozemail.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.

RE: Speeding up a Powershell script

[Darren]

My view ... RegExp syntax is fairly limited in scope and relatively easy to
learn. Powershell is a whole other beast.

I have used a fantastic tool to work with and develop RegExp for a few years
now and the small investment has paid over time and again ..

https://www.regexbuddy.com/  recommend it highly !!




-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Edward
Leafe
Sent: Saturday, 22 October 2016 7:36 AM
To: profoxt...@leafe.com
Subject: Re: Speeding up a Powershell script

On Oct 21, 2016, at 1:53 PM, Gene Wirchenko  wrote:
> 
>> +1.  It's like the UberNerds who want to obfuscate just for the "fun" of
it to be UberNerds.  I felt similar about RegExp.
> 
> Regexes can be great, but I resist the temptation to make long
regexes.  That gets in write-only code all too fast.  Instead, I might use a
couple of shorter ones with a bit of glue code.

Complex? Just add comments!

http://www.diveintopython.net/regular_expressions/verbose.html


-- Ed Leafe






[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/006401d22bdb$b7e005f0$27a011d0$@ozemail.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.

RE: Command button to take a photo

[Darren]

If you have an image on a form similar to the situation in the link below
then it is a relatively simple matter to use the API to define a rectangle
and capture that as a bitmap image file. Also relatively easy to convert to
other image formats using for example the offering in gdiplus. I am sure a
number of other options exist too. So yes - possible.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Chris
Davis
Sent: Friday, 21 October 2016 8:45 AM
To: profoxt...@leafe.com
Subject: Re: Command button to take a photo

http://fox.wikis.com/wc.dll?Wiki~VideoCaptureApi

On 20 Oct 2016, at 22:37, Sytze de Boer
> wrote:

In my application, which will be installed on a tablet or laptop, I need a
command button which will take a photograph.

As I understand it, these photos will always automatically be stored in a
specific folder.
Is this possible?
Is there someone who has done this and willing to share the source?



--
Kind regards,
Sytze de Boer


--- 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/007401d22b1c$51cf6270$f56e2750$@ozemail.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.

RE: Sending Faxes from FoxPro

[Darren]

My first thought would be a hardware solution. Some of these multifunction
printers send faxes and have appropriate drivers etc. Could be an option -
one off cost for hardware - put it on network somewhere and go for broke.

Or I recall back in the day there were cards that plugged into the PC and
these too were networkable solutions. Quick search for fax cards on google
came up with a heap of results. Bargain prices like $20.


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Tuesday, 13 September 2016 12:22 AM
To: profoxt...@leafe.com
Subject: Sending Faxes from FoxPro

I'm supporting a vertical niche app that sends faxes. (Yes, faxes.
I've gotten a lot of snarky comments from folks who can't believe in the
Third Age of the Internet that people still rely on faxes to do business,
but it is true: the recipients of orders are factories far from modern
internet hubs and faxes are still the best alternative, even though
error-prone and primitive. The system also supports order-by-email and EDI.
So, that out of the way,...)

MaxEmail has announced they have been bought by eFax, and account costs are
going up significantly. A $14.85/yr personal account will be $84/yr. A
larger account will go from $69.95/year to $19.95/mo, with $0.10/page
charges over 200 faxes. I'm still working out the cost implications.
Generally an additional $15/mo charge won't break the backs of any client,
but if there's another alternative available at a reasonable price, it's
incumbent on me to consider it.

I've checked the Wiki and the last Fax entry was dated 2008.

I've checked the leafe.com forums and mostly it's me recommended Maxemail
:). There's also send2fax, which I'm going to check out, although it looks
like the same company, rates are better. Hmmm.

Anyone else sending faxes? How are you doing it? And what kind of costs are
you incurring?

--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

[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/009601d20d43$bc77e670$3567b350$@ozemail.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.

RE: M$ giving more support to dbf?

[Darren]

V1.02 was first for me. Been with it ever since.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken
McGinnis
Sent: Sunday, 11 September 2016 6:08 AM
To: profoxt...@leafe.com
Subject: Re: M$ giving more support to dbf?

True, but change is painful or at least it seems like it would be painful.

I, like some others on this list started with Fox back in the 1980's and
like some others on this list, I hope god will deliver a miracle and save
us. I haven't prayed yet. Maybe that would help?

Note that VFP9 SP2 works great with Win10, even with only 2gb memory - even
better than on Win7,8,8.1.


On 9/10/2016 8:46 AM, Edward Leafe wrote:
> On Sep 10, 2016, at 6:39 AM, Man-wai Chang  wrote:
>
>> Resurrect Visual Foxpro, please! Make it 64-bit at least! :)
> Well, Paul McNett and I *tried* to do that when we created Dabo, which
does pretty much everything that VFP does, but with an open license and a
future path forward. It did require learning Python instead of Xbase, but
other than that, it had data binding, support for multiple backends (even a
DBF backend, if someone had maintained it). It's been production-ready for
over a decade.
>
> Very few people were willing to make the effort to move to Dabo. Sure, you
couldn't directly port a VFP app to Dabo, but new development work doesn't
have that problem. It really seems that people are much more willing to
invest in a product with no future from its owner than to invest in a
product with a future. It's like people who lived on the coast who have been
flooded as sea levels rose: instead of moving to higher ground, they keep
propping themselves above the waterline and praying for a miracle.
>
> -- Ed Leafe
>
>
>
>
>
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/signed
>text/plain (text body -- kept)
>application/pgp-signature
> ---
>
[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/007301d20bac$9e7b5910$db720b30$@ozemail.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.

RE: Processing a long character string one character at a time

[Darren]

Just done some rough code to check out a 200,000 byte string (too painful
waiting for 2M byte string to process)

Sample below shows huge benefit in the file approach.  

The only thing I can think of right now to improve it further would be to do
it in C++ or similar where you can easily treat the string as an array -
pass everything around by ref and should be faster - but it seems the file
approach is fast enough.

Substr  200,00 bytes  - 1.822 seconds
StrtoFile   200,00 bytes  - 0.001 seconds
StrtoFile   10,000,00 bytes  - 0.005 seconds

*- Substr loop
x = REPLICATE("Y", 20)

lnsec = SECONDS()

FOR n = 1 TO LEN(x)
  y = SUBSTR(x,n,1)
ENDFOR   

? SECONDS() - m.lnSec&& 1.822

*-
*- File approach 200,000 bytes
*-

lnsec = SECONDS()

=STRTOFILE(x, "c:\temp\test.txt")

lnFile = FOPEN("c:\temp\test.txt", 2)
lnChrs = FSEEK(m.lnFile,0,2)

? lnChrs

=FSEEK(m.lnFile, 0, 0)

FOR lnChr = 1 TO m.lnChrs
  y = FREAD(m.lnFile, 1)
ENDFOR 

=FCLOSE(m.lnFile)

? SECONDS() - m.lnSec   && 0.001 secs

*-
*- File approach 10,000,000 bytes
*-

x = REPLICATE("Y", 1000)

lnsec = SECONDS()

=STRTOFILE(x, "c:\temp\test.txt")

lnFile = FOPEN("c:\temp\test.txt", 2)
lnChrs = FSEEK(m.lnFile,0,2)

? lnChrs

=FSEEK(m.lnFile, 0, 0)

FOR lnChr = 1 TO m.lnChrs
  y = FREAD(m.lnFile, 1)
ENDFOR 

=FCLOSE(m.lnFile)

? SECONDS() - m.lnSec   && 0.005 secs


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Saturday, 10 September 2016 3:33 PM
To: profoxt...@leafe.com
Subject: Processing a long character string one character at a time

I have  a routine that processes each character in a file.  The file I am
working with is over 2 million characters long.  I pull it into a memory
variable with filetostr and then process each character with the substr
command.  Apparently substr has problems when dealing with a long string as
the process is painfully slow.

I suspect that I will be better off using the low level file routines to
read one character at a time but thought maybe someone knows of a way to
speed up the approach I am using now.

Thanks in advance,

Joe


--- 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/002a01d20b38$efc49e40$cf4ddac0$@ozemail.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.

RE: [NF] Looking for Alpha 5 (Alpha Anywhere) users

[Darren]

Found this page .. need to talk to them to get a quote it seems.

https://www.outsystems.com/pricing-and-editions/


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan
Bourke
Sent: Thursday, 8 September 2016 11:53 PM
To: profoxt...@leafe.com
Subject: Re: [NF] Looking for Alpha 5 (Alpha Anywhere) users

On Thu, 8 Sep 2016, at 02:36 PM, Dave Crozier wrote:
> Good find Alan,
> Looks really impressive. Just generated a multi platform app in about 
> 10 minutes albeit a fairly simple one, it works fine.

Good to hear - no idea on pricing info / licencing though, couldn't find it
anywhere!

--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

[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/001801d209da$95e74d50$c1b5e7f0$@ozemail.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.

RE: Better way of determining resulting Excel column from integer?

[Darren]

This is what I use.  It can be refined for sure but it does work. 

PROCEDURE spnCol2cCol

   LPARAMETERS vnCol

   LOCAL lnInt1, lnInt2, lnInt3, lcColumn

   STORE "" TO lcColumn
   
   lcColumn = ""
 
   DO CASE 
   
 CASE m.vnCol > 1378
 
   STORE m.vnCol - 703 TO vnCol
   
   m.lnInt1 = INT(m.vnCol / 676) + 1  && Plus 1 for the 702 component
   
   STORE m.vnCol - (m.lnInt1 - 1) * 676 TO m.vnCol
   
   STORE INT(m.vnCol / 26) + 1 TO lnInt2
   STORE mod(m.vnCol, 26)  + 1 TO lnInt3
   
   lcColumn = CHR(64 + m.lnInt1) + CHR(64 + m.lnInt2) + CHR(64 +
m.lnInt3)  
 
 CASE m.vnCol > 702
 
   lnInt1 = 1  && "A"
   lnInt2 = CEILING((m.vnCol - 702) / 26)
   lnInt3 = m.vnCol - 702 - (m.lnInt2 - 1) * 26
   
   lcColumn = CHR(64 + m.lnInt1) + CHR(64 + m.lnInt2) + CHR(64 +
m.lnInt3)  
 
 CASE m.vnCol > 26
 
lnInt1   = INT((m.vnCol - 1) / 26)
lnInt2   = m.vnCol - m.lnInt1 * 26
lcColumn = CHR(64 + m.lnInt1) + CHR(64 + m.lnInt2)  

 OTHERWISE

lcColumn = CHR(64 + m.vnCol)
  
   ENDCASE
   
   RETURN lcColumn 

ENDPROC

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Wednesday, 17 August 2016 6:27 AM
To: profoxt...@leafe.com
Subject: Better way of determining resulting Excel column from integer?

(Retrying to send this for the 3rd time; this time I trimmed the bottom)

I've got a need to know which Excel column a value will be placed using an
integer number.  I came up with this routine below but it seems klunky, and
although it works, I was wondering if someone had a better way?

FUNCTION GetColumn(tiNumber as Integer) as String LOCAL liMultiples as
Integer, lcColumn as String, liLeftover as Integer liMultiples =
INT((tiNumber-1)/26) liLeftover = MOD(tiNumber,26) IF liLeftover <> 0 THEN
lcColumn = CHR(liLeftover+64)
ELSE
lcColumn = "Z"
ENDIF
IF liMultiples >= 1 THEN
lcColumn = CHR(liMultiples + 64) + lcColumn ENDIF && liMultiples >=
1 RETURN lcColumn ENDFUNC && GetColumnLetter(tiNumber as Integer) as String

I'm trying to produce meta-code that will create the Excel outputs from a
fixed width input file, and hence my need to know which column I will be
entering the information per record.

Here's the resulting output of code that uses this routine to generate the
fields to process.  The routine above determined the value for the "Column"
value:

Num Column  Range   Length  Description
   1A   01-06 6 PROVIDER NUMBER
   2B   07-1711 MEDICAL RECORD
NUMBER 
(STANDARDIZED)
   3C   18-19 2 ADMIT MONTH (MM)
   4D   20-21 2 ADMIT DATE  (DD)
   5E   22-25 4 ADMIT YEAR  (CCYY)
   6F   26-27 2 DISCHARGE MONTH (MM)
   7G   28-29 2 DISCHARGE DATE  (DD)
   8H   30-33 4 DISCHARGE YEAR
(CCYY)
   9I   34-34 1 RECORD TYPE 1
  10J   35-36 2 ADMIT HOUR
  11K   37-37 1 NATURE OF ADMISSION

  1=DELIVERY
  12L   38-39 2 SOURCE OF ADMISSION
  13M   40-40 1 ADMIT FROM EMERGENCY
ROOM  
  1=ADMITTED FROM
  14N   41-42 2 BIRTHDATE MONTH (MM)
  15O   43-44 2 BIRTHDATE DAY   (DD)
  16P   45-48 4 BIRTHDATE YEAR
(CCYY)
  17Q   49-49 1 SEX

  1=MALE
  18R   50-50 1 RACE

  1=WHITE
  19S   51-51 1 ETHNICITY

  1=SPANISH/HISPANIC
  20T   52-52 1 MARTIAL STATUS

  1=SINGLE
  21U   53-54 2 AREA OF RESIDENCE

  COUNTY CODE
  22V   55-59 5 RESIDENCE ZIP CODE

  X ZIP CODE
  23W   60-61 2 PRINCIPAL PAYER
SOURCE
  24X   62-63 2 SECONDARY PAYER
SOURCE
  25Y   64-69 6 CENSUS TRACT
  26Z   70-71 2 DISPOSITION OF
PATIENT
  27AA  72-74 3 ALTERNATIVE RATE
METHOD
  ARM CODE
  28AB  75-76 2 SOURCE OF PAYMENT

  EXPECTED PAYOR FOR MOST

etc.


[excessive quoting removed by server]

___
Post Messages to: 

RE: Bad getwordnum

[Darren]

I am cautious of using getwordnum() for following reason.

Given: 

lcString = "1,2,,3"

My observation is there are 4 separate words in that string using the comma as 
a separator - albeit one is null

? GETWORDCOUNT(m.lcString,",")  - returns 3
? OCCURS(",", m.lcString) + 1   - returns 4
? ALINES(laLines, m.lcString, 3, ",")   - returns 4

Guess it comes down to what a word is defined as.



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen 
Russell
Sent: Friday, 29 July 2016 4:44 AM
To: profoxt...@leafe.com
Subject: Re: Bad getwordnum

Sorry Fred they were considered words when it was a numeric value when loaded 
in the array.  We were extracting notes and there were addresses and times in 
there that muddied the waters.

On Thu, Jul 28, 2016 at 11:44 AM, Fred Taylor  wrote:

> Hi Stephen,
>
> Got an example where numbers aren't considered words in GETWORDNUM()?
>
> Seems to work fine for me.
>
> Fred
>
> On Thu, Jul 28, 2016 at 6:59 AM, Stephen Russell 
> 
> wrote:
>
> > I got burned by this a long time ago in that numbers are not 
> > considered words and we had sets of addresses in our document.
> >
> > Just giving you a heads up.
> >
> > On Tue, Jul 26, 2016 at 5:00 AM, Claudio  wrote:
> >
> > >
> > > > - Original Message -
> > > >
> > > > Instead of using Getwordnum, split the string in an array using
> > > > ALINES(yourarray,yourstring,3,',')
> > > >
> > > > You can then access to each word, even if it's a null string.
> > > >
> > > > Gérard.
> > > >
[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/005801d1e906$aa33eba0$fe9bc2e0$@ozemail.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.

RE: Can you work VFP into Win10?

[Darren]

My understanding of doing something in anger is to do something for real,
not simulated, with intent and purpose. Doesn't normally equate to hostility
(though it might depending on context)

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Tuesday, 26 July 2016 10:46 PM
To: profoxt...@leafe.com
Subject: Re: Can you work VFP into Win10?

On Tue, Jul 26, 2016 at 7:11 AM, Dave Crozier  wrote:

> Although I haven't used your product in anger <

Hmmm... anger leads to hatred, and hatred leads to the Dark Side!

Is this another of those Anglicisms where English doesn't mean what us
'Mericans think? Or did autocorrect make one of its little jokes?


--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

[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/00ad01d1e788$18583ee0$4908bca0$@ozemail.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.

RE: Can you work VFP into Win10?

[Darren]

That's a bit harsh - don't know about others but VFP brings me exceptional
money, considerable time with my family (work from home mostly) and affords
me a pleasant life style. If that's using a dead product then I'd recommend
everyone sprint on down to the cemetery and get their fill cause it sure is
sweet. As they say - VFP Rocks !!
 
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Man-wai
Chang
Sent: Tuesday, 26 July 2016 4:08 PM
To: profoxt...@leafe.com
Subject: Re: Can you work VFP into Win10?

VFP is dead. Forget about it. Learn a new too and move on.

Good VFP developers don't need any form of business presentation nor
product/service seminars to mirage. They only need to hire someone to do it
and ENJOY the transition. :)

On Mon, Jul 25, 2016 at 10:38 PM, Stephen Russell 
wrote:
> I know nobody likes or trust M$, but this is a post that looks 
> potentialy interesting for you folks.  Have not looked at it because I 
> do not do WIN development but you all do.
> https://visualstudiomagazine.com/...
> This is what it presents for the signup of the webinar:
> Project Centennial: A Bridge to the Future of Desktop Installations


--
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\
http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

[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/009401d1e71e$cd6d9100$6848b300$@ozemail.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.

RE: FoxBin2Prg conversion error question

[Darren]

Easy enough to figure which are correct records.

First row of VCX ignore it.

2nd row on:

First row of class identified as:

Not empty - class, classloc, baseclass, objname 
Empty - parent

Resevred2 will have a numeric value which is number of rows that go
to make up the class definition.

Last row of class definition will have empty - class, classloc, baseclass
and parent.  The objname of last record for class will be same as objname
for first record.

 Rows between first and last will have the Parent value populated with the
Objname of the parent which of course should be within the group of records
for the class definition.

Based on that you should be able to find any rogue records.




-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Tuesday, 26 July 2016 12:03 AM
To: profoxt...@leafe.com
Subject: RE: FoxBin2Prg conversion error question

Thanks, Darren. I figure the cure will be to delete some rows manually from
the VCX but knowing which ones should be deleted is the key.

--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Darren
Sent: Monday, July 25, 2016 10:00 AM
To: profoxt...@leafe.com
Subject: RE: FoxBin2Prg conversion error question

I have occasionally seen duplicate class definitions in a VCX - in all cases
I've noted the last definition is the correct one. If such a condition
exists then the earlier instances need to be deleted. 

When saving changes to a class seems VFP writes the changes as a complete
new entry and deletes the prior entries in the VCX.

Maybe something along those lines. 

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Monday, 25 July 2016 11:33 PM
To: profoxt...@leafe.com
Subject: FoxBin2Prg conversion error question

Hi Fernando,

Since I know you've been hanging around here in ProFox I thought I'd post my
question here. If there's a better place, please let me know. :)

I've got a VCX that is generating errors when I run it through FB2P. It's
indicating there are duplicate objects in the VCX and does not generate the
VC2 file. (See log example below.) I have used the cleanup option in the
class browser but it hasn't helped. I've also USEd the VCX and run both PACK
and PACK MEMO. Can you advise on the best way to get past this error?

* Duplicated Object "gridiron.invgrid.invgrid" @Recno 139, (1st.Recno:17)

--

rk


[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/009a01d1e67f$0f1255f0$2d3701d0$@ozemail.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.

RE: FoxBin2Prg conversion error question

[Darren]

I have occasionally seen duplicate class definitions in a VCX - in all cases
I've noted the last definition is the correct one. If such a condition
exists then the earlier instances need to be deleted. 

When saving changes to a class seems VFP writes the changes as a complete
new entry and deletes the prior entries in the VCX.

Maybe something along those lines. 

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Richard
Kaye
Sent: Monday, 25 July 2016 11:33 PM
To: profoxt...@leafe.com
Subject: FoxBin2Prg conversion error question

Hi Fernando,

Since I know you've been hanging around here in ProFox I thought I'd post my
question here. If there's a better place, please let me know. :)

I've got a VCX that is generating errors when I run it through FB2P. It's
indicating there are duplicate objects in the VCX and does not generate the
VC2 file. (See log example below.) I have used the cleanup option in the
class browser but it hasn't helped. I've also USEd the VCX and run both PACK
and PACK MEMO. Can you advise on the best way to get past this error?

* Duplicated Object "gridiron.invgrid.invgrid" @Recno 139, (1st.Recno:17)

--

rk



--- 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/008d01d1e67c$d590e0f0$80b2a2d0$@ozemail.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.

RE: Checking for All-Different Characters

[Darren]

This will give you all the dates that have a unique set of digits 1900 to
 - probably more efficient ways to do it but this runs sub second on my
machine and spits out 44,640 values. Have not done any testing or checking
but it'll give you at least an idea.

CREATE CURSOR w_dates (uniquedate D)

FOR lnYear = 1900 TO 

  STORE 0 TO lnCheck
  STORE .F. TO llDuplicate
  
  *- Check the year part for duplicate number usage
  STORE STR(m.lnYear, 4) TO lcYear
  FOR n = 1 TO 4
  
STORE VAL(SUBSTR(m.lcYear, n, 1)) TO lnVal
  
IF BITTEST(m.lnCheck, m.lnVal)
  STORE .T. TO llDuplicate
  EXIT
ELSE
  lnCheck = BITSET(m.lnCheck, m.lnVal)
ENDIF 
  
  ENDFOR
  
  IF m.llDuplicate
LOOP
  ENDIF
  
  STORE m.lnCheck TO lnCheckYr

  *---
  *- Process Months
  *---
  FOR lnMth = 1 TO 12
  
*- Check the mth + year part for duplicate number usage
STORE .F. TO llDuplicate
  
STORE PADL(m.lnMth, 2, "0") TO lcMth
FOR n = 1 TO 2
  
STORE VAL(SUBSTR(m.lcMth, n, 1)) TO lnVal
  
  IF BITTEST(m.lnCheck, m.lnVal)
STORE .T. TO llDuplicate
EXIT
  ELSE
lnCheck = BITSET(m.lnCheck, m.lnVal)
  ENDIF 

ENDFOR 

IF m.llDuplicate
 
  STORE m.lnCheckYr TO lnCheck  && Restore baseline to the year value
  LOOP
  
ENDIF

STORE m.lnCheck TO lnCheckYrMth

*---
*- Process Days
*---
  
*- How many days in the month ?
lnDays = ICASE(;
  INLIST(m.lnMth, 1, 3, 5, 7, 8, 10, 12), 31, ;
  m.lnMth = 2, 28, ;
  30)
  
*- Is this a leap Year ?
IF m.lnMth = 2 AND MOD(m.lnYear, 4) = 0 AND IIF(MOD(m.lnYear, 100) = 0,
IIF(MOD(m.lnYear, 400) = 0, .T., .F.), .T.)
  STORE 29 TO lnDays
ENDIF

FOR lnDay = 1 to m.lnDays

  *- Check the mth + year + day parts for duplicate number usage
  STORE .F. TO llDuplicate

  STORE PADL(m.lnDay, 2, "0") TO lcDay
  FOR n = 1 TO 2

  STORE VAL(SUBSTR(m.lcDay, n, 1)) TO lnVal

IF BITTEST(m.lnCheck, m.lnVal)
  STORE .T. TO llDuplicate
  EXIT
ELSE
  lnCheck = BITSET(m.lnCheck, m.lnVal)
ENDIF 
  
  ENDFOR 
  
  IF NOT m.llDuplicate
  
INSERT INTO w_dates (;
uniquedate) ;
  VALUES (;
DATE(m.lnYear, m.lnMth, m.lnDay))

  ENDIF  

  STORE m.lnCheckYrMth TO lnCheck  && Restore baseline to the year +
month value - check next day in month.

ENDFOR 

STORE m.lnCheckYr TO lnCheck  && Check Next Mth in Year
  
  ENDFOR
  
ENDFOR  

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene
Wirchenko
Sent: Monday, 18 July 2016 2:29 AM
To: profoxt...@leafe.com
Subject: Checking for All-Different Characters

Hello:

  I write a logic/math puzzle each week.  They appear in my blog
(http://genew.ca/) and two local newspapers.

  Here is the latest problem:

  "Consider a date in -MM-DD format.  What is the next date where
all eight digits will be different?"

  I solved this by hand.  I decided to verify my solution with a
program.  I often cook up something in GW-BASIC, but since VFP has date
functions, I decided to go with it.

  It was very easy to set up the framework of the loop.  What threw me
for a loop is how to check that all of the digits are different.  I ended up
converting the date to string with dtos() and then testing the string with a
rather ugly-looking condition.  Is there something faster?

* Start of Code *
* 16s-16.prg
* Date Puzzle
* Last Modification: 2016-07-17
*
* Consider a date in -MM-DD format.  What is the next date where all
* eight digits will be different?

? "*** Execution begins."
? program()
close all
clear all

set talk off
set exact on
set century on
set date ansi

*

local startdate
startdate=date()

? "Start Date: "+transform(startdate)

local trydate, looping
trydate=startdate
looping=.t.
do while looping

   local trydtos
   trydtos=dtos(trydate)
   if right(trydtos,4)="0101"
  ? "Working on year "+left(trydtos,4)
  endif

   if;
iif("0"$trydtos,1,0)+;
iif("1"$trydtos,1,0)+;
iif("2"$trydtos,1,0)+;
iif("3"$trydtos,1,0)+;
iif("4"$trydtos,1,0)+;
iif("5"$trydtos,1,0)+;
iif("6"$trydtos,1,0)+;
iif("7"$trydtos,1,0)+;
iif("8"$trydtos,1,0)+;
iif("9"$trydtos,1,0)#8
  trydate=trydate+1
   else && solution
  looping=.f.
  endif

   enddo

? "Solution is "+transform(trydate)+"."

*

close all
clear all
? "*** Execution ends."
return
* End of Code *

Sincerely,

RE: Checking for All-Different Characters

[Darren]

Maybe something like ..

STORE CAST(0 AS I) TO lnCheck

lcDtString = STRCONV(DTOS(DATE()), 12)

=ALINES(laValues, m.lcDtString, 0, CHR(0))

FOR lnPosn = 1 TO 8

  STORE VAL(laValues(m.lnPosn)) TO lnVal
  
  ? lnVal

  IF BITTEST(m.lnCheck, m.lnVal)

*- Have a duplicate number  - do what ever

=MESSAGEBOX(laValues(m.lnPosn) + " appears more than once.")

EXIT 

  ELSE
  
STORE BITSET(m.lnCheck, m.lnVal) TO lnCheck
  
  ENDIF
  
ENDFOR

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene
Wirchenko
Sent: Monday, 18 July 2016 2:29 AM
To: profoxt...@leafe.com
Subject: Checking for All-Different Characters

Hello:

  I write a logic/math puzzle each week.  They appear in my blog
(http://genew.ca/) and two local newspapers.

  Here is the latest problem:

  "Consider a date in -MM-DD format.  What is the next date where
all eight digits will be different?"

  I solved this by hand.  I decided to verify my solution with a
program.  I often cook up something in GW-BASIC, but since VFP has date
functions, I decided to go with it.

  It was very easy to set up the framework of the loop.  What threw me
for a loop is how to check that all of the digits are different.  I ended up
converting the date to string with dtos() and then testing the string with a
rather ugly-looking condition.  Is there something faster?

* Start of Code *
* 16s-16.prg
* Date Puzzle
* Last Modification: 2016-07-17
*
* Consider a date in -MM-DD format.  What is the next date where all
* eight digits will be different?

? "*** Execution begins."
? program()
close all
clear all

set talk off
set exact on
set century on
set date ansi

*

local startdate
startdate=date()

? "Start Date: "+transform(startdate)

local trydate, looping
trydate=startdate
looping=.t.
do while looping

   local trydtos
   trydtos=dtos(trydate)
   if right(trydtos,4)="0101"
  ? "Working on year "+left(trydtos,4)
  endif

   if;
iif("0"$trydtos,1,0)+;
iif("1"$trydtos,1,0)+;
iif("2"$trydtos,1,0)+;
iif("3"$trydtos,1,0)+;
iif("4"$trydtos,1,0)+;
iif("5"$trydtos,1,0)+;
iif("6"$trydtos,1,0)+;
iif("7"$trydtos,1,0)+;
iif("8"$trydtos,1,0)+;
iif("9"$trydtos,1,0)#8
  trydate=trydate+1
   else && solution
  looping=.f.
  endif

   enddo

? "Solution is "+transform(trydate)+"."

*

close all
clear all
? "*** Execution ends."
return
* End of Code *

Sincerely,

Gene Wirchenko


[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/008801d1e083$0ffde490$2ff9adb0$@ozemail.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.

RE: updating 2 forms

[Darren]

Various ways.

You could pass a parameter when you create the 2nd form and pick that up in
the Init of the 2nd form then set a property on the form with the object
reference.

You could create the form and then set a property on the 2nd form with the
object reference (depends if from is modal or not).

You could use _Screen or some other public object to hold a property with
the object reference.

You could create a variable scoped public and set that to the object
reference.

I am sure there are more but that should give you something to work with. 


 


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze de
Boer
Sent: Wednesday, 6 July 2016 9:45 AM
To: profoxt...@leafe.com
Subject: Re: updating 2 forms

Darren, thanks for your suggestion.
But I'm stuck on how to pass such a reference Can you suggest?



On Wed, Jul 6, 2016 at 11:12 AM, Darren <fox...@ozemail.com.au> wrote:

> Yes be the answer.
>
> I'd probably attack it by passing a reference to the text box to be 
> updated to the 2nd form.  In the control on the 2nd form interactive 
> change event have that set the caption of the text box on the first 
> form to the value of the control on the 2nd form.
>
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
> Sytze de Boer
> Sent: Wednesday, 6 July 2016 9:02 AM
> To: profoxt...@leafe.com
> Subject: updating 2 forms
>
> Friends
>
> In a new application I am developing, I have a Form with a Command 
> button The Command button opens a 2nd form
>
> When my client enters data into this 2nd form, I need to show what is 
> being typed in a Text box on the 1st form.
> Can that be done?
>
>
> --
> Kind regards,
> Sytze de Boer
>
>
> --- 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/00e401d1d719$70770ea0$51652be0$@ozemail.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.

RE: updating 2 forms

[Darren]

Yes be the answer.

I'd probably attack it by passing a reference to the text box to be updated
to the 2nd form.  In the control on the 2nd form interactive change event
have that set the caption of the text box on the first form to the value of
the control on the 2nd form.



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze de
Boer
Sent: Wednesday, 6 July 2016 9:02 AM
To: profoxt...@leafe.com
Subject: updating 2 forms

Friends

In a new application I am developing, I have a Form with a Command button
The Command button opens a 2nd form

When my client enters data into this 2nd form, I need to show what is being
typed in a Text box on the 1st form.
Can that be done?


--
Kind regards,
Sytze de Boer


--- 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/00c301d1d712$ae1b1a50$0a514ef0$@ozemail.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.

RE: [NF] Password instructions from my local credit union

[Darren]

I worked for 10+ years in a big AU bank. They passed passwords between
systems in essentially clear text (in fact they were encrypted but everyman
and his dog knew or had easy access to the encryption key) - bottom line
though is the passwords were stored in a manner that could very easily be
exploited. And banks go on so much about security - it is a smoke screen.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Wednesday, 29 June 2016 2:17 AM
To: profoxt...@leafe.com
Subject: [NF] Password instructions from my local credit union

"Passwords must not contain all letters or numbers, and be at least 6
characters and no more than 10 characters long"

WHY  I just don't understand how here in 2016, we're limited to 10
characters.

[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/00ac01d1d199$b8910bd0$29b32370$@ozemail.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.

RE: [NF] Win10 Update anyone?

[Darren]

Maybe
http://www.howtogeek.com/224471/how-to-prevent-windows-10-from-automatically
-downloading-updates/


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of rafael
copquin
Sent: Friday, 29 April 2016 6:56 AM
To: profoxt...@leafe.com
Subject: Re: [NF] Win10 Update anyone?

Very funny Steve.

Now as a related issue I have this question:

Is it possible to stop Windows 10 to automatically install its upgrades?

I used to run on Windows 7 professional (32 bit). I upgraded to Windows
10 with no major issues other than reinstall some software with updated
drivers.

But yesterday, when I started my PC it began to update itself and the damn
thing took 37 minutes to do that
And I have a fast computer!!

In the meantime a lot of encouraging words appeared on the screen stating
that now my Windows 10 experience would be enhanced and I would reach
something akin to nirvana, but the screen was black most of the time and I
could do absolutely nothing.

What a waste of precious time!!

Again, is there a way to control these updates?

Rafael Copquin


--
Rafael Copquin


[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/00a801d1a19e$55f99620$01ecc260$@ozemail.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.

RE: Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden

[Darren]

I have V 10 as well and it is fine. The behaviour was in V 9.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan
Bourke
Sent: Thursday, 28 April 2016 5:35 PM
To: profoxt...@leafe.com
Subject: Re: Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden

I have TV 10 but don't see this - try updating your graphics drivers.

-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

[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/002701d1a126$6eafa8d0$4c0efa70$@ozemail.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.

RE: Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden

[Darren]

I've seen it with a Version of TeamViewer 9 installed.  I reported it to
them and they, very promptly gave me a fix. Don't recall seeing that
behaviour otherwise.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
mbsoftwaresoluti...@mbsoftwaresolutions.com
Sent: Wednesday, 27 April 2016 11:33 AM
To: profoxt...@leafe.com
Subject: Odd menu behavior in Win7Pro/VFP9SP2 all of the sudden

All of the sudden, when I go into VFP and choose something off the main
menu, the dropdown area appears but it's all blank.  As I scroll down over
where the item choices would be, they appear as I scan over them.

Same Windows version.  Not sure if a recent Windows Update caused it?  
Very weird.

Has anyone seen this?

Visual FoxPro 09.00..7423 for Windows [Feb 23 2009 13:20:28] Product ID
76683-120-0083971-18373

[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/016d01d1a02b$acbb29c0$06317d40$@ozemail.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.

RE: Suggestions for closing out simple applications?

[Darren]

Also if the two forms are Modal you do not need READ EVENTS or CLEAR EVENTS.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Wednesday, 2 March 2016 9:49 AM
To: profoxt...@leafe.com
Subject: Re: Suggestions for closing out simple applications?

My application is so simple that it has no menu.  Is there an advantage to
having the clear events in a form rather than directly following the read
events in the main program?

Also - what am I missing that would allow the command window to become
active after my forms close or is moving the clear events what needs to
happen?

Thank you - Joe
On Mar 1, 2016 5:09 PM, "Fred Taylor"  wrote:

> You don't need a CLEAR EVENTS after your READ EVENTS.  You need to 
> have a CLEAR EVENTS somewhere else in your code (menu option, last 
> form's Destroy method, etc.)  That will cause the main program to pick 
> up after the READ EVENTS and go from there.
>
> Fred
>
> On Tue, Mar 1, 2016 at 2:43 PM, Joe Yoder  wrote:
>
> > I have never used a framework and often just execute my stuff in the 
> > VFP environment.  When I do an exe for others to use I am never sure 
> > what commands to include to shut things down.  Sometimes I end up 
> > with applications that can't be shut down without killing them in 
> > Task Manager and sometimes I end up with code that forces me to 
> > re-execute "Modify Project" after a run after build.
> >
> > My Simple applications has a main.prg that calls a main form which 
> > calls two other modal forms. Each form shuts down with a 
> > thisform.release.  The main.prg file looks like this:
> >
> > USE Simple
> > DO FORM Main
> > READ events
> > CLEAR events
> > CLEAR PROGRAM
> > RELEASE all
> >
> > Right now this setup forces me to goto Program|Cancel before I get 
> > the command window back after a run.
> >
> > Some input from a pro would save me a lot of trial and error!
> >
> > Thanks in advance,
> >
> > Joe
> >
> >
> > --- 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/002c01d1740f$10107320$30315960$@ozemail.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.

RE: Suggestions for closing out simple applications?

[Darren]

Joe

READ EVENTS starts the EVENT processing
CLEAR EVENTS is what stops the EVENT processing

You need to put a CLEAR EVENTS somewhere in your application where it will
be executed.  Once READ EVENTS is executed it will not go to the next line
of code until a CLEAR EVENTS is issued. 

Essentially READ EVENTS is a waiting for an EVENT to occur for which an
action will take place. It will process the code associated with the event
and once completed will wait for the next event to respond to and so on
until a CLEAR EVENT is issued at which time it will no longer respond to
events. Typically a CLEAR EVENTS would be a part of an application shutdown
process or similar.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Wednesday, 2 March 2016 9:49 AM
To: profoxt...@leafe.com
Subject: Re: Suggestions for closing out simple applications?

My application is so simple that it has no menu.  Is there an advantage to
having the clear events in a form rather than directly following the read
events in the main program?

Also - what am I missing that would allow the command window to become
active after my forms close or is moving the clear events what needs to
happen?

Thank you - Joe
On Mar 1, 2016 5:09 PM, "Fred Taylor"  wrote:

> You don't need a CLEAR EVENTS after your READ EVENTS.  You need to 
> have a CLEAR EVENTS somewhere else in your code (menu option, last 
> form's Destroy method, etc.)  That will cause the main program to pick 
> up after the READ EVENTS and go from there.
>
> Fred
>
> On Tue, Mar 1, 2016 at 2:43 PM, Joe Yoder  wrote:
>
> > I have never used a framework and often just execute my stuff in the 
> > VFP environment.  When I do an exe for others to use I am never sure 
> > what commands to include to shut things down.  Sometimes I end up 
> > with applications that can't be shut down without killing them in 
> > Task Manager and sometimes I end up with code that forces me to 
> > re-execute "Modify Project" after a run after build.
> >
> > My Simple applications has a main.prg that calls a main form which 
> > calls two other modal forms. Each form shuts down with a 
> > thisform.release.  The main.prg file looks like this:
> >
> > USE Simple
> > DO FORM Main
> > READ events
> > CLEAR events
> > CLEAR PROGRAM
> > RELEASE all
> >
> > Right now this setup forces me to goto Program|Cancel before I get 
> > the command window back after a run.
> >
> > Some input from a pro would save me a lot of trial and error!
> >
> > Thanks in advance,
> >
> > Joe
> >
> >
> > --- 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/002b01d1740e$b81f05a0$285d10e0$@ozemail.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.

RE: How to allow multiple forms to update the same record pointer in a table

[Darren]

Joe if you want it zip it all up and send it to me I'll have a look see for
you.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Tuesday, 1 March 2016 4:33 PM
To: profoxt...@leafe.com
Subject: Re: How to allow multiple forms to update the same record pointer
in a table

I use a test button on the main form to set the record pointer to 25.  As
soon as I step into either of the Do Form lines the recno() changes back to
a red 1 without the watch firing. The debugger shows that it is still in the
click method of the command button that did the call.

There must be something I as a dabbler am doing differently than experienced
developers - what can it be?

I have changed everything except the data file I am trying to display and
the behavior persists.  Perhaps tomorrow I will use a different data file as
well.

Thanks to all for the input so far!

Joe

On Mon, Feb 29, 2016 at 9:21 PM, Darren <fox...@ozemail.com.au> wrote:

> Put the SET STEP immediately before the do form.
>
> Then on the toolbar click on the symbol with the arrow going into the 
> brackets. Do that repeatedly and you'll go one line at a time. You'll 
> get the idea.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
> Joe Yoder
> Sent: Tuesday, 1 March 2016 1:15 PM
> To: profoxt...@leafe.com
> Subject: Re: How to allow multiple forms to update the same record 
> pointer in a table
>
> Thanks to your instructions I have done that and see that the pointer 
> changes as soon as the "do form" line executes.  I haven't figured out 
> how to single step in the called form code. - Joe
>
> On Mon, Feb 29, 2016 at 7:59 PM, Darren <fox...@ozemail.com.au> wrote:
>
> > One way ...
> >
> > SET STEP ON in the code that calls the 2nd form.
> >
> > Go into the breakpoints setup.  (Little hand symbol) Add a 
> > breakpoint
> > - Type = "Break when expression has changed"
> > In the expression put in RECNO ("") The go back the command 
> > window and type in RESUME.
> >
> > Something like that should get you going.
> >
> > -Original Message-
> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
> > Joe Yoder
> > Sent: Tuesday, 1 March 2016 11:38 AM
> > To: profoxt...@leafe.com
> > Subject: Re: How to allow multiple forms to update the same record 
> > pointer in a table
> >
> > I'm afraid I have forgotten the little I knew about setpoints and 
> > stepping in the debugger.  I guess I need to read up on that. - Joe
> >
> > On Mon, Feb 29, 2016 at 7:36 PM, Joe Yoder <j...@wheypower.com> wrote:
> >
> > > Thanks for the idea Kurt but that was one of the first things I
> checked.
> > >
> > > I have now determined that any form I call from the main form will 
> > > always start at record 1 even if the record pointer is at a 
> > > different value just before the call.  If the called form changes 
> > > the record pointer the pointer value will persist after the form 
> > > closes.  I have added a button to simply browse the table from the 
> > > main form.  That action respects the value of the pointer on entry 
> > > and leaves the pointer
> > in the proper place on exit.
> > >
> > > There must be something about the forms I am using that causes 
> > > this problem.  I've been looking at the scx files and see that 
> > > there is a some information about a cursor there.  Is there a 
> > > setting I need to change to get the behaviour I need?  (I have 
> > > done a test project where there is only one table and the behavior 
> > > continues.)
> > >
> > > Thanks for any ideas,
> > >
> > > Joe
> > >
> > > On Mon, Feb 29, 2016 at 11:31 AM, Kurt Wendt 
> > > <kurt_we...@globetax.com>
> > > wrote:
> > >
> > >> Just a WAG - but, what is your DataSession property value for the 
> > >> Form? I think it should be set to "1-Default Data Session". That 
> > >> may be your problem if it says Private!
> > >>
> > >> Regards,
> > >> Kurt Wendt
> > >> Consultant
> > >>
> > >>
> > >> Tel. +1-212-747-9100
> > >> www.GlobeTax.com
> > >>
> > >>
> > >> -Original Message-
> > >> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf 
> > >> Of Joe Yoder
> > >> Sent: Monday, February 29, 2016 10:22 AM
> > >> To: profoxt.

RE: How to allow multiple forms to update the same record pointer in a table

[Darren]

Put the SET STEP immediately before the do form.

Then on the toolbar click on the symbol with the arrow going into the
brackets. Do that repeatedly and you'll go one line at a time. You'll get
the idea.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Tuesday, 1 March 2016 1:15 PM
To: profoxt...@leafe.com
Subject: Re: How to allow multiple forms to update the same record pointer
in a table

Thanks to your instructions I have done that and see that the pointer
changes as soon as the "do form" line executes.  I haven't figured out how
to single step in the called form code. - Joe

On Mon, Feb 29, 2016 at 7:59 PM, Darren <fox...@ozemail.com.au> wrote:

> One way ...
>
> SET STEP ON in the code that calls the 2nd form.
>
> Go into the breakpoints setup.  (Little hand symbol) Add a breakpoint 
> - Type = "Break when expression has changed"
> In the expression put in RECNO ("") The go back the command 
> window and type in RESUME.
>
> Something like that should get you going.
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
> Joe Yoder
> Sent: Tuesday, 1 March 2016 11:38 AM
> To: profoxt...@leafe.com
> Subject: Re: How to allow multiple forms to update the same record 
> pointer in a table
>
> I'm afraid I have forgotten the little I knew about setpoints and 
> stepping in the debugger.  I guess I need to read up on that. - Joe
>
> On Mon, Feb 29, 2016 at 7:36 PM, Joe Yoder <j...@wheypower.com> wrote:
>
> > Thanks for the idea Kurt but that was one of the first things I checked.
> >
> > I have now determined that any form I call from the main form will 
> > always start at record 1 even if the record pointer is at a 
> > different value just before the call.  If the called form changes 
> > the record pointer the pointer value will persist after the form 
> > closes.  I have added a button to simply browse the table from the 
> > main form.  That action respects the value of the pointer on entry 
> > and leaves the pointer
> in the proper place on exit.
> >
> > There must be something about the forms I am using that causes this 
> > problem.  I've been looking at the scx files and see that there is a 
> > some information about a cursor there.  Is there a setting I need to 
> > change to get the behaviour I need?  (I have done a test project 
> > where there is only one table and the behavior continues.)
> >
> > Thanks for any ideas,
> >
> > Joe
> >
> > On Mon, Feb 29, 2016 at 11:31 AM, Kurt Wendt 
> > <kurt_we...@globetax.com>
> > wrote:
> >
> >> Just a WAG - but, what is your DataSession property value for the 
> >> Form? I think it should be set to "1-Default Data Session". That 
> >> may be your problem if it says Private!
> >>
> >> Regards,
> >> Kurt Wendt
> >> Consultant
> >>
> >>
> >> Tel. +1-212-747-9100
> >> www.GlobeTax.com
> >>
> >>
> >> -Original Message-
> >> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
> >> Joe Yoder
> >> Sent: Monday, February 29, 2016 10:22 AM
> >> To: profoxt...@leafe.com
> >> Subject: Re: How to allow multiple forms to update the same record 
> >> pointer in a table
> >>
> >> Thanks Kurt - your understanding is correct.
> >>
> >> I have pinned down the problem to the detail form.  When I call it 
> >> something changes the record pointer to the first record.  When the 
> >> calling form gets control back the record pointer is where the 
> >> detail
> form left it.
> >>
> >>
> >> I have not been able to find any reason for this but wonder if it 
> >> is related to the fact that the form was first created using the 
> >> form
> wizard.
> >> I had grief with changing the table alias with that form so I 
> >> opened a new form and copied the complete layout.  That took care 
> >> of table name but perhaps there is an "unwanted feature" still in 
> >> place from its former life as a wizard created form.  I'd rather 
> >> not do the tedious work of regenerating the form - any ideas?
> >>
> >> Thank you,
> >>
> >> Joe
> >>
> >> On Mon, Feb 29, 2016 at 9:21 AM, Kurt Wendt 
> >> <kurt_we...@globetax.com>
> >> wrote:
> >>
> >> > Fernando - that's just the opposite of what Joe wants. He indeed 
> >> > wants

RE: How to allow multiple forms to update the same record pointer in a table

[Darren]

One way ...

SET STEP ON in the code that calls the 2nd form.

Go into the breakpoints setup.  (Little hand symbol)
Add a breakpoint - Type = "Break when expression has changed"
In the expression put in RECNO ("")
The go back the command window and type in RESUME.

Something like that should get you going.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Tuesday, 1 March 2016 11:38 AM
To: profoxt...@leafe.com
Subject: Re: How to allow multiple forms to update the same record pointer
in a table

I'm afraid I have forgotten the little I knew about setpoints and stepping
in the debugger.  I guess I need to read up on that. - Joe

On Mon, Feb 29, 2016 at 7:36 PM, Joe Yoder  wrote:

> Thanks for the idea Kurt but that was one of the first things I checked.
>
> I have now determined that any form I call from the main form will 
> always start at record 1 even if the record pointer is at a different 
> value just before the call.  If the called form changes the record 
> pointer the pointer value will persist after the form closes.  I have 
> added a button to simply browse the table from the main form.  That 
> action respects the value of the pointer on entry and leaves the pointer
in the proper place on exit.
>
> There must be something about the forms I am using that causes this 
> problem.  I've been looking at the scx files and see that there is a 
> some information about a cursor there.  Is there a setting I need to 
> change to get the behaviour I need?  (I have done a test project where 
> there is only one table and the behavior continues.)
>
> Thanks for any ideas,
>
> Joe
>
> On Mon, Feb 29, 2016 at 11:31 AM, Kurt Wendt 
> wrote:
>
>> Just a WAG - but, what is your DataSession property value for the 
>> Form? I think it should be set to "1-Default Data Session". That may 
>> be your problem if it says Private!
>>
>> Regards,
>> Kurt Wendt
>> Consultant
>>
>>
>> Tel. +1-212-747-9100
>> www.GlobeTax.com
>>
>>
>> -Original Message-
>> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
>> Joe Yoder
>> Sent: Monday, February 29, 2016 10:22 AM
>> To: profoxt...@leafe.com
>> Subject: Re: How to allow multiple forms to update the same record 
>> pointer in a table
>>
>> Thanks Kurt - your understanding is correct.
>>
>> I have pinned down the problem to the detail form.  When I call it 
>> something changes the record pointer to the first record.  When the 
>> calling form gets control back the record pointer is where the detail
form left it.
>>
>>
>> I have not been able to find any reason for this but wonder if it is 
>> related to the fact that the form was first created using the form
wizard.
>> I had grief with changing the table alias with that form so I opened 
>> a new form and copied the complete layout.  That took care of table 
>> name but perhaps there is an "unwanted feature" still in place from 
>> its former life as a wizard created form.  I'd rather not do the 
>> tedious work of regenerating the form - any ideas?
>>
>> Thank you,
>>
>> Joe
>>
>> On Mon, Feb 29, 2016 at 9:21 AM, Kurt Wendt 
>> wrote:
>>
>> > Fernando - that's just the opposite of what Joe wants. He indeed 
>> > wants Both forms to be looking at the same records - such that if 
>> > he brings up the 2nd form - and Changes to a different record - 
>> > then upon returning back to 1st form - it should now be looking at 
>> > the Same record that Form2 was pointing to!
>> >
>> > Regards,
>> > Kurt Wendt
>> > Consultant
>> >
>> >
>> > Tel. +1-212-747-9100
>> > www.GlobeTax.com
>> >
>> >
>> > -Original Message-
>> > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
>> > Fernando D. Bozzo
>> > Sent: Monday, February 29, 2016 1:16 AM
>> > To: profoxt...@leafe.com
>> > Subject: Re: How to allow multiple forms to update the same record 
>> > pointer in a table
>> >
>> > Hello joe:
>> >
>> > You may need to use private session en form 2 or on both, so record 
>> > pointers do not interfere between forms.
>> >
>> >
>> > --- 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/012101d17355$9ca7c4b0$d5f74e10$@ozemail.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.

RE: Import/Export with CSV

[Darren]

Took a look at that link and it references an Excel add-on - "Power Query" -
looks like a great additional to Excel. As a bonus seems to sort out the
issue raised.

>
http://stackoverflow.com/questions/35118402/how-to-correctly-format-an-alpha
-numerical-in-an-exported-csv-file-opened-in-exc?rq=1

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Tuesday, 1 March 2016 2:07 AM
To: profoxt...@leafe.com
Subject: Re: Import/Export with CSV

On Mon, Feb 29, 2016 at 6:30 AM, Ted Roche  wrote:
>
> Alternatively, there may be some option in the Excel import dialog to 
> turn off "Smart Parsing" or whatever Excel calls it. (LibreOffice 
> user, sorry.)

See Also:
http://stackoverflow.com/questions/35118402/how-to-correctly-format-an-alpha
-numerical-in-an-exported-csv-file-opened-in-exc?rq=1


--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

[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/00b401d17337$3535aa40$9fa0fec0$@ozemail.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.

RE: How to allow multiple forms to update the same record pointer in a table

[Darren]

Joe

I just set up a very simple example to confirm behaviour and is as expected.


If the second form always comes up on the first record then something must
be changing the record pointer. I'd put a breakpoint in the button / code
where you launch the 2nd form and watch for a change in recno() and
see what the culprit is.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Monday, 29 February 2016 2:59 PM
To: profoxt...@leafe.com
Subject: Re: How to allow multiple forms to update the same record pointer
in a table

That all makes sense.  I added wait window alias() and wait window select()
statements in debug buttons on the forms.  They all agree that the same
table is selected in the same work area but the detail always comes up on
record one and the calling form refreshes back to the same record it was on
when the detail form was called. What else could I be overlooking?

Thanks,

Joe

On Sun, Feb 28, 2016 at 7:43 PM, Darren <fox...@ozemail.com.au> wrote:

> Assume : Using the same table / alias / workarea.
>
> Moving record in one form will move in the other form.
>
> I'm assuming you want first form to reflect the move in the second 
> then you'll need to refresh that first form when you move record 
> pointer on second form.
>
>
>
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of 
> Joe Yoder
> Sent: Monday, 29 February 2016 11:33 AM
> To: profoxt...@leafe.com
> Subject: How to allow multiple forms to update the same record pointer 
> in a table
>
> I have a form that displays basic information from a table in a list 
> box with its row source as table fields.  When the user clicks a 
> record in the list box another form comes up with complete detail for 
> the selected record displayed in text boxes with the table fields as 
> their control source.  The detail screen allows previous and next 
> choices that move the record pointer.
> There is also an exit button to return to the previous screen.
>
> Both forms are modal and use the default data session
>
> What do I need to do to have both screens use the same record pointer?
> Surely I don't need to pass a record number between screens?
>
> Thanks in advance,
>
> Joe
>
>
> --- 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/00c601d172a8$ba0d96e0$2e28c4a0$@ozemail.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.

RE: How to allow multiple forms to update the same record pointer in a table

[Darren]

Assume : Using the same table / alias / workarea. 

Moving record in one form will move in the other form. 

I'm assuming you want first form to reflect the move in the second then
you'll need to refresh that first form when you move record pointer on
second form.  



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Joe
Yoder
Sent: Monday, 29 February 2016 11:33 AM
To: profoxt...@leafe.com
Subject: How to allow multiple forms to update the same record pointer in a
table

I have a form that displays basic information from a table in a list box
with its row source as table fields.  When the user clicks a record in the
list box another form comes up with complete detail for the selected record
displayed in text boxes with the table fields as their control source.  The
detail screen allows previous and next choices that move the record pointer.
There is also an exit button to return to the previous screen.

Both forms are modal and use the default data session

What do I need to do to have both screens use the same record pointer?
Surely I don't need to pass a record number between screens?

Thanks in advance,

Joe


--- 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/008701d1728a$426da3f0$c748ebd0$@ozemail.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.

RE: Import/Export with CSV

[Darren]

Seems like excel is treating what looks like a number as number and
discarding insignificant digits.  

Have you tried importing the CSV and specifying the data type for each
column ? e.g Text import Wizard.



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze de
Boer
Sent: Monday, 29 February 2016 11:20 AM
To: profoxt...@leafe.com
Subject: Re: Import/Export with CSV

The Supplier code could be letters and number, just letters, or just
numbers.

The supplier code may be 12345.1234567890 It's nothing to do with decimal
point. It's a character.
If the code is ABC12345.1234567890 all is fine.

The import routine is append from file IMPFILE type csv



On Mon, Feb 29, 2016 at 1:15 PM, Joe Yoder  wrote:

> I only dabble with Excel but I suspect that you can get your expected 
> results by setting it up to use five decimal places instead of two.  I 
> thought you could convert it in Foxpro with str(val( '12345.56'), 10, 
> 5) but for some reason that only gives 4 decimal places even with 
> decimals set to 6.  I guess that leaves string manipulation where you 
> find the location of the dot from the right edge of the trimed string 
> with the RAT function and add as many zero as you need.
>
> I'm curious why the extra zeros are important.
>
> Joe
>
> On Sun, Feb 28, 2016 at 6:36 PM, Sytze de Boer 
> wrote:
>
> > I have a problem and I hope someone can help
> >
> > I export 3 fields to a CSV file
> > Code C(15), price N(10,2) , supcode C(30)
> >
> > The code and the supcode may be pure numbers Example supcode may be 
> > 12345.56000
> >
> > I make some changes to the price (using Excel) I now import from 
> > this same file and the supcode has changed to 12345.56
> >
> > Whats the best way to overcome this?
> >
> > --
> > Kind regards,
> > Sytze de Boer
> >
> >
> > --- 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/008601d17288$5dd11fc0$19735f40$@ozemail.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.

RE: VFP9 copy to clipboard causes VFP to 'hang' for long period

[Darren]

+1 - thanks Tracy !!!

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy
Pearson
Sent: Friday, 26 February 2016 10:29 AM
To: profoxt...@leafe.com
Subject: RE: VFP9 copy to clipboard causes VFP to 'hang' for long period

Mike Copeland wrote on 2016-02-25: 
>  Tracy,
>  
>  So far, so good. For anyone else interested...
>  
>  I first tried putting a CONFIG.FPW file containing the line  
> "resource=off" in the startup folder where VFP9.exe is located.
>  Sure enough, the copy command now worked fine but VFP was brain-dead,  
> not offering any help...like all the settings that I have grown to  
> depend having it remember. Not a good option. So I removed the  
> config.fpw file and everything went back to previous behavior 
> (including  the lock up on copy to clipboard.)
>  
>  Next, on Win 7 Pro, I fired up VFP and used the SYS(2005) function to  
> find the correct, actively-in-use FOXUSER file. It was in the hidden  
> User AppData Roaming folder.
>   c:\users\username\AppData\Roaming\Microsoft\Visual Foxpro 9  I 
> started up VFP, and issued the command "set resource off" from the  
> command line (otherwise the FOXUSER file is locked.)  Use/Opened the 
> table
>   use "c:\users\username\AppData\Roaming\Microsoft\Visual Foxpro  
> 9\foxuser.dbf" in 0 exclu  Deleted all rows with ID field matching 
> "WINDSNIP" or "SNIPLAST" (there  were over 100 out of a total of 300)  
> Packed the table.
>  Exited VFP and restarted VFP.
>  
>  Now, all my good stuff is remembered between sessions, and when I use  
> the COPY to CLIPBOARD it doesn't lock up.
>  
>  BTW, before the above 'fix' I had tried clicking the menu copy button 
> on  the toolbar, using the right-click copy option, and using CTRL+C 
> on the  keyboardall of them produced the same problem.
>  
>  Hopefully this will resolve the "COPY OUT TO LUNCH" problem.
>  
>  Thanks again, Tracy!
>  
>  Mike Copeland
>  

Mike,

Awesome. It's good to hear it worked for you.

Tracy Pearson
PowerChurch Software


[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/003601d17024$b014ecf0$103ec6d0$@ozemail.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.

RE: VFP9 copy to clipboard causes VFP to 'hang' for long period

[Darren]

No solution ... but I have a similar issue and have just worked around it -
if I have a VFP app running and I try to use VFP itself (command window, prg
editing etc) then any use of the clipboard just takes forever. Be interested
to see if anyone else has the issue. The work around is to run the
application on a different machine.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Mike
Copeland
Sent: Friday, 26 February 2016 6:58 AM
To: profoxt...@leafe.com
Subject: VFP9 copy to clipboard causes VFP to 'hang' for long period

I've had this annoyance for years...but it recently got really bad.

When I have a code window open (like for a form method) and I highlight a
word or string of word in the program code, as soon as I CTRL+C or click the
copy icon on the toolbar, VFP goes to lunch..."Not Responding"...window goes
white-ish.

If I let it sit, long enough (like up to 5 minutes), it will eventually
recover...until I commit the same mistake of trying to copy text to the
clipboard. (Which I do in order to search for other occurrences, etc.)

I had this trouble in the past and I finally decided to try the NUKE
solution and deleted the FOXUSER.DBF file.
BOING! Fixed that problem! Copy works like a big dog on steriods now!
Unfortunately, it also dumped all of the other 3000+ settings and things VFP
keeps track of for reuse later. Things like smartcomplete where you type
"do" and it pops up a list of all the programs you've recently
run...which I depend on a lot!

After a while, that good stuff builds back up and things are good again, but
the COPY to clipboard seems to be even worse now (freezing for even longer
periods.)

So, my question: Is there a way, like PACKing or deleting a certain row in
the FOXUSER file, to get the COPY to clipboard to work as it should but
without loosing all the good stuff VFP remembers? (like projects recently
worked on, etc.)

Thanks for any guidance...heck I'll even take a LMGTFY or three if it helps!

Mike Copeland

[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/001b01d17009$ed913c70$c8b3b550$@ozemail.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.

RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of ListBoxes)

[Darren]

Might be to do with focus. 

>From Help:
The ActiveRow property does not return the same value as RECNO( ) in an
indexed table. ActiveRow returns zero if the grid doesn't have the focus or
when you access a row outside the grid display.


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt
Wendt
Sent: Saturday, 30 January 2016 9:42 AM
To: profoxt...@leafe.com
Subject: RE: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of
ListBoxes)

OK - strangely enough - when I was trying to review the issues and stepping
thru the Method where the main processing takes place - that ActiveRow kept
showing as Zero. But, now, in that Method - I simply put in a Wait statement
and have it report what the ActiveRow - and now its showing a proper record
# value. Very strange...

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt
Wendt
Sent: Friday, January 29, 2016 5:20 PM
To: profoxt...@leafe.com
Subject: Multi-Select Grid & Foxite Code Issue (Was...RE: A Question of
ListBoxes)

Hey Ted,

Thanks for "Getting That For me". 

So - yes, I decided to go the Grid route on this issue. I did look at the
1001/Ch 6 - but, in the webpage it refers to using sample code that came
with the book. 

However, I saw one of the links above it - from Foxite. I decided to
implement that code. To be honest - I hadn't sub-classed before, but, I
figured it out and made a Grid sub-class. 

However, I'm having a problem in implementing the code. I implemented
everything as stated on this webpage:
 https://www.foxite.com/faq/default.aspx?id=3#

I believe I implemented all the code correctly. However, I'm having a
problem with the following lines:
WITH THIS
.nActiveRow  = IIF(.ACTIVEROW = 0, .nActiveRow ,.ACTIVEROW) &&
Assign value to class property

Originally the 2nd line above was as follows:
.nActiveRow  =.ACTIVEROW  && Assign value to class property

The problem is - value in ACTIVEROW is Always Zero (a property in the Grid
). I have NO Idea why its always Zero. In theory - if I change to another
record - it should be giving the record #. 

Any suggestions would be greatly appreciated. 

Regards,
Kurt



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Thursday, January 28, 2016 4:50 PM
To: profoxt...@leafe.com
Subject: Re: A Question of ListBoxes...

On Thu, Jan 28, 2016 at 4:04 PM, Kurt Wendt  wrote:
>
> To a certain extent - I agree. If they want a Grid - maybe I should give
them one. That being said - I don't think there is a straightforward way in
a Grid to Select Multiple items.  Am I wrong? Although - After writing the
last 2 sentences - some ideas were rolling around in my head about
implementing a multi-select in a Grid. Since, at least with me - I know
anything is possible - as I've done some interesting screen designs in the
past!
>

Forgive me, but the answer is obviously: http://bfy.tw/3yWI

and again, I recommend 1001, Chapter 6 this time.

--
Ted Roche & Associates, LLC
http://www.tedroche.com

[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/004901d15ae6$c0537d50$40fa77f0$@ozemail.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.

RE: Norton will not let me send EXE - Need help fast

[Darren]

+1

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken
McGinnis
Sent: Tuesday, 19 January 2016 11:05 AM
To: profoxt...@leafe.com
Subject: Re: Norton will not let me send EXE - Need help fast

Best to advise your clients to get rid of the Norton crap and get something
like Avast. You can easily disable all their sandbox and other useless crap,
unlike Norton and McAfee

On 1/18/2016 13:31 PM, Ted Roche wrote:
> So, software that is supposed to be helping you is preventing you from 
> doing your job?
>
> Delete it.
>
> You could also try ZIPping the EXE.
>
> On Mon, Jan 18, 2016 at 4:26 PM, John Weller 
wrote:
>> How did you send it?  Because of the vagaries of various email clients,
etc I now use a shared folder in Dropbox to transfer exe files to a client.
>>
>> John Weller
>> 01380 723235
>> 07976 393631
>>
>>> I zip up an exe and send it to my customer as I have done for years.
>>> Last week, Norton would not let my customer unzip it.  The "Run 
>>> anyway" did not work.  Norton deleted the exe.
>>> So I gave the exe a txt extension.  Same thing.  Did not even let us 
>>> rename it to exe.  It deleted is.
>>> We both have the latest version of Norton.
>>
[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/006701d1524d$60b243f0$2216cbd0$@ozemail.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.

RE: OLE drag drop

[Darren]

http://www.aksel.com/whitepapers/dragdrop.htm



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kent
Belan
Sent: Thursday, 19 November 2015 3:36 AM
To: profoxt...@leafe.com
Subject: RE: OLE drag drop

More info:

I am testing "Fun with OLE drag and drop" from the Solution.app in the
Programming section.

I can not get it to drop a file from windows explorer. All I get is the
circle with a slash thru it.

Is there some setting with Windows 10 or VFP9 that I need to change to get
it to OLE drop ?



-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kent Belan
Sent: Wednesday, November 18, 2015 10:12 AM
To: 'ProFox Email List' 
Subject: OLE drag drop

Hello,

I have been asked to put a drag/drop option on one of my VFP9 forms that
asks for file names.

I have a test form with a text box set to OLEDragMode=1 Automatic and
OLEDropMode=1 Enabled and the form OLEDropMode=2 Pass to Container.

But when I try to drag a file from Windows Explorer all I get is a circle
with a slash thru it, so the drag/drop is not working

What is the trick to get the form to accept the dropped file ?

Thanks,
Kent


[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/009201d1$dc6bf4b0$9543de10$@ozemail.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.

RE: FPD 2.6 test for a drive without crashing

[Darren]

If I remember correctly (been a while since using FPD) trapping errors ..

Something like

ON ERROR x=1
X=0
Do command
If x=1
Handle error
endif

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Darren
Sent: Sunday, 25 October 2015 9:44 AM
To: profoxt...@leafe.com
Subject: RE: FPD 2.6 test for a drive without crashing

John

Is it a mapped drive or UNC + share ?


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John R.
Sowden
Sent: Sunday, 25 October 2015 9:29 AM
To: profoxt...@leafe.com
Subject: FPD 2.6 test for a drive without crashing

Is there is way in FPD 2.6 to test to see if a drive is working without
having the program crash.  I have a network where I test for a remote drive
(peer to peer net) before attempting to connect to it.  I set a variable
(above is done in the autoexec.bat) re: the sytatus of the remove node being
on line.  If there is a change in the drive, such as a reboot of the remote
computer, the environment variable does not change, but the drive is no
longer accessible. When I am in fpd, I want to confirm the drive is
available before using it so it doesn't crash.  I checked the sys()
functions, but none seem to meet the concern.

John


[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/004f01d10eae$14105c90$3c3115b0$@ozemail.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.

RE: FPD 2.6 test for a drive without crashing

[Darren]

John

Is it a mapped drive or UNC + share ?


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of John R.
Sowden
Sent: Sunday, 25 October 2015 9:29 AM
To: profoxt...@leafe.com
Subject: FPD 2.6 test for a drive without crashing

Is there is way in FPD 2.6 to test to see if a drive is working without
having the program crash.  I have a network where I test for a remote drive
(peer to peer net) before attempting to connect to it.  I set a variable
(above is done in the autoexec.bat) re: the sytatus of the remove node being
on line.  If there is a change in the drive, such as a reboot of the remote
computer, the environment variable does not change, but the drive is no
longer accessible. When I am in fpd, I want to confirm the drive is
available before using it so it doesn't crash.  I checked the sys()
functions, but none seem to meet the concern.

John


[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/004501d10ead$860bb3e0$92231ba0$@ozemail.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.

Re: FPD 2.6 test for a drive without crashing

[Darren]

SXMgaXQgYSBtYXBwZWQgZHJpdmUgb3IgdW5jIMKgKyBzaGFyZSA/CgoKV2FybSByZWdhcmRzCkRh
cnJlbgoKPGRpdj4tLS0tLS0tLSBPcmlnaW5hbCBtZXNzYWdlIC0tLS0tLS0tPC9kaXY+PGRpdj5G
cm9tOiAiSm9obiBSLiBTb3dkZW4iIDxqc293ZGVuQGFtZXJpY2Fuc2VudHJ5Lm5ldD4gPC9kaXY+
PGRpdj5EYXRlOjI1LzEwLzIwMTUgIDA4OjI4ICAoR01UKzEwOjAwKSA8L2Rpdj48ZGl2PlRvOiBw
cm9mb3h0ZWNoQGxlYWZlLmNvbSA8L2Rpdj48ZGl2PkNjOiAgPC9kaXY+PGRpdj5TdWJqZWN0OiBG
UEQgMi42IHRlc3QgZm9yIGEgZHJpdmUgd2l0aG91dCBjcmFzaGluZyA8L2Rpdj48ZGl2Pgo8L2Rp
dj5JcyB0aGVyZSBpcyB3YXkgaW4gRlBEIDIuNiB0byB0ZXN0IHRvIHNlZSBpZiBhIGRyaXZlIGlz
IHdvcmtpbmcgd2l0aG91dCAKaGF2aW5nIHRoZSBwcm9ncmFtIGNyYXNoLiAgSSBoYXZlIGEgbmV0
d29yayB3aGVyZSBJIHRlc3QgZm9yIGEgcmVtb3RlIApkcml2ZSAocGVlciB0byBwZWVyIG5ldCkg
YmVmb3JlIGF0dGVtcHRpbmcgdG8gY29ubmVjdCB0byBpdC4gIEkgc2V0IGEgCnZhcmlhYmxlIChh
Ym92ZSBpcyBkb25lIGluIHRoZSBhdXRvZXhlYy5iYXQpIHJlOiB0aGUgc3l0YXR1cyBvZiB0aGUg
CnJlbW92ZSBub2RlIGJlaW5nIG9uIGxpbmUuICBJZiB0aGVyZSBpcyBhIGNoYW5nZSBpbiB0aGUg
ZHJpdmUsIHN1Y2ggYXMgYSAKcmVib290IG9mIHRoZSByZW1vdGUgY29tcHV0ZXIsIHRoZSBlbnZp
cm9ubWVudCB2YXJpYWJsZSBkb2VzIG5vdCBjaGFuZ2UsIApidXQgdGhlIGRyaXZlIGlzIG5vIGxv
bmdlciBhY2Nlc3NpYmxlLiBXaGVuIEkgYW0gaW4gZnBkLCBJIHdhbnQgdG8gCmNvbmZpcm0gdGhl
IGRyaXZlIGlzIGF2YWlsYWJsZSBiZWZvcmUgdXNpbmcgaXQgc28gaXQgZG9lc24ndCBjcmFzaC4g
IEkgCmNoZWNrZWQgdGhlIHN5cygpIGZ1bmN0aW9ucywgYnV0IG5vbmUgc2VlbSB0byBtZWV0IHRo
ZSBjb25jZXJuLgoKSm9obgoKCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fClBvc3QgTWVzc2FnZXMgdG86IFByb0ZveEBsZWFmZS5jb20KU3Vic2NyaXB0aW9u
IE1haW50ZW5hbmNlOiBodHRwOi8vbWFpbC5sZWFmZS5jb20vbWFpbG1hbi9saXN0aW5mby9wcm9m
b3gKT1QtZnJlZSB2ZXJzaW9uIG9mIHRoaXMgbGlzdDogaHR0cDovL21haWwubGVhZmUuY29tL21h
aWxtYW4vbGlzdGluZm8vcHJvZm94dGVjaApTZWFyY2hhYmxlIEFyY2hpdmU6IGh0dHA6Ly9sZWFm
ZS5jb20vYXJjaGl2ZXMvc2VhcmNoL3Byb2ZveApUaGlzIG1lc3NhZ2U6IGh0dHA6Ly9sZWFmZS5j
b20vYXJjaGl2ZXMvYnlNSUQvcHJvZm94LzU2MkMwNjEwLjIwMjA5MDNAYW1lcmljYW5zZW50cnku
bmV0CioqIEFsbCBwb3N0aW5ncywgdW5sZXNzIGV4cGxpY2l0bHkgc3RhdGVkIG90aGVyd2lzZSwg
YXJlIHRoZSBvcGluaW9ucyBvZiB0aGUgYXV0aG9yLCBhbmQgZG8gbm90IGNvbnN0aXR1dGUgbGVn
YWwgb3IgbWVkaWNhbCBhZHZpY2UuIFRoaXMgc3RhdGVtZW50IGlzIGFkZGVkIHRvIHRoZSBtZXNz
YWdlcyBmb3IgdGhvc2UgbGF3eWVycyB3aG8gYXJlIHRvbyBzdHVwaWQgdG8gc2VlIHRoZSBvYnZp
b3VzLgoKUmVwb3J0IFtPVF0gQWJ1c2U6IGh0dHA6Ly9sZWFmZS5jb20vcmVwb3J0QWJ1c2UvNTYy
QzA2MTAuMjAyMDkwM0BhbWVyaWNhbnNlbnRyeS5uZXQK


--- 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/ae84nc0nxpir3mvqut35ume7.1445726006...@email.android.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: BITRSHIFT(n,1) v n/2

[Darren]

On my machine - I did 4 cases of dividing 40 by 2 and the slowest was  x =
BITRSHIFT(40,2)

Based on 1,000,000 iterations for each I get the following timings ...

x = 40 / 4  .. 0.1070546391
STORE 40 / 4 TO x   .. 0.0636483880
x = BITRSHIFT(40,2) .. 0.1302353828
STORE BITRSHIFT(40,2) TO x  .. 0.0844159499

I don't think the difference is too dramatic.

If I change the 40 to 51.2 the figures are slightly higher but in same
proportions to each other | x = BITRSHIFT(51.2,2) is still the slowest (and
of course inaccurate)

Changing to 2E9 I get pretty much the same timings as the first set.


Code I used  .

ACTIVATE SCREEN 
CLEAR

SET DECIMALS TO 8

DECLARE INTEGER QueryPerformanceCounter IN C:\Windows\SysWow64\kernel32.dll;
  STRING @lpPerformanceCount

DECLARE INTEGER QueryPerformanceFrequency IN
C:\Windows\SysWow64\kernel32.dll;
  STRING @lpFrequency

*- Get Timer Resolution / Frequency
lcBuffer = REPLICATE(CHR(0), 8)
QueryPerformanceFrequency(@lcBuffer)
lnFrequency = buf2dword(SUBSTR(m.lcBuffer, 1, 4)) +
buf2dword(SUBSTR(m.lcBuffer, 5, 4)) * 4294967296  
  
*
*- Case 1 | x = 2E9 / 4
*
STORE REPLICATE(CHR(0), 8) TO lcBuffer1, lcBuffer2

QueryPerformanceCounter(@lcBuffer1)

FOR n = 1 TO 100
  x = 2E9 / 4
ENDFOR 
 
QueryPerformanceCounter(@lcBuffer2)

lnStart = (buf2dword(SUBSTR(m.lcBuffer1, 1, 4)) +
buf2dword(SUBSTR(m.lcBuffer1, 5, 4)) * 4294967296) / m.lnFrequency
lnEnd   = (buf2dword(SUBSTR(m.lcBuffer2, 1, 4)) +
buf2dword(SUBSTR(m.lcBuffer2, 5, 4)) * 4294967296) / m.lnFrequency

?x, lnEnd - lnStart

*
*- Case 2 | STORE 2E9 / 4 TO x
*
STORE REPLICATE(CHR(0), 8) TO lcBuffer1, lcBuffer2

QueryPerformanceCounter(@lcBuffer1)

FOR n = 1 TO 100
  STORE 2E9 / 4 TO x
ENDFOR   
 
QueryPerformanceCounter(@lcBuffer2)

lnStart = (buf2dword(SUBSTR(m.lcBuffer1, 1, 4)) +
buf2dword(SUBSTR(m.lcBuffer1, 5, 4)) * 4294967296) / m.lnFrequency
lnEnd   = (buf2dword(SUBSTR(m.lcBuffer2, 1, 4)) +
buf2dword(SUBSTR(m.lcBuffer2, 5, 4)) * 4294967296) / m.lnFrequency

?x, lnEnd - lnStart


*
*- Case 3 | x = BITRSHIFT(2E9,2)
*
STORE REPLICATE(CHR(0), 8) TO lcBuffer1, lcBuffer2

QueryPerformanceCounter(@lcBuffer1)

FOR n = 1 TO 100
  x = BITRSHIFT(2E9,2)
ENDFOR   
 
QueryPerformanceCounter(@lcBuffer2)

lnStart = (buf2dword(SUBSTR(m.lcBuffer1, 1, 4)) +
buf2dword(SUBSTR(m.lcBuffer1, 5, 4)) * 4294967296) / m.lnFrequency
lnEnd   = (buf2dword(SUBSTR(m.lcBuffer2, 1, 4)) +
buf2dword(SUBSTR(m.lcBuffer2, 5, 4)) * 4294967296) / m.lnFrequency

?x, lnEnd - lnStart


*
*- Case 4 | STORE BITRSHIFT(2E9,2) TO x
*
STORE REPLICATE(CHR(0), 8) TO lcBuffer1, lcBuffer2

QueryPerformanceCounter(@lcBuffer1)

FOR n = 1 TO 100
  STORE BITRSHIFT(2E9,2) TO x
ENDFOR   
 
QueryPerformanceCounter(@lcBuffer2)

lnStart = (buf2dword(SUBSTR(m.lcBuffer1, 1, 4)) +
buf2dword(SUBSTR(m.lcBuffer1, 5, 4)) * 4294967296) / m.lnFrequency
lnEnd   = (buf2dword(SUBSTR(m.lcBuffer2, 1, 4)) +
buf2dword(SUBSTR(m.lcBuffer2, 5, 4)) * 4294967296) / m.lnFrequency

?x, lnEnd - lnStart
_cliptext = transform(lnEnd - lnstart)


FUNCTION buf2dword (vcBuffer)

  RETURN ASC(SUBSTR(m.vcBuffer, 1,1)) + ;
BITLSHIFT(ASC(SUBSTR(m.vcBuffer, 2,1)),  8) +;
BITLSHIFT(ASC(SUBSTR(m.vcBuffer, 3,1)), 16) +;
BITLSHIFT(ASC(SUBSTR(m.vcBuffer, 4,1)), 24)

ENDFUNC


 

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Laurie
Alvey
Sent: Thursday, 30 July 2015 7:58 PM
To: profoxt...@leafe.com
Subject: Re: BITRSHIFT(n,1) v n/2

Interesting. If I issue ? CAST(8E9 As I) it displays a negative 9 digit
number (-589934592). Also, I thought the limit for 32 bit integers was about
2E9.

Laurie

On 29 July 2015 at 13:42, Jean MAURICE jsm.maur...@wanadoo.fr wrote:

 Hi Laurie,
 I do think that BITRSHIFT is a lot quicker than /2. BITRSHIFT can be 
 done with only one machine cycle (clock tic); the division is a lot more
complex.

 BUT !
 this is true only if K is an integer (k = CAST(8E9 AS integer)). 
 Otherwise you must add add the conversion time between numeric and
integer.

 You can also add a third test : k * .5 sould be faster than k /2

 The Foxil
 Old enough to know how microprocessors work !


[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: 

RE: RTRIM() of cursor data using _VFP.DataToClip() ?

[Darren]

Ted,

This works ok for me here (haven't you heard that before)

SELECT cCursor
COPY TO cTempFile DELIMITED WITH TAB
_CLIPTEXT = FILETOSTR(cTempFile)

Paste the clipboard to Excel
Delete the temp file.

Cheers

Darren
 
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Wednesday, 15 July 2015 11:28 PM
To: profoxt...@leafe.com
Subject: Re: RTRIM() of cursor data using _VFP.DataToClip() ?

That's pretty good, although it doesn't solve the DataToClip()  issue, as I
indicate earlier.

Your process issues a REPLACE for each varchar field in the cursor.
You might speed it up a bit, especially on large disc-bound datasets with
many varchars, by concatenating all of the REPLACEs into one
command:

LOCAL ARRAY laCols[1,18]
LOCAL n As Integer, i As Integer, lcFld As String, lcCommand AS String n =
AFIELDS(laCols,tcCursor) lcCommand = REPLACE ALL 
FOR i = 1 TO n
IF laCols[i,2] == V
lcFld = laCols[i,1]
lcCommand = lcCommand + (+lcFld+) WITH ALLTRIM(EVALUATE(+lcFld+)),
ENDIF
ENDFOR
if len(lcCommand)  len(REPLACE ALL )
  lcCommand = left(lcCommand,len(lcCommand)-1)   drop last comma
  lcCommand
endif
ENDFUNC   CTOV

On Wed, Jul 15, 2015 at 7:39 AM, Laurie Alvey trukke...@gmail.com wrote:
 I have this function to TRIM all varchar fields in a cursor:

 FUNCTION CTOV(tcCursor As String) As VOID
 **
 ***
 * Date : 19/06/2014, 11:13:27
 * Author : Laurie Alvey
 * Description: Replace all varchar columns with their TRIMmed contents
 * Parameters : Name of the open cursor on which to operate. -
 *
 **
 ***
 LOCAL ARRAY laCols[1,18]
 LOCAL n As Integer, i As Integer, lcFld As String n = 
 AFIELDS(laCols,tcCursor) FOR i = 1 TO n IF laCols[i,2] == V
 lcFld = laCols[i,1]
 REPLACE (lcFld) WITH ALLTRIM(EVALUATE(lcFld)) ALL ENDIF ENDFOR ENDFUNC  
  CTOV

 Laurie


 On 14 July 2015 at 12:31, Peter Cushing pcush...@whisperingsmith.com
 wrote:

 On 13/07/2015 18:09, Ted Roche wrote:

 I thought about the TESTMERGE solution, and I do use that in some 
 parts of the app, where the client has to interface with some 
 dedicated hardware that has *WEIRD* formatting rules, but hadn't 
 considered that here. If I can get away with Tracy's solution of 
 hacking at _ClipText, I'll probably stick with it.

  You could always import the data with wide fields, calculate the 
 maximum
 widths, then create a custom cursor and import again.

 Peter





 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


[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/001801d0bf2f$acffd580$06ff8080$@ozemail.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.

RE: RTRIM() of cursor data using _VFP.DataToClip() ?

[Darren]

Try using M instead of C(30) for the cursor.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Tuesday, 14 July 2015 3:10 AM
To: profoxt...@leafe.com
Subject: Re: RTRIM() of cursor data using _VFP.DataToClip() ?

Yet another great idea!

VFP 9 SP2-ish (can't recall which HotFixes...) 09.00..5815 on this
machine.

If I SETVARCHARMAPPING ON and change the field arguments to
RTRIM(field) as field, I get VarChar results. Using DataToClip I get...
fixed columns widths again, darn. Not what I would have expected.

I thought about the TESTMERGE solution, and I do use that in some parts of
the app, where the client has to interface with some dedicated hardware that
has *WEIRD* formatting rules, but hadn't considered that here. If I can get
away with Tracy's solution of hacking at _ClipText, I'll probably stick with
it.


On Mon, Jul 13, 2015 at 12:17 PM, Richard Kaye rk...@invaluable.com wrote:
 What version of VFP are you using?
 If you set the VFP data type to VARCHAR instead of CHAR how does that
affect the behavior of DataToClip (one of my favorite functions for quick
and dirty stuff)?

 I think you've probably got the best solution. Alternatively you could use
TEXTMERGE inside a SCAN..ENDSCAN of your result cursor and build the file
yourself instead of using DTC.



--
Ted Roche
Ted Roche  Associates, LLC
http://www.tedroche.com

[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/023d01d0bdab$77afc690$670f53b0$@ozemail.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.

Re: SET RELATION TO and multiple detail report bands in VFP9SP2 RW

[Darren]

Mike it's been a while since I've done one with multiple detail bands but yes I 
believe you need to use both SET RELATION and SET SKIP. 


Warm regards
Darren

div Original message /divdivFrom: 
mbsoftwaresoluti...@mbsoftwaresolutions.com /divdivDate:08/07/2015  15:33  
(GMT+10:00) /divdivTo: profoxt...@leafe.com /divdivCc:  
/divdivSubject: Re: SET RELATION TO and multiple detail report bands in 
VFP9SP2 RW /divdiv
/divHi Darren,

Thanks for the reply.  Do you have to use SET SKIP also?

tia,
--Mike


On 2015-07-07 19:22, Darren wrote:
 Set relation and set skip.
 
 div Original message /divdivFrom:
 mbsoftwaresoluti...@mbsoftwaresolutions.com /divdivDate:08/07/2015
  09:13  (GMT+10:00) /divdivTo: profoxt...@leafe.com /divdivCc:
  /divdivSubject: SET RELATION TO and multiple detail report bands
 in VFP9SP2 RW /divdiv
 /divI have a need to use the new (lol) multiple detail band feature 
 in the
 new VFP9 Report Writer.  Honestly, I had a bad experience with SET
 RELATION back in the VFP6 days, and once I changed from direct table
 mappings in the app to Local Views, I happily dumped SET RELATION.
 
 This app has a hierarchy like this:
   Job
   --Items
   --Fees
 
 I want to create a report that uses one detail band for the Items, and
 one detail band for the Fees.
 
 Has anyone done this successfully and have any tips?  Wanted to tap
 someone's positive experiences with it.  (Typically, I always created a
 single flat file for reporting.)
 
 tia,
 --Mike
 
 
[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/8ff8d91dac879b1b594c05fc83515...@mbsoftwaresolutions.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/8ff8d91dac879b1b594c05fc83515...@mbsoftwaresolutions.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/771au79o1lklywrgcpgmuku8.1436352880...@email.android.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: SET RELATION TO and multiple detail report bands in VFP9SP2 RW

[Darren]

Set relation and set skip.

div Original message /divdivFrom: 
mbsoftwaresoluti...@mbsoftwaresolutions.com /divdivDate:08/07/2015  09:13  
(GMT+10:00) /divdivTo: profoxt...@leafe.com /divdivCc:  
/divdivSubject: SET RELATION TO and multiple detail report bands in VFP9SP2 
RW /divdiv
/divI have a need to use the new (lol) multiple detail band feature in the 
new VFP9 Report Writer.  Honestly, I had a bad experience with SET 
RELATION back in the VFP6 days, and once I changed from direct table 
mappings in the app to Local Views, I happily dumped SET RELATION.

This app has a hierarchy like this:
  Job
  --Items
  --Fees

I want to create a report that uses one detail band for the Items, and 
one detail band for the Fees.

Has anyone done this successfully and have any tips?  Wanted to tap 
someone's positive experiences with it.  (Typically, I always created a 
single flat file for reporting.)

tia,
--Mike


___
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/36afdb0074ad92c34c88e79ddd82b...@mbsoftwaresolutions.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/36afdb0074ad92c34c88e79ddd82b...@mbsoftwaresolutions.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/i6farhrges22ua37ur3wp07n.1436311379...@email.android.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: VFP Migration to MS SQL a Difficult Screen...

[Darren]

What's .Net :)

div Original message /divdivFrom: Kurt Wendt 
kurt_we...@globetax.com /divdivDate:23/06/2015  15:33  (GMT+01:00) 
/divdivTo: profoxt...@leafe.com /divdivSubject: RE: VFP Migration to MS 
SQL  a Difficult Screen... /divdiv
/divActually - I'm not using .Net at all. Other developers are - and other 
systems here are. Just not the systems I am working on...

-K-
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke
Sent: Tuesday, June 23, 2015 3:58 AM
To: profoxt...@leafe.com
Subject: Re: VFP Migration to MS SQL  a Difficult Screen...

On Mon, 22 Jun 2015, at 04:02 PM, Dave Crozier wrote:
 As alan says, there has been a complete about turn on ODBC by 
 Microsoft who originally regarded it as the spawn of the devil but now 
 agree that maybe the rest of the world does have a point.

If you're using .NET to connect to SQL Server why would you have the additional 
layer of ODBC/OLEDB when you could just use the .NET Framework Provider for SQL 
Server which is built in ? 

--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

[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/80838f1ca795b14ea1af48659f35166f1c2...@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.

Report [OT] Abuse: 
http://leafe.com/reportAbuse/80838f1ca795b14ea1af48659f35166f1c2...@drexch02.corp.globetax.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/bnjgfiutwdseum0qnqvo9yat.1435067941...@email.android.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: How to find the full computer name

[Darren]

? GETENV(COMPUTERNAME)

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul
Newton
Sent: Tuesday, 16 June 2015 9:41 PM
To: profoxt...@leafe.com
Subject: RE: How to find the full computer name

Great - Thanks Alan

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan
Bourke
Sent: 16 June 2015 12:27
To: profoxt...@leafe.com
Subject: Re: How to find the full computer name

Take a look at:

http://www.news2news.com/vfp/index.php?example=41


--
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm

On Tue, 16 Jun 2015, at 12:18 PM, Paul Newton wrote:
 Hi all
 
 I need to determine the full computer name e.g. 
 mycompu...@mydomain.com
 
 Any ideas?  I was thinking maybe WSH or WMI but can't find the 
 necessary information ...
 
 Many thanks
 
[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/007801d0a840$affe0d20$0ffa2760$@ozemail.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.

Re: Beautify on the fly defined

[Darren]

Yes. Absolutely!!


Warm regards
Darren

div Original message /divdivFrom: Wes Wilson 
erwweswil...@yahoo.com /divdivDate:07/06/2015  13:48  (GMT+01:00) 
/divdivTo: profoxt...@leafe.com /divdivSubject: Beautify on the fly 
defined /divdiv
/divConverting VFP to .NET
I am writing a program to help .NET programmers.   The program I am writing is 
looking a over 1,000 FRXs and about 2,000 SCX's.  It opens all of them in  a 
loop and creates a TXT file for each FRX and each SCX.  It also automatically 
creates a JPG of the screen when the FRX or SCX is open for editing.  Any of 
these can be quickly found and then fully documented on demand.
Every property and method is being outputted to a TXT file in an organized 
fashion.   This means the programmer does not have to modi form abc.  Nor does 
he have to bring it up to see its appearance. However, I want to beautify the 
methods before I output them.  
So my question is, can I beautify each method before I send it to the TXT file 
without any operatory intervention.   
Wes Wes Wilson, President   ERW Custom Programming, Inc. Crescent Lake Plaza
5459  Elizabeth Lake Rd.
Waterford, MI 48327 
(248) 683-4182 
www.visual-foxpro-programmer.com
www.erw.com weswil...@erw.com  
  From: profox-requ...@leafe.com profox-requ...@leafe.com
To: profox@leafe.com 
Sent: Friday, June 5, 2015 5:36 PM
Subject: ProFox Digest, Vol 146, Issue 10
   
- Forwarded Message -

Send ProFox mailing list submissions to
profox@leafe.com

To subscribe or unsubscribe via the World Wide Web, visit
http://mail.leafe.com/mailman/listinfo/profox
or, via email, send a message with subject or body 'help' to
profox-requ...@leafe.com

You can reach the person managing the list at
profox-ow...@leafe.com

When replying, please edit your Subject line so it is more specific
than Re: Contents of ProFox digest...

Today's Topics:

  1. Re: [NF] All OSs are malware (Alan Bourke)
  2. Can I Beautify on the fly? (Wes Wilson)
  3. RE: Can I Beautify on the fly? (Kurt Wendt)
  4. Re: Can I Beautify on the fly? (Kevin Cully)
  5. RE: Can I Beautify on the fly? (Kurt Wendt)
  6. RE: Can I Beautify on the fly? (Richard Kaye)
  7. RE: [NF] Powershell behind the objects (Kurt Wendt)
  8. PACK AND ALL THAT (Tormey)
  9. RE: PACK AND ALL THAT (Allen)
  10. RE: PACK AND ALL THAT (Tracy Pearson)
  11. Re: PACK AND ALL THAT (Koen Piller)
  All cryptographic code goes as source code to NSA and is returned as 
 object code to be used by windows

Does it? Source?

-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm



I am reading in over 100,000 lines of code from thousands of methods and 
outputting them to a text file.
Is there a way I can beautify on the fly
e.g.
PROCEDURE click
if a = ba = cendif
ENDPROC
 I would like to output this:
 PROCEDURE click

if a = ba = cendif
ENDPROC

Wes Wilson, President  ERW Custom Programming, Inc. Crescent Lake Plaza
5459  Elizabeth Lake Rd.
Waterford, MI 48327 
(248) 683-4182 
www.visual-foxpro-programmer.com
www.erw.com weswil...@erw.com  
  From: profox-requ...@leafe.com profox-requ...@leafe.com
To: profox@leafe.com 
Sent: Friday, June 5, 2015 10:43 AM
Subject: ProFox Digest, Vol 146, Issue 9
  
- Forwarded Message -

Send ProFox mailing list submissions to
profox@leafe.com

To subscribe or unsubscribe via the World Wide Web, visit
http://mail.leafe.com/mailman/listinfo/profox
or, via email, send a message with subject or body 'help' to
profox-requ...@leafe.com

You can reach the person managing the list at
profox-ow...@leafe.com

When replying, please edit your Subject line so it is more specific
than Re: Contents of ProFox digest...

Today's Topics:

  1. zip/unzip (Rafael Copquin)
  2. RE: zip/unzip (Kurt Wendt)
  3. Re: zip/unzip (Mike Copeland)
  4. Re: zip/unzip (Kevin Cully)
  5. RE: [NF] Win10 what you will lose in the OS update (Richard Kaye)
  6. Re: zip/unzip (Rafael Copquin)
  7. Re: zip/unzip (Laurie Alvey)
  8. Re: zip/unzip (Kevin Cully)
  9. Re: zip/unzip (Fernando D. Bozzo)
  10. Re: [NF] All OSs are malware (Ricardo Araoz)
  11. [NF] Powershell behind the objects (Stephen Russell)
  12. Re: [NF] All OSs are malware (Alan Bourke)
Years ago I had obtained a zip/unzip class from someone in this forum.
It would zip the database,tables and index files and place the zip file 
in a folder. And then one could unzip the files back to the tables 
folder, all of this automatically.

But I lost it and need something like that to include as a 
backup/recover routine in one of my programs

Rafael Copquin




I swear that sounds like something that is available in the Downloads section 
of the ProFox forum. You might want to check there first. 

Just a thought...

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Rafael 
Copquin
Sent: Thursday, June 04, 2015 2:59 PM
To: profoxt...@leafe.com
Subject: zip/unzip

Years ago I had obtained a zip

RE: App

[Darren]

Interestingly if I reply using my mobile phone (Android) the same static
happens for me too.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Sunday, 31 May 2015 10:28 AM
To: profoxt...@leafe.com
Subject: Re: App

Jeff:

You may need to adjust your rabbit ears a bit. All we got was static.


On Sat, May 30, 2015 at 6:51 PM, jeff j...@san-dc.com wrote:
 SSdsbCB0cnkgdGhhdCByb3V0ZS4gwqBUaGFua3MuCgoKU2VudCBmcm9tIG15IFQtTW9iaW
 xlIDRH 
 IExURSBEZXZpY2UKCi0tLS0tLS0tIE9yaWdpbmFsIG1lc3NhZ2UgLS0tLS0tLS0KRnJvbT
 ogVGVk
 IFJvY2hlIDx0ZWRyb2NoZUBnbWFpbC5jb20+IApEYXRlOjA1LzMwLzIwMTUgIDExOjE3IC
 IFJvY2hlIDx0ZWRyb2NoZUBnbWFpbC5jb20+AoR01U
 LTA3OjAwKSAKVG86IHByb2ZveHRlY2hAbGVhZmUuY29tIApTdWJqZWN0OiBSZTogQXBwIA
 oKQ2Fu
 IGl0IGJlIGRpc3BsYXllZCBpbiBhIHdlYiBicm93c2VyPyBDYW4gaXQgYmUgYWNjZXNzaW
 JsZSB2 
 aWEgdGhlIHdlYj8KClVzaW5nIGluZHVzdHJ5LXN0YW5kYXJkIEhUTUwgcHJvdmlkZXMgZm
 FyLW1v 
 cmUgZnV0dXJlLXByb29maW5nIHRoYW4KZGVzaWduaW5nIGZvciB0aGUgZGV2aWNlLWR1LW
 pvdXIu 
 IEhUTUwgY2FuIHJlbmRlciBvbiBQYWxtIFBpbG90cywKQmxhY2tiZXJyaWVzLCBBbWlnYX
 MsIFgt 
 Qm94ZXMsIHNldC10b3AtYm94ZXMgd2l0aCBicm93c2Vycywga2lvc2tzLAp0YWJsZXRzLC
 BwaG9u 
 ZXMsIGFuZCBuZXh0IGdlbmVyYXRpb24gcmVmcmlnZXJhdG9yLWVudGVydGFpbm1lbnQKY2
 VudGVy 
 cy4KCgoKT24gRnJpLCBNYXkgMjksIDIwMTUgYXQgNTozNSBQTSwgSmVmZiBKb2huc29uID
 xqZWZm
 QHNhbi1kYy5jb20+IHdyb3RlOgo+IElmIHlvdSB3ZXJlIGdvaW5nIHRvIGRldmVsb3AgYS
 QHNhbi1kYy5jb20+IHdyb3RlOgo+BzaW1w
 bGUgYXBwIHRoYXQgZGlzcGxheWVkIGRhdGEgaW4gYSBkYXRhYmFzZQo+IHRoYXQgd291bG
 bGUgYXBwIHRoYXQgZGlzcGxheWVkIGRhdGEgaW4gYSBkYXRhYmFzZQo+Qgd29y
 ayBvbiBhbmRyb2lkIGFuZCBJcGhvbmUsIHdoYXQgbGFuZ3VhZ2Ugb3IgdG9vbCB3b3VsZC
 B5b3Ug 
 dXNlCj4gdG8gYWNjb21wbGlzaCB0aGF0P8KgIEkga25vdyB0aGVyZSBhcmUgYSBsb3Qgb2
 YgdG9v 
 bHMsIGJ1dCBJIGFtIGxvb2tpbmcgZm9yCj4gc29tZXRoaW5nIHdoZXJlIHRoZSBsZWFybm
 luZyBj
 dXJ2ZSBpcyBub3QgdG9vIGdyZWF0Lgo+Cj4gVElBCj4KPiAtLQo+IEplZmYKPgo+IEplZm
 dXJ2ZSBpcyBub3QgdG9vIGdyZWF0Lgo+Cj4gVElBCj4KPiAtLQo+IEplZmYKPgo+YgSm9o
 bnNvbgo+IGplZmZAc2FuLWRjLmNvbQo+IFNhbkRDLCBJbmMuCj4gKDYyMykgNTgyLTAzMj
 bnNvbgo+IGplZmZAc2FuLWRjLmNvbQo+MKPiBT

TVMgKDYwMikgNzE3LTU0NzYKPiBGYXggNjIzLTg2OS0wNjc1Cj4KPiB3d3cuc2FuLWRjLmNvbQo+
 IHd3dy5jcmVtYXRpb250cmFja2VyLmNvbQo+IHd3dy5hZ2VudHJlbGF0aW9uc2hpcG1hbm
 IHd3dy5jcmVtYXRpb250cmFja2VyLmNvbQo+FnZXIu
 Y29tCj4KPgpbZXhjZXNzaXZlIHF1b3RpbmcgcmVtb3ZlZCBieSBzZXJ2ZXJdCgpfX19fX1
 9fX19f 
 X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpQb3N0IE1lc3NhZ2VzIH
 RvOiBQ 
 cm9Gb3hAbGVhZmUuY29tClN1YnNjcmlwdGlvbiBNYWludGVuYW5jZTogaHR0cDovL21haW
 wubGVh 
 ZmUuY29tL21haWxtYW4vbGlzdGluZm8vcHJvZm94Ck9ULWZyZWUgdmVyc2lvbiBvZiB0aG
 lzIGxp 
 c3Q6IGh0dHA6Ly9tYWlsLmxlYWZlLmNvbS9tYWlsbWFuL2xpc3RpbmZvL3Byb2ZveHRlY2
 gKU2Vh 
 cmNoYWJsZSBBcmNoaXZlOiBodHRwOi8vbGVhZmUuY29tL2FyY2hpdmVzL3NlYXJjaC9wcm
 9mb3gK 
 VGhpcyBtZXNzYWdlOiBodHRwOi8vbGVhZmUuY29tL2FyY2hpdmVzL2J5TUlEL3Byb2ZveC
 9DQUNX 
 Nm40dj1IMDBGQlEwd05wZXR1NWJyPVhqNFJBRF8tOHA1cEZPcmIxT1dqTllBTHdAbWFpbC
 5nbWFp 
 bC5jb20KKiogQWxsIHBvc3RpbmdzLCB1bmxlc3MgZXhwbGljaXRseSBzdGF0ZWQgb3RoZX
 J3aXNl 
 LCBhcmUgdGhlIG9waW5pb25zIG9mIHRoZSBhdXRob3IsIGFuZCBkbyBub3QgY29uc3RpdH
 V0ZSBs 
 ZWdhbCBvciBtZWRpY2FsIGFkdmljZS4gVGhpcyBzdGF0ZW1lbnQgaXMgYWRkZWQgdG8gdG
 hlIG1l 
 c3NhZ2VzIGZvciB0aG9zZSBsYXd5ZXJzIHdobyBhcmUgdG9vIHN0dXBpZCB0byBzZWUgdG
 hlIG9i 
 dmlvdXMuCgpSZXBvcnQgW09UXSBBYnVzZTogaHR0cDovL2xlYWZlLmNvbS9yZXBvcnRBYn
 VzZS9D 
 QUNXNm40dj1IMDBGQlEwd05wZXR1NWJyPVhqNFJBRF8tOHA1cEZPcmIxT1dqTllBTHdAbW
 FpbC5n
 bWFpbC5jb20K


 --- 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/004e01d09b9e$8ae277a0$a0a766e0$@ozemail.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.

RE: Excel 2013 slow automation

[Darren]

Graham

I have not seen and reduction in performance however I use a different
approach. There are also other exporters out there that work well.

For day to day stuff moving between excel and vfp I use the excel plugin
available on the news2news site
http://news2news.com/vfp/index.php?solution=14src=frontpageimgPHPSESSID=72
aecaae25cb568ecd04b67d0583bc32 . Small cost but very productive addition to
tool box.

As for excel export I wrote an export back in 2002 that has had minimal
changes over the years. Still works well and fast. Idea is simply to use the
VFP export - have the code loop through the entire table in 16,383 record
blocks - export that block to temp file. Import that temp file into excel,
copy the import and past into the destination spreadsheet. You'll have two
sheets open at the same time - one holds the 16k data and the other your
final output. If the number of records goes past the limit for the workbook
per the version of Excel then simply spawn off another workbook. In this way
you are not limited by number of records in your table and performance is
perfectly adequate (significantly better than the figures you are quoting).
All the formatting , column headers, column cells, autowidth, date format -
whatever is supported by excel - is done very rapidly and you end up with a
pretty nicely formatted and laid out  spreadsheet in a very reasonable time
period.

Other niceties (e.g. Specific formatting per row, groupings etc) are handled
by the addition of a formatting field in the data file fed to the exporter.
A bit of pre-work to the export but result if very flexible output to
spreadsheet format.

Happy to send you the code if you want.

Cheers

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Graham
Brown
Sent: Saturday, 23 May 2015 7:02 PM
To: profoxt...@leafe.com
Subject: Excel 2013 slow automation

Hello 

Has anyone seen any problems with Excel automation?

My code creates an excel spreadsheet, writing out various info from the
tables, in 2010 and earlier it takes about 1 minute to write out 1500 lines
but in 2013 it is more like 45 minutes.
Checked with AV on and off, closed all other apps etc etc so it definitely
seems to be 2013.

Regards
Graham


--- StripMime Report -- processed MIME parts --- multipart/mixed
  text/plain (text body -- kept)
  application/ms-tnef
---

[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/006f01d095ea$9f747600$de5d6200$@ozemail.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.

RE: Regular expressions (Replace Variable value between 2 fixed values)

[Darren]

This is one way ...

lcStr = fjklfjkdl lkhjegfblkhehbghgh ngbh. rngt + CHR(13) + CHR(10) +
AccountNum9/AccountNum + CHR(13) + CHR(10) +
jfewrjkbrgejklhbjkgjklebgrdlbgrekrjh

loRegexp = CREATEOBJECT(vbScript.regexp)

WITH m.loRegexp
  .ignorecase = .T.
  .global = .T.
  .multiline  = .F.
ENDWITH   

loRegExp.pattern = AccountNum([0-9]*)/AccountNum

lcnewStr = loRegExp.replace(m.lcStr, REPLACEMENTTEXT)

? lcNewStr

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken
Kixmoeller (ProFox)
Sent: Friday, 22 May 2015 1:34 AM
To: profoxt...@leafe.com
Subject: Regular expressions (Replace Variable value between 2 fixed values)

RegEx makes me irregular!!!

I guess I need to take a class or something. Angers me when I can't figure
out something like this

Nevertheless, I have a timely need to make this string:

AccountNum9/AccountNum

to this:

AccountNum/AccountNum

NOTES:
 -- The string shown is part of a much larger string.
 -- The 9s are variable-length numeric characters.

Thank you so much - ---

Ken


--- 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/00f401d094c5$6e98a4f0$4bc9eed0$@ozemail.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.

RE: Regular expressions (Replace Variable value between 2 fixed values)

[Darren]

Slight mod in case of multiple AccountNum tags ...

loRegExp.pattern = AccountNum([0-9]*?)/AccountNum

or: (This should be faster as well)

loRegExp.pattern = AccountNum([^]*)/AccountNum 



-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Darren
Sent: Saturday, 23 May 2015 5:28 AM
To: profoxt...@leafe.com
Subject: RE: Regular expressions (Replace Variable value between 2 fixed
values)

This is one way ...

lcStr = fjklfjkdl lkhjegfblkhehbghgh ngbh. rngt + CHR(13) + CHR(10) +
AccountNum9/AccountNum + CHR(13) + CHR(10) +
jfewrjkbrgejklhbjkgjklebgrdlbgrekrjh

loRegexp = CREATEOBJECT(vbScript.regexp)

WITH m.loRegexp
  .ignorecase = .T.
  .global = .T.
  .multiline  = .F.
ENDWITH   

loRegExp.pattern = AccountNum([0-9]*)/AccountNum

lcnewStr = loRegExp.replace(m.lcStr, REPLACEMENTTEXT)

? lcNewStr

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ken
Kixmoeller (ProFox)
Sent: Friday, 22 May 2015 1:34 AM
To: profoxt...@leafe.com
Subject: Regular expressions (Replace Variable value between 2 fixed values)

RegEx makes me irregular!!!

I guess I need to take a class or something. Angers me when I can't figure
out something like this

Nevertheless, I have a timely need to make this string:

AccountNum9/AccountNum

to this:

AccountNum/AccountNum

NOTES:
 -- The string shown is part of a much larger string.
 -- The 9s are variable-length numeric characters.

Thank you so much - ---

Ken


--- 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/00fe01d094c6$96da0390$c48e0ab0$@ozemail.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.

RE: [NF] Recomendations for a developer laptop

[Darren]

If it were only about those 60 seconds then I think you would have universal
agreement.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ricardo
Araoz
Sent: Tuesday, 19 May 2015 10:40 PM
To: profoxt...@leafe.com
Subject: Re: [NF] Recomendations for a developer laptop

I don't get this, my Dell will boot Ubuntu in 60-70 seconds. Then my laptop
will be on all day, unless suspended, coming up from suspension takes about
3 seconds. Why would I spend hard earned extra money to save
60 seconds on a 10 to 16 hour day? Doesn't make sense to me.
As for general performance, an i5 with my 1Tb HD are more than what I need
for everyday work. I don't edit video, and unless you are recommending a SSD
drive for playing I don't think it's money well spent.

On 19/05/15 08:13, Peter Cushing wrote:
 On 18/05/2015 12:32, Ted Roche wrote:
 HDD: not all that important, as nearly everything we run is mirrored 
 on the LAN and backed-up to the internet.

 If I was buying one now I wouldn't consider anything less than an SSD 
 drive, just for the general performance increase especially booting.
 Even if you have a small boot drive and a larger main drive.

 Peter






 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


[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/002f01d09231$b973a100$2c5ae300$@ozemail.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.

RE: VFP9: Form Data Environment

[Darren]

I've have never used form directly - always classes. No DE specifically but
effectively setup in Load Event - pretty much exclusively private data
session. Set up the Field Mapping in Options. Add database to project and
drag fields from there. Works well - being doing that since V3.0 I believe.

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Kurt
Wendt
Sent: Friday, 15 May 2015 11:11 PM
To: profoxt...@leafe.com
Subject: RE: VFP9: Form Data Environment

This is also something I have done - simply drop tables in the DE - then
drag and drop items on Form to quickly create the layout - the delete the
Table form the DE. I have heard there are some problems and limitations to
using the DE - and some issues I have run into - so that's why I then remove
the Tables from the DE after initially putting fields  Grids on the Form.

-K-

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jean
MAURICE
Sent: Friday, May 15, 2015 1:10 AM
To: profoxt...@leafe.com
Subject: Re: VFP9: Form Data Environment

my two cents :
... In fact, sometimes I open the dataenvironment, put a table on it, drag
the object to the form to have a grid and then delete the table and the
dataenvironment ! 

[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/003e01d08f14$d68a7360$839f5a20$@ozemail.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.