Hi, I’m going nuts…
If I have a link to another application why do I have to pass a filter for the primary key? I don’t want to filter on the primary key! I want to see a list of a totally different filter…
when you are linking, and you have variables in the target application, you will be asked to assign them from start-application to target application, if you don’t want, select “empty”
The problem is that if I leave the primary key empty I get this error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1
And the “sc_sql_ult_comando” is:
SELECT count(*) from pro_ProfileAktivitet where (pr_ProfileAktRID = )
It tries to filter the Primary key on an empty value :S.
Depending on the type of key I guess you need to set the filter to ‘’
Then you don’t have an empty key.
[QUOTE=aducom;28261]Depending on the type of key I guess you need to set the filter to ‘’
Then you don’t have an empty key.[/QUOTE]
So, how do I do that? I’m using a link on a HTMLImage and as I have a Primary key in the form I link to I have to pass a value for that (WHY?)!
And then the filter is built and applied by scriptcase…
Thank you.
I think I found a workaround… Setting a fixed value with the column name, then Column1 = Column1 and always true!
good job, welcome to workarounds club 