Search found 2 matches

by Stitch_Fan
Fri Jun 12, 2009 2:22 am
Forum: Databases
Topic: SQLite - Selecting multiple columns
Replies: 3
Views: 4635

Thanks for your help Jan and Trevor. The learning curve to move from doing things "the hard way" i.e. a bunch of flat files to SQLite has been a lot easier than I thought it would be. The only problem is the rev ide releases are outpacing my glacial development speed. I think using the dispatch comm...
by Stitch_Fan
Thu Jun 11, 2009 12:54 am
Forum: Databases
Topic: SQLite - Selecting multiple columns
Replies: 3
Views: 4635

SQLite - Selecting multiple columns

I have a SQLite database that keeps track of the serial ports my rev app is talking to: Table: SerialPorts PortID PortName PortStatus 1 COM1: Open 2 COM2: Closed When I try to select data from a single column... put "SELECT PortID FROM SerialPorts WHERE PortStatus='Open'" into SQLquery put revDataFr...