[NF] Novell passes control of the HULA project to Messaging Architecs
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 version of this list: http://leafe.com/mailman/listinfo/profoxtech ** 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.
test
___ 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 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: test
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 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.
[NF] Convert spam to a thing of beauty
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 them together like a word puzzle inspired by Salvador Dali's surrealism. I smiled as five haiku sprang to life: http://www.csmonitor.com/2007/0131/p20s01-stct.html ___ 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 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.
[NF] New mini computers
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 these new wave of mini PCs we'll be able to design as usual and have it fully functional on them! To me, that's very encouraging! -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! ___ 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 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 faster than VFP8?
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, objects were internally stored in a link list, and whenever you created or accessed objects, this list had to be traversed. This contributed to a linear slow-down with the number of objects you have. Calvin implemented a logarithmic lookup in VFP8, which contributed to HUGE speed increases. Our app saw 10x increases in speed in some object-intensive areas. http://blogs.msdn.com/calvin_hsia/archive/2004/12/06/276080.aspx VFP8 also was the first version with GDI+, which should speed up all your graphics, though I have noticed some glitchiness compared to the old GDI. For example, I noticed that sometimes images in controls that are 'covered up' with another control will 'shine through'... Another issue is that sometimes I've seen a slight flicker when unlocking the screen(thisform.lockscreen=.F.)-- I had to do a fairly elaborate fix using the win32 lockwindowupdate function inside a lockscreen_assign method to eliminate the flicker). As for VFP8-VFP9, I don't know of any specific changes that would be a significant speed increase, but I don't doubt that some exist(it IS a new version, so they likely did SOMETHING in the name of performance, I'd think). Personally, my building always gets slower and slower, because my build machine uses a small wizard I wrote to build all the projects and do some other things(source safe synchronization, for one)-- and there's no option to NOT regenerate component ID's when building with the BUILD command. This means that the registry on the build machine gets bloated with repeated COM object information. We have to re-image our build machine quite often due to this sometimes... -- Derek ___ 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 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] New mini computers
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 some Linux based mini PCs. http://koobox.com/ NewEgg.com has some bare boned systems that you can build up yourself that would be really sweet. -Kevin MB Software Solutions wrote: 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 these new wave of mini PCs we'll be able to design as usual and have it fully functional on them! To me, that's very encouraging! ___ 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 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] New mini computers
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 these new wave of mini PCs we'll be able to design as usual and have it fully functional on them! To me, that's very encouraging! Ultra Mobile PC's(UMPC)? Yes, they're nice-- I've tried a few that my boss got for prototyping, and I think we've sold a few. I love them mostly because it means we can leave our PocketPC solution by the wayside and not have to deal with the flakey pocketPC OS anymore. :-) The UMPC's are heavy for their size, but generally I like them. Our application is Restaurant POS, so when a customer really wants waitresses to carry around a mobile terminal, this is our solution now(formerly pocketPC's using terminal services with some customized code I used to remove borders, scale properly, etc.). -- Derek ___ 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 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: test
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 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] New mini computers
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 or something? ___ 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 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 faster than VFP8?
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/profoxtech ** 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] New mini computers
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 you going to be running on that that would need that much RAM? SQL Server or lots of virtual machines or something? ___ 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 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: [OT] Finance question for self-employed people
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:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: Tuesday, January 30, 2007 8:34 PM To: Profox Subject: [OT] Finance question for self-employed people I get the impression that if you're self-employed, you've got slim to no chance of getting a mortguage unless you've got tons of money in the bank. Can you other independents give me your 2 cents on that? tia! --Mike -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! [excessive quoting removed by server] ___ 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 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.
csv files and memo fields
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 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. Thanks Judith Judith Barer Star-K Kosher Certification 122 Slade Ave Baltimore, MD 21208 410 484 4110 Fax 410 653 9293 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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 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] New mini computers
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. ___ 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 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: csv files and memo fields
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 to myfile.csv select mytable scan \alltrim(mytable.memofield) endscan set textmerge off set textmerge to This assumes that the data in the memo fields is already comma seperated - which you didn't say. ___ 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 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: csv files and memo fields
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 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. Hi Judith, You can't do it directly as the option ignores memo fields. Copying to a CSV you could select out say the first 250 chars of the memo field (along with your other data) and then do a COPY TO with that data type CSV If your csv file has been written in this format you can append into a cursor with a field 250 chars for the memo, then insert this into your proper memo field. Peter ___ 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 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: csv files and memo fields
-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 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 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. Hi Judith, You can't do it directly as the option ignores memo fields. Copying to a CSV you could select out say the first 250 chars of the memo field (along with your other data) and then do a COPY TO with that data type CSV If your csv file has been written in this format you can append into a cursor with a field 250 chars for the memo, then insert this into your proper memo field. Peter I need to account for the field being bigger than 250 chars [excessive quoting removed by server] ___ 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 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: csv files and memo fields
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! ___ 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 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: csv files and memo fields
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 curious here. If you're taking output from one dbf with the goal of getting it into another, why can't you just COPY TO MYTRANSFER, and then append from MyTransfer into the other file? ___ 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 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.
What do I use in place of MSDE?
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 something like that? Thanks. ___ 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 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] New mini computers
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, you're SOL. Alan Bourke wrote: With all that, I'd be as worried about disk space as I would RAM. ___ 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 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: csv files and memo fields
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 separator other than a comma (say a tab). Of course, depending on why you want it in a CSV format, it may be that an XML format will work just as well. Take care, Fletcher Fletcher Johnson [EMAIL PROTECTED] 408-929-5678 - Cell 408-946-0960 - Work 501-421-9629 - Fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Judith Barer Sent: Wednesday, January 31, 2007 8:21 AM To: profox@leafe.com Subject: csv files and memo fields 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 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. Thanks Judith Judith Barer Star-K Kosher Certification 122 Slade Ave Baltimore, MD 21208 410 484 4110 Fax 410 653 9293 --- 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://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 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: csv files and memo fields
-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 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 curious here. If you're taking output from one dbf with the goal of getting it into another, why can't you just COPY TO MYTRANSFER, and then append from MyTransfer into the other file? 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 of other agencies data. There are definitely better ways to approach this issue such as using web services and such but we are not doing that. 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 me csv seems to be a hassle but using cursortoxml and xmltocursor worked very nicely for me. Thanks [excessive quoting removed by server] ___ 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 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: What do I use in place of MSDE?
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? MSSQL developers version, or something like that? Thanks. 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 size. ___ 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 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: csv files and memo fields
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 of other agencies data. There are definitely better ways to approach this issue such as using web services and such but we are not doing that. 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 me csv seems to be a hassle but using cursortoxml and xmltocursor worked very nicely for me. I knew there had to be a good reason. :-) I was going to suggest the cursortoxml, but you specified csv. However, since they agreed on XML, you might want to look at some of the white papers on www.west-wind.com. Rick discusses compressing XML during transfer, IIRC, which might be the best of both worlds. Anyway, good luck! ___ 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 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: What do I use in place of MSDE?
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/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** 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.
[NF] Drive partition size
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 ___ 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 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] Drive partition size
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 C drive, and everything else on the D drive. Which is, of course, the way it ought to be. Stupid MSFT never cared about segregating software and data, burying user data and settings in the bowels of the C drive. (rant note: Linux, by design, keeps these things separate, which is one reason I took to it so comfortably.) Anyway, supposing you're going to be using this as a typical dev machine, not a ton of new apps but you still want room to grow... I'd say 20 GB would be way more than enough for C. I've got a W2K box with a 6GB C drive and it regularly runs out of room. Another box with 12 GB is very comfortable, but I don't load it up with a lot of stuff. If you're worried, make it 25 - the difference between a 225 and a 230 D drive isn't much. s My Linux boxes have 20 GB (out of 100+) for what you would call the 'C' drive contents; the rest I leave to data. (For those of you Linux folks, that means a 100 MB /boot, an 80 GB /home dir, and 20 GB for /. I move mysql and such to a /home/data dir.) Whil ___ 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 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.
[NF] Outlook 2007 handles HTML in a different standard way
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 products, admitted that in Office 2007, by default, when you write or read an e-mail in Outlook, we are using Word as the underlying engine for that. The solution? Use Microsoft's Outlook 2007 HTML and CSS validator tool, to tell you which parts of your lean, mean HTML e-mails need to be replaced with old-fashioned HTML sludge. We love standards. That's why there are so many. http://www.eweek.com/article2/0,1895,2088905,00.asp -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.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 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] Drive partition size
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 in the recent past from partitioning, and just had headache when the limits of the c:\ drive was hit, many software apps(though sometimes customizable, but always a pain vs. hitting 'enter') put 'data' on the c:\ drive, etc. 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 really important and I don't want to lose it, I put it on D:\(seperate physical drive). I tried mirror'd raid(hardware and software) before, but it was too slow for my tastes. Having two physical drives lets you backup from one to the other as well, along with your less frequent network/tape/DVD backup. I now have a slick rsync setup to sync changed files to a small linux box I built for that purpose(and the super-important stuff to an off-site server via the internet). Which is, of course, the way it ought to be. Stupid MSFT never cared about segregating software and data, burying user data and settings in the bowels of the C drive. (rant note: Linux, by design, keeps these things separate, which is one reason I took to it so comfortably.) Most Linux distribs, and even many Linux 'gurus' I've talked to in recent years don't bother with partitioning the way we did in the past. No seperate /, /boot, /var, /home/, /usr/, and swap. Most say just / and swap. Unless you have to achieve some great performance by segregating your /var partition from the rest, etc., I really don't see the point of partitioning a single drive anymore(beyond / and swap). I'd say 20 GB would be way more than enough for C. I've got a W2K box with a 6GB C drive and it regularly runs out of room. Another box with 12 GB is very comfortable, but I don't load it up with a lot of stuff. If you're worried, make it 25 - the difference between a 225 and a 230 D drive isn't much. s Yeah-- you'll NEVER have 25GB of program files... ;-) I move mysql and such to a /home/data dir.) But mysql data is constantly accessed data, spool, and log files, which would typically be in the /var partition by general Linux partitioning rules(or at least those of 2.0 kernel when I last bothered)... -- Derek ___ 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 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: What do I use in place of MSDE?
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 those developers who have not subscribed to MSDN, or Empower. More details here: http://www.microsoft.com/sql/editions/developer/default.mspx Rick White Light Computing, Inc. www.whitelightcomputing.com www.rickschummer.com 586.254.2530 - office 586.254.2539 - fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: Wednesday, January 31, 2007 11:58 AM To: [EMAIL PROTECTED] Subject: What do I use in place of MSDE? 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 something like that? Thanks. [excessive quoting removed by server] ___ 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 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: What do I use in place of MSDE?
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 so you lose the built in scheduler. Rick White Light Computing, Inc. www.whitelightcomputing.com www.rickschummer.com 586.254.2530 - office 586.254.2539 - fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alan Bourke Sent: Wednesday, January 31, 2007 12:08 PM To: [EMAIL PROTECTED] Subject: Re: What do I use in place of MSDE? 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? MSSQL developers version, or something like that? Thanks. 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 size. [excessive quoting removed by server] ___ 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 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] Drive partition size
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 C: drive for OS and Program Files 200 Gb D: drive for data 4 Gb E: drive for windows swap and for hibernation extended partition 4 Gb for a Knoppix install with all the extras (to reset your Windows passwords when it breaks, for example, or to recover files from NTFS when Windows refuses to boot) 17 Gb for an experimental Linux install (Ubuntu or Fedora or SuSE) - you'll like it! - possibly broken up as /boot, /swap, /var, /home, /root, depending on who you want to listen too, but free space for you to experiment with. -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.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 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] Drive partition size
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-- just use one large partition. I've seen pretty much no benefit in the recent past from partitioning, and just had headache when the limits of the c:\ drive was hit, many software apps(though sometimes customizable, but always a pain vs. hitting 'enter') put 'data' on the c:\ drive, etc. 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. This means I can restore Windows in about 10 minutes. Selective stuff on D I only perodically backup, and most stuff I don't bother. -- Paul ___ 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 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] Drive partition size
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 idea of where things should be stored when I do my backups. It can get quite interesting persuading some apps to store their data on D; though :-) John Weller 01380 723235 07976 393631 I'd personally say don't bother partitioning-- just use one large partition. I've seen pretty much no benefit in the recent past from partitioning, and just had headache when the limits of the c:\ drive was hit, many software apps(though sometimes customizable, but always a pain vs. hitting 'enter') put 'data' on the c:\ drive, etc. ___ 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 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] Drive partition size
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. This means I can restore Windows in about 10 minutes. Selective stuff on D I only perodically backup, and most stuff I don't bother. That's a valid argument. Not one I'd use, however-- I am careful to keep my data backed up daily, so that if I have a disaster of sorts, I can load a fresh Windows install and be running within a few hours without the bloat of a 'used' Windows install... -- Derek ___ 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 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] Drive partition size
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 ___ 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 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.
sql server empty fields
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 empty(). When I tries is not null it returned everything. Thanks Judith Judith Barer Star-K Kosher Certification 122 Slade Ave Baltimore, MD 21208 410 484 4110 Fax 410 653 9293 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ 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 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] Drive partition size
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 point? Just install fresh from the CD/DVD... I know a lot of people do the ghosting thing, but other than limited use in a production or testing environment(this being replaced with VM's these days) stamping out installs, I personally haven't seen a whole lot of use for it. -- Derek ___ 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 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: What do I use in place of MSDE?
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 not subscribed to MSDN, or Empower. More details here: http://www.microsoft.com/sql/editions/developer/default.mspx That's the one Rick Borup told me about that I was trying to remember. However, I just finished the SQL SERVER 2005 server downloads, so I'm going to try those first. Thanks! ___ 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 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] Drive partition size
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 second drive, but if the OS crashes, you'll be reinstalling anyway. I prefer to have two drives when possible. Having said that, my laptop has a 120 gig drive that was split down the middle when I got it and I store data and downloads mostly on the D: partition. The OS and program files are on c: John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Derek Kalweit Sent: Wednesday, January 31, 2007 1:50 PM To: profox@leafe.com Subject: Re: [NF] Drive partition size 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. This means I can restore Windows in about 10 minutes. Selective stuff on D I only perodically backup, and most stuff I don't bother. That's a valid argument. Not one I'd use, however-- I am careful to keep my data backed up daily, so that if I have a disaster of sorts, I can load a fresh Windows install and be running within a few hours without the bloat of a 'used' Windows install... -- Derek [excessive quoting removed by server] ___ 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 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] Outlook 2007 handles HTML in a different standard way
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 Office System family of products, admitted that in Office 2007, by default, when you write or read an e-mail in Outlook, we are using Word as the underlying engine for that. The solution? Use Microsoft's Outlook 2007 HTML and CSS validator tool, to tell you which parts of your lean, mean HTML e-mails need to be replaced with old-fashioned HTML sludge. We love standards. That's why there are so many. http://www.eweek.com/article2/0,1895,2088905,00.asp Carl posted that on VFUG earlier today, too. Here's the part I laughed about: [However, while Microsoft acknowledges in the document that there are some HTML and CSS attributes that are not currently supported by Word's rendering engine, it says the capabilities that our customers most wanted for their HTML newsletters are supported by Outlook 2007.] My comment was that this is M$'s way of saying FU, you critics. But then again, you can't please everybody. ;-) -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! ___ 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 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: csv files and memo fields
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 me csv seems to be a hassle but using cursortoxml and xmltocursor worked very nicely for me. 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 -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! ___ 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 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.
[OT] John McCain - Straight Talk!
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/mailman/listinfo/profoxtech ** 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: What do I use in place of MSDE?
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 size. From the website, as a reminder: *You should install .NET Framework 2.0 first One way or the other, you're gonna get that DotNet framework on your PC! ;-) * -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! ___ 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 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.
[OT] Anger Management
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 man answered, saying Hello. I politely said, This is Chris. Could I please speak with Robyn Carter? Suddenly a manic voice yelled out in my ear Get the right fucking number! and the phone was slammed down on me. I couldn't believe that anyone could be so rude. When I tracked down Robyn's correct number to call her, I found that I had accidentally transposed the last two digits. After hanging up with her, I decided to call the 'wrong' number again. When the same guy answered the phone, I yelled You're an asshole! and hung up. I wrote his number down with the word 'asshole' next to it, and put it in my desk drawer. Every couple of weeks, when I was paying bills or had a really bad day, I'd call him up and yell, You're an asshole! It always cheered me up. When Caller ID was introduced, I thought my therapeutic 'asshole' calling would have to stop So, I called his number and said, Hi, this is John Smith from the telephone company. I'm calling to see if you're familiar with our Caller ID Program? He yelled NO! and slammed down the phone. I quickly called him back and said, That's because you're an asshole! and hung up. One day I was at the store, getting ready to pull into a parking spot. Some guy in a black BMW cut me off and pulled into the spot I had patiently waited for. I hit the horn and yelled that I'd been waiting for that spot, but the idiot ignored me. I noticed a For Sale sign in his back window, so I wrote down his number. A couple of days later, right after calling the first asshole (I had his number on speed dial,) I thought that I'd better call the BMW asshole, too. I said, Is this the man with the black BMW for sale? He said, Yes, it is. I asked, Can you tell me where I can see it? He said, Yes, I live at 34 Oaktree Blvd, in Fairfax, and the car's parked right out in front. I asked, What's your name? He said, My name is Don Hansen. I asked, When is a good time to catch you, Don? He said, I'm home every evening after five. I said, Listen, Don, can I tell you something? He said, Yes? I said, Don, you're an asshole! Then I hung up, and added his number to my speed dial, too. Now, when I had a problem, I had two assholes to call. Then I came up with an idea. I called asshole ..1. He said, Hello. I said, You're an asshole! (But I didn't hang up.) He asked, Are you still there? I said, Yeah. He screamed, Stop calling me! I said, Make me. He asked, Who are you? I said, My name is Don Hansen. He said, Yeah? Where do you live? I said, Asshole, I live at 34 Oaktree Blvd, in Fairfax. I have a black Beamer parked in front. He said, I'm coming over right now, Don. And you had better start saying your prayers. I said, Yeah, like I'm really scared, asshole, and hung up. Then I called Asshole ..2. He said, Hello? I said, Hello, asshole. Fucker; He yelled, If I ever find out who you are... I said, You'll what? He exclaimed, I'll kick your ass! I answered, Well, asshole, here's your chance. I'm coming over right now. Then I hung up and immediately called the police, saying that I lived at 34 Oaktree Blvd, in Fairfax, and that I was on my way home to kill my gay lover. Then I called Channel 9 News about the gang war going down on Oaktree Blvd. in Fairfax. I quickly got into my car and headed over to Fairfax. I got there just in time to watch two assholes beating the crap out of each other in front of six cop cars, an overhead news helicopter and surrounded by a news crew. NOW I feel much better. Anger management really does work. ___ 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 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.
Sort on group totals
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 ideas or not. Regards, Chester Friesen ___ 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 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: What do I use in place of MSDE?
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/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** 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: Sort on group totals
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 enough info to give me some ideas or not. 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?) -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! ___ 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 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: What do I use in place of MSDE?
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 solutions! ___ 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 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.
[NF] Drive partition size
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: http://leafe.com/mailman/listinfo/profoxtech ** 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.
[OT] Anger Management
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 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: csv files and memo fields
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 File (csv) as opposed to their .xml format. Why? The .xml file is nearly twice as large. Their .xml format is also a bit different than what VFP 8.0 used for its default settings, so I had to alter some parameters. It was not worth the hassle. But, since I retain several month's of DNC files for all Area Codes I found it ewasy to simply use csv files due to the storage required with .xml. Then again, I am not dealing with Memo fields either g... Gil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MB Software Solutions Sent: Wednesday, January 31, 2007 3:49 PM To: [EMAIL PROTECTED] Subject: Re: csv files and memo fields 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 me csv seems to be a hassle but using cursortoxml and xmltocursor worked very nicely for me. 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 -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! [excessive quoting removed by server] ___ 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 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] Drive partition size
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, The more you store the more space is wasted due to progressively larger minimum bytes used per cluster. Here are two of the resources I found that do a decent job of explaining the efficiency problem. http://www.pcguide.com/ref/hdd/file/part.htm http://www.smartcomputing.com/editorial/article.asp?article=articles/archive /l0901/39l01/39l01.asp (NTFS efficiency explained) But, with Hard Drives selling for so cheap now I look more at ease of use and cost be damned. I far prefer to run everything on Drive C, which is what pretty much of my client machines do as well. So, what the hell? I try to run in a similar environment for some semblance of consistency between my machinery and theirs. Less to deal with. Gil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ted Roche Sent: Wednesday, January 31, 2007 2:35 PM To: [EMAIL PROTECTED] Subject: Re: [NF] Drive partition size 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 C: drive for OS and Program Files 200 Gb D: drive for data 4 Gb E: drive for windows swap and for hibernation extended partition 4 Gb for a Knoppix install with all the extras (to reset your Windows passwords when it breaks, for example, or to recover files from NTFS when Windows refuses to boot) 17 Gb for an experimental Linux install (Ubuntu or Fedora or SuSE) - you'll like it! - possibly broken up as /boot, /swap, /var, /home, /root, depending on who you want to listen too, but free space for you to experiment with. -- Ted Roche Ted Roche Associates, LLC http://www.tedroche.com [excessive quoting removed by server] ___ 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 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] Drive partition size
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 really important and I don't want to lose it, I put it on D:\(seperate physical drive). I tried mirror'd raid(hardware and software) before, but it was too slow for my tastes. Having two physical drives lets you backup from one to the other as well, along with your less frequent network/tape/DVD backup. I now have a slick rsync setup to sync changed files to a small linux box I built for that purpose(and the super-important stuff to an off-site server via the internet). That would be even better, but the OP said one drive. Which is, of course, the way it ought to be. Stupid MSFT never cared about segregating software and data, burying user data and settings in the bowels of the C drive. (rant note: Linux, by design, keeps these things separate, which is one reason I took to it so comfortably.) Most Linux distribs, and even many Linux 'gurus' I've talked to in recent years don't bother with partitioning the way we did in the past. No seperate /, /boot, /var, /home/, /usr/, and swap. Most say just / and swap. I must disagree - you gotta have /home on a separate partition. That way you can mess with the rest of the box and not touch /home. If your box is still running RH 6 and you haven't reinstalled in 7 years, then, yeah, you could live that way, but s I don't do the /var, /usr, etc. partitions because it gets too hard to guess how big each needs to be. Although FC's lvm makes resizing easier, well, just not my personality. I move mysql and such to a /home/data dir.) But mysql data is constantly accessed data, spool, and log files, which would typically be in the /var partition by general Linux partitioning rules(or at least those of 2.0 kernel when I last bothered)... Yeah, I know. You point them all to the same place, basically replacing /var with /home/data. A little bit easier, but this is personal preference. The bottom line, for me, is to keep data on a separate partition. On a separate drive, even better. A separate box (file server??? s) even better... It does NOT belong in c:/documents and settings and all sorts of other garbage/. s Whil ___ 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 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: What do I use in place of MSDE?
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 users! The only real constraint is a 4GB (I think) max database size. From the website, as a reminder: *You should install .NET Framework 2.0 first One way or the other, you're gonna get that DotNet framework on your PC! ;-) Visual Source Safe also 'requires' the .NET framework. But you can uninstall it afterwards and VSS works just fine. I've yet to see a decent .NET app. I like the idea (ditto Java), but not convinced yet. -- Paul ___ 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 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.
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 = 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 (user) tables - the rest are apparently system tables whose names all begin with MSys. How can I get a count/list of the tables excluding the system tables (without iterating all of them to exclude the system tables) ? Thanks PS What I am eventually trying to do is give the user a choice of tables and then use the Access Export functionality to create a DBF(s). I have done this before using ADODB and the Microsoft.Jet.OLEDB provider but would like to try this different approach. ___ 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 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: [OT] Anger Management
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! ___ 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 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: What do I use in place of MSDE?
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, yet others reported that the page worked fine without it. Sounds like intimidation distribution marketing or something of that nature. You must have this they say but it's really not required for now...they just want it to be there for the future. I've yet to see a decent .NET app. I like the idea (ditto Java), but not convinced yet. I haven't either, but then again, I'm not looking. g -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! ___ 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 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: Sort on group totals
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 enough info to give me some ideas or not. Regards, Chester Friesen Hi, don't know if this is what you need : create cursor MyCursor (TotFld N(2), Num N(12,2)) Insert some random values here select TotFld, sum(Num) as MyTotal ; into cursor MyResult ; from Mycursor ; group by TotFld ; order by 1 and voilá, MyResult is ordered by TotFld and you have totals. Hope it helps. ___ 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 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.
[OT] Jimmy Carter's buddy now Dictator for Life of Venezuela
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/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** 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: Access automation
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 Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Paul Newton
Sent: Wednesday, January 31, 2007 5:13 PM
To: profox@leafe.com
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 = 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
(user) tables - the rest are apparently system tables whose names all
begin with MSys.
How can I get a count/list of the tables excluding the system tables
(without iterating all of them to exclude the system tables) ?
Thanks
PS What I am eventually trying to do is give the user a choice of tables
and then use the Access Export functionality to create a DBF(s). I have
done this before using ADODB and the Microsoft.Jet.OLEDB provider but
would like to try this different approach.
[excessive quoting removed by server]
___
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 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: Access automation
-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 = 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 (user) tables - the rest are apparently system tables whose names all begin with MSys. How can I get a count/list of the tables excluding the system tables (without iterating all of them to exclude the system tables) ? Thanks PS What I am eventually trying to do is give the user a choice of tables and then use the Access Export functionality to create a DBF(s). I have done this before using ADODB and the Microsoft.Jet.OLEDB provider but would like to try this different approach. 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. Jeff Jeff Johnson [EMAIL PROTECTED] 623-582-0323 Fax 623-869-0675 [excessive quoting removed by server] ___ 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 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.
[OT]Toll booth change
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 list: http://leafe.com/mailman/listinfo/profoxtech ** 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: Access automation
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
lctable=oacc.CurrentData.AllTables(i).name
IF OCCURS('MSys',lctable)=0
?lctable
endif
endfor
John
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Paul Newton
Sent: Wednesday, January 31, 2007 5:13 PM
To: profox@leafe.com
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 = 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
(user) tables - the rest are apparently system tables whose names all
begin with MSys.
How can I get a count/list of the tables excluding the system tables
(without iterating all of them to exclude the system tables) ?
Thanks
PS What I am eventually trying to do is give the user a choice of tables
and then use the Access Export functionality to create a DBF(s). I have
done this before using ADODB and the Microsoft.Jet.OLEDB provider but
would like to try this different approach.
[excessive quoting removed by server]
___
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 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.
[NF] Bill Gates Interview
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/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** 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: Access automation
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) automation ? ___ 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 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: Access automation
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 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
lctable=oacc.CurrentData.AllTables(i).name
IF OCCURS('MSys',lctable)=0
?lctable
endif
endfor
___
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 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.
[OT] Ugly troll to run for senate
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 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 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.
Vista USB
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 01250 874580 http://www.calcpay.co.uk HMRC Accredited UK payroll program ___ 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 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: Sort on group totals
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 enough info to give me some ideas or not. 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 Or, sometimes when I do have problems sorting on a column becuase no such column, I can use positional sorting: SELECT stylename, sum(units) as sumall FROM gmoodet GROUP BY stylename ORDER BY 2 ___ 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 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: What do I use in place of MSDE?
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 sort of M$ active-x control, yet others reported that the page worked fine without it. Sounds like intimidation distribution marketing or something of that nature. You must have this they say but it's really not required for now...they just want it to be there for the future. Maybe you can't really uninstall the .NET framework? I've yet to see a decent .NET app. I like the idea (ditto Java), but not convinced yet. I haven't either, but then again, I'm not looking. g You probably wouldn't know one was in front of you. Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 A good way to judge people is by observing how they treat those who can do them absolutely no good. ---Unknown http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.17/661 - Release Date: 1/30/2007 11:30 PM ___ 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 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 faster than VFP8?
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 handled. In VFP7 and earlier, objects were internally stored in a link list, and whenever you created or accessed objects, this list had to be traversed. This contributed to a linear slow-down with the number of objects you have. Calvin implemented a logarithmic lookup in VFP8, which contributed to HUGE speed increases. Our app saw 10x increases in speed in some object-intensive areas. Didn't he grab some how to from the .NET team? Bad Steve! Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 A good way to judge people is by observing how they treat those who can do them absolutely no good. ---Unknown http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.17/661 - Release Date: 1/30/2007 11:30 PM ___ 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 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 server empty fields
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 return False/True or 0/1 for your logical sample above. Select ISNULL( addl_loc_info , false ) From yourtable HTH Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 A good way to judge people is by observing how they treat those who can do them absolutely no good. ---Unknown http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.17/661 - Release Date: 1/30/2007 11:30 PM ___ 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 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: csv files and memo fields
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] [mailto:[EMAIL PROTECTED] On Behalf Of Judith Barer Sent: Wednesday, January 31, 2007 11:00 AM To: profox@leafe.com Subject: RE: csv files and memo fields -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 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 curious here. If you're taking output from one dbf with the goal of getting it into another, why can't you just COPY TO MYTRANSFER, and then append from MyTransfer into the other file? 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 of other agencies data. There are definitely better ways to approach this issue such as using web services and such but we are not doing that. 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 me csv seems to be a hassle but using cursortoxml and xmltocursor worked very nicely for me. Thanks [excessive quoting removed by server] ___ 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 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: Sort on group totals
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 don't know if this is enough info to give me some ideas or not. 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 Or, sometimes when I do have problems sorting on a column becuase no such column, I can use positional sorting: SELECT stylename, sum(units) as sumall FROM gmoodet GROUP BY stylename ORDER BY 2 Unless of course you have details in your report and you want to have the HIGHEST subtotal on top, page 1 and then the next as the data rolls. You need a two table solution with a relationship between them if I have described the issue properly. HTH Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 A good way to judge people is by observing how they treat those who can do them absolutely no good. ---Unknown http://spaces.msn.com/members/srussell/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus Database: 268.17.17/661 - Release Date: 1/30/2007 11:30 PM ___ 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 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: [OT] Anger Management
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 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. ___ 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 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: Sort on group totals
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 showing the total. 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 that's an easy part. Main Heading Name1 01/01/07 50 01/01/07 25 Total- 75 Name2 01/01/07 40 01/01/07 44 Total- 84 Name3 01/01/07 45 01/01/07 44 Total- 89 -- Regards, Chester Friesen Friesen Computer Company Willows, CA ___ 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 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: What do I use in place of MSDE?
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 web page that required you to install some sort of M$ active-x control, yet others reported that the page worked fine without it. Sounds like intimidation distribution marketing or something of that nature. You must have this they say but it's really not required for now...they just want it to be there for the future. Maybe you can't really uninstall the .NET framework? Sure you can! just delete the folder C:\%SYSTEMROOT%\Microsoft.NET\Framework\* 8-) I've yet to see a decent .NET app. I like the idea (ditto Java), but not convinced yet. I haven't either, but then again, I'm not looking. g You probably wouldn't know one was in front of you. Sure you can! If the app is running sluggish and screen refreshing seems slow, then it is probably a .NET app. Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 A good way to judge people is by observing how they treat those who can do them absolutely no good. ---Unknown http://spaces.msn.com/members/srussell/ ___ 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 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 faster than VFP8?
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 VFP7-VFP8 with how objects are handled. In VFP7 and earlier, objects were internally stored in a link list, and whenever you created or accessed objects, this list had to be traversed. This contributed to a linear slow-down with the number of objects you have. Calvin implemented a logarithmic lookup in VFP8, which contributed to HUGE speed increases. Our app saw 10x increases in speed in some object-intensive areas. Didn't he grab some how to from the .NET team? I think you meant to say... Didn't he write some how to' for the .NET team? Bad Steve! Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 A good way to judge people is by observing how they treat those who can do them absolutely no good. ---Unknown http://spaces.msn.com/members/srussell/ ___ 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 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: Sort on group totals
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 that's an easy part. Main Heading Name1 01/01/07 50 01/01/07 25 Total- 75 Name2 01/01/07 40 01/01/07 44 Total- 84 Name3 01/01/07 45 01/01/07 44 Total- 89 O.I.C. 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 4 desc,1 Output: Name3 20070101 44 89 Name3 20070101 45 89 Name2 20070101 40 84 Name2 20070101 44 84 Name1 20070101 50 75 Name1 20070101 25 75 ___ 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 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: Sort on group totals
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 that's an easy part. 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 ___ 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 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: Sort on group totals
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. -- Regards, Chester Friesen Friesen Computer Company Willows, CA ___ 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 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: Sort on group totals
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 come back to this query later and add something before the last field listed in the SELECT statement, you may not be referring to the same field anymore. For example: select cName, dDOB, cEyeColor, cHairColor, sum(iTestScore) from Dating group by 1,2,3,4 order by 4 ...and then you go and add field like so: select cName, dDOB, cEyeColor, cHairLength, cHairColor, sum(iTestScore) from Dating group by 1,2,3,4,5 order by 4 ...you're going to get a different sort order, with the first query sorting on cHairColor, whereas the second query sorts on cHairLength. (That is of course unless cHairColor = 'BLONDE'.hahaha) -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! ___ 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 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 server empty fields
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 isNull() or Nullif() You will also return False/True or 0/1 for your logical sample above. Select ISNULL( addl_loc_info , false ) From yourtable I don't have BooksOnline locally to reference right now, but isn't there an ISBLANK function that may work as well, or is that just with ASP? -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! ___ 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 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: Sort on group totals
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 UNION query, for example: Select Foo, bar from MyJunk; UNION; Select Foo, bar from YourJunk; ORDER BY Bar, Foo Blows up Select Foo, bar from MyJunk; UNION; Select Foo, bar from YourJunk; ORDER BY 2,1 OK ___ 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 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: What do I use in place of MSDE?
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 try to run it on OS flavors other than Windows (and it's not a browser-based app). -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! ___ 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 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: Access automation
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 http://fabmate.com Work smarter, not harder, with MBSS custom software solutions! ___ 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 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: Sort on group totals
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 totscore DESC,1 Just to nitpick-- you don't need the Order by Clause in the first query, because the 2nd query is your final output, and that 2nd Order by will override anything previous. :-) Have fun! ___ 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 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.
