FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

Bill, 

Isn't the code below broken for TDS 7.0?  The query becomes "insert bulk jkl
()" because colclause isn't populated unless it's TDS 8.0.  I get an error
about invalid syntax.  

Do you happen  to know the right syntax?  

Thanks.  I'll keep plugging.  

--jkl

[-snip-]
static RETCODE _bcp_start_copy_in(DBPROCESS *dbproc)
{
[...]
    if (IS_TDS70(tds) || IS_TDS80(tds))
    {
       firstcol = 1;
       strcpy(colclause,"");

       for ( i = 0; i < dbproc->bcp_colcount; i++ )
       {
           bcpcol = dbproc->bcp_columns[i];

           if (IS_TDS80(tds))
           {
              _bcp_build_bulk_insert_stmt(colclause, bcpcol, firstcol);
              firstcol = 0;
           }
       }

       sprintf(query,"insert bulk %s (%s)",dbproc->bcp_tablename, colclause
);

    }
    else
[end snip]