>We are developing an application that uses two distinct databases two databases on the same SQL Server? - with the user having privs on both?
>the default dabatabe set in the connection string i.e 'database=<maindb>' ? > and a second one used in some subqueries. >Is it possible to create an alias to the second database ? >I don´t want to use the literal name of the database a Fox alias? a SQL Server alias? - and you'll have to use the real name somewhere or how will you find the tables? In Oracle you could use a synonym - which would hide the fact that there was a second database involved, or in mosy rdb's you could use a view eg: create view myProducts as SELECT A.ProdId,A.ProdName,B.Price AS CustomerPrice FROM Products A INNER JOIN CustomerData.dbo.Products B and in Fox: nHndl = sqlstringconnect(cConnStr) ?sqlexec(nHndl, [select * from myProducts], 'curMyprods') Andrew Davies MBCS CITP - AndyD 8-)# ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Please contact [EMAIL PROTECTED] with any queries. ********************************************************************** _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
