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 derfloh 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. C

    Cursor in Data Environment

    That's true. Though a) SitesMasstec explicitly asked for a cursor and b) in the DE. Of course nothing speaks against suggesting something better than what's asked for. He's free to pick up what he thinks works best for him.
  2. C

    Cursor in Data Environment

    2) Making a parameter a form property. Fine, how do you set the form property before even starting the form? Remember a view used in a DE will even be used/queried before the init of the form. So you have to use private variables. Not a foeign concept to legacy fox developers, not even against...
  3. C

    Cursor in Data Environment

    I'll even give you some arguments against my argumentation: 1. There are thousands of error messages about anything and that's no reason to not use VFP 2. You always start with something sometimes. And lurking problems may not ever become real. 3. It would make sense to have an overview of all...
  4. C

    Cursor in Data Environment

    Should I point out a list of problems you can have with views (and all solve with experience) that will each pose a problem to SitessMasstec simply based on how I know his forum history, alone? 1. Views first need a DBC. Already have one? Fine. Better use a separate for views, because views...
  5. C

    setting focus on EXE run

    You can't have controls without any taborder, I wonder how it was to not work, if taborder fixed it. Because even if the textbox has taborder 2 and a label before it has taborder 1 the focus will go to the textbox, as a label can't have focus. Tore hit the reason for your second problem, you...
  6. C

    Bar Code Printing in Micro Size on Label

    Steve, labels are in fact quite the same as reports, just with lbx file extension and by default a format that fits label sheets. with several columns and rows. The designer designs one label of a sheet only. Many use endless paper labels instead of sheets when it comes to mass label printing...
  7. C

    How to interactively change control source of a grid at runtime?

    This is going slightly off topic now about the DE. Sorry, Rif59. To get back to the grid control: 1. When at runtime an alias/workarea of a tablename the grid is set to is changed by the code CD newdir SELECT tablename && select the workarea still using the table of the previous directory USE...
  8. C

    Cursor in Data Environment

    The data environment can contain: 1. Tables 2. Views 3. Cursoradapters So the direct answer is no. You can create a view that queries the data, you can create a cursoradapter that queries the data, but I doubt you'd want that, as it has much overhead and not just the query. Instead, just write...
  9. C

    setting focus on EXE run

    Usually you only set the taboder of the element you want to have focus first to 1 and that's it. Is the focus nowhere on the form? Then something is strange about the EXE as the primary form and it's primary control (with taborder 1) should be focused, also the main form of an EXE itself is...
  10. C

    How to interactively change control source of a grid at runtime?

    Regarding your general idea of having a directory per store. Well, it won't solve the question you have per title, changing directory the grid won't change to the same table name in that other directory, just because you changed directory. Next time you start a form that does USE some.dbf after...
  11. C

    How to interactively change control source of a grid at runtime?

    SET DEFAULT or CD (change directory) is what you use to set the directory FoxPro first looks into for tables, for example. I see many legacy developers prefer SET DEFAULT, but CD actually does the same and simply resembles what you may know from DOS, just like MKDIR does. SET PATH is like...
  12. C

    Slow excel

    You might speed this up a little simply by starting an Excel.Application or at least an Excle.Sheet object with application start. Later when you let an olebound control render an Excel chart (which the olebound control delegates to an Excel OLE server doing that) it would not necessarily use...
  13. C

    Slow excel

    Follow up on Pauls advice: When the freezing occurs within the Excel process involved in this (and yes, it will be when you append an excel file into a general field and display that in an olebound control) then the coverage might not show a line of VFP code taking long, both lines before and...
  14. C

    Strange MariaDB behavior with Sequential GUIDs

    I think overall any VFP developer is just spoiled by how simple the DBF file format organizes data in rows which have a recno() by file position. In storage engines organizing data by a clustered index and further index types not known to VFP and organizing data in heaps, trees, pages, the order...
  15. C

    Bar Code Printing in Micro Size on Label

    Preview zoomed to 300%: Screenshot of PDF viewer in 300% zoom: Same, same - except a bit of quality difference mainly in the numeric part of the barcode graphic, a bit blurry barcode lines, too. I guess this would be controllable by quality settings of the PDF conversion. I just used the...
  16. C

    Strange MariaDB behavior with Sequential GUIDs

    Even if the db would sort by id by default, you may not have the right order simply ordering by id: Imagine a simple case: You store an invoice, you have an item that is added later, after a few further invoices are stored, then you'd have a later id not in sequence. It would still be the...
  17. C

    Strange MariaDB behavior with Sequential GUIDs

    By the way: The main feature of Sequential GUIDs is not to sort data in that sequence, too. You should in general not want to sort by physical or ID order, also when using numeric IDs which are generated in a sequence/autoincrement. If you want items of invoices (or orderitems or ingredients of...
  18. C

    Strange MariaDB behavior with Sequential GUIDs

    If you query without order by, then by ANSI definition the order is undefined. Most databases still give the same reproducible order. VFP will simply give records in physical order. But not all storage of data is as simple as VFPs DBFs are with record after record in a physical order in the DBF...
  19. C

    Any idea how to deal with blank spaces?

    The thing you have to deal with here is something that's happening to you in any other database, too. Other databases, so also more modern databases, will treat char fields the same as VFP. See in MSSQL (T-SQL)...
  20. C

    Any idea how to deal with blank spaces?

    Proof of how you're wrong: Clear ? _screen.addobject("label1") _screen.label1.visible = .T. _screen.label1.caption = 'example'+'x' _screen.caption = 'example'+'x' ? 'example'+'x' ? len('example'+'x') ? ' ' $ 'example'+'x' ? Occurs(' ','example'+'x') This is what you end up with: All...

Part and Inventory Search

Back
Top