Datatype Issues When Downloading

[John Phillips]

I have come across a problem when downloading to excel from asp-db Enterprise.
We are using version 2.1623 EP against an Oracle 8.0.5 database.

When accessing the following test table:


SQL> desc jp_test
Name Null? Type
------------------------------- -------- ----
MY_DATE DATE
MY_REAL NUMBER(4,2)

The following sql statement:

salesDB.dbSQL = "Select my_date, my_real from dbc.jp_test"

returns correctly to asp-db and downloads OK, but the following two statements:

salesDB.dbSQL = "Select trunc(my_date - to_date('1-Dec-1999&#39), my_real from dbc.jp_test"

SalesDB.dbSQL = "Select my_date, round(my_real) from dbc.jp_test"

while returning correct results to asp-db give the following error in excel:

<font face=&#34;Arial&#34; size=2>
<p>Provider</font> <font face=&#34;Arial&#34; size=2>error &#39;80004005&#39;</font>
<p>
<font face=&#34;Arial&#34; size=2>Unspecified error</font>
<p>
<font face=&#34;Arial&#34; size=2>/development_ip/john_p/test.asp</font><font face=&#34;Arial&#34; size=2> line 50</font>

I assume this is some sort of datatype issue - coverting from reals and dates to integers.

John

[Frank]

John,
There is no &#34;types&#34; in download as they are all text. You can display it in the grid, you can download. Check out the forum message about ORACLE date support in ASPDB. It might help.

Frank


------------
John Phillips at 12/2/99 9:11:28 AM

I have come across a problem when downloading to excel from asp-db Enterprise.
We are using version 2.1623 EP against an Oracle 8.0.5 database.

When accessing the following test table:


SQL> desc jp_test
Name Null? Type
------------------------------- -------- ----
MY_DATE DATE
MY_REAL NUMBER(4,2)

The following sql statement:

salesDB.dbSQL = &#34;Select my_date, my_real from dbc.jp_test&#34;

returns correctly to asp-db and downloads OK, but the following two statements:

salesDB.dbSQL = &#34;Select trunc(my_date - to_date(&#39;1-Dec-1999&#39), my_real from dbc.jp_test&#34;

SalesDB.dbSQL = &#34;Select my_date, round(my_real) from dbc.jp_test&#34;

while returning correct results to asp-db give the following error in excel:

<font face=&#34;Arial&#34; size=2>
<p>Provider</font> <font face=&#34;Arial&#34; size=2>error &#39;80004005&#39;</font>
<p>
<font face=&#34;Arial&#34; size=2>Unspecified error</font>
<p>
<font face=&#34;Arial&#34; size=2>/development_ip/john_p/test.asp</font><font face=&#34;Arial&#34; size=2> line 50</font>

I assume this is some sort of datatype issue - coverting from reals and dates to integers.

John

[John Phillips]

Frank,
I don&#39;t think this is a date issue, it seems to occur when the &#39;type&#39; of the item returned is different from that of the base field(s) in the database. For instance if a real number is truncated to a integer or a calculation is done on a date resulting in an integer number. If there are no types in the download then it must be something else - but it is definitely happening.
John


------------
Frank at 12/3/99 12:09:28 AM

John,
There is no &#34;types&#34; in download as they are all text. You can display it in the grid, you can download. Check out the forum message about ORACLE date support in ASPDB. It might help.

Frank


------------
John Phillips at 12/2/99 9:11:28 AM

I have come across a problem when downloading to excel from asp-db Enterprise.
We are using version 2.1623 EP against an Oracle 8.0.5 database.

When accessing the following test table:


SQL> desc jp_test
Name Null? Type
------------------------------- -------- ----
MY_DATE DATE
MY_REAL NUMBER(4,2)

The following sql statement:

salesDB.dbSQL = &#34;Select my_date, my_real from dbc.jp_test&#34;

returns correctly to asp-db and downloads OK, but the following two statements:

salesDB.dbSQL = &#34;Select trunc(my_date - to_date(&#39;1-Dec-1999&#39), my_real from dbc.jp_test&#34;

SalesDB.dbSQL = &#34;Select my_date, round(my_real) from dbc.jp_test&#34;

while returning correct results to asp-db give the following error in excel:

<font face=&#34;Arial&#34; size=2>
<p>Provider</font> <font face=&#34;Arial&#34; size=2>error &#39;80004005&#39;</font>
<p>
<font face=&#34;Arial&#34; size=2>Unspecified error</font>
<p>
<font face=&#34;Arial&#34; size=2>/development_ip/john_p/test.asp</font><font face=&#34;Arial&#34; size=2> line 50</font>

I assume this is some sort of datatype issue - coverting from reals and dates to integers.

John