Database Problem (Access 2.0 drv & VC 1.51)

Ricky Singleton -- singler@Traveller.COM
Sunday, February 25, 1996

I have just finished (thought) writing a small database front end when I
discovered that I could not add more than 255 characters to an Access memo
field. Here are the facts and I appreciate any help ya'll can give.

1. I am using Access 2.0 driver (odbcjc16.dll) that ships with vc 1.51 (mfc2.5).

2. I get an assertion when I attempt to update the memo field with more than
255    characters. I can retrieve more than 255 however.

3. Here is the RFX_Text entry where m_Contents is a CString:

	RFX_Text(pFX, "Contents", m_Contents,  MAXINT, SQL_LONGVARCHAR);

   as per MFC Tech Note 45.

4. I have also used m_Contents as a CLongBinary as per Knowledge Base article:
        Example DDX Routine for Access Memo Fields 
        ARTICLE ID: Q119765
        

Using both methods I have been unable to transfer more than 255 characters
to the database.
BTW, I would prefer to use the CLongBinary method in order to use it to
transfer BMP or some other binary data to the database.

Thanks in Advance,
Ricky Singleton
singler@Traveller.COM
Ricky Singleton

ETS Software
http://www.bhm.tis.net/~singler/index.htm

---

Mike Blaszczak -- mikeblas@msn.com
Wednesday, February 28, 1996

----------
From: 	owner-mfc-l@netcom.com on behalf of Ricky Singleton
Sent: 	Sunday, February 25, 1996 09:40

2. I get an assertion when I attempt to update the memo field with more than
255    characters. I can retrieve more than 255 however.

_Exactly_ what assertion do you get?

Or did you mean to offer us a prize if we guessed correctly?

.B ekiM
TCHAR szSipowicz[] = _T("Boy, that part's gonna be clean.");

---

| Вернуться в корень Архива |