collect.ini

一个VC写的关于数据库操作的实用例子。可供学习

[Data_path]
Souc_path=DSN=稽查源数据;UID=;PWD=;SourceDB=d:\Program Files\All2One\SourceData;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;
Dec_path=DSN=稽查目的数据;UID=;PWD=;SourceDB=d:\Program Files\All2One\DestData;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;
[Deal_sql]
Sql=UPDATE CHECDATA SET VNO = 'R' + RIGHT(VNO,LEN(VNO)-3) WHERE LEFT(VNO,3) = 'YR-' OR LEFT(VNO,3) = 'YR*' OR LEFT(VNO,3) = 'YR=';UPDATE CHECDATA SET VNO = LEFT(VNO,6) WHERE RIGHT(LEFT(VNO,8),2) = '警' OR RIGHT(LEFT(VNO,8),2) = '学' OR RIGHT(LEFT(VNO,8),2) = '挂';
[System]
City=R
ColName=p
FjfName=fp
DateTime=24
VNo=in0
VColor=icc

PreFixCount=3
PreLen0=R
PreLen1=豫R
PreLen2=YR

ColorCount=5
Color0=2
Color1=4
Color2=1
Color3=7
Color4=6

ClassCount=4
Class0=1
;Y
Class1=2
;S
Class2=M,T
Class3=3
;U

TypeCount=5
Type0=K
Type1=H
Type2=G
Type3=B
Type4=T

StateCount=1
State0=T

ActiveCount=2
Active0=1
Active1=0