Patrick, I did what you suggested and I was am able to run any select statement from the link and get valid returns. But, when I try to create the View form in ARS I am getting the ORA-00904 Invalid Identifier on the key field. I have verified that the Key field on the SQL table is set up properly, 6 to 15 characters, Unique, and No NULL, the Column name starts with a Alpha character. I am at a loss, any ideas?
Thanks Gary Dries On 4/2/08, patrick zandi <[EMAIL PROTECTED]> wrote: > > ** Just create a view on the db side, create a dblink, then create a > synomn on the ars side. > Test link.. select * from synonm... ( I know I cannot spell .. ;-) > then create a view form.. watch out of Date fields.. and use an escalation > or a filter to write back.. > > voila .. works great.. been doing this for years.. .. Day 1 since the view > form came out.. > > Hope that helps.. > > ARS > DB > ARS VIEW ~~> Synonmn ~~> DBlink ~~> View of tables ~~> Tables > test your link ! > > > > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"