VB and Oracle LONG Datatypes 
Author Message
 VB and Oracle LONG Datatypes

Hi,

   I am having some difficulty manipulating and displaying Oracle LONG
Datatypes within my forms. I'm using VB5.0, the Oracle Data Control
and connecting to Oracle 7.3.

For instance, I wish to display a row from the table ALL_CONSTRAINTS,
this table has a column named SEARCH_CONDITION which is a LONG data
type populated with source text.

I'm aware of the GETCHUNK method of the Recordset, but have not had
any luck with it...

I hope that you may offer some assitance or perhaps suggest an
alternative method for extracting the text from these data types.

Thanxs in advance.

Rob
Programmer Analyst
WRDSB



Tue, 25 Dec 2001 03:00:00 GMT
 VB and Oracle LONG Datatypes

There are no alternative methods for accessing LONG data, unless you use
ODBC and DAO/RDO, in which case the LONG columns appear as MEMO fields and
can be accessed in their entirety. If you use OO4O, you've got to read and
write the LONG column in pieces using code.


Quote:
> Hi,

>    I am having some difficulty manipulating and displaying Oracle LONG
> Datatypes within my forms. I'm using VB5.0, the Oracle Data Control
> and connecting to Oracle 7.3.

> For instance, I wish to display a row from the table ALL_CONSTRAINTS,
> this table has a column named SEARCH_CONDITION which is a LONG data
> type populated with source text.

> I'm aware of the GETCHUNK method of the Recordset, but have not had
> any luck with it...

> I hope that you may offer some assitance or perhaps suggest an
> alternative method for extracting the text from these data types.

> Thanxs in advance.

> Rob
> Programmer Analyst
> WRDSB



Wed, 26 Dec 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. vb,ado,long datatype in Oracle 7.3

2. LONG Datatype: How to Select from VB???

3. ?CAN′T ADO RETRIEVE FROM ORACLE, FIELDS WHICH DATATYPE IS LONG (IN ORACLE)

4. JDBC, Oracle, and Oracle Long Datatypes

5. ORACLE datatype LONG and editor-widgets

6. Inserting Oracle long datatype

7. "Long" Datatypes in Oracle 8

8. Oracle LONG datatype

9. using the long datatype in Oracle 7.2

10. Question: Long datatype(text) in Migrating Oracle to SS7.0

11. Oracle... LONG Datatype


 
Powered by phpBB® Forum Software