Sorry.. typo mistake 'USERS' is the table.. Also if you are using an ms sql db, then you can also do something like this IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='tablename') --- 'tablename exists.' ELSE --- 'tablename does not exist.' Dropping Table DROP TABLE SALARY IF EXIST then create it again CREATE TABLE SALARY ( ... ) There are many ways to solve what you are trying to do..

.NET Rules

Hi.. The exception only get thrown were you use the null reference, can you post the code, and give the line num that tthrows the exception. Maybe we can see what you really trying to do. :doh::~

.NET Rules

Hi.. Has anyone wrapped the ODBC Native API into a managed C++ class. From what I have researched natiive ODBC API is still the fastest way to fecth records. Sk8tz

.NET Rules

Use Transact SQL.. Something like. IF 'USERS' NOT EXIST THEN CREATE TABLE ( ... ) Hopes his helps...

.NET Rules

Its null reference because you havent instantiated or assigned to an instance. Why it throws an exception is because you using even though it is null reference. Hope this answers your question..

.NET Rules

Hi.. Crystal does have global variables for pagenumber, or force reset of pagenumber, and you probaly have to to do this check and reset on the page header or footer group. .NET Rules

Thanks, will test, trying to write a unique little DAL that does not require any generated code, strongly typed as well. :cool: .NET Rules

I know that, I looked at that sp and I'm still fuzzy about what exactly its doing. Is there a simpler way of quering this info. :~ .NET Rules

Hi. I want to retrieve the list of indexes against a table, and the fields in the index. Also if posible the ordinal of that index. I know that sp_helpindex, will retrieve that information, but I want to do it through TSQL. Does anyone know the query or queries to retrieve this information, please post it here. Also performance is an issue, so this info must be retrieved fast. :->:->:-> .NET Rules