Search results for query: *

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.

I have FPW2.6 and the distribution kit, but am unable to create a standalone .EXE. I was sure that I had done it in the past, but all of a sudden, I get a message that says 'Feature not available'. I reinstalled the distribution kit, but that did not help. What am I missing?

It's been a while since I've used VFPXTAB, but as I recall there was no way to do this with VFPXTAB directly. To get the desired result, I added the extra fields after getting a result set from VFPXTAB.

I would agree with all of the above and add the following. The best way to build a system for both growth and flexibility is to design an n-tier system that could in the future be cut over to a larger scale database like SQL-Server or Oracle. VFP is a much better platform for designing this...

You can do the conversion(s) as part of a SQL SELECT. EX. SELECT cdate AS CHRTRAN(DTOC(dDate),'/',''),newSSN AS CHRTRAN(ssn,'-',''),etc. FROM oldTable INTO TABLE newTable Hoder=his helps.

I am attempting to print reports using @ SAY commands to an NT4 network printer from a WIN98 workstation. If I run the report generating code from inside my compiled app, it sends gibberish to the printer. However,if I run the same code outside the application, it seems to print just fine...