Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
Sorting a memory table |
Fri, Apr 7 2006 5:40 AM | Permanent Link |
Pat | 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 |
Fri, Apr 7 2006 7:06 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Sat, Apr 8 2006 4:16 AM | Permanent Link |
Pat | thanks Roy, I mucked around with it today and now it works
Pat |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |