Re: Use a character from another codepage

Hi, I don't think you can do that in Windows, but try with cpconvert: Cpconvert(1252,437,Chr(255)) Greetings Graham Trott wrote: Would like to use the block character from codepage 437 without changing codepages chr(219)=? and chr(255)= blank space VFP9 uses codepage 1252. I am not

Re: Excel ADO automation and dates.

/ HTH Jaime Vasquez. ___ 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 Searchable Archive: http://leafe.com/archives

Re: sql server and windows vista

Rafael Copquin wrote: thanks to all of you for your replies Rafael Hi Rafa, Sql 2000, 7.0 and 6.5 doesn't work with Vista, you need at least 2005 sp2 instead: http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx Saludos Jaime Vasquez

Re: VFP and Office Automation (MS Excel specifically at this time)

. the old fox wiki: http://fox.wikis.com/wc.dll?Wiki~ExcelConstants or msdn: http://msdn.microsoft.com/en-us/library/aa221100(office.11).aspx http://msdn.microsoft.com/en-us/library/bb259478.aspx HTH Jaime Vasquez ___ Post Messages to: ProFox

Re: [NF] Net TV

is with VideoLan: http://www.videolan.org/doc/play-howto/en/play-howto-en.html http://forum.videohelp.com/topic259354.html http://www.engadget.com/2005/11/29/how-to-stream-almost-anything-using-vlc/ HTH Jaime Vasquez Guatemala, C.A. ___ Post Messages

Re: [NF] Momentum for Linux PCs

diference between the first 3 is the window manager, ubuntu uses gnome, kubuntu kde and xubuntu xfce, for older machines. http://lwn.net/Distributions/ HTH Jaime Vasquez. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com

Re: Strategies for keeping connection open to MySQL web database from VFP9 client

of the article: http://en.wikipedia.org/wiki/Connection_pool Cheers Jaime Vasquez. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman

Re: [NF] Foreign Search Engines

There are more than 100 googles: http://c.asselin.free.fr/french/googleworldwide.htm Greetings. Jaime Vasquez Guatemala C.A. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version

Re: Where Do Files Go When Sent to the Vista Windows Folder?

/ATF-Cleaner.exe Saludos Jaime Vasquez Guatemala C.A. ___ 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 Searchable

Re: Excel question

want to copy in every page. I just have 2 observations: If the recordset has the number of records you want, there's no need for the sencond parameter in copyfromrecordset method. The copy will be a bit faster if you set excel visible = .t. before copy the recordset. HTH Saludos, Jaime

Re: Excel question

, everything is done in memory. No need to deal with odd codepage conversions. ADO is the method Excel underestands better. Remember use the right tool for the job. :) HTH Saludos, Jaime Vasquez Guatemala C.A. ___ Post Messages to: ProFox@leafe.com

Re: Excel question

Excel 2007 has now a limit of 1048576 rows. HTH Saludos, Jaime Vasquez Guatemala C.A. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman

Re: Excel question

Ricardo Aráoz wrote: Jaime Vasquez wrote: Ricardo Aráoz wrote: My reports generate Excel files, if the report is too long (more than 64000 lines) I use different pages in the same file. I have two ways to do it, either I export up to say 15000 lines with a copy to command to a temporary excel

Re: Excel question

truncates cells to 256 characters? No, it's limited to the limit of the cell, 32767 characters. Only 1024 display in cell, all 32767 display in the formula bar. HTH Saludos, Jaime Vasquez Guatemala C.A. ___ Post Messages to: ProFox@leafe.com

Re: Excel question

object: loExcel = NewObject(Excel.application) loWorkBook = loexcel.Workbooks.Add loWorkSheet = loexcel.ActiveWorkbook.Worksheets.Add loExcel.visible = .T. loworksheet.range(A1).CopyFromRecordset(lors) copy data to excel HTH Saludos, Jaime Vasquez Guatemala C.A

Re: Help - cannot create word.application

policy or other security setting??? Help! See if your code or config.fp has SET OLEOBJECT OFF, if yes then turn to on, or you will don't be able to create automation objects. HTH Saludos, Jaime Vasquez Guatemala C.A. ___ Post Messages to: ProFox

Re: Numbers to words

Bryant wrote: Does anyone know where I can find coding to convert numbers to words for printing checks? http://users.aol.com/FoxProResources/zipfiles/num2word.zip Other userfull procedures: http://users.aol.com/FoxProResources/fpfp.htm HTH Saludos Jaime Vasquez Guatemala C.A

Re: Numbers to words

Bryant wrote: Does anyone know where I can find coding to convert numbers to words for printing checks? Forgot to add this: http://support.microsoft.com/kb/259663 HTH Saludos Jaime Vasquez Guatemala C.A. ___ Post Messages to: ProFox

Re: SQL question: How to sum ???

sum(case when discount0 then discount else 0 end) from table. HTH Saludos, Jaime Vasquez Guatemala C.A. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http

[OT] Re: Dell to start selling PCs at WalMart

that made clothes, they put the made in usa label, but all the work is done here. http://en.wikipedia.org/wiki/Maquiladora Saludos, Jaime Vasquez Guatemala C.A. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman

Re: SQL: Count() of DISTINCT codes???

, code 1) insert into codes values(Order 1, code 2) insert into codes values(Order 1, code 3) insert into codes values(Order 2, code 1) insert into codes values(Order 2, code 3) select code, count(code) from codes group by code HTH Jaime Vasquez

Re: VB to VFP

Sytze, no need to convert, see: http://fox.wikis.com/wc.dll?Wiki~GUIDGenerationCode~VFP HTH Jaime Vasquez. Sytze de Boer wrote: Thank you Stephen Here it is Option Compare Database Option Explicit Private Type Guid Data1 As Long Data2 As Integer Data3 As Integer Data4(7

Re: [NF]MSSQL Statement-- performance inconsistency?

oconn.open 'now call the sp and get the data into the recordset: set ors = oconn.execute(test_sp) do while not ors.eof debug.print ors.fields(0).value ors.movenext loop .. HTH Saludos Jaime Vasquez ___ Post

Re: My appalling ignorance - creating visual classes

/PrgToVcx.zip HTH Jaime Vasquez. Guatemala C.A. ___ 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 Searchable Archive: http

Re: [NF] - AVI/MPG to DVD

HTH Jaime Vasquez. ___ 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

Re: [NF] Linux Advantages

interface ip set address name=Local Area Connection static 192.168.0.100 255.255.255.0 192.168.0.1 1 Or netsh interface ip set address Local Area Connection dhcp Jaime Vasquez. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: newb questions about moving and renaming classes and forms

the .scx and .sct files at the same time. The same method aplies to any file in the project. HTH Jaime Vasquez. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list

Re: [NF] Mount an ISO CD image as a virtual CD/DVD drive?

Malcolm Greene wrote: Justin/Rick, The unsupported Microsoft tool is my favorite (Justin) Try Nero (Rick) Hi Malcom, If you choose Daemon Tools, look for the last clean version: 3.47 http://www.disc-tools.com/download/daemon347+md5sum HTH Jaime Vasquez

Re: [NF] Another app broken by IE7

Whil Hentzen (Pro*) wrote: I would love a screen shot of the 'never!' message. s Whil For your eyes pleasure: http://www.thedatafarm.com/blog/content/binary/wsftpnever.png Jaime Vasquez ___ Post Messages to: ProFox@leafe.com Subscription

Re: [NF] Riping from DishNetWork

://www.videohelp.com/guides HTH Jaime Vasquez ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless

Re: Polling App

solutions samples have a demo on how to do that with VFP code, look for it in New in VFP9 - Binding To Windows Message Events - File/Folder Shell Events. HTH Jaime Vasquez. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: Directory Size

Richard Kaye wrote: You could do something similar using ADIR() ADIR(aFiles,[*.*]) x=0 FOR y=1 TO ALEN(afiles,1) x=x+afiles[y,2] NEXT ?x Cool!, another option, Thank you. Jaime Vasquez. ___ Post Messages to: ProFox@leafe.com

Re: Directory Size

://vbnet.mvps.org/index.html?code/fileapi/getdirectorysize.htm another alternative could be to use DOS: !Dir c:\windows c:\tmp\windir.txt nI = Alines(aFolderSize, Filetostr(c:\tmp\windir.txt)) ?Folder Size: + Substr(aFolderSize(nI-1),Rat( , aFolderSize(nI - 1), 2)) HTH Saludos Jaime Vasquez

Re: Directory Size

(Scripting.FileSystemObject) oDir = ofs.GetFolder(C:\windows) ?odir.Size HTH Jaime Vasquez. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman

Re: Visual Studio 2005 Professional Edition with MSDN ProfessionalSubscription

mrgmhale wrote: I can also download previous versions of apps and O/S (not Office 2000 due to the Great Java Debacle). What was the debate with Java?, I'm still using Office 2000, without any problem. Thank You. Saludos, Jaime Vasquez Guatemala, C.A

Re: [NF] MS Office Outlook 2003 Email Sent by VFP Requires Approval ... Rats

Saludos, Jaime Vasquez Guatemala C.A. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless

Re: [OT] 1 in 5 children can't find the UK on a map.

Paul Hill wrote: http://video.google.com/videoplay?docid=-4064401188831660771 Wow! and they say that the Latin Americans are ignorant Jaime Vasquez Guatemala C.A. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http

Re: Setting Default Printer

SetDefaultPrinter IN winspool.drv STRING SetDefaultPrinter(GetPrinter()) HTH Saludos, Jaime Vasquez Guatemala, C.A. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list

Re: [NF] How to save GroupWise messages?

anything about that in the groupwise documentation. Hi Gérard, it's an OE feature, someone enabled it because it's not active by default. In OE go to Tools - Accounts - Properties - Advanced, look for Break apart messages larger than, uncheck it, accept changes. HTH Saludos, Jaime

Re: How To Know If an Internet Connection is Active

Jaime Vasquez Guatemala, C.A. ___ 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

Re: [NF] How to disable Windows Genuine Advantage from phoning the mothership.

Alan Bourke wrote: http://www.theregister.co.uk/2006/06/22/wga_remove/ Oh dear .. it appears the that the above article links to is down for maintenance. After a call from MS lawyers, I'll warrant. Fifteen ways to remove WGA http://tinyurl.com/nfrgw Jaime Vasquez

Re: tab order question

Ken McGinnis wrote: Yes, that is exactly what we need. I wonder how hard that would be to create? It's already in the product: Tools - Options - Forms - Tab Ordering, Choose 'By List' Accept changes, next: View - Tab Order. HTH Jaime Vasquez Guatemala, C.A