SQLitening Support Forum

Support Forums => You've got Questions? We've got Answers! => Topic started by: Marty Francom on March 24, 2011, 01:11:06 AM

Title: Getting All records in a table
Post by: Marty Francom on March 24, 2011, 01:11:06 AM
I have a report that I want to build and I need to get ALL the records in a Table for this report.
I have been getting the records one at a time but I am sure there is a better way.

How would I get all the records (with all there fields) in a Table with one SQLitening call?
That is how should I build the call ?
Also, can the record be returned sorted by one of the fields?
Title: Re: Getting All records in a table
Post by: Fred Meier on March 24, 2011, 12:19:59 PM
slSel "Select * from T1 Order by F1"
Title: Re: Getting All records in a table
Post by: Gary Stout on March 24, 2011, 06:13:31 PM
Fred always makes it look SO simple  :D

I learn something from just about every post I read here...

Fred, Thanks for the GREAT support!
Title: Re: Getting All records in a table
Post by: Fred Meier on March 24, 2011, 10:11:57 PM
Your very welcome