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 Mike Lewis 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. Steve Yu

    SetFocus not working

    What about popping up a message to get user's attention, then return to the date field after user acknowledgement ? This is better than simply blocking the cursor movement with a red hi-lite, IMHO.
  2. Steve Yu

    oAuth 2 protocol, Microsoft Azure cloud services

    Great insight, Chris. Have been using West Wind's class library for all our API integration projects (XML,JSON decoding included); but this one seems more complicated. That may be the situation we have here. Instead of client secret (since we don't have control over the account, it'd be hard...
  3. Steve Yu

    oAuth 2 protocol, Microsoft Azure cloud services

    Can you provide an example ?
  4. Steve Yu

    oAuth 2 protocol, Microsoft Azure cloud services

    Yes, that's what we did so far. But we have also been able to code in 'native' VFP most other integration projects in the past. It is much easier to maintain. Here I'm stumped on the use of private key, with base64 encoding, of certificate for oAuth 2 validation on Azure.
  5. Steve Yu

    oAuth 2 protocol, Microsoft Azure cloud services

    Thanks for the tip, Scott. One of the requirements of this project was base64 encoding; where does this fit into the process you described ? Regards, Steve Yu
  6. Steve Yu

    oAuth 2 protocol, Microsoft Azure cloud services

    Fellow colleagues. Does VFP have commands that is capable of reaching endpoints that's only accessible via oAuth 2 protocol based on Azure ? There are sample codes in various languages except VFP in GitHub. Just wonder if it's feasible with VFP code alone (one of our guys wrote a routine in C#...
  7. Steve Yu

    Automatic date completion

    it depends on your application. You could pre-fill with today's date and just press Enter without the need to even enter the day value.
  8. Steve Yu

    Inserting Image into varbinary(max) field

    Syntax aside, a different design consideration is worth mentioning: In our shop, we don't imbed binary data (image, pdf, .xls, etc) in the DB as a general rule for a number of reasons. Instead we store only the name of the object in the DB field and the actual object separately in a designated...
  9. Steve Yu

    Inserting Image into varbinary(max) field

    SQLExec(SQL_Connection, "INSERT Into SFile (BMPField) Values ( ?M.jcBMP ) ;")
  10. Steve Yu

    Inserting Image into varbinary(max) field

    you have mismatching quote marks : two single quote(') but three double quotes(")
  11. Steve Yu

    Send E-Mail

    Points well taken. Push comes to shove, hosting legacy VFP apps under a virtual machine with compatible OS should always work as a last resort. Until 2049 that is; then someone has to figure out how to mitigate the Y2K issue again. We are still running character mode apps, 80x25 display with...
  12. Steve Yu

    Send E-Mail

    My view is VFP 9.0 and VFP in general is an antiquate technology regardless how people wants and tries to improve upon it. If it fits your purpose then just use it as is and at its most stable state in a 32-bit architecture. When 32-bit version of VFP stops working that'd be the time to hang it...
  13. Steve Yu

    Send E-Mail

    Very knowledgeable. we use West Wind for SMTP too, albeit in plain VFP 9 32-bit and have no issues.
  14. Steve Yu

    Sending bulk email messages from VFP 6.0 and VFP 9

    We use West Wind Internet and Client Tools as well for SMTP and it works extremely well. You do need your own SMTP server and the tool box requires a nominal one time cost but well worth it.
  15. Steve Yu

    Strip leading characters from a string

    Code: cStr = "FA007074000" Cfreq= transform(VAL(SUBSTR(cstr,3)),"@R 999,999,999") && " 7,074,000" Freq = LTRIM(STRTRAN(cfreq,',','.')) && '7.074.000'
  16. Steve Yu

    Create a table with Tag indexes

    Table designer implicitly creates the tag for you, localiza and codagente in your case (you can do a 'Display Status' in command window to see the structure.} If you create the table programmatically, I believe you'll have to run the 'Index on localiza tag localiza' command to create the index...
  17. Steve Yu

    Create a table with Tag indexes

    Then you can do this: index on localiza tag tag1 index on str(codagente,6) tag tag2 use reservas set order to tag1 && localiza, default ascending .... set order to tag2 .....
  18. Steve Yu

    Create a table with Tag indexes

    index on LOCALIZA + str(codagente,6) tag anytagname
  19. Steve Yu

    Report Form printer setting binding

    We did save but when we checked printer preference with the print job in queue (paused) it reverted back to printer default, without our tray selection. Steve Yu
  20. Steve Yu

    Report Form printer setting binding

    Chris, Will browse FRX table. Thank you. Steve Yu

Part and Inventory Search

Back
Top