SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in Using Openquery      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic Using Openquery Author Message birgerii Joined: 21 Feb 2007 Posts: 29 Using Openquery Hello, Not a major issue, but I've experienced that when I type "Select * From Openq" and select openquery from the dropdown without selecting any subitems, I get "Select * From Openquery o". I thought I would get "Select * From Openquery(" or "Select * From Openquery(server, 'query')" Best regards Magnus Thu May 08, 2008 3:12 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7992 Hi. This is treated just like a table function. Please expand the item and pick the first subitem named "return" it will paste what you want. (basically press arrow right and then arrow down keys) Thu May 08, 2008 11:30 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.