RE: Problem with adding primary key to a table

Another thought might be to also create the table with a unique SQL long name that is job specific and create your own temp library called NBTYTEMP or something similar.

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT

------------------------------

message: 3
date: Wed, 15 Jun 2011 19:30:49 +0000
from: Alan Shore <ashore@xxxxxxxx>
subject: RE: Problem with adding primary key to a table

Thanks Chuck AND everyone else that responded
In this respect, DDS has an advantage
I will need to rethink my logic

Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill