Answer Questions

• YingWorkOnDSL Create a Directory

  How can i create a directory when the app begins but validating if the directory exists avoiding an error code thanks a lot! Hi Eric, found it. MD fails to create a directory of more than one level, when the parent directory is either hidden or a system directory: Md (Addbs(GetEnv("APPDATA"))+Sys(2015)+"\"+Sys(2015)) Creating the directory one level at a time works, though. Hi Nora, DIRECTORY() ...Show All

• Shane_2k5 using vars in a thisform. statment

  Hello again, I have a problem using a variable in a thisform. statment. I tried it using the following code: IF v_sichtbar < 10 then         DO WHILE v_sichtbar < 11             v_button = "button0"+ALLTRIM(STR(v_sichtbar))             v_label = "label"+ALLTRIM(STR(v_sichtbar))         &nb ...Show All

• PatrickFe VFP 8 Classes

  I need to create a class in VFP 8. I have create the class and I have put it in a *.vcx file. The problem is that I need to add properties that are specific to the newly created class. How do I add properties to a class in design mode Thanks in advance >How do I add properties to a class in design mode Visually: When the Class Designer is open, go to the Class Menu and you'll see "New Property" and "Edit Property/M ...Show All

• sandeepy data from one table1 that isn't in table2

  Yallo, I know there is an easy fix, but I have spent to much time on it and can't figure it out. I have two tables that share some id numbers. I want to pull all the data from one table where the id isn't in the other table. Table1 id name 1 steve 2 clarith 3 dorthy 4 pudbo Table 2 id name 8 clem 2 clarith 6 fursmorth 4 pudbo two tables: they share records with ID 2 and 4. I need to pu ...Show All

• Nigel-uoh Need help Database trigger

  Hi    I have been tasked to convert an old Clipper app to Foxpro Ver 9.0. The old software has 2 fields in all the databases one called ChangedOn and one called DeletedOn. These fields hold the date,time,computer name, and login name of the machine and user. These fields were updated anytime a record was changed or marked for deletion.   I would like to use the database triggers to update these fields because of the numerous place ...Show All

• Mark Larsen proper practice: Grids with my own classes.

  Hi all; I am trying to find out what is the best way to put a grid in a form so the classes used in the grid are not the base classes but my own classes. If I drag the table from the DE or anywhere else, the grid created is using base classes. Should I manually create the grid by groping my own grid into the form and then start assigning the new columns etc, or is there a better trick to doing this Thank you all. ...Show All

• jack katz data from one table1 that isn't in table2

  Yallo, I know there is an easy fix, but I have spent to much time on it and can't figure it out. I have two tables that share some id numbers. I want to pull all the data from one table where the id isn't in the other table. Table1 id name 1 steve 2 clarith 3 dorthy 4 pudbo Table 2 id name 8 clem 2 clarith 6 fursmorth 4 pudbo two tables: they share records with ID 2 and 4. I need to pu ...Show All

• Karthik R Modifying a MPR file

  Hi, I need help, I have to modifiy a VFP 6.0 application and everytime I edit the MPR file I lose my changes, What I do is open the file, then I change some captions, then I compile the file and that's all. When I build the exe file, all my changes disappeared. What am I doing wrong Could you help me Thanks in advance! The menu designer automatically calls GENMENU.PRG to generate an MPR file for you for ...Show All

• Ovidiu Spacing columns in a grid.

  Is there a way to set up grids so there is a slight margin between the columns (I'd like a little space between the text of the control and the left grid line) I can't use the margin property though because its not just for the left side of the control but all around. Thx, Aleniko I'm trying to accomplish satisfying my demanding customer... :-) He wants the data within the fields spaced so its ...Show All

• Teo Lachev object is not defined but uncatchable

  It is a very strange situation and I have tried various combinations to beat it for a few days--to no avail. The code kept getting more complicated so bear with me please. The issue here is that there is a treeView and an outside button that is supposed to trigger some action. This action (search) needs TreeView.SelectedItem.Text and Tag properties. If I forget to make a selection beforehand the Type (" SelectedItem") is Undefined (&qu ...Show All

• DavidLSNB editbox control snaps.

  It is a fairly mild problem but still an inconvenience. I have an editbox and a text is assigned to it in the following manner: THISFORM.Pageframe1.Page4.Edit1.ControlSource = "(ThisForm.cData)" All other operations are done programmatically. I may force it to count the number of lines and go to a specific line and highlight it. It does. But then after a while, perhaps in about 2 minutes, it snaps to the first line (beginning of ...Show All

• nicoleVN How do I can make a new msde database using the command SQLEXEC()?

  Hi! I have to make a new msde database using SQLEXEC()! I have try this code, but, it, doesn't create me a new database, and fox doesn't get me any error! lnHandle=SQLSTRINGCONNECT("DRIVER=SQLServer; SERVER=CORSO13\MODI;UID=sa;PWD=riservato") IF lnHandle <  0         MESSAGEBOX('Connection Failed!!',16,'SQL SERVER') ENDIF SQLExec(m.lnHandle, "create database "+m.lcDatabaseName) SQLDisconnect(m.lnHandle ...Show All

• Vin Klassen Upgrading from a previous version of Foxpro

  I'm currently upgrading an application written using foxpro 3.0 Like the application Paul was rewriting a few threads back, the only thing that doesn't work is the old character screen menu. It had 10 @SAY and 10 @GET commands and a READ. Then it routed execution to .PRG files with a DO CASE ... ENDCASE loop. I am not looking into investing the time to rewrite the existing UI, and would rather just get the old program working as it was. The ...Show All

• Paulino PP Checking for Additions to a .dbf File

  All, I am wanting to build an interface of sorts for a phone messaging application.  The app writes call entries to a .dbf file that I would like to monitor for additions. Once an addition is made to the table, I would like to insert a new record in to a SQL table and change a status field in .dbf table record to establish that that the new record in SQL was written. My original thought was to use a Linked Server via SQL to the .dbf file. ...Show All

• Jelle B. Working Folder

  With VFP 3.0 I always checked whether the EXE folder sys(16,0) existed in the same folder as the current working folder set("default") + curdir() . If they did not match then I knew that CONFIG.FPW would not be read. So I would exit and display a message telling the user to modify their shortcut. Is there any way in VFP 6.0 and newer to make sure CONFIG.FPW is read regardless of the current folder or method used to start the program ======= ...Show All