文件名称：powerbuilder CrazySQLSource 3.9.2源码
文件大小：2.24MB
文件格式：ZIP
更新时间：2011-12-24 08:26:34
powerbuilder,CrazySQLSource,控件,数据库,SQL
学习Powerbuilder的好东西，里面有很多好控件，源码，作者已近停止更新，最新版4.0，可惜下载不到，这是我以前下载的，现在网上也找不到了，呵呵，还有安装的就不发了。
The first thing you will notice when you open the application is an updated Object Browser. I still need to add some functionality to it like being able to connect to a datasource and a way to refresh any node in the tree.
The other major enhancement I made was to the SQL Query windows autocomplete feature. I’ve extended it to be a little more flexible. You now have table autocomplete and custom autocomplete lists. To activate the table autocomplete list just type the name of the table owner and enter a period (e.g. select * from dbo. ). If you don’t know the table owner or don’t want to enter it you can just enter a period.
The idea of a custom autocomplete list is new. It gives you the ability to list anything you want. What displays can be a static list of items or the results of an SQL statement. By default, 3 lists are provided with the install: CSQL, DP and DT. CSQL lists all functions you can use in T-SQL. DP lists all datapart items and DT lists all datatypes. Try this:
SELECT csql.
You should see a list of functions appear. Continue typing to filter the list.
All custom lists are maintained in a new window called “My Autocomplete”. You can get to it through the Tools\My Autocomplete menu. If you select “List” for the type you would just enter a list of items in the editor window. If you enter “Command” for the type you specify a select statement. The first column in the select statement will be used for filtering and inserting into the SQL editor window.
Here’s an example of where you can use a custom list:
1. Enter a new item in the My Autocomplete window called country (assuming you have a country lookup table).
2. Change the type to Command.
3. Enter the following SQl (as an example)
SELECT country_code, country _name
FROM country _tb
4. In a new SQL Query window type
SELECT *
FROM city_tb
WHERE country _code = country.
【文件预览】：
sqlquerybuilder.pbl
text.pbl
graphwizard.pbl
datasource.pbl
datatransfer.pbl
sqlmain.pbl
visualdifference.pbl
advguiobjects.pbl
colorcombobox.pbl
options.pbl
advguicontrols.pbl
search.pbl
dockwindows.pbl
calculator.pbl
sqleditor.pbl