Prev: Clipper Programmers Needed
Next: Structure from OleAutoObject control
From: Kevin on 11 Jun 2010 10:59
Geoff,

Whenever I click on the plus sign beside a User Table I get the
following error:

Function: SQLPROVIDERTSQL:GETCOLUMNDEFAULTSARRAY
Description: adErrObjectClosed
CallStack:
ADOCREATEERROR (Line 0)
ADORECORDSET:CLOSE (Line 0)
SQLPROVIDERTSQL:GETCOLUMNDEFAULTSARRAY (Line 60)
SQLTABLE:FINDDEFAULTS (Line 12)
SQLTABLE:COLUMNDEFAULTS:ACCESS (Line 7)

This is a VO error dialog rather than yours. It has options for Ignore
and Cancel. Clicking Cancel closes SQL Master.

If I click Ignore the TreeView for the table is expanded.


Also for some reason when I right-click a table and view the script SQL
Master adds a RECID column to the script (RECID INT IDENTITY (1,1) NOT
NULL) even though the table does not have a column of that name.
Importing a DBF file also ads the RECID column even if the option is
unticked.

Kevin

From: Geoff Schaller on 14 Jun 2010 03:17
Let me look into this later...

"Kevin" <kdmurphy(a)eircom.net> wrote in message
news:lbsQn.159$K4.81(a)news.indigo.ie:

> Geoff,
>
> Whenever I click on the plus sign beside a User Table I get the
> following error:
>
> Function: SQLPROVIDERTSQL:GETCOLUMNDEFAULTSARRAY
> Description: adErrObjectClosed
> CallStack:
> ADOCREATEERROR (Line 0)
> ADORECORDSET:CLOSE (Line 0)
> SQLPROVIDERTSQL:GETCOLUMNDEFAULTSARRAY (Line 60)
> SQLTABLE:FINDDEFAULTS (Line 12)
> SQLTABLE:COLUMNDEFAULTS:ACCESS (Line 7)
>
> This is a VO error dialog rather than yours. It has options for Ignore
> and Cancel. Clicking Cancel closes SQL Master.
>
> If I click Ignore the TreeView for the table is expanded.
>
>
> Also for some reason when I right-click a table and view the script SQL
> Master adds a RECID column to the script (RECID INT IDENTITY (1,1) NOT
> NULL) even though the table does not have a column of that name.
> Importing a DBF file also ads the RECID column even if the option is
> unticked.
>
> Kevin

From: Kevin on 14 Jun 2010 11:29
Geoff,

The problem clicking on the plus sign beside the User Tables may be at
my side. I saw it several times on the day I reported it but have not
seen it yet today. I'll keep an eye on it and see if I can pin down the
cause.

Kevin

"Geoff Schaller" <geoffx(a)softxwareobjectives.com.au> wrote in message
news:hIkRn.2700$Ls1.2139(a)news-server.bigpond.net.au:

> Let me look into this later...
>
> "Kevin" <kdmurphy(a)eircom.net> wrote in message
> news:lbsQn.159$K4.81(a)news.indigo.ie:
>
> > Geoff,
> >
> > Whenever I click on the plus sign beside a User Table I get the
> > following error:
> >
> > Function: SQLPROVIDERTSQL:GETCOLUMNDEFAULTSARRAY
> > Description: adErrObjectClosed
> > CallStack:
> > ADOCREATEERROR (Line 0)
> > ADORECORDSET:CLOSE (Line 0)
> > SQLPROVIDERTSQL:GETCOLUMNDEFAULTSARRAY (Line 60)
> > SQLTABLE:FINDDEFAULTS (Line 12)
> > SQLTABLE:COLUMNDEFAULTS:ACCESS (Line 7)
> >
> > This is a VO error dialog rather than yours. It has options for Ignore
> > and Cancel. Clicking Cancel closes SQL Master.
> >
> > If I click Ignore the TreeView for the table is expanded.
> >
> >
> > Also for some reason when I right-click a table and view the script SQL
> > Master adds a RECID column to the script (RECID INT IDENTITY (1,1) NOT
> > NULL) even though the table does not have a column of that name.
> > Importing a DBF file also ads the RECID column even if the option is
> > unticked.
> >
> > Kevin

 | 
Pages: 1
Prev: Clipper Programmers Needed
Next: Structure from OleAutoObject control