SQL Related Articles: CCS Replacing Order By Clause
2003-01-20 -- Andy Stapleton
Newsgroups: comp.lang.clarion
Right,
In the NEW selection area , or whereever you need it rather ,
There is a new feature in the last update that allows you to replace the
ORDER BY clause
In this example it is used with a SHEET and TABS but works the same, when
you change the sql statement place it there.
Execute Choice(?Sheet3)
Sql1.InsertSql(6,'Order by
ITE.aspYear,ITE.Center,ITE.Show,ITE.CustNo,ITE.Item')
Sql1.InsertSql(6,'Order by
ITE.aspYear,ITE.Center,ITE.Show,ITE.AspGroup,ITE.DN')
SQL1.InsertSQL(6,'Order by
ITE.aspYear,ITE.Center,ITE.Show,ITE.AspGroup,Ite.Code,ITE.CustNo')
END
Thiswindow.reset(1)
--
Andy <> Stapleton
CIO DB|Wired.com / (ccs) Cowboy Computing Solutions
www.dbwired.com Web and Clarionet hosting
www.ccscowboy.com CCS SQL templates
www.Paywire.com ACH / Credit Card payment processing
"Omar Squiabro" wrote in message
news:3e2c1f3d@news.softvelocity.com...
> the 2 times order by, occurs when use a search by primary key..
>
> "Omar Squiabro" wrote in message
> news:3e2c1849$1@news.softvelocity.com...
> > thanks for response...
> >
> > in my trace the primary key appear 2 times in the order by, but with
inner
> > join no, but i need witout inner join..
> > where i can define the order by???
> >
> > "Andy <> Stapleton" wrote in message
> > news:3e2c1592@news.softvelocity.com...
> > > IF this is MSSQL, you also needto specify the Order by, what usually
> > happens
> > > is the same name is stuck 2 times on it...
> > >
> > > run the TRACE.EXE and look at the actual statement generated..
> > >
> > > --
> > > Andy <> Stapleton
> > > CIO DB|Wired.com / (ccs) Cowboy Computing Solutions
> > > www.dbwired.com Web and Clarionet hosting
> > > www.ccscowboy.com CCS SQL templates
> > > www.Paywire.com ACH / Credit Card payment processing
> > >
> > > "Omar Squiabro" wrote in message
> > > news:3e2acb4b@news.softvelocity.com...
> > > > Hi Again..
> > > >
> > > > I have a proble with CCS Browse, if the settings have a check mark
for
> > > > innser join the search work perfect but else generate error1.bmp,
but
> i
> > > need
> > > > my browse without this setting but generate error2.bmp, because i
have
> a
> > > > relation in the file schematic,
> > > > without inner join the error2 desapear but generate error1. any
> > > suggetion??
> > > > thanks in advance..
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Printed November 21, 2024, 6:59 am
This article has been viewed/printed 35342 times.
Google search
has resulted in 119 hits on this article since January 25, 2004.