Query does NOT refresh if there are no existing records

If you think that something doesn't work in Aware IM post your message here
Post Reply
BLOMASKY
Posts: 1471
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Query does NOT refresh if there are no existing records

Post by BLOMASKY »

I have a query on a vp with no records. I have a panel operation button to create a record, which will open a popup form, and allow the user to create a new record. After it is saved, there is NO refresh. The record is NOT displayed in the query. However, if there is an existing record, and I do the same thing, to add a shiny new record, then the Auto refresh works fine.

Bruce
customaware
Posts: 2399
Joined: Mon Jul 02, 2012 12:24 am
Location: Ulaanbaatar, Mongolia

Re: Query does NOT refresh if there are no existing records

Post by customaware »

Have you set the refresh conditions on the Query as well as the panel?
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Query does NOT refresh if there are no existing records

Post by tford »

Seems to work fine in this BSV, Bruce:
AddMe.zip
(34.39 KiB) Downloaded 544 times
Tom - V8.8 build 3137 - MySql / PostGres
Jaymer
Posts: 2449
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Query does NOT refresh if there are no existing records

Post by Jaymer »

i had this behavior over a month ago.
exactly as you describe.
only happens the first time - after that 1st rec is created.
after that, looks normal.
was latest V8 at the time
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
BLOMASKY
Posts: 1471
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Query does NOT refresh if there are no existing records

Post by BLOMASKY »

Yes, I have auto-refresh on the query. (If the panel is displaying a query there is NO option for autorefresh in the panel cell).


and I can easily duplicate this. Tom and Mark, you are telling me you do NOT have this issue when you have a BO with no records? Humm, why am I getting this then?

Bruce
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Query does NOT refresh if there are no existing records

Post by tford »

Sorry about that Bruce. With grandchildren swirling around, my first BSV totally ignored your issue.

This one works to refresh the query when adding the first instance by either a menu option or a process:
AddMe2.zip
(35.13 KiB) Downloaded 509 times
Tom - V8.8 build 3137 - MySql / PostGres
Post Reply