Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #7529
| 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 |
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
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