We really need some good sqlite getting started examples
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
We really need some good sqlite getting started examples
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
Re: We really need some good sqlite getting started examples
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?
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?
Deving on WinVista Home Prem. SP2 32 bit. Using LiveCode 4.6.1 Pro Build 1392
Re: We really need some good sqlite getting started examples
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.
Re: We really need some good sqlite getting started examples
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
"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
Re: We really need some good sqlite getting started examples
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.
Re: We really need some good sqlite getting started examples
nevermind figured that out. this is good i just needed a little push in the right direction thanks alot guys
Re: We really need some good sqlite getting started examples
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 :>(
Thanks.
[Edit: Finally got it - the example was wrong :>(
Bruce Peaslee
Windows 7 Home Premium (Service Pack 1)
ACPI x-64 based PC 9GB RAM
Windows 7 Home Premium (Service Pack 1)
ACPI x-64 based PC 9GB RAM
-
- Posts: 1201
- Joined: Sun Apr 24, 2011 2:17 am
Re: We really need some good sqlite getting started examples
peaslee wrote: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
All my best,
Barry G. Sumpter
Deving on WinXP sp3-32 bit. LC 5.5 Professional Build 1477
Android/iOS/Server Add Ons. OmegaBundle 2011 value ROCKS!
2 HTC HD2 Latest DorimanX Roms
Might have to reconsider LiveCode iOS Developer Program.
Barry G. Sumpter
Deving on WinXP sp3-32 bit. LC 5.5 Professional Build 1477
Android/iOS/Server Add Ons. OmegaBundle 2011 value ROCKS!
2 HTC HD2 Latest DorimanX Roms
Might have to reconsider LiveCode iOS Developer Program.
Re: We really need some good sqlite getting started examples
I'm using a PC.
The example didn't show the correct construction for the file name. It's [yourAccountNameHere].on-rev.com.
The example didn't show the correct construction for the file name. It's [yourAccountNameHere].on-rev.com.
Bruce Peaslee
Windows 7 Home Premium (Service Pack 1)
ACPI x-64 based PC 9GB RAM
Windows 7 Home Premium (Service Pack 1)
ACPI x-64 based PC 9GB RAM