GGuzman
Posts: 10
|
| Posted: 06/27/2004, 3:00 AM |
|
I am trying to custom insert records (for each row) into a separate table using the code below in the "Before Show Row" event, but it appears that it's not retrieving the control value for SSAN.
Records are inserted if I manually type in a value (i.e. 123456789 for SSAN), but it will not work with the standard value property (CCDRAPS.SSAN.Value). When displaying the error message, it states:
[Microsoft][ODBC Microsoft Access Driver] Field 'HIPAADisclosures.SSAN' cannot be a zero-length string. (Microsoft OLE DB Provider for ODBC Drivers)
CCDRAPS is the name of the grid
SSAN is the control value I want inserted
________________________________________
Dim HIPAAConnection
Dim ErrorMessage
Set HIPAAConnection = New clsDBSSLDRAPS
HIPAAConnection.Open
HIPAAConnection.Execute("INSERT INTO HIPAADisclosures (SSAN, RequestorLogin) VALUES ('"& CCDRAPS.SSAN.Value &"', '" & Request.ServerVariables("LOGON_USER") & "')")
ErrorMessage = CCProcessError(HIPAAConnection)
'Response.Write ErrorMessage
'Response.End
HIPAAConnection.Close
_________________________________________
Any suggestions? (Perhaps I have to retrieve the value of the SSAN control a different way?)
|
 |
 |
|
