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 |
|
Lorzendo
Starting Member
3 Posts |
Posted - 2006-01-15 : 08:51:20
|
| I don't know why my program can't support constants Enumeration, please refer to code below:rsGenFileName.CommandType = adCmdStoredProcit will return error: Variable is undefined: 'adCmdStoredProc'Anyone has idea? Thank you |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-15 : 09:20:12
|
| Ur program has reference to ADO?Whenever u type rsGenFileName and then the dot, r u getting a list of methods & properties ?U have connection to the corresponding Database ? (I mean using ADO) ? |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-16 : 01:10:01
|
| Make sure you have declared rsGenFileName of Command Object typeMadhivananFailing to plan is Planning to fail |
 |
|
|
Lorzendo
Starting Member
3 Posts |
Posted - 2006-01-16 : 08:51:12
|
| yeah, it shows a list of constant names for me to choose. Yet, when I run that page, it return variable is undefined thing. |
 |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-16 : 11:26:21
|
| -- I doubt that u have proper refernce!!-- Check for the documentation of 'adCmdStoredProc' & CommandType in MSDN -- Check some VB / ASP forum (like CodeGuru) and "Google" that as well |
 |
|
|
Lorzendo
Starting Member
3 Posts |
Posted - 2006-01-17 : 07:01:11
|
| Hi, I know what's the problem already. I should include a file like this in order to use those constants:<!--#include file = "adovbs.inc" --> "adovbs.inc" could be found in c:\program files\common files\system\adoThank you guys. |
 |
|
|
|
|
|