Answer Questions

• vodka Calculated properties not recording to table :(

  Hi there Fox folk! I have series of cusotom properties that compute values on my form based on user data input. ( example: One computes the number of days between the current date and the date entered by the form user.) The calculations work nicely on the form, but I'm unsure as to how to get these values recorded into the same table that the rest of  the user inputted values are going. The 'cells' where the results are displayed are tied t ...Show All

• jot pack table in a grid

  <--- VFP 9 newbie We have a grid on the form that views a table opened exclusively on form init.  The table is called from the grid builder and we want to manipulate it.  Below the grid is a button that is 'suppose' to clear off all items in the table.  On button _click event we select the table, delete all, then pack.  Now the grid is void of the table and grid line.  Futhur reference to that table is now invalid. Ho ...Show All

• db_guy 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

• Boywonder0337 small test on transaction atomicity

  Need help with small test on table in database with transaction. Could somebody show state of table after execution this code: CLOSE ALL CLOSE DATABASES OPEN DATABASE "c:\ path to database\data1.dbc" SHARED BEGIN TRANSACTION UPDATE data1! table 1 SET name = 'BBBB BBBB BBBB BBBB BBBB' = Messagebox ('END TRANSACTION') END TRANSACTION if in table1 before execution was 500K records with value "AAAA&q ...Show All

• figo2476 VFP Automated Test Harness aatest.app

  I'm trying to get us where we can use the Automated Testing Harness with our products.  We're having some difficulty in being able to work it with ActiveX controls such as the listview, toolbar, statusbar etc. I've narrowed the problem down to at least being likely in the GetContainerForm method, then the PlayTest method must be getting lost and errors out.  I'm running messages out via DebugOutput api calls so not to be affected ...Show All

• techmanblues Using LAN in Visual Foxpro 9.0

  Hi....I'm new here and I only know the basics in Visual FoxPro. I just want to ask on how can the client computers access my monetary system when it is on the server or other computers. The whole folder of my monetary system is located on one computer and i want to have access using other computers. I'm currently using SET DEFAULT TO C:\MONETARY to set the default folder for all the tables, forms, progs and reports. What should the path in ...Show All

• Gregg Miskelly - MSFT CommPort

  Can I know how to detect the commport with coding And what dll file I need to import Can I know what is the code for WD-202 VFD display Thanks a lots for helps. Hi >> Can I know how to detect the commport with coding And what dll file I need to import To access the comm port you need to use MSComm32.ocx. You can instantiate this as an object in VFP: oComm = CREATEOBJECT ( 'mscommlib.mscomm' ) ...Show All

• Gregfig define window

  How could we show a define window into a top level form, where-in screen visible is set to FALSE Because I try it, and it doesn't show-up, maybe i got wrong in coding. Thanks for any help Amado Ok...this is how it works, I select a group of records using define window (ex. address that begins with letter 'A' so I have Afghanistan, America, Angola, & Asia) then the brows field will show-up over my form with records stated above, then ...Show All

• gary ggerberdom With ... EndWith

  How does nesting work with With ... EndWith Does VFP work out which object I am referring to if I just enter .cDescription for example Is there a potential for ambiguity if the 2 objects have the same property I would like to use nested With ... EndWith but I am wary of introducing some difficult to find bugs. Hey Alex, I prefer to use with ... endwith for maintainability and readability:) Completeley revers ...Show All

• Vidottom 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

• Daya Anand Old Fox Pro Code Please Help

  I have the following code from an older version of Fox Pro.  I typed it into VFP 8 and I can't get it to work. Does anyone have any suggestions SET BELL OFF SET TALK OFF SET DEVICE TO SCREEN CLEAR ****** NUM1 = "   " NUM2 = "   " NUM3 = "   " NUM4 = "   " NUM5 = "   " NUM6 = "   " @ 10, 5 SAY "ENTER LOTTERY NUMBERS" @ 10, 50 SAY NUM1 PICTURE "XXX" @ 10, 50 GET NUM1 PICTURE "XXX" @ ...Show All

• Dundealing difference between PARAMETER and LPARAMETERS

  Browsing through registers.prg I realized that there is a clause PARAMETER on the top line of one subroutine. It does not seem to be a function call parameter at all, those are defined as LPARAMETER : PROCEDURE EnumKeys PARAMETER aKeyNames I could not find this keyword in HELP. What is the meaning of it There is also PARAMETERS in another subroutine. Is it the same as PARAMETER Are they all pretty much the same Thanks. A ...Show All

• Dougman Dean 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

• Sushil Sharma Changing Report Label Text At runtime using ReportListeners

  Hi, I want to change the Text of the Labels in the Report using Report Listener. My exact scenario is like this. The application which i am working is a international product and used in various languages, i want to change the report Text, Label and Static Text to the Corresponding Language selected in the application. Is there any way using ReportListener we can dynamically change the static content in the Report especially Labels and ...Show All

• Trev Hunter Need help understanding Client to host window settings

  Greetings Fox-folk! I have a simple form with a functioning webbrowser control on it. I am trying to force the URL to resize itself automatically to the size of the control on the form. A little research seems to indicate I need to do something with the ClienToHostWindow. What I see is this: *** ActiveX Control Event *** LPARAMETERS cx, cy ... which seems to suggest x and y dimensions. Could someone please post an example code snippe ...Show All