Android Question Help with SQLite

[yemi1979]

Hi,
I keep getting errors with the cursor. The code below can not see to run.

Please advice

Thanks
Dim Cursor1 As Cursor

Cursor1 = SQL1.ExecQuery("SELECT name, Longitude, Latitude FROM Stores;") cursor1 is not a valid identifier.

 

[NJDude]

Remove the semicolon at the end of the query.

 

[yemi1979]

Tried it. Still same error.

Something seems to be wrong with assigning SQL to Cursor

 

[Erel]

When do you get this error message? During runtime?

 

[yemi1979]

I get the error when I attempt to compile.

 

[Erel]

This is strange. Can you upload your project (file - Export as zip)?

 

[yemi1979]

Erel,
It is really strange. The file seems to be too large to upload here. Can I email it to you? if so, what the best email?

Thanks for your help

 

[eps]

If you comment out that offending line, does it compile?

I suspect that you've not ended a sub correctly and its giving you an odd error.

 

[yemi1979]

Erel,
I have attached the zip file.

eps,
It compiles when I comment out the line. I know it's probably something very small that I can't just find. The subs are all ended.

Thanks for your help in advance

 

[yemi1979]

Erel,
Btw, it's the discovery module.

line 116
Thanks

 

[yemi1979]

Guys,
I found the problem. The IDE doesn't like when I copy and paste code from Microsoft word.

I usually write some code on the road in word and paste it into B4A. I knew it had to be something simple.

Thanks again

 

[eps]

Great and thanks for posting the solution.

I suspect that the quotes were getting changed to ones that the IDE didn't like.

Maybe try Notepad++ or something similar? I use that for lots of other editing.