|
Templates, Tools and Utilities
for Clarion Developers
|
 |
 |
|
Icetips Article
Back to article list
Search Articles
Add Comment
Printer friendly
Direct link
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..
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Today is April 25, 2024, 6:51 pm
This article has been viewed 35108 times.
Google search
has resulted in 119 hits on this article since January 25, 2004.
Back to article list
Search Articles
Add Comment
Printer friendly
|
|
|
