Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jjjt
  • Order by date
  1. jjjt

    Problem copying folder using Scripting.FileSystemObject

    Makes sense. Thanks Chris.
  2. jjjt

    Problem copying folder using Scripting.FileSystemObject

    Chris, Rick, Thanks for the input - COMRETURNERROR() is exactly what I was looking for. With regards to the WinAPI, what are its relative merits in relation to the Scripting Object? I think I am right in saying that if we use the Scripting Object, the user has to have the right version...
  3. jjjt

    Problem copying folder using Scripting.FileSystemObject

    Hi, We're using VFP8 and the following code to copy a folder: oFSO = CREATEOBJECT("Scripting.FileSystemObject") oFSO.copyfolder(source, destination,.F.) and it works fine until such time as somebody is editing one of the files contained in the folder, at which point we get a "COM command...
  4. jjjt

    Why Are My Memo Files 2GB

    That's our suspicion, too. If we get anything concrete, I'll let you know.
  5. jjjt

    Why Are My Memo Files 2GB

    A PACK does reduce the size of the Memo file by a huge amount - we have a reindex and pack utility in our app, and recommend that users run it regularly, but more often than not they seem to ignore the advice. Horses and water and all that... In any event, we know now that a PACK will stop the...
  6. jjjt

    Why Are My Memo Files 2GB

    We've been experimenting and getting exactly the same results Griff has seen - carrying out a lot of edits on Memo fields drastically increases the size of the Memo file. Thanks to everybody for their help, we've learnt some stuff about memo fields...
  7. jjjt

    Is it necessary to re-index and run a PACK?

    Or does the PACK do both?
  8. jjjt

    Why Are My Memo Files 2GB

    The table we are looking at has 171,000 records and there are 13 memo fields per record, though the vast majority of them contain no data. The average size will vary depending on how the user is using the memo fields and can range from a couple of words to a page of notes - I would say that in...
  9. jjjt

    Why Are My Memo Files 2GB

    One thought - we never had this problem before we started to use v8 of VFP. Could this be it?
  10. jjjt

    Why Are My Memo Files 2GB

    These memo fields only hold text. No pictures or anything like that. This would mean over 1.5GB of "bloat" that would make it increadibly inefficient! Surely it cannot be right?
  11. jjjt

    Why Are My Memo Files 2GB

    But how can they be getting to 2GB in the first place? When I did a PACK the Memo File went from over 2GB in size to 326,436KB. I assume that the data stored in the Memo File represents 326,436KB what was the rest taken up with?
  12. jjjt

    Why Are My Memo Files 2GB

    We have a problem where at times our users experience an error saying: "There Is Not Enough Disk Space For....." The message ends with the name of a memo file. As it happens there is loads of space for the memo file over 90GB but the memo file itself is just over 2GB. The corresponding table...
  13. jjjt

    Bad Deleted Flags?

    We feel the index is correct and the table is wrong. Because browsing with SET DELETED ON does not show these rogue records but browsing with SET DELETED OFF shows them but with no deleted mark on them. We feel the records should be shown with a deleted mark against the record when browsing...
  14. jjjt

    Bad Deleted Flags?

    For example: We have a table with 10 records in, 3 are flagged for deletion (the little black mark when browsing a table). However the index reports 4 are deleted (We have an index on DELETED()) and as far as we are concerned this is correct because: 1. It is in line with what our code should...
  15. jjjt

    Update Word Cross-References Automatically

    I have used the code above and it does exactly what I need but it nearly caught me out, so I figured I'd post even though the thread's been dead for a while. I created three tables in my document and gave each a caption, 'Figure 1' to 'Figure 3'. In my text I made cross references to 'Figures...
  16. jjjt

    Confused about RECCOUNT

    Just as a point of interest, as Mike has suggested, adding NOFILTER will force VFP not to use a filter to get the results of the SELECT statement. Similarly, if you are creating a READWRITE cursor, this will preclude the use of a filter. Jake
  17. jjjt

    Confused about RECCOUNT

    The full code in the prg is: *Open table USE "O:\Data\Orderwise\Product_transaction_header.dbf" IN 0 SHARED AGAIN * Some transaction headers do not have purchase unit quantity ids. If the product is linked to a single * puq, then we can fill this in. If it is not, then we can't SELECT *; FROM...
  18. jjjt

    Confused about RECCOUNT

    Thanks, Mike, you've just answered what was going to be my next question - even more reason for the star I managed to give you before the site just crashed on me - not sure if it's a problem my end or Tek Tips'. Jake
  19. jjjt

    Confused about RECCOUNT

    No, I tried using GO BOTTOM ?RECNO() and you get the same result i.e. you get a count of all of the records in "product_transaction_header". I think that the same logic that Mike has noted will apply when using GO BOTTOM Jake
  20. jjjt

    Confused about RECCOUNT

    Hi, I have written a small prg using Fox 7 where I use the following SELECT statement: SELECT *; FROM product_transaction_header; WHERE product_transaction_header.pth_unit_qty_id = 0; INTO CURSOR cur_trans_w_out_puq I then do RECCOUNT("cur_trans_w_out_puq") to find out how many records...

Part and Inventory Search

Back
Top