Android Question missing Library in SQLExample [Solved]

[Roger Daley]

Hi All

Trying learn SQL.
First step fire up SQLExample Error Unknown Type: rowcol Possibly missing library reference.

Which Library? Is it only me that finds missing things?

Regards Roger

 

[aeric]

Which version of B4A and which example you are opening?

 

[Roger Daley]

B4A 9.00
SQLExample.b4a in the SourceCode Folder included with the UserGuide. Downloaded today.
https://www.b4x.com/android/documentation.html

Regards Roger

 

[aeric]

I am using B4A 9.01.2
I open the SQLExample project with no error. Do you make any modification to the code? Try clean install your B4A or check is there any duplicate SQL library exist in Libraries folder and Additional Library folder.

 

[aeric]

Unknown Type: rowcol Possibly missing library reference.

RowCol is a user defined type in Starter module. Did you delete the line?

 

[aeric]

For beginner to learn SQL, I suggest start with SQLiteLight1 example.

 

[Roger Daley]

aeric,

All fixed, I didn't delete the line from the Starter Module, I didn't have the Starter Module. I had to close the SQLExample and move the SQL Folder out of the SourceCode folder before it would load correctly. Buggered if I know.

Thanks for the screenshots, they worked were words probably wouldn't.

Regards Roger

 

[klaus]

I wanted to know if there were any problem in the B4A User's Guide zip file, so I just downloaded the B4A User's Guide zip file, unziped it and ran the program without any problem. No need to move the folder.
What did you do when to got the error.

I suggest you to look at the B4X Booklets, these are more recent, the B4A User's Guide is no more updated.
A specific booklet for SQLite databses is included.

 

[Roger Daley]

Thanks Klaus,

I'm sure it was me, I just don't know what. I'm looking at both the booklets and the User Guide.
More accurately, I'm sitting with my feet up and leaving SQL for tomorrow .

Roger

 

[klaus]

I'm sitting with my feet up and leaving SQL for tomorrow.

I need to do this sometimes too !