W
Will Lastname
The application I'm working on is writing to 2 different tables. The
first table is the ProjectName, ID (AutoNumber), and the Date/Time
added as a timestamp. The next table, writes all the components of that
project, ItemName, Creator, etc... One of the fields in this table is
ProjID and ID (Autonumber). ProjID is retrieved from a function for
grabbing the MaxOfID in the first table that is equal to ProjectName
and the date/time. I performed an executescalar to retrieve this
integer and set Viewstate("ID") = objCommand.ExecuteScalar
The problem is that when I set intID = Viewstate("ID") a value of 0 is
returned. What could cause this viewstate disappearance?
first table is the ProjectName, ID (AutoNumber), and the Date/Time
added as a timestamp. The next table, writes all the components of that
project, ItemName, Creator, etc... One of the fields in this table is
ProjID and ID (Autonumber). ProjID is retrieved from a function for
grabbing the MaxOfID in the first table that is equal to ProjectName
and the date/time. I performed an executescalar to retrieve this
integer and set Viewstate("ID") = objCommand.ExecuteScalar
The problem is that when I set intID = Viewstate("ID") a value of 0 is
returned. What could cause this viewstate disappearance?