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!

  • Congratulations SkipVought 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: *

  1. TamarGranor

    FoxPro button status

    I don't think you can check the enabled status of a control in FoxPro 2.6. That said, I haven't had to write FP2.6 code for 25 years or so, so maybe I've just forgotten. Tamar
  2. TamarGranor

    Help with visual foxpro pageframe

    The point is that it's the user's computer and the user should be able to control that stuff. Most essentially, when a user has some visual impairment (including color blindness, which is pretty common), they MUST be able to override the programmer's choices, or the application may be unusable...
  3. TamarGranor

    Create a table with Tag indexes

    I do NOT recommend using separate IDX files to keep the CDX small. IDXs are not updated when you modify the data unless you explicitly open them beforehand. The addition of the CDX (in FoxPro 2.0, I think) was a great change, as it reduced the chance of indexes getting out of sync dramatically...
  4. TamarGranor

    Does a Report use the available cursor?

    I just want to point out that you should not use a macro in this query. A name expression is faster and, more importantly, works even if the file name/path contains any spaces. (I know that's not an issue the way you're doing it, but make it a habit to use name expressions rather than macros...
  5. TamarGranor

    Convert Foxpro Memory Variable to a DBF

    Chris had a small typo in one of his links. It should be https://github.com/VFPX/nfJson. I think you'll find that tool lets you convert JSON to a cursor very easily. Tamar
  6. TamarGranor

    Flagging Help topics as favorites

    Thanks, Mike. I guess I knew that was there, but never thought about using it. Just added your first three, which are all topics I visit often. Tamar
  7. TamarGranor

    using external classes - vcx file

    I cannot urge everyone strongly enough to use the Toolbox rather than the Form Controls toolbar. It makes all this stuff so much easier. I wrote about it here: http://tomorrowssolutionsllc.com/ConferenceSessions/Making%20the%20Most%20of%20the%20Toolbox.pdf and here...
  8. TamarGranor

    How to get contents of notepad file?

    I just want to add to Chriss's detailed answer that anytime you want to break up something that's regular, try ALINES() first. So, for example, if you have a line of data separated by commas, use ALINES() and specify "," as the separator. There are times you need StrExtract() because you're...
  9. TamarGranor

    Container on a Form

    Just want to add that putting controls inside containers is way easier if you use the Toolbox instead of the toolbar. (In my view, pretty much everything about constructing forms is easier with the Toolbox.) I've written about this...
  10. TamarGranor

    Automatically append last value + 1 into the textbox

    Filip, your mentor is wrong here. If there is any possibility that more than one person will be using this application at the same time, finding the largest value and incrementing it is dangerous, because two people could do that at the same time, and you'd end up with two records with the same...
  11. TamarGranor

    How to get contents of notepad file?

    Beyond the unexpected behavior with GetWordCount()/GetWordNum(), ALINES() is faster. It doesn't matter much when the data is small, but the larger the string you pass, the larger the difference. ALINES() is simply wickedly fast, regardless of what you hand it, while pretty much every other way...
  12. TamarGranor

    Find all files used in compilation

    Just want to go back to your original question. I've written a little set of tools for playing with what's in a project and it has the ability to tell you what files in your folder structure aren't part of the project. I've written about it a couple of times; one that includes the code for...
  13. TamarGranor

    concate on field vfp

    You can't do this with just SQL in VFP. It doesn't have a way to consolidate that data. So you'll need to run the query and then use some Xbase code to loop through and consolidate. I wrote about that here...
  14. TamarGranor

    Generating graphs using excel automation

    Assuming you're talking about using automation from VFP to create a chart in Excel, check out Excel's AddChart method: https://learn.microsoft.com/en-us/office/vba/api/project.shapes.addchart Tamar
  15. TamarGranor

    update value dbo sql using vfp 8

    What is curReplications? Is that a local table/cursor in VFP or something on the server? You can't use a VFP table or cursor in a query you're sending to the server. Tamar
  16. TamarGranor

    INDEX versus TAG

    Thanks for the feedback, @SitesMasstec. I just took a quick look and I see that in introducing concepts early in the paper, I failed to make the point that VFP doesn't require a DBC for you to still consider your set of tables to be a database or that almost everything in the paper applies to...
  17. TamarGranor

    INDEX versus TAG

    Looks like the others have all sorted out your questions. I am curious what I wrote that misled you to think that CDXs were only for tables in databases (so I can say it more clearly the next time, or even fix the paper, if that's appropriate). Tamar
  18. TamarGranor

    INDEX versus TAG

    As I told a client last week, I haven't used an IDX file since we got CDXs in FoxPro 2.0. If you're in a position to replace all those IDX files with a single structural CDX ("structural" means it has the same name as the table, and opens automatically when the table does), then absolutely...
  19. TamarGranor

    Sorting the object list of a form by its objects.

    Ilya - as I understand Klaus's problem, it's not about tab order, but about the order things appear in the property sheet and method editor. Tamar
  20. TamarGranor

    How do I get the column number of a cell in a foxpro grid Visually?

    The key is to use something other than the base textbox class. Put the code in the class and use that class in each column and you have what you need. Tamar

Part and Inventory Search

Back
Top