΢ͻӦ
MICROCOMPUTER & ITS APPLICATIONS
1999 18 2 Vol.18 No.2 1999



VB 5.0ݷʼ
־աΰ
ժҪVisual Basic 5.0ݿϵṹӦĽṹͼ΢JETݿODBCDirect 2ݷʼݷʶݿؼֱӵODBC API3ݷʷ˵
ؼʣݷʶݿؼJETݿ桡ISAMODBC API
ڸӦУݿӦ൱ġΪһĿߣVisual Basic 5.0ṩ൱ǿݿȡܣWindowsĸȽǿݿлؽһ𣬲ֱܹ֧Microsoft Accessݿ⣬һ԰װISAM(Indexed Sequential Access Method)(֧ParadoxFoxproBtrieveݿļ)ODBCṹл1ӿڣֱӵODBC APIݿЩݿȡƶͨMicrosoft JET(Joint Engineering Technology)ODBCDirectʵ֡Visual BasicݿӦóɴ߼ϷΪ3֣ûӿڡݿݿ洢ûӿںݿ洢ͨݿлؽһϵṹʹͬӦóӿڿԴȡͬ͵Դ
1Visual Basicݿϵṹ
ΪʹúͲݽṹݿ⣬Visual Basicṩͼ1ʾݿϵṹڴϵṹУVisual Basicʹ2ݷʼJETݿODBCDirect3ݷʷݿؼݷʶֱӵõODBC API(Ҳ԰ѡֱӵODBC APIһּ)ݿODBCDirectݷʵĺĲ֣λӦóݿ洢֮䡣ֽṹʹʵݿнϴĶԣʹͬݷʶԷʲͬ͵ݿ⣻ݿܹݿؼݷʶݿתɶݿҲֲܹ֧ͬ͵ݿ⡣


ͼ1ݿϵṹ
ݿؼݷʶǻݿ2ݷʷݿؼʹ÷Ƚϼ򵥣ụ̂ݵޡݷʶṩû̽ӿڣܹݿȫλĿơʵϣ2ַ໥ų⣬£ܻ֮ಹ䡣⣬ODBCṹл1ӿڣֱӵODBC APIݿ
Visual Basicг˻ݿݷʷ֮⣬֧ODBCDirect⣬VB5.0ҵгͼ1ʾļ⣬ṩԶݶ(RDO,Remote Data Object)Զݿؼ(RDC,Remote Data Control)ODBCݡûҪMicrosoft SQL ServerзʣVBSQL(Visual Basic SQL Libraries)VBṩӦóSQL ServerݿĽӿں
Visual BasicݿӦóУԷ3͵ݿ⡣
1.Visual Basicݿ⡣ҲΪڲݿ⣬кMicrosoft AccessͬݸʽݿֱӴͲڲݿ⣬ߵĹЧʡ
2.ⲿݿ⡣ⲿݿֳΪISAMݿ⣬BtrievedBASE IIIdBASE IVMicrosoft FoxPro V2.02.5Visual FoxPro V3.0Paradox V3.x4.0ȡûҲԷıļMicrosoft ExcelLotus 1-2-3ӱļ
3.ODBCݿ⡣ODBCݿָǻODBC׼Ŀͻ/ģʽݿ⣬Microsoft SQL ServerҪϵĿͻ/Ӧó򣬿ʹODBCDirectüֱӰݿⲿⲿݿODBCҲ԰ⲿݿ⿴ODBCݿ⡣
2Visual BasicݿODBCDirect
Visual BasicݿĺĽṹJETݿ棬ݿصڴαȾӵϸΪ1ȸ߶һּ򻯵ı̽ӿڡΪӦóṩˣ
(1)1ANSI SQL׼﷨
(2)Ϊʹòѯṩڴܡ
(3)ֵ֧ͬݿⲿӿڡ
(4)ΪӦóṩͳһⲿӿڡ
JETݿڲ1SQL﷨ԽܷûӦóṩANSI׼SQL䣬ṩVisual BasicıطʹܡʵϣSQL﷨֧Microsoft Accessݿڲ⺯ҿΪJETֵ֧ݿṩSQL﷨
⣬JETݿ5͵ĽǷֱǣForwardOnlyDynamicTableSnapshotDynasetϳΪ¼ӦóԴ͹Աݺʹݡ
ODBCDirectָͨRDOؼDAOֱӷODBCԴļODBCԴַͨʽʱΪODBCDirectԴODBCԴͨ΢ݿӷʱΪJet ODBCӡԴ2ԴʹòͬDAO󡢷ԡODBCDirectODBCԴнϸߵĴȡЧʡ
3ݷʶDAOݿؼֱӵODBC API
ݷģݿӿڣͼ2ʾÿӦϵݿϵͳ߼ģͣݿⱾԼݿеĶάǵֶΡȡݷʶûԴͲDatabaseTableFieldIndexݿЩݿ洢һһӦģͨЩúͷʹþͿɶݿĲûͨݷʶ̣ԶԶԴзʡַʼ˳룬ิӵȡϸڣûԼԡֻܽмӵĴʹָÿݿûϸȵĿơ
ݿؼơťȵı̹ܹTableSnapshotDynaset 3ݷʶݿеݽ¼ȡܹݰ󶨿ؼʾͨõݰ󶨿ؼУDBListDBComboDBGridMSFlexGrid⣬PictureLabelTextBoxCheckBoxImageOLEListBoxComboBoxؼ԰ڵһļ¼ϡʹݿؼ򵥵ݷʷıСܹʹõƶĿܽ


ͼ2ݷģͼ
ֱӵODBC APIݿṩ̶ȵֱӿơODBC APIṩ¹ܣͷŻӾԴ佨ӣ׼ִлֱִSQL䣻ΪSQLĲез洢еݣύ񣻼״̬ϢڸԡۺԼܷнϸҪӦó˵ֱӵODBC APIʵġַصǣֱӲĿ淶Խαṩ˸Ŀƣṩ˸αͺִжԸõؿWindowsִмԴá
3ݷʷصʹ÷Χǲǻġͨ3ַʹģԵõĳַŵ㣬ҿԼٸַơ߶Visual Basicݿϵṹ˹ɺܽᣬͶʵӦãȡ˽ϺõЧ
ߵλʯѧԺѧϵ(151400)
ο
1С.ݿ⻥ODBC 2.0ʹôȫ.廪ѧ磬1995
2Ծ.Visual Basicֲ.еҵ磬1996
3ƽ.ʹVisual BasicݿӦ.ӹҵ磬1996
(ոڣ1998-08-30)
