Can't edit Memo Fields

[Shelly Mobley]

I'm having real problems editing memo fields. The fields are available during the add record process but not during the edit or update process. I have followed the example #10 under Enterprise features with no luck. Can you please assist me with this problem.

<%
set pr1=Server.CreateObject(&#34;ASP.db&#34
pr1.dbUnit = 2000
pr1.dbMDB=&#34;d:databasecnewebreqs.mdb; ; UID=webusers; PWD=&#34;
pr1.dbOptions = &#34;IsDBBlank=true,MemoParagraph=<HR>,NavTableTag =Border=1 cellspacing=1 cellpadding=3&#34;
pr1.dbSuppressMsg = true
pr1.dbSQL=&#34;Select * from [RequisitionTable]&#34;
pr1.dbMode=&#34;dual-horiz&#34;
pr1.dbGridDisplayFlds=&#34;,,VendNumb,[Location ID],Requisitioner,[Entered By],[Requisitioner Vnet],&#34; &_
&#34;[Project Number],[Requisition Entry Date],[Help Desk Ticket Number],[Date Needed],,,,,,,,,,,,,,,,,;&#34;

pr1.dbFormDisplayFlds = &#34;-1&#34;
pr1.dbMemoTextSize=255
pr1.dbFormMemo = &#34;6x75,15,16&#34;

pr1.dbGridTableTag=&#34;border=1 cellspacing=1 cellpadding=1&#34;
pr1.dbFormTableTag=&#34;border=1 cellspacing=1 cellpadding=1&#34;
pr1.dbEditFlds=&#34;0,1,2,3,4,5,6,7,8,9,10,11,12,1 3,14,15,16,17,18,19,20,21,22,23,24,25,26,27&#34;
pr1.dbEditDropFlds = &#34;3,,LocationID,[Location id],Select [Location ID] & &#39; &#39; & ID From LocationID Order By [Location ID];&#34;
pr1.dbEditParams = &#34;Tablename=LocationID, bookmarkflds=0,EditCol=2,RecordScope=Single,InputS ize=10x50&#34;
&#39;pr1.dbDisplayLookupList=&#34;(;|+)VendNumb||S elect VendNumb,VendName From VendorTable;[Location ID]||Select [Location ID],ID From LocationID;Country||Select [Country Code],Country From CountryMe;Currency||Select [Country Code],Currency From CountryMe&#34;
pr1.dbImageDir=&#34;../images&#34;
&#39; pr1.dbStartup=&#34;Edit/Add&#34;
pr1.dbImageDir=&#34;../images/&#34;
pr1.dbNavigation=&#34;bottom&#34;
pr1.dbNavigationItem=&#34;add,edit,update,filter&# 34;

pr1.ASPdb
%>

[John]

Hi Shelly,

Please see my reply under your other post.

Thanks,
John


------------
Shelly Mobley at 3/14/2002 3:20:37 PM

I&#39;m having real problems editing memo fields. The fields are available during the add record process but not during the edit or update process. I have followed the example #10 under Enterprise features with no luck. Can you please assist me with this problem.

<%
set pr1=Server.CreateObject(&#34;ASP.db&#34
pr1.dbUnit = 2000
pr1.dbMDB=&#34;d:databasecnewebreqs.mdb; ; UID=webusers; PWD=&#34;
pr1.dbOptions = &#34;IsDBBlank=true,MemoParagraph=<HR>,NavTableTag =Border=1 cellspacing=1 cellpadding=3&#34;
pr1.dbSuppressMsg = true
pr1.dbSQL=&#34;Select * from [RequisitionTable]&#34;
pr1.dbMode=&#34;dual-horiz&#34;
pr1.dbGridDisplayFlds=&#34;,,VendNumb,[Location ID],Requisitioner,[Entered By],[Requisitioner Vnet],&#34; &_
&#34;[Project Number],[Requisition Entry Date],[Help Desk Ticket Number],[Date Needed],,,,,,,,,,,,,,,,,;&#34;

pr1.dbFormDisplayFlds = &#34;-1&#34;
pr1.dbMemoTextSize=255
pr1.dbFormMemo = &#34;6x75,15,16&#34;

pr1.dbGridTableTag=&#34;border=1 cellspacing=1 cellpadding=1&#34;
pr1.dbFormTableTag=&#34;border=1 cellspacing=1 cellpadding=1&#34;
pr1.dbEditFlds=&#34;0,1,2,3,4,5,6,7,8,9,10,11,12,1 3,14,15,16,17,18,19,20,21,22,23,24,25,26,27&#34;
pr1.dbEditDropFlds = &#34;3,,LocationID,[Location id],Select [Location ID] & &#39; &#39; & ID From LocationID Order By [Location ID];&#34;
pr1.dbEditParams = &#34;Tablename=LocationID, bookmarkflds=0,EditCol=2,RecordScope=Single,InputS ize=10x50&#34;
&#39;pr1.dbDisplayLookupList=&#34;(;|+)VendNumb||S elect VendNumb,VendName From VendorTable;[Location ID]||Select [Location ID],ID From LocationID;Country||Select [Country Code],Country From CountryMe;Currency||Select [Country Code],Currency From CountryMe&#34;
pr1.dbImageDir=&#34;../images&#34;
&#39; pr1.dbStartup=&#34;Edit/Add&#34;
pr1.dbImageDir=&#34;../images/&#34;
pr1.dbNavigation=&#34;bottom&#34;
pr1.dbNavigationItem=&#34;add,edit,update,filter&# 34;

pr1.ASPdb
%>