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: *

  • Users: dylim
  • Order by date
  1. dylim

    Strange MariaDB behavior with Sequential GUIDs

    Well, for MariaDB, from hereon out, I will use "ORDER BY id" then. Again, kinda weird, coz MySQL has always shown the resulting rows already arranged. Thanks!
  2. dylim

    Strange MariaDB behavior with Sequential GUIDs

    Well, for MariaDB, from hereon out, I will use "ORDER BY id" then. Again, kinda weird, coz MySQL has always shown the resulting rows already arranged. Thanks!
  3. dylim

    Strange MariaDB behavior with Sequential GUIDs

    I use InnoDb, not MyISAM, because I need transactions. And yes, the ID field is the primary key.
  4. dylim

    Strange MariaDB behavior with Sequential GUIDs

    The reason I used sequential GUIDs is just to make sure they are ordered in the "natural order" of entry of the invoice details (child) rows. This has worked for me ever since I used MySQL, as a "workaround" to our VFP table record number.
  5. dylim

    Strange MariaDB behavior with Sequential GUIDs

    This is really strange. Ever since I have used MySQL, I have never used "ORDER BY id" to make sure they are in the 'natural' sequential order. No worries though. I will explicitly put "ORDER BY id" from hereon out since I am now with MariaDB. Thanks.
  6. dylim

    Strange MariaDB behavior with Sequential GUIDs

    Kindly check my reply to mJindrova. I have been using MySQL and it always shows the records sequentially - by the sequential GUID - without the need to put "ORDER BY id". It is only when I migrated to MariaDB recently that I noticed this behavior. If this really is the default behavior, then no...
  7. dylim

    Strange MariaDB behavior with Sequential GUIDs

    Hi, If you execute the same using MySQL, it orders it sequentially with out adding an "ORDER BY id". Strangely though, if you: select * from SODTL without any WHERE clause, it will arrange it "correctly" - sequentially. Only when you place a WHERE clause will it show the rows in reverse order.
  8. dylim

    Strange MariaDB behavior with Sequential GUIDs

    Hi Guys, I use sequential GUIDs for both my Invoice header and detail tables. Ever since I moved to MariaDb, it was only now that I noticed that if I do a select of the invoice detail rows of a particular header row, MariaDB shows the rows in REVERSE order! I have to explicitly add a "ORDER BY...
  9. dylim

    Using cursor adaptor to update blob data in MySQL

    Hi DDPL, Check out FILETOSTR() function. Also STRTOFILE(). You need them for Blobs.
  10. dylim

    Window displaying differently outside VFP environment

    SitesMasstec, What is the SCALE value in Windows Display Settings?
  11. dylim

    png file not displaying in image control

    Hi ravicoder, Is the image control Visible set to True? Or maybe is the Image control "on top" or "under" some other control?
  12. dylim

    ChilkatVFP 1.50 Released Last Week

    Bill, Hi. I am the same guy who asked you about whether you have Youtube video tutorials on your creation on Facebook or not. Perhaps you can guide me and maybe I can create them Youtube videos to help propagate your creation sir? Cheers!
  13. dylim

    How to supply filename when doing SET PRINTER TO NAME "Microsoft Print to PDF"

    Chriss, Have you been using Thor for the longest time sir?
  14. dylim

    How to supply filename when doing SET PRINTER TO NAME "Microsoft Print to PDF"

    Hi, What does Thor help us in development sir? Have heard of Thor for the longest time, but never had the change to tinker with it.
  15. dylim

    How to supply filename when doing SET PRINTER TO NAME "Microsoft Print to PDF"

    This is great! I do not need to wander farther. One more question though. Can one control or customize the dimensions of a PDF file?
  16. dylim

    How to supply filename when doing SET PRINTER TO NAME "Microsoft Print to PDF"

    Hi EinTerraner, SET PRINTER TO <PDfCreator> REPORT FORM <YourOutputName> TO PRINTER <YourOutputName> is the name of the .FRX (report form), right? Suppose I need for the name of generated PDF to be "Customer 0009 - Receipt.pdf", where shall specify this in order for the PDF to be created with...
  17. dylim

    How to supply filename when doing SET PRINTER TO NAME "Microsoft Print to PDF"

    Hi Joe, I do use FoxyPreviewer, albeit the free version. I didn't know that it can output to a PDF. I thought it was a better REPORT FORM PREVIEW interface. Perhaps you can provide me a few snippets to start off? Thanks!
  18. dylim

    How to supply filename when doing SET PRINTER TO NAME "Microsoft Print to PDF"

    Hi Experts, Am trying to the do the following: Print to a PDF from a REPORT FORM (a receipt), then email this generated PDF file as an attachment to a customer's email address. My questions: 1. Can I do a SET PRINTER TO NAME "Microsoft Print to PDF" before running REPORT FORM TO PRINT? 2...
  19. dylim

    List Out Missing Numbers of a Number Range

    Ah yes. Been to Doug Hennigs', Rick Strahl's and Mike Lewis'.
  20. dylim

    List Out Missing Numbers of a Number Range

    Well, it is now MariaDB technically. *wink* *wink* Where do you get stuff from these legends sir? I have seen a few from them, like during the days when universalthread.com existed. (It is now levelextreme, right? It seems though that it is not so much active for VFP posts anymore. I may be...

Part and Inventory Search

Back
Top