dbRScursor=1 fixes memo field not displaying with Access

Hi, I was originally having problems getting memo fields to display using MSaccess 97 and 2000 using ASPdb2002 evaluation.

When i ran the code like this the memo field was just blank

I did trying using ODBC to access the Access database, however it made no difference. I could not get OLEDB to function either

error was provider not found

code with out correction follows


Set X= Server.CreateObject("ASP.DB")

X.dbmdb="C:Inetpubwwwroot estactreg.mdb"
X.dbSQL = "SELECT arItem,arPerson,arDue,arAction FROM ActReg"

X.dbUnit = "999"
X.dbMode = "Form"
X.dbFormDisplayFlds = "arItem, arPerson, arDue"

' Memo field to display
X.dbFormMemo = "10 x 50,arAction"
X.dbMemoTextSize = -1

X.ASPdb


I found a post by Frank indicating using the dbRScursor=1 as a last resort.

This was the only way for me to get memo fields to display for me


I added the line

X.dbRSCursor=1

and then it worked

The dbRScursor is not in the Manual, can anyone tell me what it was for. Should this be used, or is there another way around it.


original reply message from Frank Kwong follows


Subject:
From:
Date: Can't populate memo field from ASPdb (reply)
Frank Kwong ()
8/22/01 10:18:17 AM

read some prev messages about memo fields in Access. Multiple memo fields got problems with the OLEDB Access driver but not the ODBC driver. Single memo field should have no problem. So, try different drivers using the Designer. Also as a last resort, use -> X.dbRSCursor=1

------------
Mark Morris at 11/1/01 8:11:59 PM


Hi, I was originally having problems getting memo fields to display using MSaccess 97 and 2000 using ASPdb2002 evaluation.

When i ran the code like this the memo field was just blank

I did trying using ODBC to access the Access database, however it made no difference. I could not get OLEDB to function either

error was provider not found

code with out correction follows


Set X= Server.CreateObject("ASP.DB")

X.dbmdb="C:Inetpubwwwroot estactreg.mdb"
X.dbSQL = "SELECT arItem,arPerson,arDue,arAction FROM ActReg"

X.dbUnit = "999"
X.dbMode = "Form"
X.dbFormDisplayFlds = "arItem, arPerson, arDue"

' Memo field to display
X.dbFormMemo = "10 x 50,arAction"
X.dbMemoTextSize = -1

X.ASPdb


I found a post by Frank indicating using the dbRScursor=1 as a last resort.

This was the only way for me to get memo fields to display for me


I added the line

X.dbRSCursor=1

and then it worked

The dbRScursor is not in the Manual, can anyone tell me what it was for. Should this be used, or is there another way around it.


original reply message from Frank Kwong follows


Subject:
I'll look into that... are you displaying the memo in the grid or by itself. Which DB are you using to test and how many Memo fields are their in the DB ?

The cursor=1 is not doc because it slow things down...
FK



From:
Date: Can't populate memo field from ASPdb (reply)
Frank Kwong ()
8/22/01 10:18:17 AM

read some prev messages about memo fields in Access. Multiple memo fields got problems with the OLEDB Access driver but not the ODBC driver. Single memo field should have no problem. So, try different drivers using the Designer. Also as a last resort, use -> X.dbRSCursor=1

I just tested that with an EP setup and experience no problem....

<%
Set X= Server.CreateObject(&#34;ASP.DB&#34;)
X.dbUnit = &#34;999&#34;
X.dbMode = &#34;Dual-Horiz&#34;
X.dbMemoTextSize = 32
X.dbDSN = &#34;DSN=nwind&#34;
X.dbSQL = &#34;SELECT EmployeeID,LastName,FirstName,Notes FROM Employees&#34;
X.ASPdb
%>

The following Access - Northwind / Employees DB display the memo (32 characters) no problem. DIsplay in dual-horiz mode (required in Memo) no problem. So, if you are not using Northwind, then send me a sample of your mdb file and I&#39;kk try it here...



------------
Mark Morris at 11/1/01 8:11:59 PM


Hi, I was originally having problems getting memo fields to display using MSaccess 97 and 2000 using ASPdb2002 evaluation.

When i ran the code like this the memo field was just blank

I did trying using ODBC to access the Access database, however it made no difference. I could not get OLEDB to function either

error was provider not found

code with out correction follows


Set X= Server.CreateObject(&#34;ASP.DB&#34;)

X.dbmdb=&#34;C:Inetpubwwwroot estactreg.mdb&#34;
X.dbSQL = &#34;SELECT arItem,arPerson,arDue,arAction FROM ActReg&#34;

X.dbUnit = &#34;999&#34;
X.dbMode = &#34;Form&#34;
X.dbFormDisplayFlds = &#34;arItem, arPerson, arDue&#34;

&#39; Memo field to display
X.dbFormMemo = &#34;10 x 50,arAction&#34;
X.dbMemoTextSize = -1

X.ASPdb


I found a post by Frank indicating using the dbRScursor=1 as a last resort.

This was the only way for me to get memo fields to display for me


I added the line

X.dbRSCursor=1

and then it worked

The dbRScursor is not in the Manual, can anyone tell me what it was for. Should this be used, or is there another way around it.


original reply message from Frank Kwong follows


Subject:
From:
Date: Can&#39;t populate memo field from ASPdb (reply)
Frank Kwong ()
8/22/01 10:18:17 AM

read some prev messages about memo fields in Access. Multiple memo fields got problems with the OLEDB Access driver but not the ODBC driver. Single memo field should have no problem. So, try different drivers using the Designer. Also as a last resort, use -> X.dbRSCursor=1

I am using The Evalauation Version of ASPdb2002

I have tried both grid and form infact i have an example using copied from your examples page, that shows the memo field below the form.

I&#39;m Running Windows 2000 Professional Service Pack 2 using IIS 5.0
the Mdac Version installed on the system is 2.61.7326.6

I tried you sample line for line and it showed ... (3 dots) for the notes column

I will send you a screen capture of the output and a copy of my mdb file,




------------
Frank Kwong at 11/1/01 9:36:33 PM

I just tested that with an EP setup and experience no problem....

<%
Set X= Server.CreateObject(&#34;ASP.DB&#34;)
X.dbUnit = &#34;999&#34;
X.dbMode = &#34;Dual-Horiz&#34;
X.dbMemoTextSize = 32
X.dbDSN = &#34;DSN=nwind&#34;
X.dbSQL = &#34;SELECT EmployeeID,LastName,FirstName,Notes FROM Employees&#34;
X.ASPdb
%>

The following Access - Northwind / Employees DB display the memo (32 characters) no problem. DIsplay in dual-horiz mode (required in Memo) no problem. So, if you are not using Northwind, then send me a sample of your mdb file and I&#39;kk try it here...



------------
Mark Morris at 11/1/01 8:11:59 PM


Hi, I was originally having problems getting memo fields to display using MSaccess 97 and 2000 using ASPdb2002 evaluation.

When i ran the code like this the memo field was just blank

I did trying using ODBC to access the Access database, however it made no difference. I could not get OLEDB to function either

error was provider not found

code with out correction follows


Set X= Server.CreateObject(&#34;ASP.DB&#34;)

X.dbmdb=&#34;C:Inetpubwwwroot estactreg.mdb&#34;
X.dbSQL = &#34;SELECT arItem,arPerson,arDue,arAction FROM ActReg&#34;

X.dbUnit = &#34;999&#34;
X.dbMode = &#34;Form&#34;
X.dbFormDisplayFlds = &#34;arItem, arPerson, arDue&#34;

&#39; Memo field to display
X.dbFormMemo = &#34;10 x 50,arAction&#34;
X.dbMemoTextSize = -1

X.ASPdb


I found a post by Frank indicating using the dbRScursor=1 as a last resort.

This was the only way for me to get memo fields to display for me


I added the line

X.dbRSCursor=1

and then it worked

The dbRScursor is not in the Manual, can anyone tell me what it was for. Should this be used, or is there another way around it.


original reply message from Frank Kwong follows


Subject:
From:
Date: Can&#39;t populate memo field from ASPdb (reply)
Frank Kwong ()
8/22/01 10:18:17 AM

read some prev messages about memo fields in Access. Multiple memo fields got problems with the OLEDB Access driver but not the ODBC driver. Single memo field should have no problem. So, try different drivers using the Designer. Also as a last resort, use -> X.dbRSCursor=1