Answer Questions

• Aaron Cheng how to SET DEFAULT TO "running program's dir" ?

  Please Help.... <SET DEFAULT changes the default directory to the directory you specify. MicrosoftR Visual FoxProR searches for a file in the default Visual FoxPro directory. The default directory is the one from which you start Visual FoxPro.> If A program called “DISP.EXE” displaying customer.dbf installed in a directory Created by user, then how to tell the DISP.EXE to look for the database (customer.dbf) The problem is if   ...Show All

• Bendudu designing query in foxpro

  After creating a query using vfp6.0 and when i re-open the query the database is unable to locate the tables. 'errors: tablename.dbf does not exist'. The query is not executed. The design is as follows: I have 5 tables which are located in different folders, i.e, table A,B,C - folder1 and table C,D - folder2 I have created a database in another folder, say c:/database, and i have added a local view. The view has to join all the tables d ...Show All

• swixstud Error using SQL to populate grid

  I have a 9 column grid that I'm trying to populate using an SQL statement in the RecordSource property of the grid.  The statement works fine if I only use 8 fields, but when I try to add the ninth field, in any order, I get a "Command contains unrecognized phrase/keyword" error. This statement works -     thisform.grdmatching.RecordSource="select main.main_id, main.prepdate, ;     main.reqby, act.desc, main.e ...Show All

• pkr2000 COPY TO CommandHi Cetin,

  In Visual Foxpro, I am trying to create a CSV file using the COPY TO command with TYPE CSV, but do not want header fields on top of the output file. Furthermore, I am also trying to attach a COMMA after every row. Current Output f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13,f14,f15,f16,f17 "0","49162","0","0","0","0","0","0","0","0", ...Show All

• David Lapides [noob questions] Arrays..

  Aaaaaaaaaaaaaaaarrrrgggghhhhhgadsfhasdjhf 1. Is foxpro incapable of returning an array from a function by using the return statement  2. Does foxpro have a function that merges 2 arrays 3. How do you pass an array as an argument to a function in a class when the array is a class variable For example: define class test as Custom     dimension Arr(1)        procedure asdf(tmpArray, tmp ...Show All

• Guna Natarajan how could i make my main prog looks like "MY EXPLORER"

  Good day to everybody, Maybe i miss this topic,..is anyone can guide me where i could find the sample for this matter. How could i make my application, that when you click the icon at the disktop it opens like you are opening the "MY COMPUTER" using 'explore' that shows drop down list, but instead of showing the drive c, cd-rom drive and e.t.c it shows all your form's name (ex. salaries, sales entry & e.t.c then a drop down f ...Show All

• amit_800 word in vfp

  i have seen in some programs a window similar to word that opens inside from vfp.is it possible to open ,lets say a word istance window inside vfp ,so that i can create save print a word document I tried it, but I selected RTF instead of Word document. No Word is required an the client PC, but a simple activex control. There's a good example in this file . Feel free to download it. Mark, RTF and MS Wor ...Show All

• SpeedyBoy Memo file is missing or invalid

  Hello, I have a DBF file an I need to open it. I have VFP9.0 and when I try to open it I get a message suc as: "Memo file C:\....\myfile.fpt is missing or is invalid." Is there a way to open this file I will deeply appreciate advices or ideas.. Thanks. Hi slarin, No he didnt give the .fpt file, but I solved my problem already, I used dbf recovery trial, and then from there I saw the structure of the table (memo), then I ...Show All

• Enselic Quick subquery ... query.

  Hi there, I have a small query with regards to FoxPro's subquery handling. In T & Oracle SQL the following query returns the data I require: SELECT * FROM tableName WHERE (SELECT count(fieldName) FROM tableName WHERE fieldName = 'testData') = 0 Whereas in FoxPro I'm getting the error "Queries of this type are not supported". Ignoring the fact the query is pointless in its current form (I'll be replacing the select w ...Show All

• Steven Randolph How to view all code used in a form and its controls.

  Hi   I would like to be able to view all of the associated code used in a form and its controls contained within it. This is how VB shows your code. Now I have to select each object and then the event to see the code for each section. I did this by accident before and cannot seem to figure out how I did it again. Please advise me on how to do this. Thank You Rob Thanks David that is what I needed! R ...Show All

• brenzy n-tier design

  I am designing an application and I want to start using n-tier design. I have no problem with the user interface but have some questions about the business and data tiers. My application will probably be all in one vfp exe so I don't particularly have to get into ADO or XML. Am I correct in assuming the actual data reading and writing statements (eg Replace, Insert etc) go into the data tier I am thinking that I would need some sort of data hand ...Show All

• KPeters minimize and maximize buttons on Report Designer

  Can you remove maximize buttons on Report Designer in Visual Foxpro 6.0 Please help. Thanks in advance, Sanj. Hi Sanj, I am not sure what to tell you.  Can you provide some more details like when you say you can't go to the next page in the report what do you mean   Do you get an error or is there another problem It would probably more productive if you put together a simple repro and sent it to me in email Cameron Slade V ...Show All

• jaymin patel 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

• Dirk Strikwerda How to print a label?

  I've got a table with name and number. I want to print a label witch this name "number" times. How can i do it. How to loop a cursor :( >> I've got a table with name and number. I want to print a label witch this name "number" times. How can i do it. How to loop a cursor FOR lnCnt = 1 TO num_to_print   LABEL FORM [name] TO PRINT NEXT     You could create a temporary cursor with the same number o ...Show All

• beezleinc How to prevent VFP application from decompiled by Refox/Unfoxall?

  I found that UnfoxAll and Refox can decompile nearly all VFP application. Is there anyway to protect VFP code from decompilation Dear Sir How To Prevent Decompile Application File Thank You To be true, one cannot protect vfp applications from decompilation.There are applications available which can even decompile the third level of protection of Refox. Anyway brand your applications or fxp files at I+ level using Refox and U ...Show All