ODBC usage?
I've wrote this code, and it seems to work:-
But there is some problems with Data-> Add Data Source -> Add SQL Query -> Design Query
First:
the tabs at the bottom:-
"Select" does not show any text at all for "name"
"Joins" does not show any text at all for "name", "Editor", or "Delete" (just empty row for each join)
"Group" Tab seems to do nothing.
Second:-
It's making crazy SQL:-
I added 2 tables - Users and Requests...
It's added the request table twice and not added the User Table, it happens if you drag the join one way (Users-> Requests), if you drag it the other way (Requests-> Users) it's ok
Any idea what's wrong with it?
Thanks,
- Anthony
    OdbcConnection myConnection = new OdbcConnection(GlobalVariables.ConnectionString);
            environmentSettings1.DesignerSettings.ApplicationConnection = myConnection;
            Report myReport = new Report();
            myReport.Design();
But there is some problems with Data-> Add Data Source -> Add SQL Query -> Design Query
First:
the tabs at the bottom:-
"Select" does not show any text at all for "name"
"Joins" does not show any text at all for "name", "Editor", or "Delete" (just empty row for each join)
"Group" Tab seems to do nothing.
Second:-
It's making crazy SQL:-
I added 2 tables - Users and Requests...
SELECT U.UserID
FROM `Request` R , `Request` R
WHERE U.UserID = R.CreatedUserID
It's added the request table twice and not added the User Table, it happens if you drag the join one way (Users-> Requests), if you drag it the other way (Requests-> Users) it's ok
Any idea what's wrong with it?
Thanks,
- Anthony
Comments
1) it was fixed yesterday, please download the latest build.
2) I've added this to buglist. I will let you know when the fix will be available.
Data-> Choose Report Data = Empty
Data -> Add Data Source crashes like this:
Thanks,
Anthony
1) Run Application
2) Click Choose Data -> Empty
3) Click Ok
4) Click Add Data Source - > Crash
but does not happen if you:-
1) Run Application
2) Click Add Data Source
Once you've done Add Data Source it works ok until you restart the application, then if you choose data first it will crash when add data source is clicked.
- Anthony
in the form's constructor, so it is executed before the report is created. To fix this error, add the following code before you set the connection:
I will fix the code in the next build, so this trick will not be necessary.
Tables:
"label1" [Blank Dropdown box] "label2"
Conditions:
"label6" [Blank Dropdown box] "label5"
I assume this is where I'm supposed to be setting left joins and such up?
Also, if you delete a join (by deleting the row on the join tab) it doesn't get removed from the SQL.
And if someone designs a query visually, then edits the SQL, then goes back to the design tab, their changes are lost, there should be a warning before this happens, or even better, their changed code could be parsed and reflected in the design view.
- Anthony
Do you have an estimate of the time to fix the visual query builder? The reason I ask is that my users are moving from Microsoft Access, and the query builder will be familiar to them, they will be disapointed if my answer is "learn SQL" [img]style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> which may mean I need to buy another report software. It's very important for my end users to be able to use the designer visually. Many thanks! - Anthony[/img]
Its author is in business trip now; he will be back in the next monday. Right now I can fix the "label1" [Blank Dropdown box] "label2" issue.
Thanks for letting me know.
If you would fix that join dialog, hopefully the users could then make the more simple reports without too much difficulty, and then when your collegue gets back from the business trip then they can fix the rest of the query builder?
Many thanks,
- Anthony
Any progress on this yet?
- Anthony
This bug is fixed, you may download the current build.