Answer Questions

• Dave Singleman order of table fields is reshuffled

  I want to use this occasion to thank everyone who has been helpting me with their advice. I still have to study some of the comments in depth to get the maximum out of them. HOWEVER, I just ran my first successful execution which converted a Visual dBASE table into a VFP table. I have a form with two (unrelated) tables on it and an external .prg file with a function with 170 lines of VFP source code. It all worked. Very cool! Perhaps before the ...Show All

• Tutnik Main Window Default Size/Location

  I would like to know what determines where the compiled EXE application window opens and what size it is. I would like to have the window: - remember if it was maximized or - remember last size and position Right now it is always starting in the top/left corner and I'm not sure what I did to get it that way. Thanks You can change the main form to AUTOCENTER = .T. if you want it to always be centered. Is that w ...Show All

• rickd24 checking RTF control for EMPTY ()

  I have trouble checking programmatically that RTF.textRTF is empty. If it is visually empty to the viewer the function EMPTY (RTF.textRTF) returns .F. If I use an assignment m.memVar = RTF.textRTF I can print it out as a set of strings (about 3) of formatting characters. It is after the control was filled with some text and subsequently that text was deleted (manually) in the control window. How can a test be done to verify that the control i ...Show All

• MarkL1976 How to get the UserID and password login to windows in Visual Foxpro?

  Could you show me the way (in Visual Foxpro) to get the UserID and password that i've logged into windows please Thanks. ChinhNguyen Since you've logged into Windows, you should know the password. Just right it down. If you do not know the pw you are not the owner of this system and God knows what your intentions are. GETENV("USERNAME") Will give you the username. I don’t think y ...Show All

• dgrm44 VFP 6 Table designer field length discrepancy

  I have a table with 51 fields and the table designer tells me there are 51 fields with a record length of 999. However, display structure shows 51 fields and gives a total length of 1,003. If I add the individual field lengths together, this comes to 998. I believe a single character is used for the delete character so 999 would seem to be correct. However, another application I am using (PReS from Printsoft) only accepts the data when I s ...Show All

• anjee DELETE FOR-PACK ON BUFFERED TABLES

  I have a buffered(5-optimistic )tables in vfp 9.0.when i use delete the records arent deleted i use tableupdate but they dont get deleted.i use pack but i get a msg saying table should be in no buffered mode i then change buff to 0 (not programmatically with cursorset.. but from dataenviroment) but is still get the msg! how can i delete a record table must be in buffered mode As you have been told several time ...Show All

• Paul Lowther Amount range

  Hi, I have a table where the salary range and deduction are stored. As an example the salary ranging from 1,000 to 1,500 has a deduction of 100. This is the part where i should be getting the amount for deduction unfortunately i don't get any record though the record exists in the table: SELECT nfrom, nto, ndeduction from tbldeduct WHERE ; tbldeduct.nfrom >= thisform.txtngross.value .and.; tbldeduct.nto <= thisform.txtngross.v ...Show All

• G_Mahajan can i just use sql to get this?

  date           transfer 20050101    200.00 20050103   -100.00 20050530     95.30 ... SQL to get： date         transfer          balance 20050101   200.00         200.00 20050103   -100.00 &nbs ...Show All

• Frank Cassata DBclick

  the dbclick event can't be effect after i wrote program in mousedown event in grid control.how can i fix it thank you i found why. if i didn't put the code of nbutton = 1 &&left click then dbclick event can be fire. if i wrote some thing there ,dbclick doesn;t work anymore . so how can i resolve it jet Hi Jet su, This is what I stated in the first reply. There is too much processing time between clicks to be able ...Show All

• Alexandre Mineev MSFT 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, Sorry to hear you are having problems. Displaying the preview using the WINDOW clause works fine for me.  I can move from page to page, print, etc. just fine. Are you saying if you remove the WINDOW clause the problems go away   If this is true maybe you can provide more details about what you doing in the ...Show All

• Laurel Hale Accessing FoxPro 2.x tables from VFP 9

  Hi, i have found, that VFP 9 cannot optimize selects / updates / deletes on FoxPro 2.0 tables - it does not use any indexes defined for these tables. When i was manipulating these tables from VFP 6, there has not been problems and all selects / updates were optimized. Can someone help me to find solution for this  Thanks in advance There is a known bug (fixed in SP1 - in public beta). If current cod ...Show All

• Neophyte How to receive record ID???

  The subject is: I want to select some records from some table ("TableA", "TableB", ...) using Select SQL to a temporery table, then I will choose one record from this Temp Table. How can I know the exact position of this record on the source table "TableA". Please give me some advices!!! Thanks Hi, you can use RECNO() in your select : SELECT *, RECNO() as position FROM tableA INTO CURSOR temp Do you have a prim ...Show All

• mkb137 "feature is not available" - complete diagnostic

  I finally had time to focus on this thing alone and get the error reporting straight. I do have now memo fields with errStamps pertaining to every breakdown. One example: FUNCTION addPropToForm (oForm) oForm.AddProperty ("dBaseWe","",1) oForm.AddProperty ("dirWe","",1) oForm.AddProperty ("comboWe","",1) oForm.AddProperty ("tabWe","",1) ...... ...Show All

• Nathan Booth EDSETENV

  I want to set up runtime environment as far as the way memo fields are displayed in the editor. I tried to use the code I found in Help: SET LIBRARY TO EDSETENV = EDSETENV("x") First, there is no library file by this name, at least I could not find it. Second, the whole thing is not recognizable by the compiler. How do I define string "x " Do I have to write a C++ module to do it But my first concern is to make the f ...Show All

• Leif Greenman foxpro *

  I have a program that we developed in foxpro 8.  I want to make it mac compatible.  can anyone help me You can run your VFP application inside the RDP client for Mac: http://www.microsoft.com/mac/otherproducts/otherproducts.aspx pid=remotedesktopclient Sorry Amy, but VFP stopped being compatible with Mac at version 3.0. ...Show All