Answer Questions

• Cittri Farms Foxpro problem I think

  Hi, I have made an program in foxpro wich will archieve mail. what I do is I first export the mail body, sender, etc to text files with vba and than get them back with foxpro, but sometimes the layout changes when I put it back. Has this something to do with that I exprot them to text files or is it something different please help Remember that most email objects used to get email have two Body ...Show All

• Ravi Thapliyal use the reccount

  hello all  I use "set filter to" and want to know how much record is match the filter condition. I use the "reccount()"  but it return the result is not I want. it is all the record count What do you expect cLocAlias to display cLocAlias is an alias for a table, not a variable that contains something you can print. Try BROWSE after the query to see your results. Tamar ...Show All

• Paul Singh UPDATE vs REPLACE record locking

  The VFP 9.0 Help file shows the following: UPDATE - SQL Command ,Remarks, Tip: "When updating multiple records in a table opened for shared access, SQL UPDATE uses record locking, unlike the REPLACE command." Locking Data, REPLACE: Current record and all records from aliased fields UPDATE - SQL: Entire table These statements seem to conflict. The first leads one to believe that the UPDATE - SQL command would lock records and i ...Show All

• Noobyone Visual foxpro 9.0 resource

  Dear Visual Foxpro, I was a developer using primitive versions of foxpro. I now again want to get into development, but I could not find any resource / Book on Visual Foxpro 9.0, and I believe there is a major change in technology. Is it possible to get ISBN # of any book on Visual Foxpro 9.0 Thanks, Ashish http://www.hentzenwerke.com is one of the sites where you can find VFP related books. ...Show All

• djellison 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 Yes, perhaps we have to accept that fact. Forturnately, not all people are programer. If they are programer, they may not be VFP programer. yeah!!! To be true, one cannot protect vfp applications from decompilation.There are applications available which can even decompile the third level of prot ...Show All

• doctorg _ReportPreview

  The code below works fine, but the problem is the report sticks with this setting. When previewing the report with Report Form Customer Preview, it starts with page 1, does not displayes the toolbar, canvas is always set to 2, zoom level to 100 %. Even when i set ToolbarIsVisible = .t. in the code below i get the old style toolobar even when i have set reportbehaviour to 90. Any solution to this. Thanks & Regards, Jitendra Shahani Local lo ...Show All

• jackwc Form clattered at design time. How to change pages?

  With many controls added to a form I am beginning to sense a problem. During runtime many controls will be invisible on the first page but when subsequent pages are chosen they will appear. It is determined programmatically. I do not see an option to choose pages at design time. It would allow me to see some controls much better. In Visual dBASE Plus such convenience if taken for granted and much appreciated. How can I do it here Thanks. ...Show All

• Bo Yu form caption

  Hy guys! I want to put on the form's caption an word which is in a table when the form appears. I wrote this code in the init event of the form:  sele user  this.caption = "Borderou " + alltrim(user.name)  this.refresh but the form's caption doesn't appear as i want. Sorry for my weak english. Liviu: Drew is correct. You don not need REFRESH() after changing caption. Another reason is also because you are coding it in the I ...Show All

• jepherz VFP 6.0 : Trim function along with List function?

  Hello! Is it possible to use the list function before using the trim one to remove any blank spaces in fields When I use the list function, the data on the screen are a bit messed up due to the amount of fields and the blank spaces. i would like to trim them and then use the list function. Is it possible If yes, any piece of code or algorithm Thank You! No. Try changing the screen font: _Screen.FontName ...Show All

• gmeh Database security

  Sorry, my english less good . I'm making a program by using Visual FoxPro computer "A". All database, tables, form, menu and report stored in that computer. Which I wish to ask: 1.        If someone using computer "B", do he/she can make program with source exist in computer "A” 2.       If there are some computer which join by workgroup or domain, then each the computer ...Show All

• DaCodeBoy Load Data

  Hello, Can I know how to load the data/information from text file to Visual FoxPro Thanks a lots for help. Jarron, It all depends in what format the data is in. If it is a simple comma delimited file (CSV) or an SDF file (a flat file with no separators or delimiters), you create a table with the proper structure to receive the data then do an APPEND FROM . Read the help file for APPEND FROM as it has man ...Show All

• LFDIII USB Modem (serial) communication question

  Hi! What I want to do and I wonder how I can do it through VFP is to communicate with my US Robotics 56K USB modem. My PC see the modem as a serial device in a COM. So I suppose what I need is a way to communicate with the serial port, right But how can I achieve that in VFP Can someone please help me Any source code, links etc is welcome (as freeware as possible please - I m talking about the links - I ve seen a lot of Active-X you n ...Show All

• Jim Shipley VFP 9.0 SQL worthless under a non client server network?

  Hello everyone; I have posted this problem here and also on UT and no solution yet. I have a small network with a 2003 server, and XP pros. I am running vfp 9 select * from products where status = "S0000" takes apx 10 seconds when run over the network. When running this locally, it takes only a fraction of a second. The product table contains 100,000 records, and the result of the SQL command is just a few hundred rec ...Show All

• flyingelvis Preview Toolbar not enabled in EXE

  The Preview Toolbar in VFP9 is not enabled when a report is generated to Preview from a compiled EXE.  _reportbehavior is set to 90.  The 90 preveiw toolbar is displayed The application runs from a main form (modeless, as Top Level Form).  Displays all reports to a preview form that is is either modal/modeless and In top level form.  I have tried as Top Level Form and In Top Level Form.  I have created the report two dif ...Show All

• DonovanDicodemy OWC11.PivotTable

  I've tried to play with MSGraph for some time and after not getting very far yet (although I got some graphs) I downloaded MS Office Pro 2003 enterprise Edition and found out that there seem to be richer controls out there. In particular I am trying to work with OWC11.ChartSpace , OWC11.PivotTable and OWC11.SprreadSheet . I have resigned to the fact that I would have to use MS Excel Spreadsheet as an interim container between my tables and the g ...Show All