Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2005
    Posts
    1

    Question Unanswered: SELECT...INTO in Visual C++ 6.0

    I don't know why doesn't work next code with Betrieve bases in Visual C++ 6.0 with Pervasive Software ODBC-32 interface installed on my machine:

    strcpy((char*)statement,
    "SELECT account.acc_bal, SUM(accrest.rest), SUM(accrest.rest_e) "
    "INTO ACCTBL IN \"d:\\\" \"dBase III;\" "
    "FROM accrest,account "
    "WHERE account.ID = accrest.ID AND accrest.FDATE = '12/10/2004' "
    "AND account.acc_bal Between 3900 and 3907 "
    "GROUP BY account.acc_bal");
    int statlen = strlen( (char*)statement );
    SQLExecDirect( hstmt, statement, statlen );

    There are no connection errors and SELECT without INTO clause works properly. But SELECT...INTO returns 558 status code that is undocumented in Pervasive documentation. And, it is terrible, it works good in Visual Basic.
    HELP PLEASE!!!
    Last edited by pervas; 01-24-05 at 05:04. Reason: Incorrectly typed text

Posting Permissions

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