Query on a View

Jhstephenson

I have a couple of strange things happening when I create a Query that uses a SQL view. The Aware version is 8.8.

I have an Operation on a Record to edit/view the main record the view is based on. This works just fine. It runs a process that finds the record and brings up the main form. No Issue. That is the only Operation on Records defined.

But, if I click on the line for a record anywhere, other than the icon for the operation, it brings up the default form for the view record. I don't have any default operations defined in Operations on Records.

Any ideas?

After selecting a record to view it displays the record in a popup window. When I close that window the headings for my query disappear.

Any thoughts on that?

Thanks,
Jim

Jaymer

Jhstephenson When I close that window the headings for my query disappear.

Jim
Are you sure they disappear, or did the form just scroll down a bit and you can't seem to scroll back up to see the headings. I've had this happen - but not tracked it down.
Since you cannot scroll UP, try and click on anything towards the top and then SHIFT-TAB a bunch to move the cursor backwards. It may go to a higher field, heading, filter box, tab name, etc. and scroll the headings back into view.

Not saying thats a customer solution, but would def. give a clue to Vlad.

aware_support

What SQL View are you talking about? Is it an externally persisted object that shows a database view?

Jhstephenson

Yes

aware_support

When you click on the line the default operation on record is executed. On the list of operations on records you can mark one operation as a default one. Please check out what you have there

Jhstephenson

The only operation on record is to run a process that opens a different form and it is not marked as a default

aware_support

Very strange. Can you send your BSV with the description how to reproduce the problem in this BSV?

Jhstephenson

I was actually able to get around it by adding another operation that does the same thing as the one already on the Operations with Records. I unchecked the Display operation name on the button and Display image on the button fields and now it at least opens the correct form.

I didn't want to have a default option on this query, but at least it goes to the right place now.

Any thoughts on why the headings disappear?

Jhstephenson

I tried that Jaymer, nothing changed.

As the heading says, this query displays what are called PASS Reports, by Location, Department, and then Employee. With an option to view an individual report for a selected employee. Here is a series of screen prints of what I see...

The query when it first comes up:
I select a location:
I select a Department:
I select an Employee:
Their PASS Report comes up as a popup window. As you can see the headings have disappeared behind the popup window.
I close the popup window:

Jaymer

Hard to tell without having access to the browser.
I agree they “disappeared “… Or to say another way “they’re not visible”.
Either scrolled off the screen, or the display was set to none.
I don’t think the HTML was removed from the page source.
Would have to see it live on a browser and I could take a look at that for you if you’d like. Just need to Login from here.

Jhstephenson

Just give me a call sometime and I can tell you how to take a look at it.