Answer Questions

• DiesIrae SELECT statement is showing unwanted display of data and is not passing data to a table.

  I'm using a SELECT statement to pull out data from a table... that is working great. What I'm trying to do is feed the selected data to a different table using REPLACE so that it can be used by a report. All of this is triggered from a command button on a form. Here's the code for the CLICK property of the button: SELECT store, stock, year_1, make_1, model_1, auction1, transport, recon, sold_for, fees, net_check, result ; FROM wholes ...Show All

• John Stallo Class Related Query

  hi all, I m new to programming. Can i add methods or property to a object (e.g. Combo box) which is placed in a container class. Thank you >> addmethod What version of Visual FoxPro are you using I have never heard of any such method or function... yes.  you can add methods and properties with code to any event in any control.  If there is already class code in the event ma ...Show All

• Dave Kafato records disappear forom tables

  A few days ago I ran into yet another problem with Fox. i have a database where the tables were supposed to be filled with the content of some text files. Those files are dumps of my old dBase tables. I have a routine in Fox code that reads the text file, generates necessary number of records and fills the fields with the content between some delimiters in the text file. Anyway, it is not the first time I do it with almost the same code. I tr ...Show All

• SethHersh simple report question

  I'm writing a report (.frx file) and from what i understand, all the fields that i want in the report need to be in the final cursor that I create. Is there a way to pull fields from another table and put them in the same report. I have a table with years and appropriate data per year, which all goes into the report no problem. I want to total all the data/year and put it at the bottom of the report. Now, I can total all the data in another tab ...Show All

• woodpecker0127 Open table exclusively?

  Forgive my ignorance - I've recently reinstalled XP and subsequently Foxpro 7.0. Now when i double click on a foxpro dbf file it opens the table and another datasession labeled 'B' (i'm supposing it's a datasession). Previously, when i opened a table i was in exclusive mode and didn't have this duplicate table open also. I normally work in exclusive mode because my data is not in a shared environment (i'm a vb developer). Any suggestions thanks ...Show All

• MartinMalek Office 2003 SP2 with Item Display Method

  I have some existing code in VFP6 that was working fine with Outlook 2003 until we installed Office 2003 Service Pack 2. This has done the same thing on 2 separate workstations that were both working. When the loMessage.Display() method executes, the application throws an error: OLE error code 0x00000001: Incorrect function. The outlook message is still displayed but something is wrong. <code> Define Class TEmailSender As TCustom &nb ...Show All

• gidon How to copy files from a local hard drive to ftp server?

  Hi! How will i copy files from a local hard drive to a certain ftp server and vice versa using VFP Do you know of a commands that will make this situation possible Any help would be greatly appreciated! Thank you! Regards, Alfred N. Roa West Wind Web Tools - wwIPStuff allows you to do FTP and much more through VFP http://www.west-wind.com/webtools.htm Using Win32 (WinAPI) Functions (using MS WinInet.DLL) http://www.news2ne ...Show All

• jjohnson foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc.

  foxpro exe and dbf's, fpt's, bak's, tbk's, but now prgs etc. I was given a foxpro program and i would like to see the code (the formulas)... i'm not sure how to do this... thank you...   Don--while I also tend to believe that VFP gives better performance than Access, I don't think your one example proves anything. How many times do we hear someone running down FoxPro because they've encountered one badly-written a ...Show All

• CampAlbion label format with underline and bold in spots

  Can you make a single label look like this This is a test of what i want. You can set the font, underline, strikeout, etc, for a particular field on the label, but it would be applied to all words in the field. In VFP9, you might could do this with the use of a report listener. One of the report gurus will likely chime in on this one. How about something along the following lines - using a RichtTex ...Show All

• MinhMinh Virtual vield code (lookup)

  I have two tables Dossier and Rolhand I'am trying to get the newest date from table rolhand into dossier. <-- Text in Red I'am using virutal field, but i can't get it to work. Table: Dossier * DOS_ID     Rol_id           Rol_date ------ -+--------------+------------ 1            05dak-91    &n ...Show All

• Samuel Hobbs DO FORM does not work in exec (for me)

  I have close to 50 clauses, it turns out, DO FORM in my application. They all work perfectly well in interactive mode with the browser but do not work at all in exec after I built it. By "do not work" I mean that I do not even get an error message. Those statements are completely ignored. What I've done so far is trying to find a formula under which I could call outside forms. As I mentioned, when a statement DO FORM <formName> ...Show All

• PabloK Date range in a *.prg

  I'm writing a little program and instead of having to fill in the date range throughout how do I write a variable for the 2 date fields. Example of an excerpt is below but the program has 17 more date lines all with the same range to run on a bi-monthly basis. SELECT Fforder.order_no; FROM ffdbc!fforder; WHERE Fforder.order_date BETWEEN {01/12/2005} AND {31/12/2005}} SELECT Fforder.order_no; FROM ffdbc!fforder; WHERE Fforder.order_date BETWE ...Show All

• RajuATP Grid Columns settings disappear

  I have a grid with about 20 columns and the following properties are defined at design time carefully: backColor, foreColor, fontSize, fontBold for the columns as well as corresponding properties for the headers. Then I have a table and I want to use a part of the table as a recordSource let say to display transaction for year 2005. I get a beautiful display. Then I have a combobox with some years like 2004, 2005, 2006, etc. It controls th ...Show All

• Mark Beiley _screen.ContinuousScroll problem

  I noticed this problem just this morning after spending many hundred hours debugging my app for the past few months when everything worked just fine. This is the setup which is hardly unusual. There is a function in a prg file and a Click method that calls it. There are a couple of print statements like: "coimng out of the function: "+numeric_id and such in the function(s) and one in the Click method. All output is character s ...Show All

• ai_rasmussen use the reccount

  hello all  I use "set filter to" and want to know how much record is match the filter condition. I use the "reccount()"  but it return the result is not I want. it is all the record count This is what I get in the next statement: 'cLocAlias' must be created with SELECT ... INTO TABLE . This statement is: SELECT * FROM cLocAlias ; WHERE cLocAlias.marks = .F. ; INTO CURSOR ...Show All