Results 1 to 3 of 3

Thread: Does Qt 4.4.0's TDS Engine support transaction and storage procedure's call

  1. #1

    Default Does Qt 4.4.0's TDS Engine support transaction and storage procedure's call

    Does Qt 4.4.0's TDS Engine support transaction and storage procedure's
    call. There is output parameter and returned recordset in the storage
    procedure.

    for examples:
    SQL Script:
    Qt Code:
    1. ----------------------
    2. declare @aaa float
    3. set @aaa = 10.0
    4. exec proc1 @aaa output
    5. -----------------------
    To copy to clipboard, switch view to plain text mode 

    Qt Code:
    Qt Code:
    1. -----------------------
    2. q.prepare("exec proc1 ?");
    3. q.bindValue(0, 0, QSql::Out);
    4. q.exec();
    5. double f = q.boundValue(0).toDouble(); // fetch the output parameter
    6.  
    7.  
    8. ------------------------
    To copy to clipboard, switch view to plain text mode 

    Thanks.
    Last edited by marcel; 20th June 2008 at 19:58. Reason: missing [code] tags

  2. #2
    Join Date
    Feb 2006
    Location
    Romania
    Posts
    2,744
    Qt products
    Qt4
    Platforms
    Unix/X11 Windows
    Thanks
    8
    Thanked 541 Times in 521 Posts

    Default Re: Does Qt 4.4.0's TDS Engine support transaction and storage procedure's call

    stored procedure returned values and and recordsets are not fully supported, as the documentation states.

    what driver and what dbms are you using?

  3. #3

    Default Re: Does Qt 4.4.0's TDS Engine support transaction and storage procedure's call

    Thanks for edited.


    Qt 4.3.1's tds (connect mssql by db-library(ntwdblib.dll)) is not support transaction and store procedure's out params or returned recordsets.
    I want to know the tds(mssql/ntwdblib.dll) of Qt 4.4.0's information about transaction and store procedure's out params.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Qt is a trademark of The Qt Company.