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
|
|
|
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
|
|
|
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
|
|
|
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/
>
|
|
|
|
|
|
|
|