oracle10g+oledb ，不能使用with as吗

llihao 2012-04-28 01:13:46

我使用oracle 10g 和,net 2003 ，数据库连接是 oledb ，在sql中使用了 with as 后，数据就不能返回了
如果不使用with as 数据就可以正常返回，这是为什么呢

...全文

90 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

lyserver 2012-04-28

打赏
举报

oracle支持with as，sql server还是盗它的呢，可能是你语句有问题，注意with as 前后的语句必须加“;”号。

orochiheart 2012-04-28

打赏
举报

关键是找找plsql是否支持 with as 可能在Oracle里面是另种写法吧和oledb应该没有关系

将oracle数据记录导出到excel文件中。先按文档中语句将数据查询出来，再拷贝到excel中

delphi如何调用Oracle的存储过程

可以取代BDE的好東西，這版支援Delphi XE connecting to the following SQL servers using 32-bit native application programming interfaces (API): Centura SQLBase Server 6(+), IBM DB2 Universal Database with CAE v5.2, Informix Server 7.2(+), Firebird, Interbase, MySQL 3.23(+), Oracle Server 7.2(+) with SQL*Net 2.2(+), Microsoft SQL Server, PostgreSQL 7.1(+), Sybase Adaptive Server Enterprise and Adaptive Server Anywhere (through Open Client, which is supported by Anywhere ver.6 as native interface), ODBC and OLEDB datasources. no distributing, installing and configuring the BDE or ODBC simultaneous access to the supported servers using Delphi 5, 6, 7, 8, 9(2005), 10(2006), 2007, 2009, 2010, XE or C++Builder 5, 6, 2006, 2007, 2009, 2010, XE (Pro and above) to develop Client/Server applications query with an updatable result set query with macro support table component thread safe BLOB-fields (including LOB and BFILE for Oracle8) stored procedure support (with mutiple result sets for IBM DB2, Microsoft and Sybase SQL Server) bi-directional and unidirectional result sets cached updates record filtering support of data-aware components InfoPower support using images stored by Centura SqlWindows(or Team Developer) in their proprietary format interfaces (public methods and properties) of SQLDirect components are compatible with standard BDE data access components (TSession, TDatabase, TQuery ..).

除unidac外我愛用的一套，可存取不同資料庫，取代掉BDE，僅供各位同好試用，喜歡的話請購買支持開發者。 SQLDirect Component Library is a light-weight Borland Database Engine replacement for Borland/CodeGear/Embarcadero Delphi v.5 - 10, 2010, XE-XE10 and C++Builder v.5 - 2010, XE-XE10. It uses the native application programming interfaces to access to the following SQL-servers: IBM DB2 Universal Database Informix Server Interbase/Firebird Server Microsoft SQL Server MySQL Server Oracle Database Server PostgreSQL Server SQLite Database Sybase Adaptive Server Enterprise and Adaptive Server Anywhere Unify (Centura, Gupta) SQLBase Server ODBC datasources OLEDB datasources Using of SQLDirect Component Library gives you the following advantages: connecting to the following SQL servers using 32-bit native application programming interfaces (API): Centura SQLBase Server 6(+), IBM DB2 Universal Database with CAE v5.2, Informix Server 7.2(+), Firebird, Interbase, MySQL 3.23(+), Oracle Server 7.2(+) with SQL*Net 2.2(+), Microsoft SQL Server, PostgreSQL 7.1(+), SQLite, Sybase Adaptive Server Enterprise and Adaptive Server Anywhere (through Open Client, which is supported by Anywhere ver.6 as native interface), ODBC and OLEDB datasources. no distributing, installing and configuring the BDE or ODBC simultaneous access to the supported servers using Delphi 5, 6, 7, 9(2005), 10(2006), 2007, 2009, 2010, XE-XE7 or C++Builder 5, 6, 2006, 2007, 2009, 2010, XE-XE7 (Pro and above) to develop Client/Server applications query with an updatable result set query with macro support table component thread safe BLOB-fields (including LOB and BFILE for Oracle8) stored procedure support (with mutiple result sets for IBM DB2, Microsoft and Sybase SQL Server) bi-directional and unidirectional result sets cached updates record filtering support of data-aware components InfoPower support using images stored by Centura SqlWindows(or Team Developer) in their proprietary format interfaces (public methods and properties) of SQLDirect components are compatible with standard BDE data access components (TSession, TDatabase, TQuery ..). Thread Safety Note Thread safety is supported by the following software: Oracle SQL*Net 2.3 or above Centura SQLBase Ver. 7 or above IBM DB2 Ver. 5.2 or above Microsoft SQL Server Ver. 6 or above MySQL Sybase ASE and ASA through OpenClient Ver. 11.1 or above SQLDirect 6.5 was released. Delphi/C++Builder 10.1 Berlin support ftStream-Parameter support support ftWideString support (SQLBase 11.5+) bugfixes

NO.1报表控件 Stimulsoft Reports.Net 2010.1 Full Stimulsoft Reports.Net is the report generator which helps you create flexible and feature rich reports. It is a suite of 100% managed .Net components written in C#. Stimulsoft Reports.Net is delivered with source codes. All reports are created in report designer with handy and user-friendly interface. You can use the report designer both in design time and in runtime. No royalties for using the report designer in runtime are required. Using StimulReport.Net you can create reports on the bases of the variety of data sources which are as follows: Ado.Net, Ms Sql, Oracle, Odbc, OleDB, FirebirdSql, PostgeSql, IList, IEnumerable, ITypedList. Created reports can be used both in Windows Forms and in Asp.Net. Rendered report can be exported to: Pdf, Xml, Html, Excel, Rtf, Txt, Emf, Bmp, Jpeg, Gif, Png, and Tiff. StimulReport.Net is runtime royalty-free.

111,126

社区成员

642,541

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

让您成为最强悍的C#开发者

试试用AI创作助手写篇文章吧

+ 用AI写文章