Tutorials to .com

Tutorials to .com » Database » Foxpro » FoxPro Tutorial

FoxPro Tutorial Articles


21: sub-group by the application of
Section V of the application of sub-group by First of all, to talk about how the work of division. For example: Table: temp1 have the following records: bh sl aaa 1 aaa 4 ccc 2 bbb 5 aaa 9 bbb 7 Statistics temp1 now look how many there are...

22: the use of union
Section IV, the use of union union can be a synthesis of several SQL commands, the order request is generated by these tables, the number in the field, field type, field length, field are exactly the same order. Following this is the case, are gene...

23: The difference between the four links and the use of
Section III of the difference between the four links and the use of Links: As a verb, it means two or more tables together and create a result set, the result set for each table column and row of the merger. Tables are generally connected to the u...

24: on, where, having the different
Section II on, where, having the different Here is an example to compare the conditions on the filter on, where, having what the difference between: Table recdbf reads as follows: There is also a supplementary table tempyf record date of 12 months...

25: select - SQL workflow
Section I select - SQL workflow Further complicated SQL commands, but also by some of the basic structure of the composition. Therefore, in view, to do a very complex SQL command, to a level it will be folded at the end into the most simple, so eas...

26: Using SQL pass-through
Section IV use SQL pass-through Compared with the use of an alternative view is to use a separate SQL pass-through. This means that you send to the back-end SQL statements and understand that to tell it what to do. If you want to add a record to se...

27: The use of view - trying to second
Section III of the use of view - trying to second Well, is not in view of these circumstances it is not going to help? You are not surrendered to them? More than ready to try the. View of the above question is composed by two tables, but you do not...

28: The use of view - to try a
Section II, the use of view - to try a The first application is to create libraries using a remote view. Easy to set up view can be parameterized, it can return only one or a small number of records to support the cache and table cache line, as wel...

29: SQL Server 6.5 Example application of basic library data
Section I, sample data In this paper, an example of the use of data from SQL Server 6.5 the application of basic library. Application of the library used to track its members, its book and lending. Library of database programs as shown below. Libr...

30: Remote View and SQL pass-through of the difference between
Introduction You in Microsoft Visual FoxPro development team in a lot of friends spent a lot of time to develop the Visual FoxPro, is a robust, powerful front-end client-server applications. Remote View and SQL pass-through to provide a powerful to...

31: Visual FoxPro to use the Slider control
Slider Control in COMCTL32.OCX, its help file is CTRLREF.HLP. Slider controls and sound volume control in a similar sliding block; it is provided with a control value and be a drag along the guide to indicate the selected value. Commonly used in the...

32: Visual FoxPro to use the ProgressBar control
COMCTL32.OCX located in the ProgressBar control, and its help file is CTRLREF.HLP. The control to give us a Windows 95 style progress bar, as you drive from one to copy a large file to another drive when the Windows 95 displayed as the progress bar....

33: Visual FoxPro to use the Calendar Control
Calendar control is located in MSACAL70.OCX (in the \ WINDOWS \ SYSTEM directory; in helping document described as the wrong MSACAL.OCX). Help file called MSACAL70.HLP. Provided the control in your application's ability to contain the calendar. ...

34: Visual FoxPro to use the Common Dialogs control
Common Dialogs Control III If you used FoxPro GETFILE () and PUTFILE () function. How much you might be a bit sorry for them: There is no way to change the title of the dialog box. PUTFILE () function is always asked whether users would like to c...

35: Visual FoxPro to use the TreeView control control
Section II of TreeView control VFP 5.0 the new ActiveX control is a powerful TreeView, visual and attractive tool, you can be used in many applications. However, the use of complex and simple technical documentation discouraged many people. In this...

36: Visual FoxPro to use the ImageList control
ImageList control is very simple, but on the other because I use to control it, so we will first discuss it. ImageList controls a number of pre-loading images, so other controls (such as the TreeView and ListView controls) can have the image resourc...

37: The use of ActiveX controls in Visual FoxPro
Introduction Visual FoxPro includes many ActiveX (the original OLE) controls, which can be used to add a large number of new features to your applications. They include the TreeView, ListView, StatusBar and CommonDialog control, allows you to creat...

38: Conclusion foxpro
Off-line view can be updated to expand the capacity of view, allowing you to add your application is difficult to achieve VFP3 function. Test sample of the text accompanying procedures, and to consider the application in your view of the use of off-...

39: foxpro to maintain the source table
If you have an application must not stop too much work or table the application so that it can not be stopped indexing, you will face the question: If the workstation or server crash, and called for the destruction of the index reconstruction , how ...

40: a number of local data foxpro
Assumed to be an office of 12 clients to write an application. Each office has their own copy of the data sheet, but the Office of the Office document must contain the complete data for data maintenance. Once a month, the Office document to their he...


Page 2 of 5
[1]   [2]   [3]   [4]   [5]