Answer Questions

• Jeff Parker How to print a Table structure?

  Hi, is there a way to print a table structure (table fields, not the table contents) on the printer either programmaticaly or by a menu What I mean is when you modify a table their is no way to print the structure of the table! This is what I m trying to achieve. To print the structure of the table on the printer. So far I always had to press the PrintScreen button and then go to the Paint program, Paste and print . But of course this is n ...Show All

• joyhrs Calling a report with a command button on a form

  I'm trying to call/open a report with a command button that resides on a form.  How can I do this   I'm new to VFP & I've searched the help file but found nothing. No, its the REPORT FORM command: REPORT FORM <.FRX FileName> <other clauses here> Drew Speedie VFP MVP Thanks for the info!  Do I type the SET PATH TO in the command window Please ...Show All

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

• ramkim does sqlserver have the funtion as same as recno() of vfp?

  if not,how can i get the unique numbe of each record for example in vfp i can do like this select *,recno() from tablename coz i am just doing some test of sql in vfp8 and my friend's dbf doesn;t has the unique filed.so i used recno() to idenfied it,now  i want to know it  whether does work in sqlserver.... No. SQL Server is set-oriented, not record oriented like VFP. It does not make sense to ask for individual record ...Show All

• darc 12 hour time format

  Hello, I am doing a program that will compute the time in and time out.  As much as possible I want to do the time() function and not the datetime() function but the problem is if I use time() it displays the 24 hour format.  What I am tasked to do is to subtruct the time out to time in and be able to display the 12 hour format. Any advice will be greatly appreciated. Hi, Have you considered what happens when someone works ...Show All

• Keith Rains "Resources file version mismatch" error after VFP8 SP1

  Hi folks, I have just installed the VFP8 SP1 and recompiled my EXE. However, am now getting 2 errors when I try to run the new EXE: 1. "Resources file version mismatch", followed by 2. "Visual FoxPro cannot start. Could not load resources". The two errors come up one after the other. I have searched for and deleted the Foxuser.dbf and Foxuser.fpt both in the windows\system32 directory and my application's directory. Any ideas on how to ...Show All

• Chris_tr Dot Net Examples with VFP

  I am seriously thinking about starting to use some of the dot net features within VFP.  Where would be a good place to start with some maybe code examples of how to call dot net functions... or how this can be worked..  (beyond data access and web services)   I am more interested in desktop applications at this point. But any pointers would be helpful..  Thanks so much .  Bob Lee    ...Show All

• rolexx Records Disappear

  I'm using a program called Auto Shop Controller from http://autoshopcontroller.com/ . This program uses Visual FoxPro. For some reason, some records mysteriously disappear. This has been going on for as long as I've been using the program, which is three years. I can't get any help from the program's vendor without paying an exorberant price for an minor update and then even more money for a support agreement. Even with that, they don't guarante ...Show All

• Forseti Windows Service

  How create Windows Service in VFP 6 To run a VFP application as a service you need a helper application like SRVANY.EXE from the Windows Resource Kit. However, VFP 6 is not the most suitable version to do this. While you can turn a VFP 6 EXE into a service, it's very difficult to make it run stable, because VFP 6 was designed with desktop applications in mind. VFP 9 is much better in this regard. Thank you ...Show All

• swmiller Create a Directory

  How can i create a directory when the app begins but validating if the directory exists avoiding an error code thanks a lot! Hi Eric, found it. MD fails to create a directory of more than one level, when the parent directory is either hidden or a system directory: Md (Addbs(GetEnv("APPDATA"))+Sys(2015)+"\"+Sys(2015)) Creating the directory one level at a time works, though. *//ummh, may be someth ...Show All

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

• Siric FoxPro character fields in .Net showing as blank strings.

  Not sure if this should be in the FoxPro forum, or the C# forum. I have a dBase database, with a table (table1). table1 contains a field (myField) which is a fixed length, 4-character field. With each record this field contains 4 ASCII characters (which were created by converting decimal values into ASCII). Now ... I think that the first 2 or 3 characters are ASCII value 0 (null). Also, some of them contain Extended ASCII codes. My problem ...Show All

• Augustinscuba Open table exclusively?

  Forgive my ignorance - I've recently reinstalled XP and subsequently Foxpro 7.0. Now when i double click on a foxpro dbf file it opens the table and another datasession labeled 'B' (i'm supposing it's a datasession). Previously, when i opened a table i was in exclusive mode and didn't have this duplicate table open also. I normally work in exclusive mode because my data is not in a shared environment (i'm a vb developer). Any suggestions thanks ...Show All

• victorashi Unexpected disconnecting of remote connections under VFP 9 SP1

  I have problem with unexpected disconnecting of remote connections under VFP 9 SP1 runtimes (only under SP1 runtimes). For example, using _VFP object to access forms will cause this and I am analysing other situations. Using _SCREEN object does not cause this. Does anyone found this too and in what situations   Yes, I am using public beta SP1 - VFP version is : 09.00.0000.3307   Because this problem can be seen only u ...Show All

• J Quick difference between PARAMETER and LPARAMETERS

  Browsing through registers.prg I realized that there is a clause PARAMETER on the top line of one subroutine. It does not seem to be a function call parameter at all, those are defined as LPARAMETER : PROCEDURE EnumKeys PARAMETER aKeyNames I could not find this keyword in HELP. What is the meaning of it There is also PARAMETERS in another subroutine. Is it the same as PARAMETER Are they all pretty much the same Thanks. P ...Show All