|
Add a space....
/space before your order by clause...
'WHERE TEMEMP = TE1EMP and ' + STS + ' ORDER BY AGE,DESC';
Smith, Mike on Thursday, March 07, 2013 2:23 PM wrote:
<<SNIP>>
This is the original SQL statement.
<<SNIP>> WHERE TEMEMP = TE1EMP and TEMEES = 'FR' Order by age desc;
<<SNIP>> Here is where I'm at now.
Select ;
When FPEMP = 'F' ;
Sts = 'TEEMES = ' + Q + 'FR' + Q;
When FPEMP = 'P' ;
Sts = 'TEEMES = ' + Q + 'PT' + Q;
EndSl ;
sqlstring =
'select <<SNIP>>
'WHERE TEMEMP = TE1EMP and ' + STS + 'ORDER BY AGE,DESC';
<<SNIP>>
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.