DAO Field Size Limit Question, Please Please Help.

DAO Field Size Limit Question, Please Please Help.

Post by Jake Linde » Thu, 30 Dec 1999 04:00:00



I've got a semi-serious situation on my hands, depending on weither or
not the world is going to end this weekend.. ;).

My problem is simple, I'm using VB6, and SQL 7.0. I'm using DAO 3.51,
when I get a recordset from the SQL server, any field that is longer
than about 255 characters is truncated. These fields are of type
VARCHAR, length 5,000 to 8,000. the data is in the database (one field
in particular is 3200 characters long (a description)) but when I create
a recordset and say, output the values to a textbox, or any control for

field which would hold the traditional "memo" useless.. I'm positive
it's not SQL, but rather something with DAO.. I would use ADO, but this

understand.

Thanks!

-Jake..


(common y2k, rock the house so we can have a break..:))

 
 
 

1. COMBO BOX, PLEASE HELP, PLEASE HELP, PLEASE HELP!

From:

Organization:
              The University of Iowa
 Newsgroups:
              comp.databases.xbase.fox

I'm using VFP 3.0 for Mac and want to design a form with combo
boxes. Everything seems fine but after I checked any item on
any drop-down list there is nothing to appear in the box itself.
In other words, I can see the list and check any item, but
nothing shows up in the filled box. I designed these combo
boxes using combo box builder and every step seems correct.
I would like to hear from anyone regarding this problem. I
want to express my sincere thanks for your kind help in
advance.

Fang Qian

2. Oracle DBA NEEDED: ASAP

3. emergency please help me please please please

4. Backups of large databases

5. APPROACH QUERY-PLEASE PLEASE PLEASE PLEASE HELP

6. IPC / Bequeath protocol

7. array of fields using DAO (Please HELP )

8. Oracle Reports 6i

9. DAO - field description help please

10. Please Please, help me with memo-fields, real problem

11. Please help! DAO question

12. A DAO Question, please help!

13. Please, please, please help!!