PB 7 ddw uses old select at runtime 1

[Qik3Coder]

Powerbuilder 7.0.3
SQL 2005

I have a datawindow with a super basic select:

SELECT  a.code , a.desc     
FROM a   
ORDER BY a.code ASC

I needed to filter out some values, so the select now looks like:

SELECT  a.code , a.desc     
FROM a   
[b]WHERE code <> '0' and desc is not null[/b]
ORDER BY a.code ASC

When i run the retrieve in the designer, it works fine. I then delete all the rows, and hit the debug window.
It then uses the old select and all the values show in the dropdown. I have exported the datawindow, and it shows the correct select.

I did a google for every combination of pwerbuilder datawindow sql that i could find, to no avail.

Thanks,


If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this [red]"there was an error crap"[/red]

 

[mbalent]

Did you change the original datawindow object or create a new one with your where clause? If new, make sure the new datawindow object is referenced in the datawindow control.

Matt

"Nature forges everything on the anvil of time

 

[Qik3Coder]

I just added the where clause to the existing one.

It's odd. I exported the datawindow and the select is the "new" one. When I click Retrieve from the datawindow itself, it returns the new filtered set.

When i use the datawindow in the existing drop down, it uses the old select.
I haven't done a whole lot of powerbuilder dev'ing, just basic bug fixes.

Thanks,

If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this [red]"there was an error crap"[/red]

 

[Qik3Coder]

Here's some awesomeness.

I opened the dddw, did a save as dddw2. Set the datawindow to use the dddw2. ran it. List is filtered. Set back to dddw, ran it, and it shows the unfiltered list.

Thanks for the brain tickler about creating a new window.

If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this [red]"there was an error crap"[/red]

 

[miguelleeuwe]

You probably have a duplicate object in a diferent library.
At runtime, that's the one encountered and not your latest modified one.

there's no compiling error on duplicate datawindows.



regards,
Miguel L.