[NF] Novell passes control of the HULA project to Messaging Architecs

2007-01-31 Thread Michael Hawksworth
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 OT-free

test

2007-01-31 Thread Alan Bourke
___ 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 o

Re: test

2007-01-31 Thread Ed Leafe
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 po

[NF] Convert spam to a thing of beauty

2007-01-31 Thread srussell
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 th

[NF] New mini computers

2007-01-31 Thread MB Software Solutions
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 the

Re: VFP9 faster than VFP8?

2007-01-31 Thread Derek Kalweit
> 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,

Re: [NF] New mini computers

2007-01-31 Thread Kevin Cully
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 s

Re: [NF] New mini computers

2007-01-31 Thread Derek Kalweit
> 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/evolutio

Re: test

2007-01-31 Thread Alan Bourke
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

Re: [NF] New mini computers

2007-01-31 Thread Alan Bourke
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

Re: VFP9 faster than VFP8?

2007-01-31 Thread Alan Bourke
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: http://leafe.com/mailman/listinfo/profo

Re: [NF] New mini computers

2007-01-31 Thread Kevin Cully
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. 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 you

RE: [OT] Finance question for self-employed people

2007-01-31 Thread Virgil Bierschwale
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] [mailto

csv files and memo fields

2007-01-31 Thread Judith Barer
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 usin

Re: [NF] New mini computers

2007-01-31 Thread Alan Bourke
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. > With all that, I'd be as worried about disk space as I would RAM. _

Re: csv files and memo fields

2007-01-31 Thread Alan Bourke
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 textmerg

Re: csv files and memo fields

2007-01-31 Thread Peter Cushing
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 conve

RE: csv files and memo fields

2007-01-31 Thread Judith Barer
-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 programt

Re: csv files and memo fields

2007-01-31 Thread Vince Teachout
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!

Re: csv files and memo fields

2007-01-31 Thread Vince Teachout
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 jus

What do I use in place of MSDE?

2007-01-31 Thread Vince Teachout
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

Re: [NF] New mini computers

2007-01-31 Thread Kevin Cully
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,

RE: csv files and memo fields

2007-01-31 Thread Fletcher Johnson
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 se

RE: csv files and memo fields

2007-01-31 Thread Judith Barer
-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

Re: What do I use in place of MSDE?

2007-01-31 Thread Alan Bourke
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?

Re: csv files and memo fields

2007-01-31 Thread Vince Teachout
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 file

Re: What do I use in place of MSDE?

2007-01-31 Thread Vince Teachout
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: http://leafe.com/mailman/listinfo/p

[NF] Drive partition size

2007-01-31 Thread James E Harvey
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

Re: [NF] Drive partition size

2007-01-31 Thread Whil Hentzen (Pro*)
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

[NF] Outlook 2007 handles HTML in a different "standard" way

2007-01-31 Thread Ted Roche
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

Re: [NF] Drive partition size

2007-01-31 Thread Derek Kalweit
> > 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

RE: What do I use in place of MSDE?

2007-01-31 Thread Rick Schummer
>>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 f

RE: What do I use in place of MSDE?

2007-01-31 Thread Rick Schummer
>>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 shi

Re: [NF] Drive partition size

2007-01-31 Thread Ted Roche
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

Re: [NF] Drive partition size

2007-01-31 Thread Paul Hill
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 bot

RE: [NF] Drive partition size

2007-01-31 Thread John Weller
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 ide

Re: [NF] Drive partition size

2007-01-31 Thread Derek Kalweit
> 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 D

RE: [NF] Drive partition size

2007-01-31 Thread John Weller
> 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 ___ Po

sql server empty fields

2007-01-31 Thread Judith Barer
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 em

Re: [NF] Drive partition size

2007-01-31 Thread Derek Kalweit
> > 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

Re: What do I use in place of MSDE?

2007-01-31 Thread Vince Teachout
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

RE: [NF] Drive partition size

2007-01-31 Thread john harvey
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 sec

Re: [NF] Outlook 2007 handles HTML in a different "standard" way

2007-01-31 Thread MB Software Solutions
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 > Micros

Re: csv files and memo fields

2007-01-31 Thread MB Software Solutions
Judith Barer wrote: > > 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 m

[OT] John McCain - Straight Talk!

2007-01-31 Thread Ed Leafe
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: http://leafe.com

Re: What do I use in place of MSDE?

2007-01-31 Thread MB Software Solutions
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 data

[OT] Anger Management

2007-01-31 Thread Michael Madigan
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. A

Sort on group totals

2007-01-31 Thread Chester Friesen
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 idea

Re: What do I use in place of MSDE?

2007-01-31 Thread Alan Bourke
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: http://leafe.com/mailm

Re: Sort on group totals

2007-01-31 Thread MB Software Solutions
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

Re: What do I use in place of MSDE?

2007-01-31 Thread MB Software Solutions
Alan Bourke wrote: > Well, AFAIK it has never made a PC melt or anything. > That's because of good cooling fans on the motherboard. -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software so

[NF] Drive partition size

2007-01-31 Thread Eurico Chagas Filho
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: ht

[OT] Anger Management

2007-01-31 Thread Eurico Chagas Filho
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 posting

RE: csv files and memo fields

2007-01-31 Thread mrgmhale
> 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"). Actually, when I download the Area Code files from the FTC for Do Not Call lists monthly for clients I use their Fla

RE: [NF] Drive partition size

2007-01-31 Thread mrgmhale
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, Th

Re: [NF] Drive partition size

2007-01-31 Thread Whil Hentzen (Pro*)
>>> 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 >

Re: What do I use in place of MSDE?

2007-01-31 Thread Paul Hill
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

Re: Sort on group totals

2007-01-31 Thread Chester Friesen
MB Software Solutions wrote: > You should be able to do it with VFP5 and up! Just create a column > called iSort and then write logic to populate accordingly, then order by > that column. (Or perhaps I'm missing your point?) > I'll think that through a little, I was totalling each riders dat

Access automation

2007-01-31 Thread Paul Newton
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 contain

Re: [OT] Anger Management

2007-01-31 Thread Ricardo Aráoz
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! __

Re: What do I use in place of MSDE?

2007-01-31 Thread MB Software Solutions
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,

Re: Sort on group totals

2007-01-31 Thread Ricardo Aráoz
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

[OT] Jimmy Carter's buddy now Dictator for Life of Venezuela

2007-01-31 Thread Michael Madigan
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: http://leafe.com/mailman

RE: Access automation

2007-01-31 Thread john harvey
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 Mess

RE: Access automation

2007-01-31 Thread Jeff Johnson
-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 = CREAT

[OT]Toll booth change

2007-01-31 Thread Michael Madigan
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 li

RE: Access automation

2007-01-31 Thread john harvey
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 lc

[NF] Bill Gates Interview

2007-01-31 Thread Ed Leafe
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: http://leafe.com/mailma

Re: Access automation

2007-01-31 Thread Paul Newton
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 (

Re: Access automation

2007-01-31 Thread Paul Newton
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

[OT] Ugly troll to run for senate

2007-01-31 Thread Michael Madigan
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 Messag

Vista & USB

2007-01-31 Thread Andrew Stirling
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

Re: Sort on group totals

2007-01-31 Thread Vince Teachout
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

RE: What do I use in place of MSDE?

2007-01-31 Thread Stephen the Cook
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 inst

RE: VFP9 faster than VFP8?

2007-01-31 Thread Stephen the Cook
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

RE: sql server empty fields

2007-01-31 Thread Stephen the Cook
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

RE: csv files and memo fields

2007-01-31 Thread Virgil Bierschwale
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] [mailt

RE: Sort on group totals

2007-01-31 Thread Stephen the Cook
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 >> r

Re: [OT] Anger Management

2007-01-31 Thread Nicholas Geti
I had to laugh on this one. But you are pulling our legs. - Original Message - From: "Michael Madigan" <[EMAIL PROTECTED]> To: Sent: Wednesday, January 31, 2007 4:19 PM Subject: [OT] Anger Management > Anger Management > When you occasionally have a really bad day, and you > just need

Re: Sort on group totals

2007-01-31 Thread Chester Friesen
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

Re: What do I use in place of MSDE?

2007-01-31 Thread Eugene Vital
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 (withi

Re: VFP9 faster than VFP8?

2007-01-31 Thread Eugene Vital
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 so

Re: Sort on group totals

2007-01-31 Thread Vince Teachout
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, b

Re: Sort on group totals

2007-01-31 Thread Vince Teachout
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,

Re: Sort on group totals

2007-01-31 Thread Chester Friesen
Vince Teachout wrote: > Well, Here's one way: > > SELECT rider, SUM(nscore) as totscore FROM foobar GROUP BY rider INTO > CURSOR totcurs nofilter > > SELECT Foobar.Rider, Foobar.Ddate, Foobar.Nscore, totcurs.totscore ; > FROM foobar INNER JOIN totcurs ON foobar.rider = totcurs.rider ; > ORDER BY

Re: Sort on group totals

2007-01-31 Thread Chester Friesen
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. -- R

Re: Sort on group totals

2007-01-31 Thread MB Software Solutions
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 c

Re: sql server empty fields

2007-01-31 Thread MB Software Solutions
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? > > I

Re: Sort on group totals

2007-01-31 Thread Vince Teachout
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 - i

Re: What do I use in place of MSDE?

2007-01-31 Thread MB Software Solutions
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.I guess the real way to find out is if you

Re: Access automation

2007-01-31 Thread MB Software Solutions
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! -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http

Re: Sort on group totals

2007-01-31 Thread Vince Teachout
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 ; > ORD