FoxPro - General FoxPro Topics

Thread preview

Thread	Last Post	Replies

local views open slowly	07 Dec 2007 16:42 GMT	6
I have a database (DBC and tables) on a local server. When I open a table (a customer table) with about 3000 records it takes about 1 sec When I use the table via a local view nodata (regular view of the same single table, all fields), it takes 3 times as long (3-4 seconds).
replacement of missing values	07 Dec 2007 16:04 GMT	1
Given the following raw tables with the fields, a, b, and c: a b plus 111 10 0 111 10 0
Fastest way to convert 1000's of YYYYMMDD char dates to real dates?	07 Dec 2007 13:58 GMT	13
Signature -Lew The workers took the robot for Maria.
cast and precision	07 Dec 2007 11:27 GMT	2
I'm doing a series of principal * rate calculations and the rate lookup itself is calculated in a sql statement. When I first wrote the query, vfp showed me a cursor with 4 decimal places in the rates col .. which isn't enough for my users, so I redid the query using cast( <calc> ...
shared connection	07 Dec 2007 07:08 GMT	4
What are the ramifications of using a shared connection in the creation of a remote view, compared to an "unshared" connection? FoxPro docs say this: "The SHARE keyword specifies that Visual FoxPro use a new statement handle
Converting DBF to MySQL	07 Dec 2007 01:33 GMT	4
My tables has memo fields. DBF2MYSQL can´t convert this fields. How Can I do this? Thanks. Alejandro
Win Home Server Console Crash	06 Dec 2007 22:27 GMT	2
Could someone help me with some ideas of what to check? I'm running Windows Home Server (OEM edition) an on older system that was used for all phases of the beta testing with no problem. The OEM version was installed and all connector software updated on 5 systems - all okay for a ...
password	06 Dec 2007 21:39 GMT	1
Does anyone have a quick (and dirty) password module I can front-end to my project? I am using VFP9.0 on XP machines Signature Lost in Tampa
Outlook 2003 rules	06 Dec 2007 21:20 GMT	2
About 2 months ago I noticed that several of the rules that I had setup disappeared. At one point I had over 100 rules setup, the next day I had about 30. I have no idea where they went and now when I try to create a new one it says there is insufficient space to store all your ...
Service Control Manager error messages	06 Dec 2007 15:40 GMT	2
My computer is running like a sick 2 legged dog. the event viewer shows the same error approximately 8 times a minute (my guess at why it is so slow), the error message is shown below. Event Type: Information
Pure sql solution to date period	06 Dec 2007 15:23 GMT	4
I've got a semi sql solution to this problem, but can I do it in pure sql? Here it is: Given a table in the form name, date, rate, create a result cursor in the form name, startdate, enddate, duration (it's crosstab ish). The idea is for
VFP 9 on Windows 2008 TS	06 Dec 2007 05:33 GMT	6
We are testing W2k8 TS. On 32 bit OSs we copy the VFP support files to the \System32 directory. However, this does not work on W2k8. Any suggestions? Thanks.
Sending Reports by e-mail	06 Dec 2007 02:16 GMT	1
Is there a simple way to send a report by e-mail in VFP9? I have some reports that I would like to be able to send to some people as well as print them. Thanks in advance
Sending Reports by e-mail	05 Dec 2007 18:59 GMT	3
Is there a simple way to send a report by e-mail in VFP9? I have some reports that I would like to be able to send to some people as well as print them. Thanks in advance
Sync Grids	05 Dec 2007 07:01 GMT	1
Is it possible to have 2 grids on a form with both of them having the same number of columns and identical column sizes and have them both scroll left or right when the user scrolls one of the grids left or right. There would be no sync of the vertical scrolls, only the left and ...