Line data    Source code

       1             : #include "common.h"
       2             : 
       3             : int
       4          10 : main(void)
       5             : {
       6             : 
       7             :         int i;
       8             : 
       9             :         SQLLEN cnamesize;
      10             : 
      11             :         const char *command;
      12             :         SQLCHAR output[256];
      13             : 
      14          10 :         odbc_connect();
      15             : 
      16          10 :         odbc_command("if object_id('tempdb..#odbctestdata') is not null drop table #odbctestdata");
      17             : 
      18          10 :         command = "create table #odbctestdata ("
      19             :                 "col1 varchar(30) not null,"
      20             :                 "col2 int not null,"
      21             :                 "col3 float not null," "col4 numeric(18,6) not null," "col5 datetime not null," "col6 text not null)";
      22          10 :         odbc_command(command);
      23             : 
      24          10 :         command = "insert #odbctestdata values ("
      25             :                 "'ABCDEFGHIJKLMNOP',"
      26             :                 "123456," "1234.56," "123456.78," "'Sep 11 2001 10:00AM'," "'just to check returned length...')";
      27          10 :         odbc_command(command);
      28             : 
      29          10 :         odbc_command("select * from #odbctestdata");
      30             : 
      31          10 :         CHKFetch("SI");
      32             : 
      33          70 :         for (i = 1; i <= 6; i++) {
      34          60 :                 CHKGetData(i, SQL_C_CHAR, output, sizeof(output), &cnamesize, "S");
      35             : 
      36          60 :                 printf("output data >%s< len_or_ind = %d\n", output, (int) cnamesize);
      37          60 :                 if (cnamesize != strlen((char *) output))
      38             :                         return 1;
      39             :         }
      40             : 
      41          10 :         CHKFetch("No");
      42             : 
      43          10 :         CHKCloseCursor("SI");
      44             : 
      45          10 :         odbc_command("drop table #odbctestdata");
      46             : 
      47          10 :         odbc_disconnect();
      48             : 
      49          10 :         printf("Done.\n");
      50          10 :         return 0;
      51             : }