Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Does my Column exists?

Status
Not open for further replies.

Setta

Programmer
Jul 9, 2003
22
BR
Hi everybody, I new around.

I have a question that's really bugging me.

I have this page (in ASP Visual Basic), and in some moment it creates in my database (MS Access) a temporarycolumn in one of my tables. It does it 'cause I need the column to reorganize the recordset.

Well, in the end of the page, the temporary column is dropped via SQL.

BUT - here is the mess - sometimes the column is not dropped, and everything goes really wild.

Well the "whys" are not so important right now.

What I need is:
In the beggining of my page I need to check if my Temporary column exists, if does I must dropp it, if does not great.

Could any of you gimme a hand with this?
Thanks a lot folks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top