|
| Improper use of the word RIGHT |
 |
Mon, 24 Mar 2008 15:12:37 -040 |
q.sql := 'select * from eDetail_report.dbf ORDER BY EndtKey RIGHT OUTER
JOIN Endts.dbf E ON (E.EndtNum = eDetail_report..EndtNum )
I absolutely need the first table indexed on EndtKey, as the records from
this table tend to print out of order. How can I state this without
offending dBase?
--
Dan Anderson
UBI Processing Dept.
andersond@ubinc.com
800-444-4824 ext 101
|
| Post Reply
|
| Re: Improper use of the word RIGHT |
 |
Mon, 24 Mar 2008 17:07:20 -050 |
Not sure if this will solve your problem but,
q.sql := 'select * from eDetail_report.dbf D ORDER BY EndtKey RIGHT OUTER
JOIN Endts.dbf E ON E.EndtNum = D.EndtNum'
I noticed the following:
1. You did not give an alias to eDetail_report
2. ( ) are optional in this case and can be omitted
3. notice here "eDetail_report..EndtNum " you have two (2) .. (dots)
4. There does not appear to by a closing '
Claus
"Dan Anderson" <andersond@ubinc.com> wrote in message
news:tlgRxVejIHA.644@news-server...
> q.sql := 'select * from eDetail_report.dbf ORDER BY EndtKey RIGHT OUTER
> JOIN Endts.dbf E ON (E.EndtNum = eDetail_report..EndtNum )
>
> I absolutely need the first table indexed on EndtKey, as the records from
> this table tend to print out of order. How can I state this without
> offending dBase?
>
> --
> Dan Anderson
> UBI Processing Dept.
> andersond@ubinc.com
> 800-444-4824 ext 101
>
|
| Post Reply
|
| Re: Improper use of the word RIGHT |
 |
Tue, 25 Mar 2008 02:37:57 -040 |
In article <$ERc84fjIHA.960@news-server>, cmygind@yahoo.com says...
> Not sure if this will solve your problem but,
>
> q.sql := 'select * from eDetail_report.dbf D ORDER BY EndtKey RIGHT OUTER
> JOIN Endts.dbf E ON E.EndtNum = D.EndtNum'
>
> I noticed the following:
>
> 1. You did not give an alias to eDetail_report
> 2. ( ) are optional in this case and can be omitted
> 3. notice here "eDetail_report..EndtNum " you have two (2) ..
(dots)
> 4. There does not appear to by a closing '
>
> Claus
Dan & Claus,
The ORDER BY EndtKey clause should be the last clause of the SQL
statement.
--
Geoff Wass [dBVIPS]
Montréal, Québec, Canada
.|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
|
| Post Reply
|
| Re: Improper use of the word RIGHT |
 |
Tue, 25 Mar 2008 06:47:18 -050 |
Geoff,
You are right.
Claus
"Geoff Wass [dBVIPS]" <gswassREMOVE_ME@attglobal.net> wrote in
message
news:MPG.225267d1fc2a74898a01e@news.dbase.com...
> In article <$ERc84fjIHA.960@news-server>, cmygind@yahoo.com says...
>> Not sure if this will solve your problem but,
>>
>> q.sql := 'select * from eDetail_report.dbf D ORDER BY EndtKey RIGHT
>> OUTER
>> JOIN Endts.dbf E ON E.EndtNum = D.EndtNum'
>>
>> I noticed the following:
>>
>> 1. You did not give an alias to eDetail_report
>> 2. ( ) are optional in this case and can be omitted
>> 3. notice here "eDetail_report..EndtNum " you have two (2) ..
(dots)
>> 4. There does not appear to by a closing '
>>
>> Claus
>
>
> Dan & Claus,
>
> The ORDER BY EndtKey clause should be the last clause of the SQL
> statement.
>
> --
> Geoff Wass [dBVIPS]
> Montréal, Québec, Canada
>
> .|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
> .|.|.| ---------------------------------------------------------- |.|.|.
> .|.|.| IT Consultant http://Geoff_Wass.com |.|.|.
|
| Post Reply
|
|
|
|
|
|
|
|
|
|