Search:

Type: Posts; User: Sam Neuner

Page 1 of 53 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    22
    Views
    473

    Re: Set NOCOUNT ON Question

    Quote from Microsoft Documentation on SET NOCOUNT:

    "Stops the message that shows the count of the number of rows affected by a Transact-SQL statement or stored procedure from being returned as ...
  2. Replies
    22
    Views
    473

    Re: Set NOCOUNT ON Question

    YOU DA MAN!! Works great!!

    Still locks up on Saverecord if Set NOCOUNT ON and no Set NOCOUNT OFF. Any idea why? (No problem, easy to add the OFF, but just curious)
  3. Replies
    22
    Views
    473

    Re: Set NOCOUNT ON Question

    Yes, I will give it a try. Thanks.
  4. Replies
    22
    Views
    473

    Re: Set NOCOUNT ON Question

    Martin thanks for testing this for me. I set my testing up with the Repeat/Loop just as you have. After further testing it seems that the "Delete" statement in the script is causing the problem. You...
  5. Replies
    22
    Views
    473

    Re: Set NOCOUNT ON Question

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

    Example:



    Handle hoConnection hoStmt
    String[][] sQueryData
    String[][] sQueryData2
    Integer iNextSet
  6. Replies
    22
    Views
    473

    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...
  7. Replies
    22
    Views
    473

    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,...
  8. Replies
    22
    Views
    473

    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

    ...
  9. Replies
    22
    Views
    473

    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...
  10. Replies
    22
    Views
    473

    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...
  11. Replies
    8
    Views
    231

    Re: SQL Query question

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

    Re: SQL Query question

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

    Re: SQL Query question

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

    Re: SQL Query question

    Never mind, I found it.
  15. Replies
    8
    Views
    231

    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...
  16. 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!
  17. Re: REST API Post Problem returning Json object

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

    It is listed under Certificates there.
  19. 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.
    ...
  20. 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?
  21. 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...
  22. 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...
  23. Re: REST API Post Problem returning Json object

    BTW, have you tried a similar test?
  24. 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...
  25. Re: REST API Post Problem returning Json object

    Status Code = 0.
Results 1 to 25 of 1318
Page 1 of 53 1 2 3 4