Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Assinging UDT a value in .adp

Status
Not open for further replies.

Mantle51

Programmer
Aug 17, 2006
97
US
Hello,

How would I go about assigning the value in a form in .adp project to a user defined data type in SQL server. I've already created the variable as EndDate and I'd like the following event to reflect in SQL Server...

Private Sub Evaluation_ID_BeforeUpdate(Cancel As Integer)
EndDate = CVar([Evaluation_ID])

Thank you
 
I would not use a user defined data type. In SQL server 2000 they are very much a pain if you ever need to modify them. Not sure if this has improved in 2005. Most people I know who used one of these regretted it later.

"NOTHING is more important in a database than integrity." ESquared
 
In that case I will declare a global variable in the .adp file.

Thanks so much
 
You convert the variable to the base type of the user-defined data type.

[COLOR=black #d0d0d0]When I walk, I sometimes bump into things. I am closing my eyes so that the room will be empty.[/color]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top