Articles
Search: 
Page 1 of 26

Monday, November 21st, 2016, by Rafael Copquin
This article demonstrates an ability to parse the select command passed as a parameter, for the development of a cursor adapter that can be used to retrieve records form a SQL Server engine. The class analyzes the select statement and creates the updatablefieldlist, updatenamelist and cursorschema thus enabling the creation of the cursor adapter.
Wednesday, June 5th, 2013, by Rafael Copquin
When Microsoft discontinued development of Visual FoxPro, many would-be writers on VFP issues stopped sending articles to the UniversalThread and as a result, no more articles on VFP were published, with a few exceptions. Over the years, I kept receiving requests from many readers for a continuation of the VFP and Accounting article published in March 2007. I extend my thanks to Michel Fournier for allowing me to publish its continuation. In the first part of this article I explained...
Monday, January 1st, 2001, by Hugh Winters
Dear Hugh, Michel, Universal Thread, and the FoxPro Community: On behalf of the FoxPro team, I want to send my thanks for the “Microsoft and FoxPro 10 Year Anniversary Card” from the community. We received the special anniversary hats and shirts, and of course, we enjoyed the airplane flying over the Microsoft campus on June 21st! This effort means a lot to me personally, since I worked on the Fox team for many years, and was intimately involved with the design and development of Visual FoxPr...
Monday, January 1st, 2001, by Hugh Winters
Pictured by David Chilcott, Outformations More than 100 Visual FoxPro developers and others attended a presentation by Ken Levy on the topic of Visual FoxPro and Microsoft Dot Net interoperability. The event was located at the ProBusiness facilities in Pleasanton, California and was hosted as a joint meeting of the Silicon Valley Visual FoxPro SIG, Bay Area Association of Database Developers and the Sacramento Visual FoxPro SIG. At the end of last night's presentation Hugh Wi...
Monday, January 1st, 2001, by Hugh Winters
1992-2002    On behalf of the thousands of FoxPro developers and programmers worldwide and the millions of users they serve with software applications written in Visual FoxPro, it is our distinct honor and privilege to wish all of the fine people at Microsoft and especially the Fox Team a very happy 10th anniversary of the union of FoxPro and Microsoft.    We thank you for 10 great years and sincerely wish all the bes...
Monday, January 1st, 2001, by Hugh Winters
"Boss, de plane! de plane!" Large view of the banner Overall view of the plane Some of the Fox team members prepare for the plane to fly over with the FoxPro banner, taken at about 11:25am PST. Picture includes Calvin Hsia (Lead Developer, Visual FoxPro) getting ready to video tape the event, Alan Griver (Lead Program Manager and Evangelist for Visual Basic .NET), Cathi Gero (contractor on the Fox team), Fabian Winternitz (Test Engineer, VFP team). J...
Monday, January 1st, 2001, by Hugh Winters
Many thanks to all who signed the card Congratulations for your 10th anniversary birthday since the purchase of Fox Software! Keep it rolling!Michel Fournier, Fournier Transformation, Anjou, Quebec, CanadaThanks for bringing me such a wonderful product. Here's my sincere hope for another 10 years together!Hugh Winters, Worlddata Services, Inc, Napa, California, United StatesFoxPro Rocks!!!Sarosh Wadia, Calgary, Alberta, CanadaHappy birthday,thanks for brought great happy to us in the past yea...
Monday, January 1st, 2001, by Hugh Winters
June 4, 2002 Boss, de plane! de plane! Video of the plane Just the other night I was reading about the history of Visual FoxPro when it came to me that this month (June 2002) marks the 10th anniversary of Microsoft's purchase of FoxPro. As I thought back about that time, suddenly a rush of feelings filled me and I can still remember how validated I felt as a FoxPro user when great big Microsoft bought my favorite programming/database product from small but fiesty Fox Sof...
Monday, January 1st, 2001, by James Edgar
(Originally published under this title in Virtual FoxPro Users Group Newsletter of January 2001.) Mouse management in Visual FoxPro can be a little trying. It’s hard to determine in code where the mouse is positioned on a form and it seems almost impossible to force FoxPro to consistently display the hourglass pointer during lengthy process. It’s an hourglass over one object, an arrow over another, then an I-bar and so on. A lot of elaborate code has been devoted to working around ju...
Monday, January 1st, 2001, by James Weil
According to Microsoft, the Visual Foxpro setup can be run in quiet mode. RUN setup.exe /Q This will launch and run setup without user intervention. The following parameters will run Setup in quiet mode with various options: /Q will run setup with the "Initializing setup..." dialogue box, the progress bar, and the "Setup complete" dialogue box with the OK button at the end of the process. /QT will run setup without any dialogue boxes. /QNT will run setup with the "Initiali...
Monday, January 1st, 2001, by James Edgar
This paper was written in 1993 and has been modified periodically from time to time since that date. It has absolutely no application to the law in alien lands such as Canada or Louisiana. There is an ancient truism among attorneys that "An oral contract is not worth the paper it wasn't written on." - a truism so old that it was first written in Latin. And it is absolutely true. Any lawyer will tell you that, at least in theory, oral agreements are enforceable in court, but in practice they ...
Monday, January 1st, 2001, by John Koziol
This is the presentation article for a introduction to data buffering for experienced FPD/FPW people I gave. It's an overview to buffering and basic buffering uses and commands. Data Buffering in Visual FoxPro Introduction to Data Buffering in Visual FoxPro Prepared for the Tallahassee FoxPro Users Group (TFUG) ã 1999, John Koziol, Advanced Systems Design (jkoziol@asd-web.com) Feel free to distribute this document at will providing the author remains credited. ...
Monday, January 1st, 2001, by Jim Nelson
Current behaviour of RELEASE where OBJECT memvars are concerned The Help for the RELEASE command of both VFP 5 and VFP 6 summarizes its function (in the header statement) as follows: "Removes variables and arrays from memory" Now this does not explicitly state that OBJECTs are included in the scope of the RELEASE command, but the "Developer's Guide" (VFP 5) and the "Programmer's Guide" (VFP 6) - on page 72 of each - explicitly states that the RELEASE command will clear OBJECTs from memo...
Monday, January 1st, 2001, by Janis Booth
The N-tier model The term N-Tier refers to the various levels of responsibility is a system’s design. The N in N-tier can be any number from 2 on up. A very common design is the 3-Tier model. In the 3-tier model the application is divided into 3 distinct tiers of responsibility, the user interface, the business logic, and the database. Each of these tiers can be implemented using one or more objects that are dedicated to the responsibilities of that tier. User Interface The us...
Monday, January 1st, 2001, by Janis Booth
User interface design is a vast and often misunderstood area of application design. Too often, in application development, there is a large amount of time spent designing the data and the application framework. There is very little time spent designing the user interface. We build forms and put controls in them, without concern for the user’s goals. We build menu systems without thinking about where the options should be to be most useful. Forms tend to become crowded as we try to s...
Monday, January 1st, 2001, by Janis Booth
This session will be focused on the new OLE Drag and Drop capabilities in Visual FoxPro 6.0. Although our focus is on Drag and Drop we will spend some time discussing the user interface technique of direct manipulation in some detail in order to understand where drag and drop fits into user interface design. The prerequisites for this session are having some familiarity with Visual FoxPro Forms and the controls we use in those forms. Also being comfortable with the designers and the prop...
Monday, January 1st, 2001, by Janis Booth
Object oriented system development is new to many of us and being new it presents some challenges. Among those is the process of planning and managing a project. Most of us have developed projects before. On those projects we have worked with the users to discover what the system was to do and how it should do those things. We designed the programs and wrote the applications. So what is so special about object orientation? One of the issues with object orientation is the very fact that ...
Monday, January 1st, 2001, by Janis Booth
Visual FoxPro is Object Oriented. So what does that to me as a developer? How can object orientation make my life easier? We all know there is a learning curve to climb in order to understand objects and we’ve been told there is a payoff for climbing that curve. This papern will investigate one of those payoffs, a reduction in our development time. Development Time Development time is always at a premium and steps we can take that reduce it are quite valuable. Object orientation ...
Monday, January 1st, 2001, by John Harvey
FoxPro is alive and well! Devcon had many eye opening sessions and the technology is moving forward. I wished this version had been version 3. With all the new wizards and the extensible framework, we should pick up alot of new users. The learning curve coupled with the lack of a built-in framework has kept many from moving from the 2.6 product or other xbase apps to VFP. Overall, VFP is getting good press and it's not even out of Beta. MS Tech Ed was another "brain drain" but was wort...
Monday, January 1st, 2001, by Vladimir Shevchenko
Let assume that you live anywhere around the globe and want to develop an application with multilanguage support. It does not matter where do you live: Russia, USA, Canada, Switzerland etc, because you will always get the same problems with localization of user interfaces. Nowadays, you have different strategies for proper and cost-effective localization. The best strategy (from my point of view) is INTL by Steven Black, you shouldn't miss it in any case. However, all localized applications hav...
Monday, January 1st, 2001, by Eric Moore
One of the questions most often asked on the Universal Thread by beginning to intermediate users is ‘How can I use my control classes in my grids?’ Well, answering that is easy. Right-click on the grid, choose edit from the popup menu, click on the column in which you want your new control to go, click on your control in the toolbar, and drop into the grid on your selected column. Then go to the properties sheet, select the default control from the members list, click on the grid, and press dele...
Monday, January 1st, 2001, by Michel Fournier
Xitech (Europe) produces tools for the Windows software developer. They specialize in FoxPro Developer tools, data and code recovery and security. In this article, we will see an overview of 5 of their tools. You will find more details about each of them from Xitech documentation. To get Xitech contact information, see their entries in the Universal Thread Visual FoxPro forum Classified Software & Products section. Cryptor Cryptor prevents unauthorised access to your application files via ...
Monday, January 1st, 2001, by Jerry Kreps
A review of Nelson King’s "Visual Foxpro 5.0 For Windows - Developing an Application Framework," 892 pages, ISBN 1-55851-560-7, with a 1.44 Mb diskette containing a sample framework. The book is rated at "Intermediate to Advanced" It is not. It would be better described as being at the beginning to intermediate level. While not explaining how to program per se, the vast majority of the pages are devoted to explaining how to use the VFP5 IDE and giving code snippets to explain the various VFP5...
Monday, January 1st, 2001, by Vladimir Shevchenko
One of my clients wants to have a smart grid class. Among other cool features this class should be able to remove the columns from the grid on the fly. Basically, the user will click the right button over the grid and choose from popup menu the Remove current column option. I said, "No problem, Sir" and went to my computer to see what I have to do. The first thing that I saw was DeleteColumn method in grid class. This method has one parameter called nIndex that refers to Column's index inside ...
Monday, January 1st, 2001, by Tom Hayward
As a long time "traditional" FoxPro programmer finding myself in the middle of learning Visual FoxPro 5.0, I have watched topics pop up which sometimes launch many people into sort of a frustrated attempt to lay out some arguments quickly into a sort of helpful response. One of these topics is the comparison between Access and FoxPro, visual or otherwise. Partly because of my long association with one tool, or language, (where I have been increasingly amazed over the years with its power a...
Monday, January 1st, 2001, by Janis Booth
This material was presented at GLGDW and DevCon and will be presented at Frankfurt next month. Overview We have all heard it, "This application needs security in it that is very powerful and that protects the data?". What does that mean? What is "Powerful" security? What does the data need to be protected from? How much should this security cost? How do we measure the cost of the security? Consider your home, you would like to feel that there is some security there. You can use deadbo...
Monday, January 1st, 2001, by Janis Booth
This material was presented at GLGDW and DevCon and will be presented at Frankfurt next month. Overview What we will see Designing a framework is not a small undertaking. There are many considerations to be addressed by the design. Using an effective design can mean the difference between success or failure on a development project. In this session we will discuss the major points and issues related to the design of an application framework. The high points are listed below. Establ...
Monday, January 1st, 2001, by Christian Berrigan
Rebuilding your Index Tags from scratch without losing your Primery Key, Candidate Keys, or your Persistent Relations Rebuilding a .cdx from scratch (DELETE TAG ALL, then rebuilding each tag) will delete all your persistent relationships in the .dbc, and if you haven't stored your PRIMARY and CANDIDATE index metadata, as well as testing for it when rebuilding your index tags, all your index tags will be type 'Regular'. At first, it's easy to just think we'll rebuild index tags without del...
Monday, January 1st, 2001, by Mark McCasland
More and more we are seeing larger companies migrating their databases to Oracle. Usually this is done for data warehousing and for publishing data to the Internet or a company intranet. What I attempt to explain in this FAQ is how to configure a Windows 3.1 or Win95 workstation to access the Oracle server and database. The assumption that I do make is that the Oracle DBA has properly installed Oracle and the SQL*Net "listener" on the Oracle server. Each workstation that will be used to acces...
Monday, January 1st, 2001, by José Constant
Voici une version de Visual FoxPro beaucoup plus mûre que la précédente. Visual FoxPro 3.0 introduisait la programmation orientée objet et le Database Container. Mais il s’agissait en quelque sorte d’une première version, handicapée du fait qu’elle devait tourner dans des environnements 16-bit (Windows 3.11) et 32-bit (Windows 95 et NT). Dans Visual FoxPro 5.0 – il n’y a pas de version 4 – l’orientation reste la même, mais la maturité est ...
Monday, January 1st, 2001, by John Adams
In Windows programming, users should have nearly complete control over how the program looks. Properties such as background color, fonts, and the like should be left to the users discretion. The same can be said of VFP applications. Numerous articles have been written about VFP becoming part of the Microsoft family of development environments. As such, we should try to incorporate as many Windows design philosophies into our VFP applications as possible. In addition to adherence to Windows desig...
Monday, January 1st, 2001, by Todd Burstain
First of all what is HTML Help. HTML help is a new concept that combines standard HTML with an active-x object called HHCTRL.ocx. he HHCTRL.ocx control has several subitems if you will. These include a table of contents, index file, related topics, splash screen, shortcut, Winhelp (window or popup), about box, and version. Full discussion of these can be found at www.microsoft.com/workshop/author/htmlhelp. I will simply focus on the ones that pertain directly to making a simple HTML help sys...
Monday, January 1st, 2001, by Mike Antonovich
What Will We Cover In This Session: Why Use A Database? How to Define A Database Normalize the Tables Building the Tables Defining Indexes in Visual FoxPro Referencing Open Tables with Alias Identifiers Establishing Relations Between Tables Other Table Level Features of the Database Container Some Database Container Safety Tips Why Use A Database? Designing an application requires many decisions even before you begin writing the first line of code. Obviously, the first decisio...
Monday, January 1st, 2001, by Javier Borrajo
I have just transformed my whole application to private dataSessions. Private data sessions are not what you really think they should be, i.e. really private data sessions, and this is why I had to make a lot of workarounds for the app to work. So I decided to resume some of my experiences so that any one interested in taking the same step I took won't fall in the same mistakes. In a Private DataSession there are a lot of SET commands that are private to the form. This is very well known, but...
Monday, January 1st, 2001, by Nick Neklioudov
I believe all of us are familiar with that set of four navigational buttons "First", "Prior", "Next", "Last" we use for data entry or maintenance forms. You need to put some code in their Click() events, enable or disable navigation buttons, according to the position of record pointer in a table. Of course, usually all we do it only once, and save this commandgroup as a class for reuse. I would like to suggest another approach for VFP 5.0 which eliminates the need in that commandgroup at all. ...
Monday, January 1st, 2001, by Rock Legendre
The idea of VcxEditor was borned when I was reading an article of Chin Bae in FoxPro Advisor (April 1997) on how to create visual header and cursor subclasses. I suggest you to read this article because it was very useful for me and I think that it is a good starting point. VcxEditor is a tool that let you play with class libraries and forms more like a table instead of "designing interface" that's the reason why it's a little bit more difficult to start with but it allow you full control on...
Monday, January 1st, 2001, by Christian Desbourse
Simulate SEEK, DO..WHILE and SCOPE Do you want to retrieve the five companies following ‘France restauration’ in Customers ? Oh I know, xBase junkies can do that with a SEEK, and a DO WHILE and ....but aren’t we talking SQL ? We will use a UDF to control the scope : FUNCTION incremnt PARAMETERS n_count n_count = n_count + 1 RETURN .F. Before issuing the query, we initialize the counter and other variables: cnt = 0 n_scope = 5 CoName = ‘France restauration’ and now the qu...
Monday, January 1st, 2001, by Christian Desbourse
If you include two tables in a query without specifying a join condition, every record in the first table will be joined with every record in the second table, with huge results as a consequence.
Monday, January 1st, 2001, by Christian Desbourse
One of the most powerful command available with FoxPro’s language, SELECT-SQL allows you to extract from your databases the right data you need. For the beginner, FoxPro provides a built-in RBQE dialog which builds the SELECT-SQL statement and stores these in QPR files, which can be executed from within an application. The RBQE dialog doesn’t cover all the possibilities of the SELECT-SQL command and you will sooner or later be forced to write your own statements without the help of RBQE. The SE...
Monday, January 1st, 2001, by Christian Desbourse
Our sample data consists of two tables, an employee table and a table defining the timetable we want to display. The timetable is defined with the starting time (date, hour and minutes) and the employee in charge (hempl_id) of a number of time slot allocations of 30 minutes each. The data usually cover a one-week period starting on any day of the week. The time of the day covered can extend from 0.00 to 23.30.
Monday, January 1st, 2001, by Christian Desbourse
You have set up an extensive security system to control access to your application through user log-in procedures, and password entry. But some people tend to be security reluctant, they write their password on the wall, or worse, everybody is using the same "Hello" password.
Monday, January 1st, 2001, by Gérald Santerre
Cet article est un extrait de ce que vous pouvez trouver sur ma home page http://www.total.net/~gersan. Ce site est avant tout un site maison, il est sans prétentions. Si vous y trouvez quelque chose qui vous intéresse, prenez le! BTW, it's all in french!
Monday, January 1st, 2001, by Maurice De Beijer
An application framework is a set of reusable components with a reusable application design. This means that you not only get a lot of functional code but you also start with a design of how they work together. This means that an application framework can provide far more functionality that a library of functions as these are basically independent of each other.
Monday, January 1st, 2001, by Rick Strahl
By now you've undoubtedly heard that object oriented programming has arrived in Visual FoxPro. Many aspects of Visual FoxPro are implemented using objects by extending the existing FoxPro language with a great implementation of object oriented (OO) extensions. The OO implementation in Visual FoxPro is one of the most complete that has been provided in a high level language database language yet. The beauty of the implementation is that it can co-exist with existing procedural code to allow you t...
Monday, January 1st, 2001, by Rick Strahl
For the last several months I've been developing Internet related apps using Visual FoxPro exclusively. Ever since I started on this venture the demand for Internet apps has been tremendous and the results using Visual FoxPro have been excellent. Several of the apps I worked on were conversions of existing apps to Visual FoxPro for speed reasons - the move from ODBC to a Visual FoxPro data backend resulted in a 3-5 fold increase in query speeds as well as a great reduction of processor load on t...
Monday, January 1st, 2001, by Michel Poiré
Michel Poiré, from La Confédération des Caisses Populaires Desjardins, talks to us about the approach they've taken for the TOOL-BOX, their first major Visual FoxPro developement project.
Tuesday, June 2nd, 2009, by Lutz Scheffler
A commonly problem seems to be to run an app with the VFP Version / SP it is compiled. VFP itself gives not much help on this. But some little compiler commands like #IF and #DEFINES will do the trick.
Friday, May 8th, 2009, by Lutz Scheffler
When printing, sometimes there is a need to know if a report is printed or not. Since we have no simple way to see if something is realy printed we can at least check if the user send a complete report to the spooler. This article deals with the way to solve this problem with and without object assisted reports (aka listeners).
Wednesday, April 1st, 2009, by Bonnie DeWitt
Great tips from the .NET developer community compiled by Bonnie Berent.
Wednesday, April 1st, 2009, by Michel Fournier
This article describes some basic techniques to manipulate some images in .NET. It covers image resizing, image cropping and the ability to save an image into a JPG high resolution format.