Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Wolfgang Riedmann" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: About Ado create view Date: Wed, 26 Nov 2014 17:39:33 +0100 Lines: 25 Message-ID: References: <0b4e7344-c6e9-4786-98d0-7f99ce75aa5d@googlegroups.com> <8Ykdw.11590$Za1.10196@fx22.am4> <74319246-e4b9-43d9-809c-bc8bd9a01b9a@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Trace: individual.net 2TaKqsYlnN9tjKlX+2c4ZAZfGufNQD5Z8+NqLvQeUZ9wWrNI0= Cancel-Lock: sha1:Wz8pToZwd5+IHzcWOxXlmqfSU90= User-Agent: XanaNews/1.18.1.6 Xref: csiph.com comp.lang.clipper.visual-objects:7527 Hi Jorge, > > > IF I create ( see bellow ) a View within my app ( vo 2.8 win7 > > > 64 sqlserver 2008r2 Vo2Ado ) The view not works. > > > IF I create it out of my app ( with some utility ) all works > > > fine... > > > Why ? > 1) I have no error on create > ( The view appears on sql management ) > > 2) The view does not return data, only that , > there is no message/error etc > ( both in my app and sqlserver managemnt ) > > 3) All happens on my stand alone pc ( same user it could be possible that the view needs to be "compiled" and that your utility does this automatically. Wolfgang --