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
0
Please sign in to leave a comment.
Comments
0 comments