Answer Questions

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

• Carsten Herrmann Cannot 'USE' two tables in VFP90 - XP ONLY?

  I am using a stand-alone exe in VFP90 and I am trying to create a new form with the following in the init: SELECT 0 USE 'accntdb' ALIAS 'accntdb' SELECT 0 USE 'presetdb' ALIAS 'presetdb' I am compiling with VFP90 S/P 1.  Now, this will open both tables when run on Win2K just fine, but when run on XP (latest s/p) only the data in the 'presetdb' table is visible in the browser.  The alias is still recognized, but ther ...Show All

• Ramey Primary key + delete....

  General Design Question…. Suppose I have a table (Table1) with a primary key (PKId), if a user deletes a record then wants to add a record with the same PKId value there is a Primary key violation because the table has not yet Been packed. What is the best solution to this I have Considers the Following… 1) Indexing on PKId+!deleted() , but this would only solve the problem if he delete the record once, what happens if h ...Show All

• Rocco Mastrangelo Back To Front (MSFlexGrid)

  My Form containts a MSFlexGrid (MSFG) and a textbox (txtCell). I want to use txtCell to update value for MSFG. This code in MSFG.EnterCell method: With This Thisform.txtCell.Visible=.T. Thisform.txtCell.Move .Top+.CellTop, .Left+.CellLeft, .CellWidth, .CellHeight Thisform.txtCell.ZOrder Thisform.txtCell.SetFocus EndWith But MSFG is always front of txtCell. Please help me! Thanks! Unfortunately that's the ca ...Show All

• ShaneCourtrilleDev can't reindex 82,000 kb file

  Let me begin by thanking you for the help.  I am not a avid foxpro programmer.  I have a table in my database that has been acting up the past few weeks, but usually a reindex would fix the problem.  Today It won't let me reindex.  I type reindex and press enter and instead of getting the counter on the bottom right hand corner.  It does absolutely nothing.  If I delete the .cdx file and try -- still nothing.  ...Show All

• Steve - new to VPF9 upgrading old foxpro apps

  we currently have foxpro version 5, and a handfull of apps which were developed on it.  the person who developed them has since left us and it has become my job to find a way to upgrade these apps.  the problem is that i don't know the first thing about foxpro - i am a coldfusion guy.  so the biggest thing we want to do is to get the data from the foxpro databases into a sql server database.  if we do this can we still run t ...Show All

• Cazz88 Combo control in Grids

  Hi every body. can some body tell me the way that how to add combobox in grid. Thanks how to add combobox in grid The article that Andy referred you to also comes with classes and sample forms that sjow you how to do this. Marcia Akins has an article " How to Put a Combo Box in a Grid " posted at her website http://www.tightlinecomputers.com/Downloads.htm It covers the topic in more detail than we c ...Show All

• ZY George Li Log in

  I need to create a log in screen and need to have 3 levels of access rights for users.  Level 1 user with very limited rights (access to just a couple of forms) up to Level 3 full access to all functions.  I currently have a table with first and last names user names passwords and access rights.  Any thoughts or suggestions Thanks  Foxpro ships with a sample login program.  If ...Show All

• Gary Wang Selecting a section of a grid for cut/paste.

  Hi; I have a client who is interested in selecting portions of a grid and then cut/paste it. Any ideas Thx, AK Thx. But I guess no way to just use the mouse to select a PORTION of the grid Kinda like in Excel where you select a portion, or a section. In other words, I would like to select not an entire row, but a section of rows/columns. A. Then use an activex grid like M ...Show All

• stenknz Fonts, Fonts and more Fonts.

  Hi everyone, I have posted this quetion before, but I still don't have a reaonable solution. I have a whole bunch of reports which are created in FOXBASE. These are generated using simple commands. Initially we want to run them as they are. The problem is that no matter what font I try, it is not identical to the older 'text' font. Since we are printing on forms, we need the font to be identical. Is there no way to print something ...Show All

• RogerJD Memo File Corruption on VFP9 ONLY

  I am just beginning work for a new client.  This client wanted a VFP5 app upgraded to VFP9..they're using Novell (lastest version).  After the conversion (very little changes needed to be made), they started getting file and memo corruption errors as well as indexing errors.  I took a copy of the data and tried a recopy using SCATTER MEMO MEMVAR to a new fresh data file (using GATHER MEMO MEMVAR) in VFP90.  I got the same er ...Show All

• Pravin Pagare delete record

  this question seems to be ... but I tried many times to do it but I couldn't . I'm using VFP 6.0 . I created a form and take data from mytable . After that I created Del button and wrote a small code in Click event . This is my code : if messagebox("Do you want to del this record ",36,"Notice")=6 delete thisform.refresh and the result is 0 record deleted . I don't know why . Is this related to "primary key" from mytable . If someboby ...Show All

• Brian Kramer Looking for partner developer

  Hello, Because of my professional services, I often have requirements of small business applications for many areas. VisualFox would fit perfect to solve them. As I’m just a novice developer, I cannot afford most of the cases, so the sale and new client are lost. Is there somebody in the Forum who could be interested on something like this I could manage all the menus, screen and help translations into Spanish. Best regards :) ...Show All

• Kevin Prendergast 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

• PLion SELECT - SQL executed partically

  I have 11,000 directories in my machine on one partition only (C:). In order to expedite search for file I need (I found MS search engine too slow) I scan all directories once in 10 days and create a table with directory shorthands and a field where extensions of the files located there are stored. Some directories have too many various types of files and I use a memo field to store extensions for them. Thus the primary field has 80 char length ...Show All