http://www.novell.com/coolsolutions/feature/18552.html
--
Michael Hawksworth
Visual Fox Solutions
[EMAIL PROTECTED]
www.foxpro.co.uk
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions
pass
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All
When to much crud hits your inbox, some people have taken the extra step
to read the gibberish the filter misses, and from it:
First I scanned the text for phrases with the right number of syllables
(five for each first and last line, seven for each line in the middle).
Then I set about fitting
Was watching Live with Regis and Kelly just now (while working on some
code of course!) and the tech guy was demonstrating the new mini PCs
running a full Windows operating system.
Even though Foxpro wasn't able to be run on handhelds in the earlier
days, with the advancement/evolution of
I can't answer the specific question, but I recently took an app from V7
to V9, and the users are all claiming about a 30% speed increase in
overall performance.
Do you use objects? If so, that's why. Calvin changed something from
VFP7-VFP8 with how objects are handled. In VFP7 and earlier,
I was very tempted to purchase a mini PC, but went with a laptop
instead. One downside seemed to be the maximum RAM that the mini PCs
can currently take; 1G. I wasn't going to buy anything that didn't
handle 2G of RAM, preferably 4G.
Was the show demoing a Shuttle, or AOpen system?
Koobox has
Was watching Live with Regis and Kelly just now (while working on some
code of course!) and the tech guy was demonstrating the new mini PCs
running a full Windows operating system.
Even though Foxpro wasn't able to be run on handhelds in the earlier
days, with the advancement/evolution of
Ed Leafe wrote:
pass
Distinction, surely.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless
Kevin Cully wrote:
One downside seemed to be the maximum RAM that the mini PCs
can currently take; 1G. I wasn't going to buy anything that didn't
handle 2G of RAM, preferably 4G.
What are you going to be running on that that would need that much RAM?
SQL Server or lots of virtual machines
There is certainly a *huge* speed hike from VFP6 to VFP9 in our
application.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list:
Virtual machines, MySQL, PostgreSQL, REALbasic. All while running
Firefox and Thunderbird on a MEPIS desktop. The more RAM, the better to
keep things running peppy. g
I'm wondering if I should try installing Vista in a VM. I guess I'll
have to, before too long.
Alan Bourke wrote:
What are
Even when I was making very good money, I typically had to buy my house
loans..
They want 5 years of history so that they can make sure you are capable of
sustaining the payments..
Virgil Bierschwale
http://www.bierschwalesolutions.com
-Original Message-
From: [EMAIL PROTECTED]
Does anybody have an idea how I could generate a csv file programtically
that would include in it the info from memo fields. What would be the
simplest way to do this?
I also would like to take a csv file and append it to a dbf file with
memo fields. I tried converting the file to a string
Kevin Cully wrote:
Virtual machines, MySQL, PostgreSQL, REALbasic. All while running
Firefox and Thunderbird on a MEPIS desktop. The more RAM, the better to
keep things running peppy. g
With all that, I'd be as worried about disk space as I would RAM.
Judith Barer wrote:
Does anybody have an idea how I could generate a csv file programtically
that would include in it the info from memo fields. What would be the
simplest way to do this?
Personally I always use textmerge to create files like this.
set textmerge on noshow
set textmerge
Judith Barer wrote:
Does anybody have an idea how I could generate a csv file programtically
that would include in it the info from memo fields. What would be the
simplest way to do this?
I also would like to take a csv file and append it to a dbf file with
memo fields. I tried converting
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Peter Cushing
Sent: Wednesday, January 31, 2007 11:37 AM
To: [EMAIL PROTECTED]
Subject: Re: csv files and memo fields
Judith Barer wrote:
Does anybody have an idea how I could generate a csv file
Judith Barer wrote:
I need to account for the field being bigger than 250 chars
Then you pretty much have to write code to generate the text output
yourself. :-( Be careful of embedded line breaks, soft returns, and
delimiters within your memo field!
Judith Barer wrote:
I also would like to take a csv file and append it to a dbf file with
memo fields. I tried converting the file to a string using strtofile
and then using a alines but the file is so big that it generates a
subscript out of range error. I am using VFP 8.0.
I'm just
I'm having a brain-fart morning here. I know that MSDE is pretty much
obsolete, but I need to test VFP code on a MSSQL server backend. What
should I be using instead, and where do I get it. Someone actually told
me last week, but hey, that was a whole week ago? MSSQL developers
version, or
Naw. The laptop came with 160G HD and most of the data is just proof
of concept and demo and development type stuff. For real production
data, that goes on another server and other storage.
In upgrading storage, there are lots of options. If you need RAM and
your machine won't take any more,
Judith,
Another option might be to use a cursorToXml.
Then you can convert that to a comma separated file. If done right, you could
probably automate the whole things (look up the tag in the structure to
determine what type of delimiter to use.) You could even make it so you could
choose a
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Vince Teachout
Sent: Wednesday, January 31, 2007 11:55 AM
To: [EMAIL PROTECTED]
Subject: Re: csv files and memo fields
Judith Barer wrote:
I also would like to take a csv file and append it to a dbf file
Vince Teachout wrote:
I'm having a brain-fart morning here. I know that MSDE is pretty much
obsolete, but I need to test VFP code on a MSSQL server backend. What
should I be using instead, and where do I get it. Someone actually told
me last week, but hey, that was a whole week ago?
Judith Barer wrote:
I am not taking one dbf file and transferring it to another. What I am
doing is sharing data. I work for a kosher certifying agency and what I
am doing is sharing data with other certifying agencies so I am supposed
to create csv files of our data and download csv files
Alan Bourke wrote:
SQL Server 2005 Express Edition.
http://msdn.microsoft.com/vstudio/express/sql/register/default.aspx
Many thanks, Alan!
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
Is there a recommended drive size for the C drive in a partitioned hard
drive?
I'm getting a new pc with a 250G HDD.
I thought I'd just have software installed on the C drive, and everything
else on the D drive.
James E Harvey
Corresponding Officer/M.I.S.
bus: 717-637-8931
fax: 717-637-6766
James E Harvey wrote:
Is there a recommended drive size for the C drive in a partitioned hard
drive?
It depends on what you're going to use the box for and what/how much
you're going to install on it.
I'm getting a new pc with a 250G HDD.
I thought I'd just have software installed on the
Heads up to those of you foolish enough to send HTML email. Outlook
2007 uses less components of IE and more components of Word for
rendering and editing emails, resulting in changing behavior.
Asked about the controversial move, Chris Capossela, who manages the
Microsoft Office System family of
Is there a recommended drive size for the C drive in a partitioned hard
drive?
It depends on what you're going to use the box for and what/how much
you're going to install on it.
I'd personally say don't bother partitioning-- just use one large
partition. I've seen pretty much no benefit
MSSQL developers version, or something like that?
There is a SQL Server Developer's Edition which is the full SQL Server for $50.
Cannot use it for
production databases, but works great in development mode and you get
everything (no limitations of
MSDE or SQL Server Express). It is perfect for
Also, unlike MSDE, it has a Management Studio application and no throttling
on the number of
concurrent users! The only real constraint is a 4GB (I think) max database
size.
Another constraint to consider when moving from MSDE to SQL Server 2005 Express
is the SQL Agent no
longer gets shipped
On 1/31/07, James E Harvey [EMAIL PROTECTED] wrote:
Is there a recommended drive size for the C drive in a partitioned hard
drive?
I'm getting a new pc with a 250G HDD.
I thought I'd just have software installed on the C drive, and everything
else on the D drive.
primary partitions
25 Gb
On 1/31/07, Derek Kalweit [EMAIL PROTECTED] wrote:
Is there a recommended drive size for the C drive in a partitioned
hard
drive?
It depends on what you're going to use the box for and what/how much
you're going to install on it.
I'd personally say don't bother partitioning--
I *always* set aside a separate partition for OS and apps which I then make
a ghost image of. That way if I get problems I can always restore a known
good copy of my apps and OS. It also means that all the data I need to
backup is on a single drive and I don't have to go trawling through M$'s
One advantage of a small Windows partition is that it's easier to backup.
My C drive is only 10Gb and it's about 50% full. Only Windows and
Program files live on C, any data (pictures, mp3s etc) live on D,
which is 140Gb.
I can easily boot from a USB stick and burn a Ghost image to DVD.
without the bloat of a 'used' Windows install...
If you take the image immediately after the initial install and setting up
there is no bloat and the image can be used to reduce bloat by restoring it.
John Weller
01380 723235
07976 393631
___
What would you use in an sql select statement for sql server to replace
empty() function of vfp. I would like to do the following in t-sql
Select items.item_num , iif(!empty(addl_loc_info),.t.,.f.)
So I see that you need to use case instead of iif but I do not know what
to use instead of
without the bloat of a 'used' Windows install...
If you take the image immediately after the initial install and setting up
there is no bloat and the image can be used to reduce bloat by restoring it.
But then it doesn't have any applications or windows updates, at which
point, what's the
Rick Schummer wrote:
There is a SQL Server Developer's Edition which is the full SQL Server for
$50. Cannot use it for
production databases, but works great in development mode and you get
everything (no limitations of
MSDE or SQL Server Express). It is perfect for those developers who have
If you are merely partitioning the same drive, then I don't see the big deal
of using a different partition over using a c:\data\... folder. Ideally, you
would have one drive that contains the OS and program files and another for
data. I've even done it where the program files are stored on the
Ted Roche wrote:
Heads up to those of you foolish enough to send HTML email. Outlook
2007 uses less components of IE and more components of Word for
rendering and editing emails, resulting in changing behavior.
Asked about the controversial move, Chris Capossela, who manages the
Microsoft
Judith Barer wrote:
snipped
There are definitely better ways to approach this issue such as
using web services and such but we are not doing that.
Why not?
We had agreed to use XML files which worked fine but the files are quite
large. So
some agencies requested to use csv instead. For
http://www.youtube.com/watch?v=ioy90nF2anI
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list:
Alan Bourke wrote:
SQL Server 2005 Express Edition.
http://msdn.microsoft.com/vstudio/express/sql/register/default.aspx
Also, unlike MSDE, it has a Management Studio application and no
throttling on the number of concurrent users! The only real constraint
is a 4GB (I think) max database
Anger Management
When you occasionally have a really bad day, and you
just need to take it out on someone, don't take it out
on someone you know, take it out on someone you don't
know. I was sitting at my desk when I remembered a
phone call I'd forgotten to make. I found the number
and dialed it.
I have an app in VFP7 that I need to sort on group totals. Is that a job
for VFP9? Forget it for VFP7?
Now, the report looks nice, but needs the totals sorted on each group. I
have tried a 2 pass routine, but it's not really working right. I don't
know if this is enough info to give me some
MB Software Solutions wrote:
One way or the other, you're gonna get that DotNet framework on your
PC! ;-)
Well, AFAIK it has never made a PC melt or anything.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
Chester Friesen wrote:
I have an app in VFP7 that I need to sort on group totals. Is that a job
for VFP9? Forget it for VFP7?
Now, the report looks nice, but needs the totals sorted on each group. I
have tried a 2 pass routine, but it's not really working right. I don't
know if this is
Alan Bourke wrote:
Well, AFAIK it has never made a PC melt or anything.
That's because of good cooling fans on the motherboard. g
--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
Work smarter, not harder, with MBSS custom software
Hi
40 Gb Drive C
40 Gb Drive D Programs
20 Gb Drive E Development
140Gb Drive F Movies, books, pictures, etc
E.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list:
Let me see, u are an asshole.
Yeah it works, thanks.
E.
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All
Where have we heard this concern (about XML file size) before?!?!?
Sounds like your CSV-wanting partners are old fashioned (...not that
there's anything wrong with that). g
Actually, when I download the Area Code files from the FTC for Do Not Call
lists monthly for clients I use their Flat
Disk space is cheap. I just toss in another big honker when needed, and run
single partitions on all Hard Drives, except for the few dual-boot PCs I
have.
I used to partition my drives years ago to get maximum storage efficiency
when a 1Gb HDD ran $800 (yes, eight hundred!). With FAT16/FAT32,
I'm getting a new pc with a 250G HDD.
I thought I'd just have software installed on the C drive, and everything
else on the D drive.
Personally, I have two hard drives(dual 200GB SATA's I bought years
ago)-- the C:\ drive I use for system and anything I can lose, and if
something's
On 1/31/07, MB Software Solutions [EMAIL PROTECTED] wrote:
Alan Bourke wrote:
SQL Server 2005 Express Edition.
http://msdn.microsoft.com/vstudio/express/sql/register/default.aspx
Also, unlike MSDE, it has a Management Studio application and no
throttling on the number of concurrent
Hi all
I am trying to get a list of tables in an MS Access MDB and what I have
so far is
oAcc = CREATEOBJECT(Access.Application
oAcc.OpenCurrentDatabase(MyDatabase.MDB)
LOCAL lnTables
lnTables = oAcc.CurrentData.AllTables.Count
This returns a value of 9 for lnTables but the MDB only contains 2
Michael Madigan wrote:
Anger Management
When you occasionally have a really bad day, and you
just need to take it out on someone, don't take it out
on someone you know, take it out on someone you don't
know.
Shit! So now you've figured out why do I chat with you... asshole!
Paul Hill wrote:
Visual Source Safe also 'requires' the .NET framework. But you can
uninstall it afterwards and VSS works just fine.
Wow...that's interestingjust like the recent post here (within 2
months?) of a web page that required you to install some sort of M$
active-x control,
Chester Friesen wrote:
I have an app in VFP7 that I need to sort on group totals. Is that a job
for VFP9? Forget it for VFP7?
Now, the report looks nice, but needs the totals sorted on each group. I
have tried a 2 pass routine, but it's not really working right. I don't
know if this is
Good job you big failure.
http://www.cnn.com/2007/WORLD/americas/01/31/chavez.venezuela.ap/
Saddam - Hung for the Holidays
http://www.cafepress.com/rightwingmike
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
oAcc = CREATEOBJECT(Access.Application)
lcmdb=GETFILE('mdb')
oAcc.OpenCurrentDatabase(lcmdb)
LOCAL lnTables
lnTables = oAcc.CurrentData.AllTables.Count
FOR i = 1 TO lntables
lctable=oacc.CurrentData.AllTables(i).name
IF OCCURS('MSys',lctable)=0
?lctable
endif
endfor
John
-Original
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Paul Newton
Sent: Wednesday, January 31, 2007 4:13 PM
To: [EMAIL PROTECTED]
Subject: Access automation
Hi all
I am trying to get a list of tables in an MS Access MDB and what I have
so far is
oAcc =
http://www.break.com/index/toll_booth_prank1.html
Saddam - Hung for the Holidays
http://www.cafepress.com/rightwingmike
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this
I just checked the code in Access 2007 and found they are using 0 based
arrays, so modify the code to the following:
oAcc = CREATEOBJECT(Access.Application)
lcmdb=GETFILE('mdb')
oAcc.OpenCurrentDatabase(lcmdb)
LOCAL lnTables
lnTables = oAcc.CurrentData.AllTables.Count
FOR i = 0 TO lntables-1
Bill Gates on The Daily Show:
Part 1: http://tinyurl.com/ytmfve
Part 2: http://tinyurl.com/2y3cbj
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
Tx Jeff
Jeff Johnson wrote:
Paul: I have done this hundreds of times using ODBC. Very straight forward
and you can SCAN the access tables and write to the DBF.
That would be using SPT (SQLConnect and SQLExec) right ? And this would
be another approach - in addition to (i) ADO and (ii)
Thank you John but I did ask
How can I get a count/list of the tables excluding the system tables
(without iterating all of them to exclude the system tables) ?
john harvey wrote:
I just checked the code in Access 2007 and found they are using 0 based
arrays, so modify the code to
Al Frankenstein is going to run for senate. I can't
wait to start selling Al Franken is an ugly troll
t-shirts.
http://www.startribune.com/587/story/972540.html
Saddam - Hung for the Holidays
http://www.cafepress.com/rightwingmike
___
Post
Hi
Just got this from my ISP, Orange in the UK
If however you are planning on buying a new PC, or upgrading your
existing one to Windows Vista, we need to make you aware that it may
have an impact on your Orange broadband service, as your USB modem might
not work.
Oops!
--
Andrew Stirling
Chester Friesen wrote:
I have an app in VFP7 that I need to sort on group totals. Is that a job
for VFP9? Forget it for VFP7?
Now, the report looks nice, but needs the totals sorted on each group. I
have tried a 2 pass routine, but it's not really working right. I don't
know if this is
MB Software Solutions wrote:
Paul Hill wrote:
Visual Source Safe also 'requires' the .NET framework. But you can
uninstall it afterwards and VSS works just fine.
Wow...that's interestingjust like the recent post here (within 2
months?) of a web page that required you to install some
Derek Kalweit wrote:
I can't answer the specific question, but I recently took an app from
V7 to V9, and the users are all claiming about a 30% speed increase
in overall performance.
Do you use objects? If so, that's why. Calvin changed something from
VFP7-VFP8 with how objects are
Judith Barer wrote:
What would you use in an sql select statement for sql server to
replace
empty() function of vfp. I would like to do the following in t-sql
Select items.item_num , iif(!empty(addl_loc_info),.t.,.f.)
Is it null?
If so you have isNull() or Nullif()
You will also
I don't have foxpro here, but use the old
Copy to file name type sdf, substituting sdf with whatever it is that
creates an excel file.
Seems like it is TYPE 123, but I'm not sure...
Virgil Bierschwale
http://www.bierschwalesolutions.com
-Original Message-
From: [EMAIL PROTECTED]
Vince Teachout wrote:
Chester Friesen wrote:
I have an app in VFP7 that I need to sort on group totals. Is that a
job for VFP9? Forget it for VFP7?
Now, the report looks nice, but needs the totals sorted on each
group. I have tried a 2 pass routine, but it's not really working
right. I
I had to laugh on this one. But you are pulling our legs.
- Original Message -
From: Michael Madigan [EMAIL PROTECTED]
To: profox@leafe.com
Sent: Wednesday, January 31, 2007 4:19 PM
Subject: [OT] Anger Management
Anger Management
When you occasionally have a really bad day, and you
Vince Teachout wrote:
I must not be understanding the problem. This works fine for me in vfp7:
SELECT stylename, sum(units) as sumall FROM gmoodet GROUP BY stylename
ORDER BY sumall
I'm learning here. ;-) That's close, that gives me a one record for
each rider with a sumall field
Stephen the Cook wrote:
MB Software Solutions wrote:
Paul Hill wrote:
Visual Source Safe also 'requires' the .NET framework. But you can
uninstall it afterwards and VSS works just fine.
Wow...that's interestingjust like the recent post here (within 2
months?) of a
Stephen the Cook wrote:
Derek Kalweit wrote:
I can't answer the specific question, but I recently took an app from
V7 to V9, and the users are all claiming about a 30% speed increase
in overall performance.
Do you use objects? If so, that's why. Calvin changed something from
Chester Friesen wrote:
I need all the
records in the table to show in the report sorted by the order that the
above came up with. i.e., sorted by the Names, but in the order of the
Totals. I hope I'm making sense! Actually the example below should be
descending instead of ascending, but
Chester Friesen wrote:
I need all the
records in the table to show in the report sorted by the order that the
above came up with. i.e., sorted by the Names, but in the order of the
Totals. I hope I'm making sense! Actually the example below should be
descending instead of ascending, but
Vince Teachout wrote:
Actually, if you have VFP9, you can do it with one query:
SELECT A.Rider, A.dDate, A.nScore, ;
(Select SUM(nscore) FROM foobar B WHERE b.rider = a.rider) ;
FROM foobar A;
ORDER BY 4 desc,1
I have VFP9, but I started this project before I got it.
--
Chester Friesen wrote:
BTW, what does the 4 do after the Order By, also the 1 after the Desc?
It allows you to specify the column to be used by column reference
number, as in the 4th column from your SELECT statement, as opposed to
naming the field specifically. But be careful: if you
Stephen the Cook wrote:
Judith Barer wrote:
What would you use in an sql select statement for sql server to
replace
empty() function of vfp. I would like to do the following in t-sql
Select items.item_num , iif(!empty(addl_loc_info),.t.,.f.)
Is it null?
If so you have
MB Software Solutions wrote:
Chester Friesen wrote:
BTW, what does the 4 do after the Order By, also the 1 after the Desc?
What Mike said. I usually use the column names instead of the column
numbers, but there are a few places where you have no choice but to use
the numbers - in a
Stephen the Cook wrote:
You probably wouldn't know one was in front of you.
...which simply reiterates the point that you (as the end-user) usually
don't give a hoot as to what your solution is written in. It could be
Dabo for all we know. g I guess the real way to find out is if you
Jeff Johnson wrote:
Paul: I have done this hundreds of times using ODBC. Very straight forward
and you can SCAN the access tables and write to the DBF.
So post some sample code for him, Jeff! g
--
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
Chester Friesen wrote:
SELECT riderid, ;
SUM(nscore) AS totscore ;
FROM Foobar;
GROUP BY riderid ;
ORDER BY totscore DESC ;
INTO CURSOR totcurs nofilter
SELECT * ;
FROM Foobar;
INNER JOIN totcurs ;
ON Foobar.riderid = totcurs.riderid ;
ORDER BY
90 matches
Mail list logo
