Welcome to the SQLitening support forums!
Started by Paul Squires, September 06, 2007, 08:15:14 pm
Quote from: tom cone jr on September 07, 2007, 08:51:59 amYour test table includes a mix of text and numeric data types. Is SQLite converting the numeric to string value automatically as the recordset is populated?
QuoteWhen building the recordset row by row you're using column numbers to fetch one field (column) at a time. To do this you use column position numbers rather than column (field) names. Is it possible to fetch an entire row in one step? If you have to fetch the row column by column can you use column names?
QuoteI guess these questions reveal how little I know about SQL in general and SQLite in particular don't they?
Quote from: tom cone jr on September 07, 2007, 08:51:59 am....If you have to fetch the row column by column can you use column names?
Quote from: Marc Van Cauwenberghe on September 07, 2007, 09:30:08 amResult: Time to iterate 51639 rows 1.484 seconds.Very nice!!!Marc
' PRINT #f&, RTRIM$(sData, ANY ", ")
' sData = sData & sql3_rsGetAt( rs, j ) & ", "
sSQL = "SERVER = localhost; PORT = default; UID = PSS234; PASSWORD = sqlrocks"