We really need some good sqlite getting started examples

[kcwvc52]

I have gone through the tutorials provided but they just don't seem to provide enough info to get you started using livecode and sqlite. i also have sql yoga which does simplify the process some but is very limited on its power. it would be nice to see examples of adding variables to a database also. naming tables the name of a variable. i have seen examples but they are in no way straight forward it has several responses none of which worked. please someone guide me to something that could help

[jesse]

You may want to checkout http://forums.runrev.com/viewtopic.php? ... 4&start=30. Townsend provides a great sample stack it really helped me get some ideas. It uses just plain old sql-lite.

you mentioned you had sql yoga... for someone who knows sql pretty well would it be helpful you think? plus it only works for sql lite, not mysql right?

[kcwvc52]

thanks that is helpful me and some of my colleagues have been searching for something similar to this. as far as sql yoga it features seem to be kinda limited and by what i understand it only works with sqlite. i'm still going over the documentation to understand it a little better.

[Klaus]

Hi kcwvc52,

"SQLYoga" supports:
MySQL
PostGreSQL
SQL Server (ODBC)
SQLite
Valentina local and client
!

For me the LiveCode "SQLite" example stack was very helpful, what exactly do you not understand?


Best

Klaus

[kcwvc52]

i am understanding everything now except for creating custom names for db's and tables. such as using variables to name them. the whole process of using sql seems not very livecode like. i guess it gets easier the more you use it.

[kcwvc52]

nevermind figured that out. this is good i just needed a little push in the right direction thanks alot guys

[peaslee]

The example provided is good if the database is on the local machine. What stumps me is how to handle the situation where the file is on the server. Is there an example for that?

Thanks.

[Edit: Finally got it - the example was wrong :>(

[BarrySumpter]

The example provided is good if the database is on the local machine. What stumps me is how to handle the situation where the file is on the server. Is there an example for that?

Thanks.

[Edit: Finally got it - the example was wrong :>(

Hi Bruce,
Just wondering how you got this to work?
I'm trying to run Townsends sample on Android and can't get it to connect/find the database on the server.
Or perhaps you were just testing on the desktop to a server?
tia

[peaslee]

I'm using a PC.

The example didn't show the correct construction for the file name. It's [yourAccountNameHere].on-rev.com.