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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Constant Problem

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 = adCmdStoredProc

it 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) ?
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-01-16 : 01:10:01
Make sure you have declared rsGenFileName of Command Object type

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

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.
Go to Top of Page

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
Go to Top of Page

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\ado

Thank you guys.
Go to Top of Page
   

- Advertisement -