Re: [NF] Net TV

Hi, The easiest way to stream video 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. __

Re: [NF] MSSQL attach MDF file without LDF file?

e. >> >> > That's what I thought. They'll just have to send it again, correctly. > Thanks. > > Hi, use the sp_attach_single_file stored procedure: EXEC sp_attach_single_file_db @dbname = 'pubs', @physname = 'c:\mssql7\dat

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

d drag the constants to a code window. 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 _

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

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 n

Re: [NF] Momentum for Linux PCs

bian. The main 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 Ma

Re: Excel ADO automation and dates.

you want. Another option is to format the cells with data: Suppose the data is in column C: Columns("C:C").Select Selection.NumberFormat = "dd/mm/" HTH Jaime Vasquez. ___ Post Messages to: ProFox@leafe.com Subscription Maintena

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

thing, as you can see in the links at the end 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 vers

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 Gua

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

the COM interfase, which is what this dll does. 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/m

Re: Directory Size

oFs = createobject("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-fre

Re: Directory Size

, is shown here: http://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(" &q

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 Messa

Re: Polling App

act to the events. The vfp9's 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: Pr

Re: [NF] Riping from DishNetWork

it. > Lots of info here: http://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/listinf

Re: [NF] Another app broken by IE7

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

Re: newb questions about moving and renaming classes and forms

ject will rename 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 versio

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/da

Re: [NF] - AVI/MPG to DVD

/tinyurl.com/27muet 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 expli

Re: [NF] Linux Advantages

windows but that can be done in Windows too: netsh 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.

Re: My appalling ignorance - creating visual classes

on: ftp://leafe.com/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 Searc

Re: [NF] Terabyte servers for the home

he disks, start the machine, configure the disks, and you're ready to go. HTH Saludos, Jaime Vasquez Guatemala C.A. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free versio

Re: Setting Default Printer

th: DECLARE INTEGER 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

Re: Parse FullPath() UNC

ow = 3 Else *-- Drive Letter, Start at second row: lnRow = 2 EndIf *-- Folder structure For lnI = lnRow To lnFolders lcFldrs = lcFldrs + "\" + aFolders(lnI) next ?lcFldrs Note: in versions prior to 9, substitute the parameter 4 in alines() w

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: [NF]MSSQL Statement-- performance inconsistency?

g = "your connection string" 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

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

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

char(10)) insert into codes values("Order 1", "code 1") insert into codes values("Order 1", "code 1") insert into codes values("Order 1", "code 1") insert into codes values("Order 1", "code 2") insert into codes valu

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

quilas", factories 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 Subscrip

Re: SQL question: How to sum ???

NT ELSE 0 END) from table Do it this way: select sum(case when discount<0 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

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 Guat

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 t

Re: Help - cannot create word.application

have any ideas? Could it be a group 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.

Re: Excel question

ing Sequence=general;" loconn.Open lors.Open("select * from credidt.dbf", LoConn) *excel object: loExcel = NewObject("Excel.application") loWorkBook = loexcel.Workbooks.Add loWorkSheet = loexcel.ActiveWorkbook.Worksheets.Add loExcel.visible = .T. loworksheet.range(&qu

Re: Excel question

t. Speed, no need to create phisical files, 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. ___

Re: Excel question

it is for Excel, not ADO, although 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 thi

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 t

Re: Excel question

gt; .. and does anyone know if the excel .CopyFromRecordset method also > 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. __

Re: Excel question

I thing the solution you found is the best, create a recordset with the number of records you 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

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

r: http://www.blackyard.net/downloads/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

Re: [NF] Foreign Search Engines

e have Google Guatemala: www.google.com.gt 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/

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 Va

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

Re: How To Know If an Internet Connection is Active

Msg = "Not connected!" EndIf MessageBox(msg) 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/m

Re: [NF] How to save GroupWise messages?

find 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.