CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> IDE/GUI

 visual query builder where, group by, order by

Print topic Send  topic

Author Message
donsafar


Posts: 90
Posted: 03/21/2006, 6:41 AM

I created a grid control usin the query builder. I made a mistake in the where clause. It appears there is no way to modify the where condition without adding a new where condition. I haven't used 3.0 much since the betas, but the where, group by and order by used to appear down the left side and you could select and modify easily. Now I must add a where condition to get the where window to display, then remove the condition and modify the condition that was in error. Am I missing something? version 3.0.2.2.
_________________
Don Safar
View profile  Send private message
wkempees


Posts: 1679
Posted: 03/21/2006, 9:27 AM

You are missing something, or somethins is malfunctioning.

Open the page containing your grid in Design.
Click the grid, so that the properties window is displaying the grid's properties.
Click in the Properties window on the Data Source, it will then display the [...] ellipses, click them, VQB will come up.
Default it will show 3 panes 1 left showing the SQL structure, 1 right top showing the graphical representation of all tables and 1 right bottom initially showing the selected fields for the SQL.
(I assume you are in Table mode)
Now in the left pane click on WHERE
The bottom right pane should now display the content of the where clause and all the necessary tools to (+) add fields or expressions.
Clickin on each line should bring up the setting dialog.

Any of the above not working? => Support!

Walter



_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message
donsafar


Posts: 90
Posted: 03/22/2006, 4:21 AM

Support supplied the answer to correct the problem. delete HKEY_CURRENT_USER\Software\YesSoftware\CodeChargeStudio3\Options\VQB.. Now VQB works like it should.
_________________
Don Safar
View profile  Send private message
WKempees
Posted: 03/23/2006, 3:32 AM

Whoopie

"donsafar" <donsafar@forum.codecharge> schreef in bericht
news:444214142d3620@news.codecharge.com...
> Support supplied the answer to correct the problem. delete
> HKEY_CURRENT_USER\Software\YesSoftware\CodeChargeStudio3\Options\VQB.. Now
> VQB
> works like it should.
> _________________
> Don Safar
> http://www.insights-web.com
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>


Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.