Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Angry Unanswered: how to get SQL_DESC_BASE_TABLE_NAME useing SQLColAttribute

    sybase 12.5
    vc++
    i want get the table name use SQLColAttribute();
    but the result is NULL

    exam:
    ....
    (Select aa from bb)
    rc = SQLPrepare(m_hStmt,(unsigned char *)szSQL,SQL_NTS)
    SQLExecute(m_hStmt);
    rc = SQLColAttribute(m_hStmt,i,SQL_DESC_BASE_TABLE_NAME ,szTable,128,&nTable,NULL);
    ....

    i test at sql is successed ; but in sybase szTable is NULL,
    why ??
    thanks!!!

  2. #2
    Join Date
    Oct 2003
    Posts
    2
    Quote Originally Posted by liwenlong
    sybase 12.5
    vc++
    i want get the table name use SQLColAttribute();
    but the result is NULL

    exam:
    ....
    (Select aa from bb)
    rc = SQLPrepare(m_hStmt,(unsigned char *)szSQL,SQL_NTS)
    SQLExecute(m_hStmt);
    rc = SQLColAttribute(m_hStmt,i,SQL_DESC_BASE_TABLE_NAME ,szTable,128,&nTable,NULL);
    ....

    i test at sql is successed ; but in sybase szTable is NULL,
    why ??
    thanks!!!


    WHY ????
    WHY ????
    WHY ????
    WHY ????
    SO SORRY!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •