Forms 4.5 question

[Quoted] I want to display something like "record 1 of 336" immediately after a query. I searched everything I could think of to find some sort of system variable that already has the last record number, but couldn't find anything. So, I came up with two possible solutions. First, to use create a dynamic query by concatenating "select count(*)" with the rest of the query that Forms just executed, using Forms_DDL. Since that won't return a value, I know I have to use a stored procedure. Unfortunately, right now I don't have permission to create a procedure. (I'm working on that.) So, that leaves me with my second idea, which is to go to the last record, store that record number in a variable, and then go to the first record. This can be PAINFULLY slow, so I'm looking for other solutions. I keep thinking that it shouldn't be this complicated... does anyone have other suggestions? Did I miss some helpful system variable? Has anyone used Forms_DDL with a procedure, and was it fast?

Thanks,
Carol Chandler Received on Wed Jul 16 1997 - 00:00:00 CEST