Re: Serious errors with 'Create view' command

Hi Tom

I can't get the view designer to create the coding that I need, either! It
doesn't come out with the same brackets. How are you suggesting that I cut
and paste it? It's the 'text' in the view designer 'sql view' that's WRONG in
the first place and thus cutting and pasting that would just repeat the
problem. To where are you suggesting tyhat I 'paste' the cut-out anyway? I
can't paste it INTO the view designer sql view window as that's Read Only!

There is the facility to 'edit stored procedures' but I can't seem to make
that do ANYTHING!

ian



"tom knauf" wrote:

Hi,

I would create the view in the viewdesigner and cut/paste the code generated
by the viewdesigner (right click - view sql)

HTH
Tom


"Barley Man" <BarleyMan@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:A4DB29BB-1787-4E90-83A6-2209790A74EA@xxxxxxxxxxxxxxxx
I have used the following 'create view' statment:-

Create Sql View combinedview;
AS Select inventory.inumbr, inventory.divno, inventory.deptno,
inventory.subdeptno, inventory.classno, ;
inventory.istyl;
FROM inventory ;
WHERE (?mydivno <= 0 Or divno = ?mydivno);
AND (?mydeptno <= 0 Or deptno = ?mydeptno);
AND (?mysubdeptno <= 0 Or subdeptno = ?mysubdeptno);
AND (?myclassno <= 0 Or classno = ?myclassno)

However, when I 'inspect' (modify) the created View by looking at the sql,
the 'view' created is NOT the same as the one I requtested and appears as
follows:-

SELECT Inventory.inumbr, Inventory.divno, Inventory.deptno,;
Inventory.subdeptno, Inventory.classno, Inventory.istyl;
FROM drilldown2!inventory;
WHERE ?mydivno <= 0;
OR (Inventory.divno = ?mydivno;
AND ?mydeptno <= 0);
OR (Inventory.deptno = ?mydeptno;
AND ?mysubdeptno <= 0);
OR (Inventory.subdeptno = ?mysubdeptno;
AND ?myclassno <= 0);
OR (Inventory.classno = ?myclassno)

The change is not immediately obvious to see but it IS there. The
positioning (and thus the effects) of the brackets have changed
SUBSTANTIALLY
and the routine simply fails to perform properly. I need the EXACT
functionality of the statement contained within the 'create
view'instructions
but I simply can't get it to 'transfer' into the database as a 'view'!

It does not appear to be a simple error in the 'view sql' routine as the
view BEHAVES EXACTLY in line with the version being displayed by 'view
sql'
and that's NOT what I want, nor what I requested!

What on EARTH am I supposed to do about THAT?

Ian



.

Relevant Pages

  • RE: Parameterized components?
    ... I know how to parameterize a SQL string, ... In that walkthrough...all the data adapters are configured on the component ... I want to populate a listbox called "Location". ... > a designer will popup that looks like the MS Access SQL designer, ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Enterprise Manager confusion
    ... case of Microsoft introducing functionality in a Service Pack. ... On my old laptop, I had SQL Server Enterprise Manager installed, I believe ... sizes in the View designer, and properly handles CASE statements as well. ... It also take *dreadfully* long to load any complex queries into the View ...
    (microsoft.public.sqlserver.tools)
  • Re: How to solve DataSet Designer SQL errors?
    ... generating SQL to configure data adapters. ... to the 2003 style of dragging data adapters onto a component designer ... Builder, using a Jet 4.0 connection to an Access 2003 DB. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Enterprise Manager confusion
    ... the QA would outweigh the once-per-load/save slowness in the View designer. ... Now, on my new laptop, I have what I thought was the same version of SQL ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)
  • Re: Enterprise Manager confusion
    ... like table positions and column sizes weren't displayed, ... Now, on my new laptop, I have what I thought was the same version of SQL ... the View designer over a VPN connection (sometimes 30-60 seconds or even ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)