Assinging UDT a value in .adp

[Mantle51]

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

 

[SQLSister]

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

 

[Mantle51]

In that case I will declare a global variable in the .adp file.

Thanks so much

 

[ESquared]

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]