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 Wanet Telecoms Ltd 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

    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.
  2. 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?
  3. 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...
  4. 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!
  5. 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...
  6. dylim

    List Out Missing Numbers of a Number Range

    Ah yes. Been to Doug Hennigs', Rick Strahl's and Mike Lewis'.
  7. 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...
  8. dylim

    List Out Missing Numbers of a Number Range

    Chriss, This is a treasure trove! Thanks bro! Dennis
  9. dylim

    List Out Missing Numbers of a Number Range

    Chriss, Will try this out sir. So basically, it is using "old-fashioned VFP commands" vs "SQL commands". Thanks as always.
  10. dylim

    List Out Missing Numbers of a Number Range

    Hi Joe, Agree with you on this in that a permanent table will be provide for a faster and snappier operation. However, this will be an ad hoc type of query, wherein the management checks for any missing invoices that were not posted. So basically, management will query the system for any...
  11. dylim

    List Out Missing Numbers of a Number Range

    This is confirmed Sir Tore. Code I used (thanks Tore): select nrefno+1 as missing from serial where nrefno+1 not in (select nrefno from serial ) It will detect the first "hole", it will not show if there is a second consecutive missing one. The desired query result should have been 4, 8, 10...
  12. dylim

    List Out Missing Numbers of a Number Range

    This is cool. Will check this out too. Thanks Tore!
  13. dylim

    List Out Missing Numbers of a Number Range

    Hi Mark, SELECT * FROM csrAllValues WHERE iValue NOT in (Select iValue FROM csrValues) ORDER BY 1 INTO CURSOR csrMissingValues So, basically, create a cursor for "all values" (csrAllValues), then check against csrValues. Nice! Thanks you sir! Will compare the LOOP / LOCATE algo against this...
  14. dylim

    List Out Missing Numbers of a Number Range

    Hi Guys, Me again. I need to show the user which invoice numbers are missing given a number range. Suppose the following: Actual Invoice Numbers: 1,2,3,4,5,8,9,11,12,13,15 (each of these numbers are in their respective invoice records) Number Range: 1 to 15...
  15. dylim

    Variables: NULL vs RELEASE

    What ill effect will it have if one just RELEASEs it without setting it to NULL first?
  16. dylim

    Variables: NULL vs RELEASE

    Hi Experts, It's me once again. I have a business object that opens certain cursoradapter (CA) objects. For example, boCustomer will open the Customer CA object and the Salesman CA object. oCustomer = NEWOBJECT( "boCustomer" ) && the Init does the creating of cursoradapters Customer and...
  17. dylim

    Reading MySQL 8 encoded data into VFP9

    if he makes replies like how he does, I am sorry, but he is definitely not contributing to the un-aging of VFP:.
  18. dylim

    Reading MySQL 8 encoded data into VFP9

    Steve, IMHO, maybe, I guess it's a difference of upbringing/culture/value sets? No judgement here okay? I was tolerant at his hubris and inconsiderate remarks. And in your words, I simply "tolerated". When I read GGUEROS's reply to Chris's brash comments, I simply seconded the same...
  19. dylim

    Reading MySQL 8 encoded data into VFP9

    Welcome to the club GGUERA! And for a while I thought, it was just me. People who really want to help should be kind as well. Not brash, insulting, and full of hubris. Cheers! Romans 12:16: "Be alike affected to each other: not aiming at high things, but accommodating yourselves to...
  20. dylim

    SQL Command to Show Monthly Sales Including Months with Zero Sales

    Well, that is why I stated or expressed apologies for my ignorance. Once again, my sincerest apologies if your mental stratosphere is beyond mine.

Part and Inventory Search

Back
Top