Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi charlie,
Isn't it possible to modify the SPT in such way it includes the last_name ? Are you using SQL 7 ? Then you might be able to make a view out of the SPT and use a normal P-view to include the last_name in a seperate view on top of that one.
Walter,
>Hi Walter:
>
>I should have been more specific. These are SPT cursors returned via ODBC from SQL Server SP's. Once they arrive at the client, I set up the proper indexes so I can relate the tables. I need to create some sort of compound index, like STR(foreign_key) + last_name so the child records will appear to be sorted by last_name and still maintain the relation. Need to know if there is a better way to do this.
>
>Charlie
Previous
Next
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