I would like to use a part of this project. In fact, I have all informations about connection, and I just want to use a part of the project : the frame that builds query.
But there is no comment in all the code, no documentation (I made a javadoc, but nothing), so I really don't know what to use...
Thanks a lot,
Geraldine.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Have you tried to give a look to the examples (package nicky.querybuilder.sample)?
Could you describe in way more detailed of what you would like to do?
Regards, nicky
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I ran InsideWindow, but something is missing for my use : save/load query syntax. Can you tell me which class to use? Because the thing I really need is the "syntax".
other two things : - when I join two fields, it is ok. But if I want to "disjoin", I don't manage, how to do?
- then, I saw that the "syntax" use database.table.field (for example globe.p_ctc.ctcincde) and I would like only table.field for generic syntax. Where can I change this thing in your code?
Thank you very much,
your work is great (even without any comments or docs, I managed to understand things!!)
Geraldine.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Geraldine,
i have integrated freeQueryBuilder component in
my project freeReportBuilder.
But the release of freeReportBuilder on SourceForge have old version of the freeQueryBuilder.
I will update the release between any day.
If is useful i can send you source and all project freeReportBuilder.
bye Pino
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
In fact I am internship in a compagnie that wants to change from Crystal reports to jasper reports. So they need to edit reports, we use iReport for jasper reports. But iReport is good for people that know about query and programs.
The users do not know anything about this, that's why I try to improve iReport...
Géraldine.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
But loading a query is still difficult. In fact, I don't want to use all the workspace and the application. I would like something that constructs a queryModel : for example queryLoader(String query) that returns a querymodel. Is there still a method that does that thing, or code that can be re-used?
Thanks,
Géraldine.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The most important works!!!
I will give you later (when everything will be "clean") what I modified (serializable in querymodel class and querytokens class and few more things)
I speak french (mother language), english and a little bit of german, but not italian... sorry...
Géraldine.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I need the same thing that Geraldine need, but i haven´t known how start with the query builder part, and the rest of the project, can someone give me an explanation for dummies?
Thanks a lot!
sorry for mi english.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I would like to use a part of this project. In fact, I have all informations about connection, and I just want to use a part of the project : the frame that builds query.
But there is no comment in all the code, no documentation (I made a javadoc, but nothing), so I really don't know what to use...
Thanks a lot,
Geraldine.
Have you tried to give a look to the examples (package nicky.querybuilder.sample)?
Could you describe in way more detailed of what you would like to do?
Regards, nicky
I found most of what I wanted :
I ran InsideWindow, but something is missing for my use : save/load query syntax. Can you tell me which class to use? Because the thing I really need is the "syntax".
other two things : - when I join two fields, it is ok. But if I want to "disjoin", I don't manage, how to do?
- then, I saw that the "syntax" use database.table.field (for example globe.p_ctc.ctcincde) and I would like only table.field for generic syntax. Where can I change this thing in your code?
Thank you very much,
your work is great (even without any comments or docs, I managed to understand things!!)
Geraldine.
1) look at:
nicky.sqleonardo.Workspace.QueryEntry.load()
nicky.sqleonardo.Workspace.QueryEntry.save()
2) use right-click
3) nicky.querybuilder.QueryTokens line 154 -> String identifier = name; ...you must test ;)
I am curious to know what type of program you are developing and if then I can see the final result?
Nicky
Hi Geraldine,
i have integrated freeQueryBuilder component in
my project freeReportBuilder.
But the release of freeReportBuilder on SourceForge have old version of the freeQueryBuilder.
I will update the release between any day.
If is useful i can send you source and all project freeReportBuilder.
bye Pino
In fact I am internship in a compagnie that wants to change from Crystal reports to jasper reports. So they need to edit reports, we use iReport for jasper reports. But iReport is good for people that know about query and programs.
The users do not know anything about this, that's why I try to improve iReport...
Géraldine.
Thank you very much for your answer,
point 2 and 3 are ok.
But loading a query is still difficult. In fact, I don't want to use all the workspace and the application. I would like something that constructs a queryModel : for example queryLoader(String query) that returns a querymodel. Is there still a method that does that thing, or code that can be re-used?
Thanks,
Géraldine.
This is a thing on which I am working... it deals with building a sql-parser... it is very difficult.
The methods load() and save(), can help you to understand how to save and reload...
Where would you like to save the queries,in a file or in a database? (Have you thought about making serializable the QueryModel class?)
I would like to save it in a file. Something very simple with a text (if it is possible). But you tell me it needs a sql-parser... looks difficult...
Is it possible to save querymodel?
Géraldine.
try:
add implements of Serializable interface on QueryModel class
build a new class like FileQuery and implements methods that use ObjectOutputStream.writeObject and ObjectInputStream.readObject (more on JavaDoc)
to reload QueryModel in the QueryBuilder component use QueryModel.load(QueryBuilder builder)
I hope to have been clear...I am Italian ;)
Thanks thanks thanks a lot!!
The most important works!!!
I will give you later (when everything will be "clean") what I modified (serializable in querymodel class and querytokens class and few more things)
I speak french (mother language), english and a little bit of german, but not italian... sorry...
Géraldine.
Hi, Everyone,
I need the same thing that Geraldine need, but i haven´t known how start with the query builder part, and the rest of the project, can someone give me an explanation for dummies?
Thanks a lot!
sorry for mi english.
Hi,
I'm sorry but there's not documentation.
I could help you, but I have not understand what you want to do. If you need to start SQLeonardo use this command line: java -jar sqleonardo.jar
Nicky
I know how execute SQLeonardo, but i dont know how connect it to my db2, also I need work with query builder, but i dont know how to use it
thanks!
I hope that can help...
* To connect DB2 *
(http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0512kokkat/#install)
driver-class = COM.ibm.db2.jdbc.app.DB2Driver
url = jdbc:db2:<database>
(http://querybuilder.sourceforge.net/faq.html)
* To create a query *
http://querybuilder.sourceforge.net/metadata_explorer.jpg
Nicky
THANKS A LOT!!!!
THAT WAS JUST THAT I NEEDED
I'm sure that I'll ask you again later, but right now is OK.
Thanks again
and sorry for my english again