Details in a Grid using JOIN [ SOLVED ]

Applications Grid / Reports
#1

I have a Grid using JOIN, but I am getting an error to see the Details (magnifying glass).
I didn’t change anthing after create the application.

#2

Re: Details in a Grid using JOIN

Can you provide more details?

What is the error?
What is the SQL statement
Do you have the table schema

Regards,
Scott.

#3

Re: Details in a Grid using JOIN

This is happening because Scriptcase is trying to construct the WHERE clause based in the fields specified in JOIN clause.

You should access “Grid>>Details>>Settings” to select Field Keys that will be in WHERE clause.

V?tor Jamil

#4

Re: Details in a Grid using JOIN

Thanks for reply.
I will try.

#5

Re: Details in a Grid using JOIN

Thanks a lot Vitor and Scott.
It works now.