張貼者:2010年8月12日 上午12:24未知的使用者
[
service orderble 已於 2012年8月8日 下午2:52 更新
]
為了你的客戶,服務器和Web應用程序的用戶能夠創建和執行自己的查詢。 該 Automated- SQL-Builder是一個ActiveX控件,可用於任何應用程序與用戶提供查詢功能,提供了強大的除了你的整體報表解決方案。 -------------------------------------------------- 開發商:SBS Development 原廠網址: http://sbsdev.com/automatedsqlbuilder.htm更新日期:2011/05/18 採購正式版、大量授權報價、技術支援、軟體諮詢、委託採購、詢問報價請來電 02-29299388 分機16 , 來信service@orderble.com,或 點我------------------------------------------------------------------------------
發特色 - 支持幾乎任何SQL的ANSI - 92數據庫,包括Oracle,DB2中,MySQL和MS Access和SQL Server的。
- 互聯網加強和啟用。包括數字簽名和標記安全執行腳本和初始化。
- 設施,以改變該控件的用戶界面語言從英語(默認),以當地語言或語言的選擇。
- 當負荷性能改進的控制連接到大型和複雜的數據庫。
- 綁定到數據庫連接控制在設計時通過連接屬性頁或在運行時,提供必要的連接參數。
- 工作束縛(數據庫連接)或無限制(無連接)模式。
- 選擇表和視圖,你想暴露給用戶。
- 支持使用表和字段的別名。 讓你隱藏本機數據庫表和字段名稱顯示定制(用戶友好)表和字段名稱給用戶。
- 添加/刪除表和字段在運行時。
- 諮詢及法定組織中的位置在屏幕上的任何地方,其隱藏並設置其重點使用任何新的左,上,可見光和設置焦點屬性和方法。
- 限制用戶的功能,利用該控件的一系列全面的屬性,方法和事件。
- 利用控制新的或現有的應用並使其工作在幾分鐘內。
- 控制暴露用戶生成的SQL字符串和查詢結果的形式1
ADO記錄集。 - 。NET兼容
用戶功能
Developer Features - Support for virtually any SQL ANSI-92 Database, including Oracle, DB2, MySQL, MS Access and SQL Server.
- Internet enhanced and enabled. Including Digital Signature and marked Safe for Scripting and Initialisation.
- Facility to change the control's User Interface language from English (default) to your local language or a language of your choice.
- Improved Control load performance when connecting to large and complex databases.
- Bind Control to a Database Connection at Design time via the Connection Property page or at Run-time by providing the necessary Connection arguments.
- Work in Bound (Database Connection) or Unbound (No Connection) mode.
- Select the Tables and Views that you wish to expose to the user.
- Supports the use of alias tables and fields. Enables you to hide native Database Table and Field names by displaying bespoke (user friendly) Table and Field names to the user.
- Add/Remove Tables and Fields at run-time.
- Position the ASB Form anywhere on the screen, hide it and set its focus using any of the new Left, Top, Visible and Set Focus Properties and Methods.
- Restrict user functionality by utilizing the control's comprehensive array of Properties, Methods and Events.
- Utilize Control in new or existing Applications and have it working in minutes.
- Control exposes User generated SQL string and query results in the form of an
ADO Recordset. - .NET Compatible
User Features Fresh ‘XP’ look and feel. Select Tables/Fields. Ability to create Table Joins. Support for WHERE and HAVING conditions. Search Database for available Field values. Automated assumptions based on a combination of the previously added criteria and query operators selected by the user. Assumptions can be edited using the versatile edit WHERE grid. Support for Group By Clause. Support for Order By Clause. Ability to build Calculated Fields. Open, Save and Delete Queries. Manually edit a copy of the assembled SQL using the SQL Scratch Pad. View Query results. Export Query results to Excel.
|
|