Recent content by jpugh

It turns out that Rick's first inclination was on target - it was something really obvious. The fact was that the code that creates the Word.Application object was not even running on the client system. I was checking for a .DOC file that was in the wrong place and when it wasn't found, the...

Rick, Good question. Our OS (WIN2000) is the same, however our versions of MS Word are different. I'm not sure why this would make a difference, since I didn't think the VFP app would carry any info about the version of Word it was instantiating. What am I missing? Jon

I have an app that uses OLE to place data into a Word document. On my development system, it works just fine, but on my customer's system, nothing happens - no error messages; simply no response. I suspect that something is missing from by install setup (I'm using VFP 7.0, so it's...

Thanks for your responses. It turns out that the "Quick Edit" check box was the culprit. Regards, Jon

I am trying to run FOX DOS 2.5 in WIN2000. It seems to run fine except the mouse won't work. Any suggestions? Thanks, Jon

Michael, My 2 cents: For all but the simplest apps (like a single form) I would recommend a 3rd party framework. PROS: (a short list) 1. Standard routines/classes that are (relatively) bug free. 2. A team of really good programmers constantly improving the base of your applications. 3...

Your prompting made me go back and re-try something and this time it worked: When installing MSDE, add the argument "SECURITYMODE=SQL" to the command line, e.g. i:\sqlmsde\setup.exe SECURITYMODE=SQL For NT or 2000, this will load MSDE with SQL Server authentication instead of...

fluteplr, Thanks for your response. I don't have SQL 2000 Enterprise. Can you tell me how to check or change the MSDE security?

I am trying to connect with MSDE from VFP7 using SQL-DMO and am so far unsuccessful. I have no trouble setting up an ODBC connection using SQLCONNECT(), but when trying to connect through a server object, I keep getting the error message: "Not associated with a trusted SQL server...

Anthony, I think the timer is the way to go. Simply place a timer object on the form, place the code you want to run in the Timer Event method of the timer object and set the Interval property in milliseconds. (10000 or 15000 for the case you described.) Have Fun. Jon Pugh

Gladys, Although a little more "brute force", I think the following should work : SELECT exporttable SCAN STRTOFILE(MyField1 + ",",'MyFile.txt',.T.) STRTOFILE(MyField2 + ",",'MyFile.txt',.T.) STRTOFILE(MyMemoField + CHR(13),'MyFile.txt',.T.) ENDSCAN If...

Yue, I have tried doing updates the same way you are, had the same problems and could find no way around it. I have found it much easier to update tables on a record by record basis (BUFFERING=3), especially on a remote view where, as you suggest, there can be data problems. This way I can...

If you have access to VFP, you could also use the "Upsizing" wizard to move the data to SQL server. Jon Pugh

I have SP4 loaded and do appear to get the strange behavior you talked about in 1. In fact, the Default for AddLineFeeds is .T.

You might also want to look at SBT which is written in VFP6. They were recently purchased by Computer Associates. FYI, SBT has been around since the late 80's and has always been written in Fox.