Recent content by TomBascom

  1. TomBascom

    Question Scan a table between recids.

    The "i = i + 1." in dumpbyrecid.p is also an error - I edited the post to comment that out.
  2. TomBascom

    Question Scan a table between recids.

    The sports2000 db didn't get to recids that big ;)
  3. TomBascom

    Question Scan a table between recids.

    Oops! Fixed it.
  4. TomBascom

    Question Scan a table between recids.

    Dumping by RECID is possible. There are pros & cons: PRO: useful when the db is damaged and you cannot traverse indexes useful if you want to avoid IO on indexes which might sometimes be faster CON: not exactly intuitive if the rows per block badly mismatches the data you will do lots of...
  5. TomBascom

    Question Scan a table between recids.

    Rob's questions are great too. To elaborate on my original answer: /* recid.p */ /* this part is just for giggles */ function numRows returns int64 ( input tblName as character ): define variable i as int64 no-undo. define variable b as handle no-undo. define variable q as handle...
  6. TomBascom

    Question Scan a table between recids.

    Yes. It is possible. (It’s late, and I am jammed tomorrow so it might be a day or so before I can expand on that...)
  7. TomBascom

    Remove Record from Query Buffer without delete record

    That's... um, well... on the one hand I admire it's cleverness. OTOH... it's not exactly a model of clear and obvious ;) I can see the attraction. Like a moth to the flame.
  8. TomBascom

    Remove Record from Query Buffer without delete record

    > (I must short the code of 1.000 chars..) I'd start by getting rid of the ridiculous Hungarian Notation prefix gobbledygook.
  9. TomBascom

    Question Proper way to enable SQL?

    Yes, that would be true. You could, possibly, do something like limit the 4gl connections to 40 and allow 20 SQL connections. Or you could upgrade to a less restrictive license and more connections.
  10. TomBascom

    Remove Record from Query Buffer without delete record

    A BUFFER is a pointer to a single record. It is not the result set from a QUERY. To filter your results you need to focus on writing a WHERE clause that selects the records you want. There is no post-processing to remove records from a QUERY result set. You seem to be comfortable with a...
  11. TomBascom

    Answered How to access database fast...

    So the fields are actually mstr_nbr and mstr_status? Then it should be possible to take the most recent version of the revised query, without the temp-table, and run it. And that code ought to perform quite a bit better at the task that you have shown us - namely counting up the total of...
  12. TomBascom

    Answered How to access database fast...

    This is where things are with the code I have suggested over on StackOverflow: define temp-table tt_mstr field mstr_nbr as integer /* or whatever the proper data type is */ index mstr_nbr-idx is primary unique /* I am assuming mstr_nbr is unique */ . for each mstr...
  13. TomBascom

    Answered How to access database fast...

    I'm sorry but you are making it really difficult by trickling out partial information and making apparently conflicting claims about your configuration. If your database is a Progress database you do not need QUERY-TUNING and information about SQL Server drivers is a distraction. On the other...
  14. TomBascom

    Answered How to access database fast...

    Having a driver installed doesn’t mean that you are using it.
  15. TomBascom

    Answered How to access database fast...

    On Stackoverflow you claimed it is SQL Server 6.03 (after claiming it was a Progress db). Here you are saying SQL Server 2014. Which is it?
Top