• Welcome, Guest. Please login.
 
July 14, 2020, 06:20:49 am

News:

Welcome to the SQLitening support forums!


Sqlite, SELECT function problem

Started by XX7, March 25, 2015, 04:13:26 pm

Previous topic - Next topic

XX7

Hi ,

I have old MS access db, now is the time to convert in SQLite, data migration complite.
But in VBA code I have problem.
Connection with base goes ok, problem is when I try to select 2 Cell from table.(X and Y cell)
For ex. old code was:
SQLQuery "SELECT [X]  & [Y] FROM [data] WHERE [Z]='test", strFilePath, blnRet, varArray
This function working ok, when I work with access db, with SQLite won't.

Any idea how to solve this issue?




XX7

I working in VBA, if you have any info how to solve that in VBA source, thx.

XX7

Bern Ertl

It appears that you are missing a single quote after the word test (before the double quote).  In any event, SQLite syntax for a SELECT statement is slightly different.

SELECT [X], [Y] FROM [data] WHERE [Z]='test'