Try varchar2 instead of varchar.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Gary Dries Sent: Thursday, March 27, 2008 4:52 PM To: [email protected] Subject: View Form not see a Key Field
** I am creating a couple of View forms to a SQL DB table from an Oracle DB remedy system using a dblink. Via the DB Link I am able to connect to the table and load all the fields but I do not see a column in the key field drop down of the create view dialog. In both tables the field I am wanting to use as the key is a 15 byte varchar, Null not allowed, and it is not designated as a key in the SQL db. On the first table the only column I see is a 4 byte int status field, and on the second I do not see a column listed at all that table which only contains varchars. any ideas Thanks G. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
