Try erasing all the fxp's. Sometimes they contain a lot of trash and wind
up getting pulled into the compliand.
-Lew Schwartz
On Fri, Apr 26, 2013 at 3:06 PM, Kevin Cully
wrote:
> There is something the Ed wrote in the ProFox downloads section that helps
> set memory allocations.
>
> I don't th
Very clear description, inspiring, thanks Thierry Nivelet
Thanks, Thierry.
Ken Dibble
www.stic-cil.org
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: htt
There is something the Ed wrote in the ProFox downloads section that
helps set memory allocations.
I don't think it has anything to do with the size of the PRG, but has
something to do with the running of the Foxpro program and the allocated
memory for the program.
Just a foggy guess.
-Kevi
At 11:39 2013-04-26, Desmond Lloyd wrote:
Interesting article... This program definitely breaks this principle at
least by 10X 8-)
I have some very large .prg files myself. One is nearly 1/4
MB. I have never seen that error.
Take a look at the on-line help for that error
messa
At 10:33 2013-04-26, Rick Schummer" wrote:
My suggestion is to start here:
http://fox.wikis.com/wc.dll?Wiki~VFPVersionBaseClassConcordance~VFP
The Visual FoxPro Wiki Concordance pages are top gun as are the
What's New books.
Thank you. I will be checking out that link.
And then there
Interesting article... This program definitely breaks this principle at
least by 10X 8-)
Regards,
Desmond
On 26 April 2013 13:11, Desenvolvimento - Metha <
desenvolvime...@methasistemas.com.br> wrote:
> Desmond,
>
> Probably too much responsability to one program. Better you extract some
> bl
At 18:05 2013-04-25, Ken Dibble wrote:
If I want to have a form inside of another form's validation
and set focus in the second form, I can not do so. Apparently,
using LostFocus is a solution for this. I experimented a bit but
then had to do something else.
I gave up messing with all
Desmond,
Probably too much responsability to one program. Better you extract some
blocks, save them in another program and call them. I also recommend you
read this article:
http://en.wikipedia.org/wiki/Single_responsibility_principle
Regards,
Marcio
Em 26/04/2013 14:54, Desmond Lloyd escr
Perhaps a challenge...
Have an old 4000 line program written in VFP6. Have just spent about an
hour cleaning up some spaces, removing tabs etc. Even used Ultra Edit to
cleanup some of it. Got part way through and when I went to compile I am
now getting a "Program to large error".
There have b
My suggestion is to start here:
http://fox.wikis.com/wc.dll?Wiki~VFPVersionBaseClassConcordance~VFP
The Visual FoxPro Wiki Concordance pages are top gun as are the What's New
books.
And then there is "try it out and see if it no longer is a bug" process. For
me, nothing like proof something wo
On Fri, Apr 26, 2013 at 11:13 AM, Kurt Wendt wrote:
> Wow Stephen! So - this ADO is SO DAMNED Powerful - it works on a Psychic
> Level? COOL!
>
> :-P
>
> And - I like the Try...Catch suggestion w/optional Install.
>
> -
>
I remember using the ADO data acquisition for taking years
No - the install doesn't sound to bad - and its good to have a really simple
solution to implement - especially since I most probably won't be the one to
implement it.
-K-
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan
Bourke
Sent: Friday, Apri
I second that motion!
I have communicated w/Gary offlist at times - as I've been VERY Impressed
with what he has been able to accomplish w/VFP given his handicaps - and its
also pretty wild using VFP to control Various pieces of HW - which can
almost sound like fun for a Techy...
-K-
-Origi
Amen.
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul McNett
Sent: Friday, April 26, 2013 11:21 AM
To: profox@leafe.com
Subject: Re: primary or unique index
You are an inspiration, Gary.
On 4/26/13 9:04 AM, Gary Jeurink wrote:
> I'm a home bound quadri
On Fri, Apr 26, 2013, at 05:01 PM, Kurt Wendt wrote:
> Alan - your suggestion DOES Sound really easy. But, this M$ Component you
> speak of - I understand its Free - but, I need to actually download &
> Install it to use it? And, I will have to install it at client on their
> PC's
> as well???
>
You are an inspiration, Gary.
On 4/26/13 9:04 AM, Gary Jeurink wrote:
> I'm a home bound quadriplegic that started around fox pro 3.0 or so. I run
> my living-room/house off snippets of code all of you provide for me. Today
> I'm trying to figure out VM ware in order to get my 64 bit computer to t
Wow Stephen! So - this ADO is SO DAMNED Powerful - it works on a Psychic
Level? COOL!
:-P
And - I like the Try...Catch suggestion w/optional Install.
-K-
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen
Russell
Sent: Friday, April 26, 2013
On Fri, Apr 26, 2013 at 11:03 AM, Kurt Wendt wrote:
> Ah - so this is ADO?!
> --
>
Yep. Use the Force Luke.
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/pl
You could put the exe on their drive when they get the update to run this.
You could query use of it and in a try catch install it if not found
working. :)
Maybe you can't because of admin rights as well. :(
On Fri, Apr 26, 2013 at 11:01 AM, Kurt Wendt wrote:
> Thanks again to everyone for
I'm a home bound quadriplegic that started around fox pro 3.0 or so. I run
my living-room/house off snippets of code all of you provide for me. Today
I'm trying to figure out VM ware in order to get my 64 bit computer to talk
to a 16-bit gadget (and of course) through fox pro. Many of the answers y
Ah - so this is ADO?!
-K-
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen
Russell
Sent: Friday, April 26, 2013 12:02 PM
On Fri, Apr 26, 2013 at 10:52 AM, Alan Bourke
wrote:
> The way I tend to do this these days is the Office Data Connectiv
On Fri, Apr 26, 2013 at 10:52 AM, Alan Bourke wrote:
> The way I tend to do this these days is the Office Data Connectivity
> Components (free Microsoft component). Handles all types of Excel files
> via OLE DB:
>
> This.SQLHandle = SqlStringConnect("Driver={Microsoft
>
Thanks again to everyone for the extensive replies on this Thread.
Alan - your suggestion DOES Sound really easy. But, this M$ Component you
speak of - I understand its Free - but, I need to actually download &
Install it to use it? And, I will have to install it at client on their PC's
as well??
The way I tend to do this these days is the Office Data Connectivity
Components (free Microsoft component). Handles all types of Excel files
via OLE DB:
This.SQLHandle = SqlStringConnect("Driver={Microsoft
Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};" ;
Actually memofields are quite possible.
Been a long time, but you just need to set the memowidth and then read off
line by line via a scan, or do while
Did a lot of mailing list mergers for ziff davis institute way back when and
the technique I've been describing works flawlessly.
I'd probably n
Thinking outside of the box here. Setup a connection string that you can
put the file&path they pick via a file picker and use ADO to pull the data.
That accepts the various tabs or workbooks, which you can query.
On Fri, Apr 26, 2013 at 9:40 AM, Kurt Wendt wrote:
> Hey folks - I think this s
...and finally,
Don't forget that you could always export from VFP to XML and then this will
import directly into the newer versions of Excel no problem...
Dave
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier
Sent: 26 April 2013 16:04
To: ProFo
Kurt,
Oh, and don't forget that importing memo fields is a big No-No without
automation being used!
Dave
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Kurt Wendt
Sent: 26 April 2013 16:11
To: profox@leafe.com
Subject: RE: Excel Data Import into VFP w/Mult
John,
I worked for Retail and Distribution with the Singer 1500 terminals and old
Singer System 10 machines. After the Singer buyout most of the staff left or
stayed down with ICL at Stevenage so I was left to support the 1500 terminals
which were realy powerful for the time and battled with the
One thing I forgot to mention as its been a very long time.
I created a foxpro table 255 characters wide with a single field (use 1,000
if vfp handles it)
I read the csv into that single field, and then did the substr() portion
which is a very simple loop
Then you most likely will need to set th
Thanks Dave - I just passed on to the others here all the input you folks
gave me - along with the Caveat you listed below - and I will let them mull
it all over - as I am already buried with the Biggest project we have going
here! And - I am for the most part up to this point - going it alone on t
I hear you about program breakage when XLS file columns are changed - and
there was a HEATED Thread on this forum not too long ago - exactly related
to this...
-K-
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Virgil
Bierschwale
Sent: Friday, April
Kurt,
The "sheet" option doesn't seem to work correctly on 2007 and above and If I
remember correctly there is also a row limit on the number of rows that you can
import into Excel, which is why I resorted to Automation which also allows you
to format the data correctly.
Dave
-Original Me
Hey Dave - thanks for your additional input - much appreciated. Will keep
everyone's responses in mind as the others here move forwards with working
on this project.
-K-
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave
Thayer
Sent: Friday, Apri
Fred - thanks SO MUCH For that Heads up. I should have quickly looked at the
Import command. Maybe the Sheets thing is newer to VFP 9. But, I will
Definitely consider this option.
And - since its this Other Guy here who will do the project - the concept of
Automation is probably foreign to him (k
Understood.
I used to automate it.
Did a gig for the childrens hospital in boston a long time ago.
For some reason they could not access the accounts payable history on the
mainframe
I used this technique to grab the data via obdc from the mainframe where
they controlled the keys.
All they had
Hey Dave - thanks for the input.
I suspect when you wrote "import into separate tabs" - that you really meant
"import FROM separate tabs". And, yeah - I kinda figured that might be the
case. Although - Fred seems to disagree - and mentioned how it could
possibly be done.
-K-
-Original Messag
On Fri, Apr 26, 2013 at 8:40 AM, Kurt Wendt wrote:
> This client of ours - they are getting Excel spreadsheets from a Factor.
> And, they want to pull the Excel data into our systems to process it & run
> reports. The main problem I see - is that the Spreadsheet has Multiple
> Tabs/Pages - and so
Thanks for all the quick input folks!
Virgil - I don't think the client would be too thrilled to have to open the
Excel file - do an export - and THEN run some import within our system. But,
I will keep this possibility in mind as an option - especially since it may
be cheaper and easier to implem
The IMPORT command does have a SHEET option for XL5 nad XL8 TYPEs
though I've never used them. I usually use automation to have more control
of what's going on.
Fred
On Fri, Apr 26, 2013 at 7:40 AM, Kurt Wendt wrote:
> Hey folks - I think this should be a quick question - pretty much a Yes or
You can't automatically import into separate tabs, unless you use Automation,
in which case it is quite easy.
Dave
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Virgil Bierschwale
Sent: 26 April 2013 15:45
To: 'ProFox Email List'
Subject: RE: Excel Data
I'm rusty, but I always saved each page as a csv if memory serves me correct
and then did a import into sdf
>From there I wrote a routine that would read each line, get the substring I
wanted and plug it into the table
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On
Dave,
Which part of Singer did you work for? I was seconded to the Link-Miles
Simulator Division from 78 to 82.
John
John Weller
01380 723235
07976 393631
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of
> Dave Crozier
> Sent: 26 April 2013 13
Hey folks - I think this should be a quick question - pretty much a Yes or
No answer.
This client of ours - they are getting Excel spreadsheets from a Factor.
And, they want to pull the Excel data into our systems to process it & run
reports. The main problem I see - is that the Spreadsheet has
Adam,
Never knew you worked for ICL, so did I for 6 years when they took over Singer,
who I was with originally. You'll remember the yearly "October Revolutions"
then! lol
Dave
-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Adam Buckland
Sent: 26 April 2
Not disagreeing with you, but that was over 20 years ago.
The part I supplied was written by a guy named cringely.
http://www.cringely.com/2013/04/25/two-h-1bs-walk-into-a-bar-more-on-the-vis
a-scam/
You might want to watch the first 15 minutes of this video because from what
I'm hearing, this i
Hi Virgil,
Late to the thread, but I have to disagree with you. Microsoft did not employ
exclusively experienced programmers, I had two other Companies (ICL and HP
Labs) under my belt before I went to Microsoft, yes I relocated from the UK to
Washington, but the interview process was more abou
47 matches
Mail list logo
