In many Novell networks today, the data platform is still based on DOS FoxPro environment, general workstations are diskless stations, but the leadership of the workstation is often used to prepare a better, and equipped with WIN95 or WIN98 systems, if only for data query or simple processing,
will result in waste of resources, and if other work is done at the same time, it cannot ensure network security.
----In view of this, we have designed a
FOXPRO System Index
FoxPro 2. 5 Standard Edition FoxPro 2. FoxPro under 5 Enhanced Windows The maximum number of records per database L0 billion L0 billion 1 billion the maximum number of characters in each record 650006500065000 maximum number of fields per record 255 255255 max characters for each field 254254254
by web, lan, and even your own computers and applications.
Visual FoxPro makes it easy to organize data, define Database Rules, and create applications.Visual FoxPro integrated development environment not only has powerful object-oriented programming toolsAnd Client/Server capabilities, and supports Ole and ActiveX. If you have installed InternetExplorer, and it is the default browser. You can use the foll
---------- DBF import SQL Server table ----------
The following uses SQL2000, VFP6, and above as an example.
Method 1: execute the following statement in the query analyzer (select the corresponding database first)
-- If the SQL table that accepts the imported data already existsSelect * from openrowset ('msdasql ', 'driver = Microsoft Visual FoxPro Driver; SourceType = DBF; SourceDB = c :\', 'select * from aa. dbf ')
-- You can also import the corres
First, the question of the proposedThe most recent project encountered ASP pairs of FoxPro library tables (*. DBF) operation problem. In reality, many applications use DBF tables, how to use these data in the network environment, so many friends are helpless.I also checked a lot of information, did not find a detailed explanation for the solution. After the test, the preliminary solution to this problem, take out and share with you.This article attemp
select "MicrosoftOle db provider for ODBC drivers, and then, "1. Select use data source name", select "DBASE" in the listFiles "; 2. "Enter Login Server Information" can be ignored; "3. enter the initial directory to be used. copy the directory path of the DBF file to the directory. The complete connection string is "provider = msdasql.1; persistSecurity info = false; Data Source = DBASE files; initial catalog = {data_path} "(where {data_path} is the. DBF storage path ). Click "test connection"
Encryption | decryption
Data library encryption and decryption technology, one of FoxPro
Author: ccbzzp
In reality, the security of the data is very important, especially in a very important department like the bank,
So the encryption of the data is particularly important, and in the long term, the pen is always the encryption and decryption of the various numbers.
Write the law, I hope to help you, and we also explore together, learn together, and p
former is used for desktop databases such as ACCESS and FOXPRO components, and the latter is to implement the new version of ADO components. In:
Http://download.microsoft.com/download/access2000/SP/4.0/NT5/EN-US/Jet40SP5_W2K.exeHttp://download.microsoft.com/download/dasdk/install/2.60.6526.3/WIN98Me/CN/mdac_typ.exe
These are standard SQLExportStatement:
Select * into [office/9.shtml 'target = '_ blank' class = 'Article'> Excel8.0; database =ExportDir
This simple method. I don't know. It's a pity.
Select * into [Excel 8.0; database = export Directory]. Export table name from tableSelect * into [FoxPro 2.6; database = export Directory]. Export table name from tableSelect * into [FoxPro 2.5; database = same as above]. Export table name from tableSelect * into [dBase III; database = same as above]. Export table name from tableSelect * into [Paradox 4.X; da
' Visual FoxPro Connection method:
Set Adocon=server.createobject ("Adodb.connection")Adocon.open "Driver={microsoft Visual FoxPro Driver};sourcetype=dbc;sourcedb=*.dbc;exclusive=no;"
' Ms Text connection method:
Set Adocon=server.createobject ("Adodb.connection")Adocon.open "Driver={microsoft Text Driver (*.txt; *.csv)};d bq=-----;" _"Extensions=asc,csv,tab,txt;persist Securityinfo=false;"
' Ms text OL
I went online for a long time and found the driver or something. I used to use Navicat directly.1. Create a database test in mysql.2. Open the plus sign on the left of the database test, which will display tables, views, functions, and so on.3. On the 'table' page, right-click the ---> Import wizard. For example, import foxpro --- here and select the dbase file (*. dbf) option.4. Select the dbf file. Select the encoding. Next step5. Whether to create
If we need to use the writeprivateprofilestring of the Win32 API functionFor this function, we first need to declare this function in the form that calls this function.If we want to execute it in the click function of a button, we should write it like this
* -- Define write applicationProgramDLL Functions of INI filesDeclare integer writeprivateprofilestring in WIN32API as writeprivstr;String csection, string ckey, string cvalue, string cinifileSet path to "E: \ foxproproject" Do writeinifi
Dim conn as new ADODB. Connection
Dim RS as new ADODB. recordset
Conn. Open "driver = {Microsoft Visual FoxPro driver}; sourcetype = DBF; sourcedb = D: \ backup \"
Rs. Open "select * from TT. DBF", Conn
Rs. movefirst
For I = 0 to Rs. Fields. Count-1
TTT = TTT Rs. Fields (I). Name ","
Next I
Msgbox ttt
Do
Msgbox Rs. Fields (0). Value
Rs. movenext
Loop until Rs. EOF
Preliminary findings .....When this step is placed in COM +And
In. Net, common VFP functions, no, finding an alternative, troublesome, and time-consuming. One of the learning practices.
With this Tookit, we can also use the same basic functions as VFP in. net. Thanks for your convenience !!
Tookit has been implemented beyond225VFP function.
You don't have to be a newbie... Function... Parameters ..
Toolkit has a complete help file, including examples of VB.net, C #, and VB.net, C #Source codeIs also a super good example of comparative learning.
When I
Some time ago, I helped a student complete a Visual FoxPro Sorting Algorithm assignment question and recorded it here.
I. Question requirements:
The program requires the user to enter n numbers first, finally, the original input series are output in sequence, the series after the ascending order, the series after the ascending to the smallest arrangement, and the series after the large to small arrangement at both ends.
Ii. program code:
Clear
Data | database
The WWW web page of the Internet has a large number of two-dimensional tables, some of which are converted from a database. The author has written a program to automatically realize the database file into the Hypertext table, which is very efficient and is introduced to readers. The design idea of the program is simple: open. DBF database, which reads each field of the database in record order, and then adds the table control character of the HTML file to the. html file
Summary: Apache support Chinese domain name binding, Apache support Chinese domain name binding, teach you how to let Apache support Chinese domain name binding , according to my actual experience, how to let Apache support Chinese domain name binding, It's absolutely useful for Apache to
Sublime Text 2-the Sexiest code Editor! The programmer must be an artifact! Cross-platform support Win/mac/linux, support 32 and 64-bit, support the syntax highlighting of various popular programming languages, code complement congruent ...Syntax highlighting, code hinting completion, code folding, customizing skins/color schemes, multi-note pages:SUBLIMETEXT2 su
UI interface is completely different, then upload the logic and interface to write the dead, encounter different situations need targeted transformation. For a single case, of course, the lightest, only to consider the current situation, not the function can be completely thrown away, can be the most streamlined, but not easy to reuse. If a wheel cannot be reused, it certainly cannot be counted as a qualified wheel. Be aware of this, and now that you have embarked on the road of making wheels,
-linkbutton"Plain= "true"ID= "button495769"Iconcls= "NULL"onclick= "onClickbutton495769 ();" >End escalationa>Get the ID of the selected row and stitch it up:function onClickbutton495769 () {var rows = $ (' #tabgrid20170726191838251403 '). DataGrid (' getselections '); if (Rows! = NULL) {var ids = ""; for (var i=0;iClick on the specific task to achieve the jump:function onClickRow20170726191838251403 (rowindex, RowData) {var row = $ (' #tabgrid20170726191838251403 '). DataGrid (' GetSelected ');
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.