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 Chriss Miller 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

    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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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)...
  9. 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...
  10. C

    Combobox not populated with array

    That's good. If you, SitesMasstec, run that last demo from MarK, you'll be able to verify what I said. that it's eventually always the list that's holding the data a combobox shows. If you run the example and then suspend with the menu item Program->Suspend, the form will still run and you can...
  11. C

    Combobox not populated with array

    I don't find it, but I think I once even told you you could use the combox list as no matter what rowsourcetypes you use the data always ends up in the comboboxes own list anyway, no matter if you bind to a cursor, dbf, array or whatever else. And that was at a case where you struggled using...
  12. C

    Combobox not populated with array

    To point out what you should take and learn from MarKs post: 1. Use Rowsourcetype 5, array. That makes it much simpler than building up the combobox array (list) with Additem calls, just have an array as the items the combobox displays: ADD OBJECT cboBox as ComboBox WITH Top = 30, Left = 6...
  13. C

    Why does what appears to be a simple append query is pasting 5 duplicate rows?

    Well, if there are no records also in CVReferrals your original query wouldn't tell it will add 5 records. The 5 actually tells me (us) that CVReferrals has had 5 records at the time you did this. The way you did this query without any WHERE clause the number of records of CVReferrals plainly is...
  14. C

    Why does what appears to be a simple append query is pasting 5 duplicate rows?

    Why are you even selecting from CVReferrals? It seems to me you want to insert one record, that's done with a simple INSERT ... VALUES: INSERT INTO CVInsQuotes ( CVID, Company, Quote ) VALUES ([Forms]![CommercialVehicles]![CVID], 'National General', [Forms]![CommercialVehicles]![NatGen]) When...
  15. C

    Strange error

    Well, I have to move back a bit from that, as even CLEAR ALL EXTENDED does not remove anything from SET('LIBRARY'). Anyway, CLEAR ALL is a repair tool when you're in an IDE that crashed from an error, it can do more harm than good, though, after an IDE restart. Even when CLEAR ALL helps instead...
  16. C

    Strange error

    Looking for references of any routines, methods, functions called ReadInt and WriteInt I find they are contained in Christian Ehlscheidts vfp2c32 FLL. If SET('LIBRARY') does not contain that FLL you'll get this error, as VFP won't know from code calling these FLL functions whether they are FLL...
  17. C

    cloud storage privacy concerns

    Perhaps to guide the discussion a bit. I'd like to hear from anyone interested to share thoughts: 1. How much do you trust / distrust cloud providers? I would also ask for the governments, but we don't need to get into political views here, just mainly the question would you fear your code or...
  18. C

    cloud storage privacy concerns

    As I said, there's a similar thing in WMI, too, but I'd want to do one single script file doing the watching, staging and encryption in one place and for that would abandon VFP alltogether. For such a taks VFP will always become glue code only , that brings together other component, which...
  19. C

    cloud storage privacy concerns

    In https://powershell.one/tricks/filesystem/filesystemwatcher me and Steve Meyerson had a short exchange on cloud storage privacy in the context of using a cloud for version control of projects. At one I said I do backup a folder tek-tips for most things I maintain tek-tips related: (costs...
  20. C

    COPY FILE in an Exe

    Okay, still the perfect solution for backing up a project right after build is the project hook AfterBuild event, not putting it into the EXE just because you use the "Run after build" option. The BeforeBuild may even be better, as it could save the state in case the build itself goes wrong and...

Part and Inventory Search

Back
Top