Search:

Type: Posts; User: Sam Neuner

Page 1 of 53 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    15
    Views
    232

    Re: Set NOCOUNT ON Question

    I am using NOCOUNT because of multiple "Select"s!

    Example:



    Handle hoConnection hoStmt
    String[][] sQueryData
    String[][] sQueryData2
    Integer iNextSet
  2. Replies
    15
    Views
    232

    Re: Set NOCOUNT ON Question

    What is confusing is that the following example is given for using ESQL in the Help:

    Get SQLConnectionId of ghoConnection "ID1" to hoConnect
    Get SQLOpen of hoConnect to hoStmt
    Send...
  3. Replies
    15
    Views
    232

    Re: Set NOCOUNT ON Question

    I guess that begs the question "Should (or Is it OK) ESQL use the same connection as the existing used to connect to the database in the App?" or should a new one be created? If using the same one,...
  4. Replies
    15
    Views
    232

    Re: Set NOCOUNT ON Question

    Different table.



    Get SQLConnectionId of ghoConnection "CONNECTID" to hoConnection

    Get SQLOpen of hoConnection to hoStmt
    Send SQLExecDirect of hoStmt sQuery

    ...
  5. Replies
    15
    Views
    232

    Re: Set NOCOUNT ON Question

    The system does not lock up immediately after the execution. It only locks up when the Saverecord is executed. I did notice that this only happens when the Saverecord is done after the...
  6. Replies
    15
    Views
    232

    Set NOCOUNT ON Question

    Using ESQL, If I execute this statement: "Set NOCOUNT ON; Select Count(*) from Tempchk;" and then do a Saverecord on a table the system locks up!! However if I execute this statement: "Set...
  7. Replies
    8
    Views
    211

    Re: SQL Query question

    Looks like SQLGetStmtAttribute(hoStmt,SQLSTMTATTRIB_COLUMNCOUNT) may work (getting the column count instead of row count). Doing further testing.
  8. Replies
    8
    Views
    211

    Re: SQL Query question

    Sorry that is not correct!! That function only indicates how accurate the row count is!!
  9. Replies
    8
    Views
    211

    Re: SQL Query question

    //Get SQLGetStmtAttribute of hoStmt SQLSTMTATTRIB_ROWCOUNT to iRows
    If (SQLGetStmtAttribute(hoStmt,SQLSTMTATTRIB_ROWCOUNT) > 0) ;
    Get SQLFetchResultsetValues of hoStmt to sQueryData
  10. Replies
    8
    Views
    211

    Re: SQL Query question

    Never mind, I found it.
  11. Replies
    8
    Views
    211

    SQL Query question

    I have a global function that executes my embedded SQL Queries passing the query statement as a paramter. It returns the Result Set if one. In this function how can I test to find out if a result...
  12. Re: REST API Post Problem returning Json object

    I cannot call it from the browser, I get the warning. However, my certificate is listed under Trusted Root Certification Authorities in mmc!
  13. Re: REST API Post Problem returning Json object

    I call call both the REST and the WebApp from the browser with no problem.
  14. Re: REST API Post Problem returning Json object

    It is listed under Certificates there.
  15. Re: REST API Post Problem returning Json object

    I managed to create the certificate and went through the process of trusting from google searches but can not seem to get it trusted. Not really a problem though, I can click Yes each time.
    ...
  16. Re: REST API Post Problem returning Json object

    I do not know how to do this. Now that I can turn off the SSL for testing I may just do that. What are the steps in IIS to set HTTPS up if I want to?
  17. Re: REST API Post Problem returning Json object

    Do not think is was! When I changed the HTTP transfer to use the normal port (80?) it worked. The SSL and ifSecure were set in the transfer object so it was using port 443? I know nothing about...
  18. Re: REST API Post Problem returning Json object

    This is what I got from Fiddler: Result 502

    [Fiddler] The connection to 'localhost' failed. <br />Error: ConnectionRefused (0x274d). <br />System.Net.Sockets.SocketException No connection could...
  19. Re: REST API Post Problem returning Json object

    BTW, have you tried a similar test?
  20. Re: REST API Post Problem returning Json object

    Thanks for the reminder, I forgot that I can have multiple instances of the Studio running so that I can debug the REST while running the other WebApp. When calling from the other WebApp (using...
  21. Re: REST API Post Problem returning Json object

    Status Code = 0.
  22. Re: REST API Post Problem returning Json object

    Get "Http request failed"
  23. Re: REST API Post Problem returning Json object

    Yes, I have written both server and client. This App works find when executed on the Live server. This same code which is ported to the Live server where it works correctly does not when executed...
  24. Re: REST API Post Problem returning Json object

    Just to elaborate further, I am returning a Json object with a message/error based on the result of the Get/Post. It is this object that is not being returned when run from the Studio.
  25. Re: REST API Post Problem returning Json object

    It works in the Postman, just not from the Studio.
Results 1 to 25 of 1314
Page 1 of 53 1 2 3 4