craftleft.gif (3002 bytes)QuickTable
Home | API | Tutorial | Download | Support | Contact topblack.gif (108 bytes)


QuickTable User Cp  |  Register  |  Members  |  Search  |  Help
    |- QuickTable Discussion Forums > General QuickTable Support/Help Post New Topic   Post A Reply
QBE Query-by-example printer friendly version
next newest post | next oldest post
Author Messages
ginoc{@}akr.de
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 23:59:59  

Hello,
is there a feature called "QBE", Query-by-example?
When dealing with huge DBs, it is not usefull to select the whole
table. Instead the user is filling an empty row with his/her's
selection rules.
This will generate the "where" clause of the SQL Statement.
Maybe I did not see it in the examples.
Otherwise it is very impressive.
Thank you.
Kind regards,
Gino Crepaldi
admin{@}quicktable.org
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 23:59:59  

currently quicktable doesn't have a direct support for query by example. There are three options to implement this.

1) You can implement your own engine to implement QBE and once you get the resultset back, call quicktable.refresh(yourResultset)

2) based on user criteria, you can create the SQL with the WHERE clause and then, setSelectSql(yourSql); refresh(();

3) Use a third party QBE engine like DBKona from weblogic, and finally after you execute the query, get the resultset from DBKona and refresh into quicktable using refresh(yourResultset) method.

Info about DBKona

http://www.weblogic.com/docs51/techoverview/db.html

http://edocs.bea.com/wls/docs70/javadocs/weblogic/db/jdbc/TableDataSet.html

Another tool http://www.trash.net/~ffischer/admin/index.html

Ben

Post New Topic   Post A Reply Jump to:
Contact Us | QuickTable - A Java DBGrid | Privacy Policy All times are GMT -5 Hours.
Welcome to QuickTable Forums, Guest!  
Login
Username :
Password :
In order to fully utilize the abilities of this board, you are required to register as a member. Registration is free, and allows you to do lots of things including turning on or off certain features of this board. Register now!
Powered by CuteCast v2.0 BETA 2
Copyright © 2001-2003 ArtsCore Studios