Answer Questions

• Torsten Borg Reindexing a free table in .NET

  I am responsible for a set of VFP Free Tables used for storing client information.  The front end for these tables has been created by a third party, however, the system is problematic and the index becomes corrupted on an almost daily basis. I am currently looking at a way of reindexing the tables on a nightly basis, as part of a scheduled application.  One slight snag, I'm a C# developer, not a VFP developer. I have downloaded the ...Show All

• ilango2006 Error 2091: Table "name" has become corrupted

  Hi again, I got this error during debugging. Of course I cannot vouch for my still problematic code because the table is filled out programmatically. Quite possible the code did something wrong. But if you have any general comments as to how handle such problems and especially what this " third party repair utility " looks like, I would appreciate it. Thanks. The error message: Visual FoxPro 9.0  Table "name" has beco ...Show All

• SudeepNambiar remote data

  I want to create a system with 1 database and many users that can access it a solution is the server client model ok lets say we have a database in a remote server(vfp database) i go to each client and make a datasource and a connection to that database 1)the tables of that database will ONLY be viewed by clients through remote views 2)if yes ,i will put the views in the data enviroment 3)if yes,i can insert,delete,update,buffer...etc the views ...Show All

• Sorin Varzaru Suppress Prompts

  Is there anyway to suppress dialog prompts in vfp 8 I'm writing over a file about 60 times, so I don't want to click everytime it needs to over write the file. Thanks! You use line comand: SET NOTIFY OFF set safety off Dave ...Show All

• PeteL - MSFT object is not defined but uncatchable

  It is a very strange situation and I have tried various combinations to beat it for a few days--to no avail. The code kept getting more complicated so bear with me please. The issue here is that there is a treeView and an outside button that is supposed to trigger some action. This action (search) needs TreeView.SelectedItem.Text and Tag properties. If I forget to make a selection beforehand the Type (" SelectedItem") is Undefined (&qu ...Show All

• Sunrise828 How to add private key to Windows key ring so that it can be used with CAPICOM in a FOXPRO app

  Hi, I was wondering if anyone knew how to add a predefined private key to the windows key ring so that it can be used with the CAPICOM object to decrypt messages encrypted with the paired RSA public key. The encryption will take place within a FoxPro application.  Thanks, gigadude ...Show All

• Ron Hinton How to create a distribute package in VFP8.0?

  Dear Expert, In VFP6.0 there is a wizard called setup which can be used to generate an application distribute package, it is, however, no such function build in VFP 8.0, how do I do the distribution generation Please help. You can install a special version of InstallShield. It is on the original VFP8 CDROM/DVD. Take a look at this doc: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp/html/fowlkwalkt ...Show All

• Ramzee Need help adding a new auto increment integer field to a table

  Hi     I have a table that I want to add a auto increment integer field. I go into the database designer, Right click on the table I want to add the field to then select modify. Then I insert a field and give it the name client_id set the type to Integer (autoinc) it defaults to a width of 4. Then I tell it to index it accending.    This works but on all the existing records it sets the field to 0. If I add a new r ...Show All

• Rod A. 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

• Yuri Kuznetsov lan/wan difference

  Hi everyone, I always browse this forum (for a long time now) I get really good info and answers to many of the situations I've encountered during my process of discovering what to do with a VFP application; since I've never work with VFP before. I've learned a lot, but there is still things that I can't figure out. The application runs fine in a LAN environment, but when is accessed in a Wan environment, there is specifically one form that ...Show All

• MURALEE KRISHNAN migrating VFP app to .net (architecture question)

  Hello everyone! I'm a fairly experieced database developer (SQL Server primarily, and Oracle quite a bit less). My experience with .net is primarily vb.net to built asp.net applications, using web services as my middle man. I just started at a new company which has a few legacy systems, one of which is a rather large FoxPro application. There are a host of problems associated with it, primarily data conflicts. Because the company has grown so mu ...Show All

• Derek Greer can i use pack command to local view or remote view?if not,how can i do the same function?

  thank you Hey jet, if the reply above was the right answer you can click the "mark as correct answer" button! No you cannot pack a view. I issue a: =TABLEUPDATE(.T.,.T.) Then I close and reopen the view. i got it.thank you ...Show All

• hunchback Which one is faster, cursors, queries, local views, other?

  Hello, I'm using VFP 7 on a very old machine. I'm working with very large tables and I need to create a lot of queries, but my tables are so large it takes forever to load the results. I've been creating cursors on the run from SELECT statements but it's still very slow.... What can I do to optimize my queries/views so they are much faster... I'm new to this, so I don't know much... I just need to be able to run all this queries ...Show All

• Shri Borde Downloading and uploading file from URL

  Hi. First task : How to download a file from internert via FoxPro Second task : How to upload a file in Foxpro via ftp Thanks Hi. Nice, but still not what I was looking for. I want to get list of files from a directory on FTP for example in listbox. Then I will choose one of them to download. Download will look like a "copy to" not like explorer download. Like copying file from one plac ...Show All

• WillfinDavid 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. Thank you very much for the reply. One more question: Do I have to define window for each form or is there any better solution for it like something global definition of window. so I can use one window definition for number of different reports.   Thanks again, sanj. Hi Sanj, I believe what you want to do is use the WI ...Show All