LiveCode Forums.

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 ...

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 ...