Full Screen Update

[Dan Hendricks]

I am including my asp code. The Full Screen Update is not working for me. I am using ASPdb Pro. Thanks for any help.

<%
dim cnn, rs, F1, i, Top, Bottom
set cnn = Server.CreateObject( &#34;ADODB.Connection&#34
cnn.Open = &#34;gui&#34;
set rs = Server.CreateObject( &#34;ADODB.Recordset&#34
rs.Open &#34;tasks&#34;, cnn,, 3
Top=Clng(session(&#34;SV_RecordPointer_5511&#34)
Bottom=Recptr + clng(session(&#34;SV_GridInc_5511&#34)
for i = Top to bottom
F1=Request.Form(&#34;CompletedC&#34; & rs(&#34;TaskID&#34)
rs.MoveNext
next
rs.Close
cnn.Close
%>

<form method=&#34;POST&#34; action=&#34;tasks-FullScreenEdit.asp&#34;>
<%
Set X=Server.CreateObject (&#34;ASP.DB&#34
X.dbUserLocalText = zHead & &#34;,<Center><h3>NOC Tasks</h3></Center>;&#34;
X.dbUnit=5511
X.dbImageDir = &#34;/images/aspdb/&#34;
X.dbMode = &#34;Grid&#34;
X.dbGridCol = &#34;2&#34;
X.dbDSN = &#34;gui&#34;
X.dbSQL = &#34;Select * from Tasks Where Completed = No Order by Frequency&#34;
X.dbGridTableTag = &#34;border=1&#34;
X.dbButtonsOnOff = &#34;EditDropOff&#34;
&#39;X.dbGridDisplayFlds = &#34;TaskID,Task,Frequency,Completed&#34;
X.dbEditParams = &#34;TableName=Tasks, BookMarkFlds=TaskID&#34;
X.dbEditFlds = &#34;Task,Description,Frequency,Completed&#34;
X.dbEditUpdateROFlds = &#34;Task,Frequency,Description&#34;
X.dbEditDropFlds = &#34;Frequency,,,/Daily/Weekly/Monthly&#34;
X.dbColor = &#34;White,Black,White,Black,LightBlue&#34;
X.dbGridInc = 50
X.dbGridIncMax = 50
X.dbMemoTextSize = -1
X.dbFilterFlds = &#34;Task,Frequency,Completed&#34;
X.dbFilterParams = &#34;Help=False&#34;
X.dbMagicCell = &#34;(;,[]#|~/+{})Completed,,<INPUT NAME=&#39;CompletedC#0#&#39; VALUE=&#39;#4#&#39;>&#34;
X.dbCountSQL = &#34;SELECT COUNT(1) FROM Tasks&#34;
X.dbNavigationIcon = &#34;Std&#34;
X.dbNavigation = &#34;Bottom&#34;
X.dbNavigationItem = &#34;top,prev,next,bottom,update,Add,Reload,GridCo l&#34;
X.dbButtonAnchor = False
X.dbExportFlds = &#34;Description,TaskID&#34;
X.ASPdb
%>

<Center><input type=&#34;submit&#34; value=&#34;Update&#34;></center>
</form></Center>

[Frank Kwong]

No, it won&#39;t for now but when the features are rolled down (check web site product matrix) it will. I&#39;ll check.


------------
Dan Hendricks at 8/15/01 4:59:17 PM


I am including my asp code. The Full Screen Update is not working for me. I am using ASPdb Pro. Thanks for any help.

<%
dim cnn, rs, F1, i, Top, Bottom
set cnn = Server.CreateObject( &#34;ADODB.Connection&#34
cnn.Open = &#34;gui&#34;
set rs = Server.CreateObject( &#34;ADODB.Recordset&#34
rs.Open &#34;tasks&#34;, cnn,, 3
Top=Clng(session(&#34;SV_RecordPointer_5511&#34)
Bottom=Recptr + clng(session(&#34;SV_GridInc_5511&#34)
for i = Top to bottom
F1=Request.Form(&#34;CompletedC&#34; & rs(&#34;TaskID&#34)
rs.MoveNext
next
rs.Close
cnn.Close
%>

<form method=&#34;POST&#34; action=&#34;tasks-FullScreenEdit.asp&#34;>
<%
Set X=Server.CreateObject (&#34;ASP.DB&#34
X.dbUserLocalText = zHead & &#34;,<Center><h3>NOC Tasks</h3></Center>;&#34;
X.dbUnit=5511
X.dbImageDir = &#34;/images/aspdb/&#34;
X.dbMode = &#34;Grid&#34;
X.dbGridCol = &#34;2&#34;
X.dbDSN = &#34;gui&#34;
X.dbSQL = &#34;Select * from Tasks Where Completed = No Order by Frequency&#34;
X.dbGridTableTag = &#34;border=1&#34;
X.dbButtonsOnOff = &#34;EditDropOff&#34;
&#39;X.dbGridDisplayFlds = &#34;TaskID,Task,Frequency,Completed&#34;
X.dbEditParams = &#34;TableName=Tasks, BookMarkFlds=TaskID&#34;
X.dbEditFlds = &#34;Task,Description,Frequency,Completed&#34;
X.dbEditUpdateROFlds = &#34;Task,Frequency,Description&#34;
X.dbEditDropFlds = &#34;Frequency,,,/Daily/Weekly/Monthly&#34;
X.dbColor = &#34;White,Black,White,Black,LightBlue&#34;
X.dbGridInc = 50
X.dbGridIncMax = 50
X.dbMemoTextSize = -1
X.dbFilterFlds = &#34;Task,Frequency,Completed&#34;
X.dbFilterParams = &#34;Help=False&#34;
X.dbMagicCell = &#34;(;,[]#|~/+{})Completed,,<INPUT NAME=&#39;CompletedC#0#&#39; VALUE=&#39;#4#&#39;>&#34;
X.dbCountSQL = &#34;SELECT COUNT(1) FROM Tasks&#34;
X.dbNavigationIcon = &#34;Std&#34;
X.dbNavigation = &#34;Bottom&#34;
X.dbNavigationItem = &#34;top,prev,next,bottom,update,Add,Reload,GridCo l&#34;
X.dbButtonAnchor = False
X.dbExportFlds = &#34;Description,TaskID&#34;
X.ASPdb
%>

<Center><input type=&#34;submit&#34; value=&#34;Update&#34;></center>
</form></Center>

[Donna]

You can do full screen editing. there is a good working example of how to do thia at www.mmstools.com ... example 127
I hope that helps!
Donna


------------
Frank Kwong at 8/15/01 11:17:50 PM

No, it won&#39;t for now but when the features are rolled down (check web site product matrix) it will. I&#39;ll check.


------------
Dan Hendricks at 8/15/01 4:59:17 PM


I am including my asp code. The Full Screen Update is not working for me. I am using ASPdb Pro. Thanks for any help.

<%
dim cnn, rs, F1, i, Top, Bottom
set cnn = Server.CreateObject( &#34;ADODB.Connection&#34
cnn.Open = &#34;gui&#34;
set rs = Server.CreateObject( &#34;ADODB.Recordset&#34
rs.Open &#34;tasks&#34;, cnn,, 3
Top=Clng(session(&#34;SV_RecordPointer_5511&#34)
Bottom=Recptr + clng(session(&#34;SV_GridInc_5511&#34)
for i = Top to bottom
F1=Request.Form(&#34;CompletedC&#34; & rs(&#34;TaskID&#34)
rs.MoveNext
next
rs.Close
cnn.Close
%>

<form method=&#34;POST&#34; action=&#34;tasks-FullScreenEdit.asp&#34;>
<%
Set X=Server.CreateObject (&#34;ASP.DB&#34
X.dbUserLocalText = zHead & &#34;,<Center><h3>NOC Tasks</h3></Center>;&#34;
X.dbUnit=5511
X.dbImageDir = &#34;/images/aspdb/&#34;
X.dbMode = &#34;Grid&#34;
X.dbGridCol = &#34;2&#34;
X.dbDSN = &#34;gui&#34;
X.dbSQL = &#34;Select * from Tasks Where Completed = No Order by Frequency&#34;
X.dbGridTableTag = &#34;border=1&#34;
X.dbButtonsOnOff = &#34;EditDropOff&#34;
&#39;X.dbGridDisplayFlds = &#34;TaskID,Task,Frequency,Completed&#34;
X.dbEditParams = &#34;TableName=Tasks, BookMarkFlds=TaskID&#34;
X.dbEditFlds = &#34;Task,Description,Frequency,Completed&#34;
X.dbEditUpdateROFlds = &#34;Task,Frequency,Description&#34;
X.dbEditDropFlds = &#34;Frequency,,,/Daily/Weekly/Monthly&#34;
X.dbColor = &#34;White,Black,White,Black,LightBlue&#34;
X.dbGridInc = 50
X.dbGridIncMax = 50
X.dbMemoTextSize = -1
X.dbFilterFlds = &#34;Task,Frequency,Completed&#34;
X.dbFilterParams = &#34;Help=False&#34;
X.dbMagicCell = &#34;(;,[]#|~/+{})Completed,,<INPUT NAME=&#39;CompletedC#0#&#39; VALUE=&#39;#4#&#39;>&#34;
X.dbCountSQL = &#34;SELECT COUNT(1) FROM Tasks&#34;
X.dbNavigationIcon = &#34;Std&#34;
X.dbNavigation = &#34;Bottom&#34;
X.dbNavigationItem = &#34;top,prev,next,bottom,update,Add,Reload,GridCo l&#34;
X.dbButtonAnchor = False
X.dbExportFlds = &#34;Description,TaskID&#34;
X.ASPdb
%>

<Center><input type=&#34;submit&#34; value=&#34;Update&#34;></center>
</form></Center>

[Frank Kwong]

Very good, that&#39;ll work too...


------------
Donna at 8/16/01 10:33:53 AM

You can do full screen editing. there is a good working example of how to do thia at www.mmstools.com ... example 127
I hope that helps!
Donna


------------
Frank Kwong at 8/15/01 11:17:50 PM

No, it won&#39;t for now but when the features are rolled down (check web site product matrix) it will. I&#39;ll check.


------------
Dan Hendricks at 8/15/01 4:59:17 PM


I am including my asp code. The Full Screen Update is not working for me. I am using ASPdb Pro. Thanks for any help.

<%
dim cnn, rs, F1, i, Top, Bottom
set cnn = Server.CreateObject( &#34;ADODB.Connection&#34
cnn.Open = &#34;gui&#34;
set rs = Server.CreateObject( &#34;ADODB.Recordset&#34
rs.Open &#34;tasks&#34;, cnn,, 3
Top=Clng(session(&#34;SV_RecordPointer_5511&#34)
Bottom=Recptr + clng(session(&#34;SV_GridInc_5511&#34)
for i = Top to bottom
F1=Request.Form(&#34;CompletedC&#34; & rs(&#34;TaskID&#34)
rs.MoveNext
next
rs.Close
cnn.Close
%>

<form method=&#34;POST&#34; action=&#34;tasks-FullScreenEdit.asp&#34;>
<%
Set X=Server.CreateObject (&#34;ASP.DB&#34
X.dbUserLocalText = zHead & &#34;,<Center><h3>NOC Tasks</h3></Center>;&#34;
X.dbUnit=5511
X.dbImageDir = &#34;/images/aspdb/&#34;
X.dbMode = &#34;Grid&#34;
X.dbGridCol = &#34;2&#34;
X.dbDSN = &#34;gui&#34;
X.dbSQL = &#34;Select * from Tasks Where Completed = No Order by Frequency&#34;
X.dbGridTableTag = &#34;border=1&#34;
X.dbButtonsOnOff = &#34;EditDropOff&#34;
&#39;X.dbGridDisplayFlds = &#34;TaskID,Task,Frequency,Completed&#34;
X.dbEditParams = &#34;TableName=Tasks, BookMarkFlds=TaskID&#34;
X.dbEditFlds = &#34;Task,Description,Frequency,Completed&#34;
X.dbEditUpdateROFlds = &#34;Task,Frequency,Description&#34;
X.dbEditDropFlds = &#34;Frequency,,,/Daily/Weekly/Monthly&#34;
X.dbColor = &#34;White,Black,White,Black,LightBlue&#34;
X.dbGridInc = 50
X.dbGridIncMax = 50
X.dbMemoTextSize = -1
X.dbFilterFlds = &#34;Task,Frequency,Completed&#34;
X.dbFilterParams = &#34;Help=False&#34;
X.dbMagicCell = &#34;(;,[]#|~/+{})Completed,,<INPUT NAME=&#39;CompletedC#0#&#39; VALUE=&#39;#4#&#39;>&#34;
X.dbCountSQL = &#34;SELECT COUNT(1) FROM Tasks&#34;
X.dbNavigationIcon = &#34;Std&#34;
X.dbNavigation = &#34;Bottom&#34;
X.dbNavigationItem = &#34;top,prev,next,bottom,update,Add,Reload,GridCo l&#34;
X.dbButtonAnchor = False
X.dbExportFlds = &#34;Description,TaskID&#34;
X.ASPdb
%>

<Center><input type=&#34;submit&#34; value=&#34;Update&#34;></center>
</form></Center>