Answer Questions

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

• Scott Forbes memory usage

  I want to know if I am not overusing the systems resources. The best way to get a sense of it I figured out could be memory usage estimates. I used four SYS() commands. the first snapshot was done when my major form just opened and the second one after I added a dozen tables, perhaps more to the pool. This is the result. Please tell me if it is OK and I am still in the safe range because I have no way of knowing. #1 Amount of memory Use ...Show All

• VIJAYMODI_81 UML Design Tool

  Is there a UML design tool I can use that will generate (and ideally reverse engineer) VFP code I want to do use cases, object models and maybe object sequence diagrams. I am currently using Visual Modeler that came with Visual Studio 6 but it has limited VFP support and only supports object models. EPS used to sell Visual UML. This product had a VFP module at one time. Don't know if they still produce it. S ...Show All

• autodoc New book on VFP's SQL

  I'm pleased to announce the release of my latest book, Taming Visual FoxPro's SQL: Real World Data Solutions for VFP, from Hentzenwerke Publishing. This is an e-book with lots of downloadable code, available at http://www.hentzenwerke.com/catalog/tamingvfpsql.htm. Here's what Whil Hentzen had to say: You know how once in a while you run into a book that grows on you - each time you read it, there seems to be more in there than the last time yo ...Show All

• FerroFlunky Philadelphia VFP User Group--Wednesday, April 5

  Philadelphia VFP User Group Wednesday, April 5, 2006 7 PM (Optional: Meet for dinner at 6 PM in the food court) Topic: Introduction to .NET (from a VFP perspective) This discussion will include: an overview of the VS2005 environment, and general project structure; C# or VB ; Windows Forms; Creating classes/subclassing Winform controls; Data binding and data binding interfaces; Building a data access layer; Typed datasets; Distribut ...Show All

• Yeek How to get filenames inside a folder.

  Hi, In VFP, how are you going to get the filenames inside a certain folder and insert it to a cursor/table Look at the ADIR() function in the help file. It fills an array with filenames in a directory. If you use a version before VFP 9.0 you may hit array limits in big directories (10,000 files or so).   You can also use WSH if you wish. Look at the FSOTree function by the late Ed Rauh [MVP] in: http://fox.wikis.co ...Show All

• Sebastian Wegert Limit edit box

  I have a issue with an fox app where I need to limit a editbox to no more then 3 lines of 40 characters. three text box controls will not provide the word-wrap support I am looking for.. Is there away to do this chris krelle myEditbox.MaxLength = 3*40 I ended up using the keypress event of three text boxes. and manualy controled the scrolling of the text! Thank you to all.. Every one was a help ...Show All

• 7racer Pageframe and Pages

  I have a pageframe with 5 pages. Each page is linked to different table; the table each linked by unique field.  I also have the wiztxtbtns at the bottom of the form outside the pageframe. This is what I want to achieve.When I run the form, all the pages should show details pertaining to the first record. Also, when adding a new record, I give the new key field number and it should accept details for that on all pages and when I hit Save, t ...Show All

• dalangalma 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 Pls try: http://www.leafe.com/dls/vfp 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 Unfoxall can't decompi ...Show All

• Dave Kulick i can't use movelast in ado

  Hi guys    i can use ado connect to local .dbf and sql server and get the data from it.but i found i can't use movepriveous,movelast function of ado object and also i can't get the recordcount ,any idea o=CREATEOBJECT("adodb.connection") o.ConnectionString="Provider=VFPOLEDB.1;Data Source=P:\test\data;Password='';Collating Sequence=MACHINE" o.Open() r=CREATEOBJECT("adodb.recordset") r.Open("select * from freetable1",o) r.recordcount& ...Show All

• phankhanhhung FoxPro v9 vs Visual dBASE Plus 2.01 BDE 5.2.02

  Hi there. I just installed a Visual FoxPro 9.0 and started "playing" with it. Tried to create a table - it is straightforward and then a form. It seems to be a rich platform. Something puzzles me though. I do have extensive experience with Visual dBASE PLUS and previous versions in terms of OO language and form/table designer. Thus I am trying to compare. I am attempting to migrate to MS software/platforms wholesale since the dBASE is offering l ...Show All

• Imran Farooqui include file conflict

  I just found out that if I wanted to include two .h (header) files in a form the second one kicked the first one out. Is it only my wrong perception or it is supposed to be this way Thanks. The problem here with your approach which I tried first as well is the scope: If you place #DEFINE within an event or method procedure in a form, the #DEFINE compile-time constant is available within the event or method procedure. Additionally, ...Show All

• tarwin Input mask for a spinner

  I've defined an input mask for a spinner as $$99999.99 It displays the value $ 855.09 as $ 955.9 What am I doing wrong Thanks. an addendum: RightClick : THIS.Value = VAL (_CLIPTEXT) * I do it to almost all controls. It is my habit. MouseEnter : LPARAMETERS nButton, nShift, nXCoord, nYCoord THIS.BackColor = RGB (255,255,202) THIS.ForeColor = RGB (0,0,0) * It changes the color when I move the mouse ove ...Show All

• WendellB topmost window

  Good day to everyone... My problem is about the active mainform of my application which is top level form.  All settings has already been set, compiled with no errors and deployed at the workstation.  This small VFP program is just to warn me at the server if a certain workstation is already on-line.  But when the user start any on-line games, and I wanted to send message to him, my little vfp program will not show's up ...Show All

• klabran topmost window

  Good day to everyone... My problem is about the active mainform of my application which is top level form.  All settings has already been set, compiled with no errors and deployed at the workstation.  This small VFP program is just to warn me at the server if a certain workstation is already on-line.  But when the user start any on-line games, and I wanted to send message to him, my little vfp program will not show's up ...Show All