Question on Use of BulkOperations

From: TSH (mathematicus_at_yahoo.com)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 10:46:07 -0500

In trying to write to a table WITH a primary key, suppose that there are TWO
different arrays containing the desired data that need to be written one
after the other. The arrays are not of the same length.

The procedure would be something like:

SQLBindCol(StmtHndl, column, SQL_dataType, Pointer to array1...
SQLBulkOperations(StmtHndl,SQL_ADD,...
SQLBindCol(StmtHndl, column, SQL_dataType, Pointer to array2...
SQLBulkOperations(StmtHndl,SQL_ADD,...

Upon doing this,
The first array is written ok, but onthe second BulkOps the driver gives an
error saying that duplicate values are being written though there are NO
such duplicates between the contents of the arrays.
The error seems to be given on the SECOND row of the array2, the first row
gets written ok.

Other symptoms:
If the table does not have a primary key things go ok.
OR
If the first arrays is recycled to hold the second batch of data SO THAT the
second BINDCOL is deleted, things go ok.

So I need to know how can one write more than one array of data via BulkOps
without the total data being a multiple of the first array?

Any hints will be appreciated
Ernesto

Relevant Pages

  • Choose two numbers
    ... code finds the largest number in the first row of the first array ... By writing these two numbers from each row of the arrays ... Dim lastrow As Long ... Wend ...
    (microsoft.public.excel.programming)
  • Re: SQLBulkOperations question
    ... The arrays are not of the same length. ... T> gives an error saying that duplicate values are being written though ... T> If the table does not have a primary key things go ok. ... T> BulkOps without the totla data being a multiple of the first array? ...
    (microsoft.public.data.odbc)
  • SQLBulkOperations question
    ... In trying to write to a table WITH a primary key, ... The arrays are not of the same length. ... The error seems to be given on the SECOND row of the array2, ... without the totla data being a multiple of the first array? ...
    (microsoft.public.data.odbc)
  • Re: Idiom for array index that Im foreaching over?
    ... I have taken the first array to be the measure of all. ... > minimum length of all arrays offered, ... > be other useful strategies. ... Assigning to the "goob" routine both chooses this option and sets the ...
    (comp.lang.perl.misc)
  • Re: Filling a matrix with values
    ... in the matrix (starting in the second row) equal to the sum of the ... because x and y are arrays, and I need to access only two single ... the meaning of 'the element to the top-left of it'. ...
    (comp.lang.apl)