Hi, I have been working through the datagrids tutotial on the MM site and an
having problems with the Edit & Delete Button pages.
[url]http://www.macromedia.com/devnet/mx/dreamweaver/articles/data_grids_pt3_04.html[/url]
If some could help with either or preferrably the Edit button tutorial first
that would be much apreciated. If it is any help on the data_grids_pt3_04.html
page I get as far as (6) and cannot see the Submit As: option of NVarChar 'Just
added it to the options manually in the end'. Also a bit confused as to where
to put the datatype for Access: Date/Time that the section indicates. When I
test the Edit Button the following error shows up on my browser.
System.FormatException: Input string was not in a correct format. at
System.Number.ParseInt64(String s, NumberStyles style, NumberFormatInfo info)
at System.Int64.Parse(String s) at
DreamweaverCtrls.DataSet.ConvertParameterValue(Str ing strValue, Enum theType)
at DreamweaverCtrls.DataSet.OnDataGridUpdate(Object Src,
DataGridCommandEventArgs E) and when I test the Delete Button in the next
section the following errors are output. System.Data.OleDb.OleDbException:
Could not delete from specified tables. at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr) at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS
dbParams, Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior,
Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior,
String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at
DreamweaverCtrls.DataSet.OnDataGridDelete(Object Src, DataGridCommandEventArgs
E)