Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #7529

Re: About Ado create view

From Malcolm G <malcolm-news2012delete@delete.jobstream.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: About Ado create view
References <0b4e7344-c6e9-4786-98d0-7f99ce75aa5d@googlegroups.com> <8Ykdw.11590$Za1.10196@fx22.am4> <74319246-e4b9-43d9-809c-bc8bd9a01b9a@googlegroups.com>
Message-ID <_todw.12211$zz2.5728@fx06.am4> (permalink)
Organization virginmedia.com
Date 2014-11-26 17:55 +0000

Show all headers | View raw


On 26/11/2014 15:52, dextrasistemas.jorge@gmail.com wrote:
> El miércoles, 26 de noviembre de 2014 10:54:14 UTC-3, Malcolm G  escribió:
>> On 26/11/2014 10:35, dextrasistemas.jorge@gmail.com wrote:
>>>
>>>  Hello 
>>>
>>>  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 ? 
>>>
>>>
>>>  oCmd := AdoCommand{}
>>>  oCmd:ActiveConnection := oLogin:oConn     
>>>
>>>                  
>>>
>>>     cQuery  :=  ' CREATE VIEW vw_ordenes_de_compra AS ' + ; 
>>>                 ' SELECT o.Ord_ID,  o.fecha,  t.operacion , p.proveedor, f.FormaPago,  o.total, o.aprobada, o.completa, o.enviada FROM ordenes AS o  ' + ; 
>>>                 ' JOIN proveedores as p ON p.Pro_ID = o.Pro_ID ' + ; 
>>>                 ' JOIN operaciones as t ON t.Ope_ID = o.Ope_ID ' + ;    
>>>                 ' JOIN formapago   as f ON f.Pag_ID = o.Pag_ID '    
>>>
>>>                    
>>>     oCmd:CommandText := cQuery       
>>>     oCmd:CommandType := adCmdText  
>>>   
>>>
>>>     oCmd:Execute(@lResult,nil,nil)
>>>  
>>> Best regards
>>> Jorge
>>
>> What error(s) do you get on create?
>> Is the view created and not usable or not created?
>> Does the user you are using have rights to create views (in the app and
>> in the external utility)?
> 
> 
> 
> 1) I have no error on create 
>    ( The view appears on sql management ) 

Umm - so if the view is there and correctly defined what is the problem
(as if the view is in SQL server and does not work on SQL server the
problem is not in VO)

> 2) The view does not return data, only that , 
>    there is no message/error etc
>    (  both in my app and sqlserver managemnt )

Does every property of the view look the same in sql server for both
ways of making it?

What happens if you make the view in sql server management studio rather
than using the "tool"?

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

About Ado create view dextrasistemas.jorge@gmail.com - 2014-11-26 02:35 -0800
  Re: About Ado create view Malcolm G <malcolm-news2012delete@delete.jobstream.com> - 2014-11-26 13:54 +0000
    Re: About Ado create view dextrasistemas.jorge@gmail.com - 2014-11-26 07:52 -0800
      Re: About Ado create view "Wolfgang Riedmann" <wriedmann@gmail.com> - 2014-11-26 17:39 +0100
      Re: About Ado create view Malcolm G <malcolm-news2012delete@delete.jobstream.com> - 2014-11-26 17:55 +0000
    Re: About Ado create view Malcolm G <malcolm-news2012delete@delete.jobstream.com> - 2014-11-28 14:33 +0000
      Re: About Ado create view dextrasistemas.jorge@gmail.com - 2014-11-28 11:06 -0800
        Re: About Ado create view Malcolm G <malcolm-news2012delete@delete.jobstream.com> - 2014-11-28 20:51 +0000
  Re: About Ado create view dextrasistemas.jorge@gmail.com - 2014-11-26 10:26 -0800
  Re: About Ado create view dextrasistemas.jorge@gmail.com - 2014-11-29 03:04 -0800
  Re: About Ado create view Robert van der Hulst <rjvanderhulst@gmail.com> - 2014-11-30 08:13 -0800
    Re: About Ado create view dextrasistemas.jorge@gmail.com - 2014-12-01 03:37 -0800
      Re: About Ado create view Malcolm G <malcolm-news2012delete@delete.jobstream.com> - 2014-12-01 12:04 +0000

csiph-web