Search:

Type: Posts; User: Garret Mott

Page 1 of 80 1 2 3 4

Search: Search took 0.11 seconds.

  1. Re: Export PDF DR7 reports with a given name (client side)

    I've seen far worse code! :)
  2. Re: Export PDF DR7 reports with a given name (client side)

    You're welcome - though please remember my code is Windows, not web. What I have is this:



    Set Output_Device_Mode to PRINT_TO_FILE
    Set peOutputDestination of...
  3. Re: Export PDF DR7 reports with a given name (client side)

    I believe it's the same whether Windows or Web:

    Set psExportFileName of oReport to sFileName //File Filename with what you need.
  4. Replies
    19
    Views
    664

    Re: Exporting 1 Million Records very slow

    I too was going to suggest a tight loop like Evertjan's code.

    Another possibility (completely untested) would be to fill an array from embedded SQL & then write out the array.
  5. Re: Migration from DB2 to Mysql - loss of performance

    MySQl has many tweaks available. Most all are done through My.ini, but it's something of a black art.

    Unfortunately, MySQL is mostly used for small DBs and the issues we find in a big one (the...
  6. Re: Detect capslock enabled in a password cwebform

    I didn't - sorry!
  7. Re: Detect capslock enabled in a password cwebform

    Procedure OnTimer Integer wParam Integer lParam
    Date dDate
    String sHour sMin sTime sTimeCheck sLoginHour
    Integer iHour iMin iShift
    Boolean...
  8. Replies
    6
    Views
    324

    Re: Chilkat - Help

    I save all "emails" to a table, then have a standalone DF service that reads the records & sends using Chilkat. When one client using it does invoicing , it sends out thousands of emails with the...
  9. Replies
    6
    Views
    284

    Re: Refresh All Tables

    Might be something a bit more pungent than "rascal'.... :)

    There's your drawback to SDI. With MDI, it's one compile.
  10. Replies
    8
    Views
    382

    Re: MySQL Temp Table gotcha

    That or "this is what happens when you state something you shoulda known". :)
  11. Replies
    6
    Views
    284

    Re: Refresh All Tables

    Can't do that if you're not on the DAW driver...

    I've been in a situation over the last 6 months of restoring old Backups every few weeks that are guaranteed to have missing columns, so I've had...
  12. Replies
    8
    Views
    382

    Re: MySQL Temp Table gotcha

    Thanks to both of you. Learn every day!
  13. Replies
    6
    Views
    284

    Refresh All Tables

    Hi -

    This may not be the right section of the forum, but I'm hoping Stephen will sigh & move it if so.

    It'd be nice to have a Refresh All button in the table explorer. Why?

    I often have to...
  14. Replies
    8
    Views
    382

    Re: MySQL Temp Table gotcha

    Probably could. 00000000.00 worked, so I went with it. I was just surprised by the result with 0.
  15. Replies
    8
    Views
    382

    MySQL Temp Table gotcha

    Hi -

    This has nothing to do with drivers or DF - simply MySQL.

    I had code similar to the following in a stored procedure (simplified here):


    CREATE TEMPORARY TABLE tmp_Totals
    ...
  16. Replies
    11
    Views
    520

    Re: OnRelationalPromptListError

    I understand why you are using a lookup. What I was trying to explain was that you only put the prompt_callback code in the view where it's not related. In a view where it is related, don;t add it.
  17. Replies
    11
    Views
    520

    Re: OnRelationalPromptListError

    It wasn't clear to me exactly how you are using the prompt_callback. It should only be used when you are using it as a non-relational lookup. So - in the view where you have the relationship don't...
  18. Replies
    10
    Views
    650

    Re: MSSQLDRV Numeric precision

    MS SQL Server allows up to 38. MySQL can go higher, depending on the number of places to the left of the decimal. DB2 allows 31.

    IMO, if DAW is serious about using SQL backends, more than 8...
  19. Replies
    19
    Views
    717

    Re: Can't load DLL DFBTRDRV

    I hope you realize how that post could be interpreted if this weren't a programmer's forum.... ;)
  20. Replies
    10
    Views
    656

    Re: MS Linedraw

    PC-Write was shareware - but I did beta testing for them & contributed $. That meant I could give a copy of it to everyone who bought a system. Worked out well.
  21. Replies
    1
    Views
    321

    HTTP Request Failed

    Hello -

    DF 19.0

    A customer is switching to Avalara for sales tax calcs & requires JSON web services. It's all working 99% smoothly, but users will occasionally get the HTTP Request Failed...
  22. Replies
    10
    Views
    656

    Re: MS Linedraw

    Ha - I just (literally just got back from the dump) threw out my 5.25 floppies & manual for PC_Write - what I used back in 2.3 days. It had a great line draw feature where (IIRC) you could hold down...
  23. Replies
    11
    Views
    467

    Re: POS User interfaces

    Good point Dan. I coulda phrased that better. WinPrint is certainly more work than a WYSIWYG reporting tool - but in this instance it was indeed the right tool for the job. An 8.5x11 20 line...
  24. Replies
    11
    Views
    467

    Re: POS User interfaces

    I have a manufacturing customer who makes reamers - a tool used in machining to make a drilled hole smooth & accurate (think engine blacks & the like). Do not google "reamers"...........

    @ the...
  25. Thread: Query Tool

    by Garret Mott
    Replies
    20
    Views
    1,064

    Re: Query Tool

    Now if I'd suggested that, Bob would reply "Thanks for volunteering to do it Garret!"

    :)
Results 1 to 25 of 2000
Page 1 of 80 1 2 3 4