Announcement

Collapse
No announcement yet.

cannot view sql query when there is an error in the query build

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • cannot view sql query when there is an error in the query build

    In a control app I need to insert into another table and update another table. So in the events OnValidateSuccess I'm using the SC fonction provided to build the insert and update sql query.

    I've an error in my query and when I run the app a popup windows appear to tell me there is an error which is fine.
    the problem is that I cannot see my query to find out what is the error. In the popup windows there is a link (last line) to see the query but it do not work. I should be able to see my query or I'm gonna use my own way to build the query (not using the provided macro in the event). But I don't know why the link provided to see the query is not working. It would be very usefull to be able to see the query for debugging purpose.

    see the screen capture, last line should be a link to display my query
    Attached Files

  • #2
    Hello claude,

    Please activate debug mode on application --> settings. By doing so, you will be able to see the query SC performed on your RDBMS.

    regards,
    Bernhard Bernsmann

    Comment

    Working...
    X