Answer Questions

• brassringMike Cursors, Views, and Grids

  Using VFP8... I have a simple form with a grid. I want to use a cursor object to use as the record source for the grid so I can let the user change which column to sort on. I Select and order the data and create the cursor (csrTemp) in the form.init, the view that is used in the Select is in the Data Environment. I'm not sure how to reference the cursor in the data source for the grid, when I run the form it seems like the order is from ...Show All

• Traceofmetal New to Word integration using DDE

  We currently are using word integration that involves a foxpro table where each field represents a mergeable item.  The data from the foxpro table is pumped into an excel spread sheet and then into Word.  I want to eliminate excel as well as get around the limit of being only able to have 255 merge fields.  To this end I want to have one foxpro table that contains two fields , the first field will hold all the merge field names, a ...Show All

• Nate Block EOF() for a low level file function

  Hi there, I just ran into a problem with this code. What I want to do is to open a TEXT or binary data file and read it as a *binary* file byte by byte. What I found to my surprise was that the VFP EOF() function presumes that the file that's been opened is a TABLE! How do you go about reading bytes from a data file I am getting an error message that the alias is not found.. filename1 = "C:\Program Files\tcp_ip.txt" filehandle1 = FOPEN ( ...Show All

• Hariharan Can't write to new tables.

  Hey, I was given the task of updating a project in .NET and foxpro. I opened up the foxpro database and added a couple tables. I can write to them from the command line, but I can't insert or update records through the oledb. The users have write access, and can write to any of the old tables, but not the new ones. I am doing this in VFP 6.0. I don't know what the version to make the originals was. What am I missing ...Show All

• Michael Junkin Deleted records still getting fetched

  ok so I have deleted records in a VFP 6.0 table, and when I query anything the deleted rows still get pulled up, what am I doing wrong yes that worked, thanks very much! I should note that I need to be able to have them actually fully deleted via queries through .NET >> O k so I have deleted records in a VFP 6.0 table, and when I qu ...Show All

• Lakshmi [noob questions] Arrays..

  Aaaaaaaaaaaaaaaarrrrgggghhhhhgadsfhasdjhf 1. Is foxpro incapable of returning an array from a function by using the return statement  2. Does foxpro have a function that merges 2 arrays 3. How do you pass an array as an argument to a function in a class when the array is a class variable For example: define class test as Custom     dimension Arr(1)        procedure asdf(tmpArray, tmp ...Show All

• DOAHunterX problems on textbox in VFP

  hi guys...i just want to ask about this problem on textbox in VFP...because compared to Visual Basic, when i try to press the backspace to erase the characters on it,it erases and goes to the beginning of the textbox...but on VFP, when i try to erase the characters on the textbox, it erases too but goes to other controls or sometimes if you have two textboxes,it will go the second textbox and then pressing backspace again will go back to the fir ...Show All

• Andre Carrilho New to VFP please recomend any good books

  Hi     I have been tasked to update our current DOS based clipper 5.3 database system to VFP 9.0. We have already determined that all our data directly imports to VFP and we have started converting the screens from the DOS based clipper app to VFP. I have a VB programming background and some access programming experiance. I will have a VFP programmer available for about 20 hrs to train me. I would like to get any recomended books ...Show All

• ptaylor How to Disable VP main Splash screen and FoxPro window

  Hi I have a small application in VFP. I have a PRG for which i have made a short cut at my desktop. No when i click on that, first VFP Splash screeen occurs, then vfp window, then My aplication loads. I do not want the VFP Splash screen and vfp window to be displayed. please help Use the -T command line switch. From VFP Help: " Suppress the display of the Visual FoxPro splash screen. By default, when Visual FoxPro starts, ...Show All

• linkes8 VFP 6.0 and MS Server 2003 Scheduler

  An existing VFP 6.0 '.exe' file, ran for years on Server 2000, crashes the indexes of several tables when it's run on a new Windows 2003 server via the "Scheduler" utility. It will run if I start the '.prg' from within VFP and it will run in the 'Scheduler' if I don't log off of the server. It's set up to run as a service under the Admin. user account. Any suggestions Nothing cons ...Show All

• CarlosDV how to send control codes via "???" to receipt printer

  Hi All, I am writing a POS system and using a receipt printer (Epson TM-U220D). Unfortunately the printer drivers from Epson didn't work & hence I resorted to using the Windows Generic/Text printer. I am using a series of to output to the printer, which works fine. My problem is that I need to do some form of simple formatting on the receipt, e.g. make company name bold, etc. My question is, how do I send the control codes to achieve t ...Show All

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

• cynistersix End datasession users?

  I sharing data in LAN network, what to end datasession users What do you mean Releasing all forms using a private datasession, all session objects and close databases all would do it. Do you mean to kick them off to do some maintanence If so then you should implement a notification system. As I remember there was an implementation on universalthread downloads. I don't know how that one performs but at least ...Show All

• peace467 Form's vcr buttons not working on all tables in data environment

  I have a form that has 2 table's located in it's data environment.  When I use the vcr buttons to scroll through the data on the form, all of the fields from 1 of the tables is not scrolling.  It remains on the first record of the table no matter what. What could be causing this Are these the vcr buttons from one of the foundation classes that come with VFP If so, that object was designed to skip t ...Show All

• Neal Walters Help with adding a button to a grid column programmatically

  Help     I am working on a VFP 9.0 app that has a grid that shows 3 different sets of data depending on a radio button selection. This is why I need to do this programmatically. I need to add a command button to one of the columns. I can add the command button using the IDE and it works fine. But when I add it using the following code all I get is a grey background in the column. I thought it might be because the command butt ...Show All