The Usage of ODBC to Expand the Function of SQL in Foxpro

Abstract

Abstract: This paper explores a new method that expands SQL in Foxpro to overcome its limitation by ODBC and LCK. Theauthor emphasizes on the usage of LCK and its interface between ODBC and Foxpro. It provides a set of effective ways to strengthedthe function of Foxpro, which brings the system developments based on Foxpro into a new world of Windows programming.[

摘要： 针对Foxpro的SQL语句的局限性讨论了一种通过ODBC和LCK扩展Foxpro的SQL语言的方法。着重介绍了LCK的使用方法及其与ODBC和Foxpro之间的接口。为Foxpro的功能增强提供了一套有效的实现手段，使基于Foxpro的系统开发进入了Windows编程的广泛天地。

关键词: Foxpro, 开放数据库互连, 库构造工具集, SQL

CLC Number:

TP311.13

Zhou Haofeng. The Usage of ODBC to Expand the Function of SQL in Foxpro[J]. , 1999, 25(01): 73-75.

周皓峰. 使用ODBC扩展Foxpro的SQL功能[J]. , 1999, 25(01): 73-75.

/ Recommend / Download Citations

URL: https://www.ecice06.com/EN/Y1999/V25/I01/73

[1]	DING Lin, YANG Yang, GUO Caili, GUO Jianzhang, LI Zheng. A Text-to-SQL Method Based on Fine-Tuning Large Language Models with Table Creation Information [J]. Computer Engineering, 2026, 52(11): 402-411.
[2]	LIN Xiaoqing,ZHANG Fu,CHENG Jingwei. SPARQL Query Optimization Based on Longest Property Path Filtering [J]. Computer Engineering, 2018, 44(11): 7-13.
[3]	YANG Xiujuan,DONG Jun,LI Huihui,YUAN Yanzhong,CHEN Xiaodan. Reverse Furthest Neighbor Query Method Based on Improved Metric Index [J]. Computer Engineering, 2017, 43(4): 234-238.
[4]	YUE Guohua,CHEN Peng. Fast Output Algorithm of Embedded Electronic Map Based on MapInfo Data [J]. Computer Engineering, 2017, 43(1): 93-97.
[5]	GAO Jun,HAO Zhongxiao. Credible Nearest Neighbor Query in Constraint Fuzzy Network [J]. Computer Engineering, 2015, 41(1): 54-60.
[6]	SUN Hailong,WANG Nihong,WANG Chunyan. CKNN Query Based on Constraint of Directional Relation in Road Network [J]. Computer Engineering, 2014, 40(12): 50-56.
[7]	HAO Xiao-hong, ZHANG Li-ping, ZHAO Ling-qiang, LI Song. 3DR39-3d Orientation Relation Model and Reverse Orientation Relation [J]. Computer Engineering, 2014, 40(7): 258-262.
[8]	SUN Hai-long, WANG Ni-hong. CKNN Query Based on RRN-Tree in Road Network [J]. Computer Engineering, 2014, 40(6): 306-311.
[9]	DI Liang, DU Yong-ping. Application of LDA Model in Microblog User Recommendation [J]. Computer Engineering, 2014, 40(5): 1-6,11.
[10]	LU Ti-guang, LIU Xin, LIU Ren-ren. Universal Crawling Algorithm for Microblogging Data [J]. Computer Engineering, 2014, 40(5): 12-16,20.
[11]	GAI Wei-lin, XIN Dan, WANG Lu, LIU Xin, HU Jian-bin. Review of Date Fusion and Decision-making Methods in Situation Awareness [J]. Computer Engineering, 2014, 40(5): 21-25,30.
[12]	GAO Jun, HAO Zhong-xiao. Nearest Neighbor Query for Fuzzy Object in Constraint Network [J]. Computer Engineering, 2014, 40(3): 39-45.
[13]	YIN Shao-hong, FAN Gui-dan. Top-k Frequent Itemsets Mining Algorithm over Data Streams Based on Matrix [J]. Computer Engineering, 2014, 40(3): 55-58,75.
[14]	FENG Jia-jun, WANG Xiao-lin, TIAN Qing. Text Retrieval Model Based on Counting Bloom Filter [J]. Computer Engineering, 2014, 40(2): 58-61.
[15]	SUN Tao, SUN Hong-feng, CHEN Wei-heng, LIANG Sai-ting. Skyline Query in Dataset with Normally Distributed Attributes [J]. Computer Engineering, 2014, 40(1): 45-48.

Please choose a citation manager

Content to export