Search:

Type: Posts; User: mmengel28

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: How to execute (Call) MySQL stored procedure?

    Martin:

    CK driver version: Database driver(s): DATAFLEX, ODBC_DRV (6.3.0.15), MSSQLDRV (6.3.0.15)
    MySQL version: '5.6.25-enterprise-commercial-advanced-log'

    I did what you suggested and I was...
  2. Re: How to execute (Call) MySQL stored procedure?

    Sorry, Marco, I don't understand what you're asking, but I'll take a stab. I've tried a connection string which specifies the schema (a database in MSSQL?) in MySQL. I've also tried a System DSN. The...
  3. Re: How to execute (Call) MySQL stored procedure?

    Garret:

    I tried Send SQLSetArgument and got "Required message argument missing" at that line.

    Thanks,
    Mike
  4. Re: How to execute (Call) MySQL stored procedure?

    Samuel:

    Answers to your questions:
    DF release: DataFlex 2019 Studio 19.1 - 19.1.58.159
    64bit or 32: 64
    CK driver version: Database driver(s): DATAFLEX, ODBC_DRV (6.3.0.15), MSSQLDRV (6.3.0.15)...
  5. How to execute (Call) MySQL stored procedure?

    We've been successfully using SQL Server for a number of years now. While keeping it the default DB for our WebApp, I'd like to be able to connect to a MySQL database/schema to pull a record set in....
  6. Replies
    11
    Views
    3,364

    Re: Convert Date to Unix Timestamp -- Vincent?

    Kelly:

    I'm looking for DF code that will convert Unix date/timestamp and convert it to DF DateTime. You mentioned you have that. Would you be willing to share it?

    Thanks,
    Mike
  7. How can I catch errors that would result in an HTML 500 Error?

    We're currently using DF19.1 for our WebApps. We're using it in an older style where we have classic ASP pages that directly call a method of a web object, the result of which is HTML output from the...
  8. Replies
    8
    Views
    1,195

    Re: How to determine if an object exists

    Great work. Thanks for your patience and explanation.
  9. Replies
    8
    Views
    1,195

    Re: How to determine if an object exists

    I'm tracking with you. Let me ask you a nitpicky question. You intentionally assigned a value of 0 to the hoJson handle variable. How do we actually know the hoJson object has been destroyed? It's...
  10. Replies
    8
    Views
    1,195

    Re: How to determine if an object exists

    Michael:

    As usual, your explanation was very helpful and spot on. Based on your code snippets, I did the following, which worked:

    Integer iDebug
    Move 0 to iDebug

    Handle hoJson
    Get Create...
  11. Replies
    8
    Views
    1,195

    Re: How to determine if an object exists

    Wil:

    TFYR. Your code snippet is exactly what I needed. Also, thanks for the link to dfSplat. I haven't played with it, yet, but from what I've read in the wiki, this looks like something I've been...
  12. Replies
    8
    Views
    1,195

    How to determine if an object exists

    I hope everyone is staying safe and healthy these days. I have what seems to be an easy question, but I can't seem to find the correct answer. I'm trying to check if an object exists. Here's some...
  13. Need some help with error handling and logging in WebApps

    We're in a situation where my users are getting errors that I'm not seeing and cannot reproduce. Most of the time the errors are not logged in the DF WebApp Event Log. I'm able to see a "fatal...
  14. Re: How do I refactor code into multiple methods without clearing a table buffer?

    Unfortunately, this didn't work, probably due to my error.

    After I closed the table (alias) in the refactored method, the parent (calling) method threw an error indicating the table was no longer...
  15. Re: How do I refactor code into multiple methods without clearing a table buffer?

    Wil:

    This is probably an uninformed, knee-jerk reaction, but I'm always a little nervous about leaving a buffer uncleared. Although I know now which method is calling the refactored method, I...
  16. Re: How do I refactor code into multiple methods without clearing a table buffer?

    Matt:

    I had thought about passing a struct, but wanted to get community feedback. Your suggestion confirms this.

    Thanks,
    Mike
  17. Re: How do I refactor code into multiple methods without clearing a table buffer?

    Michael:

    Thank you for the both the explanation of the buffer as a global variable and the suggestions that followed. Both were clear and very helpful.

    Thanks,
    Mike
  18. Re: How do I refactor code into multiple methods without clearing a table buffer?

    Jan:

    Between yours and the rest of the comments, I have a much better understanding of what's going on and how to resolve it. Thank you very much. I have a few more follow up questions that are...
  19. How do I refactor code into multiple methods without clearing a table buffer?

    Assume for a moment I have found a record in a table in a method, Method1:

    Function Method1 String val1 Returns String
    Boolean bBooleanVariable
    Clear TABLE_A
    Move val1 to TABLE_A.Col1
    Find Eq...
  20. Re: Is there an ORM tool that can be used with DF?

    Michael, thanks for clarifying and for the example. Something like your example is what I'm looking for. Does that exist for DF?

    If not, does anyone who uses SQL stored procedures have...
  21. Re: Is there an ORM tool that can be used with DF?

    Bump. Anyone? Bueller?
  22. Is there an ORM tool that can be used with DF?

    Is there either native ORM (Object Relational Mapping) or an external ORM tool/library that is used with DF? I'm looking for a way to shortcut the process of having a recordset returned by a stored...
  23. Replies
    3
    Views
    1,408

    Re: How to join two JSON objects

    Harm, you confirmed what I was thinking about interacting between both of the JSON parsing systems. Thanks for the suggestions.
  24. Replies
    3
    Views
    1,408

    Re: How to join two JSON objects

    For the sake of clarity, I'm trying to figure out how to work with JSON using both legacy code (using Erik Sven's work with JSON) and the new JSON features in DF 19.0 (cJsonObject). Here's what the...
  25. Replies
    3
    Views
    1,408

    How to join two JSON objects

    I've been using Erik Svensson's JSON package(s) for several years now (big thanks, Erik), and am now beginning to use the JSON features in DF 19.0. I have two legacy methods that are returning JSON...
Results 1 to 25 of 49
Page 1 of 2 1 2