vfp html

The page box (pageframe) is also a basic control of VFP, use it can produce similar to the Effect of Windows dialog box, about the common properties and methods of this control please refer to VFP Basic Tutorial-page box and page a article. The page box control itself is a container that can contain several pages, and a page is also a container in which you can add various objects, so adding objects or cod

In this example, the execution of the procedure is to use the empty () function to determine whether the text box is empty when the record is added, and to use locate to do record pointer positioning (refer to the VFP table record pointer positioning and data ordering), and to determine whether or not to duplicate the data already in the table. Complete the data checksum in the above manner, and if a non-empty, repeatable condition is met, use the App

Looking at the example of VFP: Summarize the results of the query in this example, the summary results are displayed in the table control. This article makes further improvements to this example, and you can select Datasheet or text file at run time to output the results of the query as "query results" while displaying the summary results in the table control. DBF "or" query result. txt ". This example applies the knowledge of the GROUP BY clause in

The Registry is a database in Windows that stores system hardware information, application information, and user information. It provides the best place for applications to save parameter settings. In Windows operating system, when we run the “regedit.exe file, we can see from the open registry editing window that the Registry consists of two parts: the first layer of each item on the left is called the primary key of the Registry, double-click the keys extended by each primary key latency. the

Use a Transact-SQL statement in mssql2000 to process DBF Data Conversion　　 1. query DBF dataSelect * From OpenDataSource ('vfpoledb', 'Data source = "D:/VFP/test. DBC" ')... test1　　 Select .*From OpenRowSet ('msdasql ','Driver = {Microsoft Visual FoxPro driver };Exclusive = no; collate = machine; deleted = yes; null = no;Sourcedb = D:/VFP/test. dBc; sourcetype = dBc ;','Select * From test1') as　　 Select *Fr

After so many years of mixing in the forum, we have seen an obvious trend: more and more netizens are using VFP and SQL server for the system. Many people are concerned about how to operate or manage SQL Server from VFP. You can use views, SPT, or ADO to perform data operations on SQL Server. However, to manage the server itself, it seems that only SPT can be used to send some commands. In fact, Microsoft h

This example is a "wage list" showing the nature of each record and the actual wage. This example uses the SELECT statement to calculate bonuses, grants, and so on in the form's Init event, and outputs the query results to a temporary table named LSJJ that contains the "real money" and "employee number", and then the People information table A table join query with a temporary table lsjj and sort the results of the query to the temporary table LSB, which includes the fields and wages that you wa

This example applies to the knowledge of the Between...and clause in the SELECT statement, referring to the SELECT statement: Select SQL command or the SQL language tutorial. This example runs the following diagram: This example uses the "Data 1" database "People information table", about the database is already looking at the case of VFP: sample database is given in the article, no longer detailed here. The production steps are as follows: Crea

Welcome to the Oracle community forum and interact with 2 million technical staff. Due to my working relationship, I often come into contact with Microsoft's database development tool VFP and use it to develop common application systems, the menu bar with complete functions is one of the most common tasks in VFP Application Development. The menu bar with complete functions is an important part of the system

VFP because it is simple and easy to learn, can quickly set up application software by the vast number of programmers love, but its database system is not safe also makes the majority of users very headache. With the application of MS SQL Server database system, its powerful security can be widely praised. In the long-term programming practice, I found that the use of VFP SQL pass-through (SPT) technology c

The examination is over, the superior department requests to report the result: The field name is the student number, the name, the class, each subject achievement and the total score, the width is 14, 8, 12, 4, 4 respectively. The score and total score requirements are numeric and the rest are character type. The file name is: the school name. dbf. Can the school report the result is the workbook file that Excel 2000 establishes, how to convert the workbook file that Excel 2000 builds to confor

The interconnection of different database platforms is generally called the heterogeneous service of databases. Currently, all major databases can achieve such Heterogeneous Interconnection, but the specific implementation technologies of different vendors are different, such: in SQL SERVER, it is called LINKED SERVER, and ODBC is used to interconnect with other databases. The test environment in this article is: Operating System: WINDOWS2000 SERVER (Traditional Chinese System) Install the datab

vendors are different, such: in SQL SERVER, it is called LINKED SERVER, and ODBC is used to interconnect with other databases. The test environment in this article is: Operating System: WINDOWS2000 SERVER (Traditional Chinese System) Install the database: SQLSERVER2000 (English version) and VFP6.0 Specific steps: 1. Install VFP6.0 and SQL Server2000 on the PC. 2. Configure the ODBC data source for windows. Choose "start"> "program set"> "System Management Tools"> "Data Source"> "ODBC" to config

The interconnection of different database platforms is generally called the heterogeneous service of databases. Currently, all major databases can achieve such Heterogeneous Interconnection, but the specific implementation technologies of different vendors are different, such: in SQL SERVER, it is called LINKED SERVER, and ODBC is used to interconnect with other databases. The test environment in this article is: Operating System: WINDOWS2000 SERVER (Traditional Chinese System) Install the datab

The last two examples describe how to create classes interactively by using the Class Designer, or you can programmatically create a class. But it's cumbersome to create classes in this way, and it takes a lot of patience to debug, relatively small. To expand the knowledge bar, this article on the programming method to define the sentence format of the class to do a simple introduction, but there is no need to delve into and waste too much time, after all, there is already a visual, powerful "C

Combo box Control (ComboBox) is also a commonly used control in VFP, the combo box has the function of text box and list box, its name probably also comes from this. The common properties and methods of the combo box are given in detail in the basic course of VFP-the combo box control (ComboBox). In the application of the combo box control, a very important link is its RowSourceType and rowsource combinati

text1 in the current form and assign values using the with structure, the Code is as follows:With thisform. text1. Width = 10 set the width to 10. Enabled =. T.. Forecolor = RGB (0, 0, 0)EndwithNote: In the statement block in the middle, the solid dots before each attribute name (such as width) cannot be missing. Iii. common attributes of VFP objects are shown in the following table: Iv. Object methods:The object method determines the operation t

It is well known that the bubble sort (bubble sort) described above is the least efficient one in the common simple sort method. The sort of selection we're introducing today is also one of the simple sorts, but it's more efficient than bubble sorting and easier to implement. These common methods of sorting are more commonly found in the C/s data, if you want to implement these sorting methods in VFP, the principle is the same, but in the code to ach

VB has a control array, use it to set the properties of the control, the most direct function of this thing is to simplify the code. Today we simulate the VB control array in VFP, operate one of the most basic controls in VFP: Label control. In VFP Basic Tutorial-Label control (label) in the article on the control of the properties and uses have been described in

This article introduces in VFP to realize the bubble to sort the question, considers makes the example to be good understanding, therefore this article still will use the example way to express. In this case, at the beginning of the design, it is handled in this way: Define a scoped, 10-dimensional array that uses the text box on the form to enter and receive 10 digits consecutively, and then sort the 10 numbers from small to large. But run a bit, thi