ODBC error -1 on Fetch

I have a table in MS Access that I'm trying to access via ODBC. I get a -1
on the Fetch and ended up putting on Trace in the ODBC admin tool. I end up
getting an error on what turns out to be the last field stating that the
field is required. I put something in the field and now the second to last
field on the fetch creates a -1 error code, once again stating that the
field is required. In the design view for the DB both of these fields are
flagged as not being required. I'm using Realia COBOL WB 3.3.

On Wed, 13 Apr 2005 22:59:15 -0500, <thepla@attglobal.net> wrote:

>I have a table in MS Access that I'm trying to access via ODBC. I get a -1
>on the Fetch and ended up putting on Trace in the ODBC admin tool. I end up
>getting an error on what turns out to be the last field stating that the
>field is required. I put something in the field and now the second to last
>field on the fetch creates a -1 error code, once again stating that the
>field is required. In the design view for the DB both of these fields are
>flagged as not being required. I'm using Realia COBOL WB 3.3.
>

Can you please post your code, both COBOL and SQL bits, and Access
driver version used.



Frederico Fonseca
ema il: frederico_fonseca at syssoft-int.com

It turns out there was a bug in the compiler. CA has always responded with
unbelievable speed in responding to the couple bugs I have found over the
years. The problem was that when the Access DB had the "Not Required" flag
set and there was not any data I would get -1 on the Fetch.

Thanks for you offer to assist.

Stev
"Frederico Fonseca" <real-email-in-msg-spam@email.com> wrote in message
 news:dv8s51pvkho6acukhr6qek8lkjkotk3eil@
4ax.com...
> On Wed, 13 Apr 2005 22:59:15 -0500, <thepla@attglobal.net> wrote:
> 
>
> Can you please post your code, both COBOL and SQL bits, and Access
> driver version used.
>
>
>
> Frederico Fonseca
> ema il: frederico_fonseca at syssoft-int.com

It turns out there was a bug in the compiler. CA has always responded with
unbelievable speed in responding to the couple bugs I have found over the
years. The problem was that when the Access DB had the "Not Required" flag
set and there was not any data I would get -1 on the Fetch.

Thanks for you offer to assist.

Stev
"Frederico Fonseca" <real-email-in-msg-spam@email.com> wrote in message
 news:dv8s51pvkho6acukhr6qek8lkjkotk3eil@
4ax.com...
> On Wed, 13 Apr 2005 22:59:15 -0500, <thepla@attglobal.net> wrote:
> 
>
> Can you please post your code, both COBOL and SQL bits, and Access
> driver version used.
>
>
>
> Frederico Fonseca
> ema il: frederico_fonseca at syssoft-int.com