How do you get Total Records count in an Xbasic function?

[kingcarol]

I need to write an Xbasic function that checks whether there are any records displayed in a grid (both before or after a search). If no records are displayed, I need to exit the function so that it will not cause an error. Does anyone know how I would get the Total Records value into an Xbasic function?

[kingcarol]

Re: How do you get Total Records count in an Xbasic function?

I cannot believe that I have spent all day trying to accomplish this when I know it must be a simple thing that I'm overlooking. I have put Total Records, Count Records, Record Count, etc., etc., into message board and Wiki search and still don't have a clue. I have tried to study the Xbasic that is generated that shows the Total Records on a grid in order to try to figure it out. But, I am now tempted to throw my computer out the window.....

[frankbicknell]

Re: How do you get Total Records count in an Xbasic function?

Carol,

It should be easy but I spent a lot of time trying to figure out how to put the total record count in the navigation bar. If you have a search part, in the AfterSearch event you can use Args.Info.TotalRecords parameter. I then assigned it to an Args.rtc.variable that i could use in other events. I think you can get it in javascript also and you could pass it to an ajaxcallback. A lot of work for something that seems like it should be easy to do.

PS if you throw your computer out the window make sure nobody is standing underneath.

[madtowng]

Re: How do you get Total Records count in an Xbasic function?

This would be my thought.
TABLECOUNT()
Syntax
Number_Of_Records as N = TABLECOUNT( Lookup_Table as C, Filter as C )

[kingcarol]

Re: How do you get Total Records count in an Xbasic function?

I think that TABLECOUNT is for counting records in a table, not the current grid after searching or filtering, but I could be wrong. There is a parameter in AfterSearchSubmit client side event called recordsInQuery that I may be able to use to grab the count and send it into the Xbasic function. It's late and I haven't tried it, and I'm wondering if it will work after a QBE search, which, BTW, the afterQBESearch event does NOT have a parameter for the recordsInQuery. I'm tired after a day of this, so will try in morning and report back. It DOES seem like there should be a simple way to do this... I think I'll have to do all these steps just to deal with this... 1 - when grid opens, do a lookup for the query the grid is based on to get the count. 2 - after a search, do a javascript something to get count and send it into Xbasic function. 3 - after a QBE search, do something (what???) to get the count. 3 - after checkboxes are filtered, so something (what???) to get the count. So, HOW DOES ALPHA GET THE {TOTAL_RECORDS} count that shows at the top of the grid anyway???? Should not be such a mystery.

[madtowng]

Re: How do you get Total Records count in an Xbasic function?

I use <%a5 ? tablecount("c:\warehousing\new-ins.dbf","convert_type(mytimestamp,'D')=date()")+" inbound transactions" %> to show how many inbound transactions were entered for today.

If that doesn't work for you, I did find this note in the AfterSearch Event : 'aa[].text = "alert('Search done. Records found: " + args.info.totalRecords+"');".

[Selwyn Rabins]

Re: How do you get Total Records count in an Xbasic function?

I need to write an Xbasic function that checks whether there are any records displayed in a grid (both before or after a search). If no records are displayed, I need to exit the function so that it will not cause an error. Does anyone know how I would get the Total Records value into an Xbasic function?

It is very hard to answer this question as phrased, because you don't give any context. How is this Xbasic function invoked?

The most common way in which user defined Xbasic function are called is when a button on a grid is clicked, or some other event fires, that invokes the Grid Object's ajax callback method and the callback specifies the name of the xbasic function that will be invoked on the server to handle the callback.

I'll therefore presume that that's what you mean.

When a Grid is executed, (either the initial load, or when any type of search, or page navigation is done), the server obviously knows how many records are in the Grid and it sends that information back to the browser where it is stored in the Grid Object. This mean that any Javascript code you execute can find out how many records are in the current query by reading the value of the {grid.object}._rowsInGrid property.

When any callback is made to the server, the information is sent back to the server. It is in the __si (short for state info) object that you will see as part of every callback.

So, to get to the point:

If you put a debug(1) into your Xbasic function that handles an ajax callback, then run the Grid in Working Preview, then click the button that does the callback, the debugger will open, and you will be able to see that the 'e' object has an e.__si object and inside that you will see:


e.__si.RecordCount

which has a count of the current number of records in the grid query.

[kingcarol]

Re: How do you get Total Records count in an Xbasic function?

Thank you, Selwyn. I did do the Working Preview and debug yesterday to search for an e object that had something to do with Record Count, but didn't dig deep enough into the layers of the e object. Now I know to dig down farther.

I was busy trying to get the count of the records in a grid because I wanted to prevent the Xbasic behind an Action Button from firing if there were no records in the grid. This morning I finally stumbled on another thread that showed the solution for hiding an Action button if there are no records in that grid, and that takes care of my issue. The solution is to put grid.logicalRecordNumber > 0 in the Client Side Show/Hide Expression on the Action Button Editor. Here's a short video of it working: http://screencast.com/t/7MiGq8nT6z

[frankbicknell]

Re: How do you get Total Records count in an Xbasic function?

Thank you Selwyn, I have been searching for that for a long time,

[Selwyn Rabins]

Re: How do you get Total Records count in an Xbasic function?

please remember that there is a wealth of information that is in the e object that is passed into the xbasic function that handles the callback. using the xbasic debugger to explore what's in e is a great way to find out what's there.

similarly, using Firebug to see what gets posted back to the server on a callback is another great way to figure out stuff.

The combination of the xbasic debugger (when you are in working preview mode) and Firebug, are two invaluable tools for web developers.

[Peter.Greulich]

Re: How do you get Total Records count in an Xbasic function?

Yup, we love the xbasic debugger.

[frankbicknell]

Re: How do you get Total Records count in an Xbasic function?

Thank you, I am aware of those tools. Firebug has helped me figure out so many puzzles. I was speaking directly to the e.__si object. I looked through what I thought was all of the nooks and crannies of the e object in the debugger and somehow missed that one.

[kingcarol]

Re: How do you get Total Records count in an Xbasic function?

Wish List - An alphapedia page that lists all the things in the e object, what they capture, and examples of using them in Xbasic code. It would have been wonderful to come across the e.__si.RecordCount by doing a search for record count in the Alphapedia. If there was a page that had a list with e.__si.RecordCount in it, and a description that had the words record count in it, I would have found it quickly. The way it is now we don't know if it's something that might be in the e object or not, then we have to do a debug, then we have to click and expand a ton of stuff just hoping that we find it somewhere amongst abbreviations like si that we're not sure about.

[Peter.Greulich]

Re: How do you get Total Records count in an Xbasic function?

Wish List - An alphapedia page that lists all the things in the e object, what they capture, and examples of using them in Xbasic code. It would have been wonderful to come across the e.__si.RecordCount by doing a search for record count in the Alphapedia. If there was a page that had a list with e.__si.RecordCount in it, and a description that had the words record count in it, I would have found it quickly. The way it is now we don't know if it's something that might be in the e object or not, then we have to do a debug, then we have to click and expand a ton of stuff just hoping that we find it somewhere amongst abbreviations like si that we're not sure about.

Yes. This chimes in nicely with 1 or 2 other posts about the damn WiKi.

http://msgboard.alphasoftware.com/al...010#post587010


http://msgboard.alphasoftware.com/al...014#post587014

[Fulltimer]

Re: How do you get Total Records count in an Xbasic function?

I've been trying to find a solution to return the Total Records in a grid query using Xbasic and I've come across the thread. I want to use it in the OnSQLCountQuery event because I want to add a new record if the grid is blank ( no records ).

I found the e.__si.RecordCount method ( or property!!!! ) that seems to have been accepted as the solution. It however
does not work for me. In fact, the runtime tells me that this is not a real property. Worst yet is there is NO AUTO COMPLETE to help me determine what methods or properties ARE available.

Please help with my two issues:

*Why doesn't the e.__si.RecordCount work?

*Why does Auto Complete (ie. intellisense) not exist in ALL areas where you can type in Xbasic code?