General information
Category:
Coding, syntax & commands
Thom,
Good one! thanks for that....
>If instead you did something like:
>
>SELECT APN AS Status, SPACE(25) AS FullStatus ;
>FROM MyTable ;
>GROUP BY Status ;
>INTO TABLE ShowStatus
>
>UPDATE ShowStatus ;
>SET FullStatus = GetDesc(ShowStatus.Status, "APN")
>
>SELECT MyTable.*, ShowStatus.FullStatus ;
>FROM MyTable, ShowStatus ;
>WHERE MyTable.APN = ShowStatus.Status ;
>INTO CURSOR Disp2Grid
>
>Then GetDesc() will fire less than a half dozen times. Additionally, you can optimize the queries
>for better performance.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only