Search found 2 matches
- 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...
- 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...