Answer Questions

• TPR Coming from Excel to VFP9 and need help understanding math functions on cells

  I have set up a simple data tracking form that breaks out the associated costs of a vehicle going to Auction ( dealer costs, transportation fees and so on) for my employer. It works great, and I can enter data into the database successfully, and my Report will print it out nicely sorted by Store. I would now like to create cells on my data entry form that calculate and display various math procedures on the data being entered. For instance, ...Show All

• jpkuzma MAPI and Set Default..

  When using mapi I am loosing my “set default” to goes back to the c: I wind up putting code like as follows just to correct it. Mdefa=set(‘default’) Mpath=set(‘path’) <Mapi code here> Set default to &Mdefa Set path to &mpath I’m not sure why I have to reset the path, the set(‘path’) still returns the correct path but foxpro can’t find the files! I have the same problem when users select certain PDF Pri ...Show All

• MalcolmB Cant get FTP commands work

  Dear All, After i format my windows i cant test my batch files running and ftp command like mget or mput. MY clients oso met the same problems. now we cant upload data to FTP server.Both of us using win98 OS. Please help. I tested at other pc some can run batch file but but some it just hang at there. ...Show All

• lufa string func failures? bugs?

  I found that when applied to THISFORM.Edit1.Text, VFP native EDIT control, the following functions always return 0: AT( ), ATC ( ), ATLINE( ), OCCURS ( ) They cannot be used for any purpose. The following functions work: LEN ( ), $, SUBSTR ( ) I did not bother checking RATLINE( ) , RAT( ) and RATC( ). I presume, they would fail also. Is it a bug Also I found oddly enough that command COPY FILE fileName1 to fileName2 fails i ...Show All

• Luke Bedggood editbox programmatic change

  I am looking for an easy way to determine if I've made interactive change in an editor box. The issue is that there are about 16 controls on a container, they are initialized from a table record thus their values at activate time generally are not trivial default. I have to save the changes with a SAVE button if I made any but I want this button's click method to quickly determine which control values have been changed. I do not want to do REPLA ...Show All

• Terry Muench 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

• amdMcBook 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 Actually, there are two different issues. One is a bug and the other is n ...Show All

• floppes Word Document Formating

  Dear Expert I create some table in word with following procedure. These codes were written by Sir Cetin Basoz and by some other UT Professors. The codes work fine. #Define wdTableFormatColorful2 9 #Define wdTableFormatContemporary 35 #Define wdTableFormatElegant 36 #DEFINE wdAlignParagraphThaiJustify 9 #DEFINE wdOrientPortrait 0 #DEFINE wdOrientLandscape 1 #DEFINE wdCellAlignVerticalBottom = 3 *Local oWord As Word Application, ...Show All

• BambooZelD Form Feed Character

  Hello Experts: I am using FPUTS to write text to a file. At the end of each page I need to insert Form Feed Character. How can I do this Try adding CHR(12) as your FF character. I normally work them from memory but any decent ASCII table would show it. Here's one I found through Google: http://www.lookuptables.com/ Thanks Alex. Is ther ...Show All

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

• PaulWelby editbox programmatic change

  I am looking for an easy way to determine if I've made interactive change in an editor box. The issue is that there are about 16 controls on a container, they are initialized from a table record thus their values at activate time generally are not trivial default. I have to save the changes with a SAVE button if I made any but I want this button's click method to quickly determine which control values have been changed. I do not want to do REPLA ...Show All

• Jim Mead 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

• Jdjr2 Additional fields in table exported to txt

  Hello, I need to output from a VFP 6 table to a text file. When I use "copy to mytext.txt delimited with ," I get an additional field before and after each of the original fields from the table. This means that in my new text file, fields 1,3,4,6,7,9,10,12,13 etc are empty fields that were not present in the table and fields 2,5,8,11,14 etc are the fields with data. Can anyone tell me how to avoid these "extra" field ...Show All

• Giles Copnell 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 Sorry I forgot to say that I am using ...Show All

• Ed77 Need help on a small open table code

  Hi, I m trying to make a general opentable function that I will use with all my apps in the future. Now I need someone to explain to me a few things to see things more clear. Here is my code: function OPENTABLE(TABLENAME)  LOCAL TABLETOOPEN *Ok this is just a full path I make for the dbf file. I do not know if it the right way.what it gives is  eg. c:\program files\my app\data\mytable.dbf  TABLETOOPEN=TOSTRING(checkpathf ...Show All