SQL Query don't work anymore in optimiser

Tom Verkerk

Hello everybody,
When I have a rule in Customize which works normaly in SBO 2007 SP00 PL49 and export this one to SBO2007 SP01 PL06 then it's not working anymore.
When I create a simple new one it's also not working.
SQL Query:
SELECT 'Tekst'
Rule see attachment
I hope someone can give me advise.
Kind regards
Tom Verkerk

Olaf Borke

Hello Tom,

please can you add your rule again?
The attachement is not available....

Thanks

Olaf

Raphael Strotz

Yeah please add Rule, perhaps the error and your JPEG .. thanks!

Tom Verkerk

[quote]"t.verkerk@dotcombusiness.nl"]
Hello everybody,
When I have a rule in Customize which works normaly in SBO 2007 SP00 PL49 and export this one to SBO2007 SP01 PL06 then it's not working anymore.
When I create a simple new one it's also not working.
SQL Query:
SELECT 'Tekst'
Rule see attachment
I hope someone can give me advise.
Kind regards
Tom Verkerk
[/quote]

Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/t-verkerkdotcombusiness-nl/Rule.JPG]Rule.JPG[/url]

Raphael Strotz

Yeah thanks.. but what is the expression of the rule? your SQL query ? Do you got one ?

Tom Verkerk

See above in my mail.

Nothing is working even not a simple SELECT 'Tekst'.

Raphael Strotz

ok im screamed :( nothin happend! i just test it in other fields and forms !


Hope Egloff has an answer !

Tom Verkerk

I'm happy it's not only by me.

Manuel Marhold

Hi.
I think there is already a thred for this in this forum.

you cannot run queries to an windows by using "SQL" as typ

Tom Verkerk

But it's working in SBO SP00 PL49 and it has also working in earlier versions.

Michael Egloff

There must be another rule to made this SQL results visible.

If you add a SQL rule in the optimizer, the results won't be displayed. To make this happen you have to create a new window and a grid to display your rules (optimizer, cscode).

Tom Verkerk

Hello Michael,

Can you explain me with a sample beacause I don't understand what you wrote.

Kind Regards,
Tom Verkerk