数据库及相关技术
怎么在BCB中取SQL Server/Sybase中符合条件的表
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区select name from sysobjects where name >= 'xx040801' and name < 'xx040901'
后，取结果集
执行后来 Query1->FieldByName("name")->AsString;
为什么语句中错误，说没有name字段
有什么更好的方法？
而且sysobjects有25个字段，查询后，Query1中得到的字段只有24个，name确实没了，原来的第二项id变成了第一项
相关推荐
SYBASE表数据库导出程式(源码)(需CTLIB for D6)
SYBASE表数据库导出程式(源码)(需CTLIB for D6)CTLIB在本站可以下载到. 我以前上传过. 常常要导出数据,从SYBASE和SQL Server上导到EXCEL. 导多了烦,于顺手写了两个程序(for MSSQL和SYBASE),for MSSQL 在本站也可找到,拿出来给大家用. 有兴趣交流ERP/MRP系统及SAP系统,C++/DELPHI/BCB/MSSQL SERVER/SYBASE/ORACEL编程技术的加我(mail:/msn : shap_it@hotmail.com)
SQLAPI for_BCB
C++ 访问SQL数据库类库 支持 (Oracle, SQLServer, Sybase, DB2, InterBase, SQLBase, Informix, ODBC)
SQLDirect v3.2.3 for Delphi BCB
SQLDirect Component Library is a light-weight Borland Database Engine replacement for Borland Delphi v.3 - 7 and C++Builder v.3 - 6. It uses the native application programming interfaces to access to the following SQL-servers: Centura (formerly, Gupta) SQLBase Server, IBM DB2 Universal Database, Informix Server, Interbase/Firebird Server, Microsoft SQL Server, MySQL Server, Oracle Database Server, PostgreSQL Server, Sybase Adaptive Server Enterprise and Adaptive Server Anywhere, ODBC datasources
SQLDirect.Professional.v4.0.Delphi.BCB
SQLDirect组件库是Delphi的非可视化系列组件。这些组件扩充了Delphi可视化组件的能力，使你通过BDE、ODBC方式能够访问数据库服务器上的数据，支持所有已知的数据组件。 现在这个组件库支持下列数据库服务器： Centura SQLBase (version 6 and 7), Oracle Server (7.2+), IBM DB2 Database, Informix, Interbase, MySQL, PostgreSQL, Microsoft SQL Server and Sybase Adaptive Server Enterprise and Adaptive Server Anywhere（通过开放的客户端库）。今后上面的列表还会进一步扩展。
SQLDirect.v3.0.3.Full.Sources.For.Delphi.BCB
SQLDirect Component Library - set of non-visual Delphi components. These components expand possibilities Delphi Visual ComponentLibrary, give you access to data on SQL-servers around BDE or ODBC and support all data-aware components. Now library supports the following SQL-servers: Centura SQLBase (version 6 and 7), Oracle Server (7.2+), IBM DB2 Database, Informix, Interbase, MySQL,PostgreSQL, Microsoft SQL Server and Sybase Adaptive Server Enterprise and Adaptive Server Anywhere (through Open-Client Library). Hereafter this list will extend. For access to databases the native programming interface (API) of servers is used only. It means, that access to SQLBase-databases needs SQLBase Client for Windows, to the databases on Oracle - Oracle SQL*Net, to the DB2 databases - Client Application Enabler, to the databases on SQL Server - SQL Server Client and to the Sybase databases - Sybase Open Client libraries.
