Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-21 : 09:41:16
|
| Mikhail writes "I am trying to use sp_OAGetProperty inside the UDF in SQL 2000.I've created the instance of the object and now I need to call the function in the DLL.The problem is that function expects 2 parameters (1 - string, 2 - boolean). How can I pass boolean from SQL Server inside sp_OAGetProperty .I could not find any way of doing that ?ThanksMikhail" |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-02-21 : 09:57:20
|
| Have you tried using a bit? If so, I would suggest using a byte and making it either 0 or 1. |
 |
|
|
maloy
Starting Member
19 Posts |
Posted - 2002-02-21 : 11:08:57
|
| Try using the sql_variant datatype.HthMaloy |
|
|
|
|
|
|
sp_OAGetProperty