Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
Ptonka

Avatar / Picture

Veteran
Registered:
Posts: 147
Reply with quote  #1 
Hi Freaks,
i use a grid (Table View_Report_BR) which created by some Filters.
So i create a string called %Suchstring like :
 
Description = '%Filter'

The string %Suchstring  is in ROW(s) at the properties of the grid.

The grid will be filled correctly. Now i need the number of Datasets and i
created another string at "Do this" in a Button like:

%Anzahl_Ruf:=%SelectSQL("select count(*) from View_Report_BR_MA where %Suchstring")

So i hope that %Anzahl_Ruf will be filled with the number of datasets.
But it doesn't work !!!  Everytimes %Anzahl_Ruf = 0.

What's the problem? Please help.
Thanks, Joe
0
jasonstorey

Member
Registered:
Posts: 19
Reply with quote  #2 
One thing worth noting would be if your %Suchstring variable which continues the query has something similar to "bla like '%substri%'  " it will give issue as metastorm with think it's a variable and not a sql wildcard. you need to double up them up (%%).

Something easy to overlook.

EDIT: then again that would probably just break your procedure not return 0....

__________________
JasonStorey
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!