I have a memory table with records like

JobID, JobNumber
100, 30A
100, 30A
150, 40A

problem is I now have added another record

160, 35A

to it and I want to sort the table by the JobNumber before I pass it
onto Report Builder. Resultant record order would be

100, 30A
100, 30A
160, 35A
150, 40A

I tried reverse engineering another simliar table and using the
IndexDefs code, but no luck.

Any ideas on solving this?

Thanks for any help,
Pat

Pat


Depends on how the memory table is created if via SQL just add the appropriate ORDER BY clause otherwise you need to add an index. Again I'd use SQL for it - something like

CREATE INDEX IF NOT EXISTS "JobNumber" ON "Memory\yourtable" (_JobNumber);

should do it.

Roy Lambert

thanks Roy, I mucked around with it today and now it works  

Pat