Answer Questions

• ArnieM VFP 9.0 SQL worthless under a non client server network?

  Hello everyone; I have posted this problem here and also on UT and no solution yet. I have a small network with a 2003 server, and XP pros. I am running vfp 9 select * from products where status = "S0000" takes apx 10 seconds when run over the network. When running this locally, it takes only a fraction of a second. The product table contains 100,000 records, and the result of the SQL command is just a few hundred rec ...Show All

• Patty B Fonts, Fonts and more Fonts.

  Hi everyone, I have posted this quetion before, but I still don't have a reaonable solution. I have a whole bunch of reports which are created in FOXBASE. These are generated using simple commands. Initially we want to run them as they are. The problem is that no matter what font I try, it is not identical to the older 'text' font. Since we are printing on forms, we need the font to be identical. Is there no way to print something ...Show All

• Shaun Miller MS VFPOLEDB on 64 bit Operating Systems

  This is a bit annoying because there doesn't seem to be any reference about this on any of Microsoft's sites. Is the VFPOLEDB not compatible with 64 bit operating systems When trying to use it with either XP Pro 64-bit Edition or Windows Server 2003 64-bit edition, I get the "Provider not installed on local Machine." I find it hard to believe (sort of) that Microsoft would not specify that, nor get a patch out for it. Many of my ...Show All

• Fenixk19 Grids are readOnly. How do I put text in them?

  Hi there. Kind of embarrassing asking simple question when other people post such advanced requests. I am new here. I got as far as creating a form with two grids and other controls I need. There is a Pageframe that switches between pages and I have each grid on the corresponding page. All the way I am making comparisons with dBASE stuff which I hope soon will be a thing in the past. Anyway, when I run the form all rows in grids appear to be rea ...Show All

• Simeon Antonov 12 hour time format

  Hello, I am doing a program that will compute the time in and time out.  As much as possible I want to do the time() function and not the datetime() function but the problem is if I use time() it displays the 24 hour format.  What I am tasked to do is to subtruct the time out to time in and be able to display the 12 hour format. Any advice will be greatly appreciated. But surely that's a display issue, not a data storage is ...Show All

• Yew Thean Hoo Which one is faster, cursors, queries, local views, other?

  Hello, I'm using VFP 7 on a very old machine. I'm working with very large tables and I need to create a lot of queries, but my tables are so large it takes forever to load the results. I've been creating cursors on the run from SELECT statements but it's still very slow.... What can I do to optimize my queries/views so they are much faster... I'm new to this, so I don't know much... I just need to be able to run all this queries ...Show All

• Mac7 Use or not BLOB fields with SQL Server

  Hi: We are deciding which would be the better approach for managing a lot of files ( PDF, JPG, DOC, DWG, ETC. ). We are speaking about thousand of files and thousand of megabites. As far as we are developing with VFP 9.0, we would be able to use BLOB fields. But we are not sure if it will be the best choice for us, taking in account, the amount and sizes of the files. Could anyone help us Regards, Ana Madrid, Spain www.amby.net www.PortalFox.c ...Show All

• cgerull Median

  Hi all, I have a simple table with ages listed (called c_age). Does one know how to find the median of these ages Does VFP have a built in Median() function Mike SELECT age FROM c_age ORDER BY age INTO ARRAY aTemp   nCount = ALEN(aTemp, 1)   IF MOD(nCount, 2) = 0     nLo = aTemp(nCount / 2)     nUp = aTemp(nCount / 2 + 1)     nMedian = (nLo + nUp) / 2 EL ...Show All

• Silicon MSComctlLib.TreeCtrl.2 BackColor ???

  MSComctlLib.TreeCtrl.2 does not have BackColor property. Is it possible to define one (it is of course possible) and actually make it functionable Thanks. If you are the only user of your controls than it might not matter. Otherwise my basic reason was that it doesn't behave as you expect it to be (even if the user loved the color). You might see what I mean when you add multilevel nodes expanding/shrinking (especially if nodes too hav ...Show All

• Luiz Papa How can I use a stored procedure in my asp.net app

  I'm trying to execute a stored procedure in my webform, I tried the next code: OleDbCommand cmdtemp; OleDbConnection conn; conn = new OleDbConnection(ConfigurationSettings.AppSettings["strConnection"].ToString()); cmdtemp = new OleDbCommand("storeProc_1",conn); cmdtemp.CommandType = CommandType.StoredProcedure; try { conn.Open(); cmdtemp.ExecuteNonQuery(); conn.Close(); } catch (Exception ex) { string Mensaje = ex.Message; conn.Close() ...Show All

• Yoseph Problems with Command REN ???

  Hello!!! I usually use the following command in VFP6 (in Win98): !Ren Folder1 Folder2 to rename the name of Folder Folder1 to name Folder2. It is OK. But I can't use this command in WinXP (SP2). I don't know why Can any one help me Thanhs a lot. Have you tried the VFP command: RENAME FileName1 TO FileName2 Hi Alex !!! I've tried yours Script: ooFSO = CreateObject("Scripting.FileSystemObject") o ...Show All

• Vishu Philadelphia VFP User Group meets this Wednesday, November 9

  Wednesday, November 9, 2005--7:00 PM Microsoft's Malvern office: http://www.microsoft.com/mscorp/info/usaoffices/greaterpa/malvern.mspx Speaker: Robert PierceBio: Robert Pierce is currently the Manager of Information Services and senior developer at Smooth-On Inc., a rubber and plastics manufacturing company located in Easton, PA. With 21 years of custom Fox programming experience; he has been a consultant, a contract programmer, and part of th ...Show All

• r0dr1g0 Help with query in VFP 9.0

  I'm new to VFP folks - I have a database in Access that I query to get results for up to date jobs. I have tried mirroring the database in VFP but I can't get my query to work in VFP, even with the wizard. Can anyone help just by looking at the SQL for each I get only 15 or so records in VFP, whereas I return 95 records in Access. Thanks! Access SQL Code: Probably you had a problem in mirroring the tables. Check FAQ #8039 on www.universalt ...Show All

• AndyMauer THIS.AddProperty does not work in exec--BUG

  This is official and may be reported as a bug. In VFP9+SP1 THIS.AddProperty does not work in execs . Period. I am pretty certain the pandits around here haven't been aware of it. The error message is 1001: feature is not available. What works, it turns out, is ADDPROPERTY (THIS,cPropertyName,<initval>). I had .addProperty literally in hundreds of places. Had to replace them with the other incarnation. The monster has been debugged a ...Show All

• Heinz_Richards Changing Report Label Text At runtime using ReportListeners

  Hi, I want to change the Text of the Labels in the Report using Report Listener. My exact scenario is like this. The application which i am working is a international product and used in various languages, i want to change the report Text, Label and Static Text to the Corresponding Language selected in the application. Is there any way using ReportListener we can dynamically change the static content in the Report especially Labels and ...Show All