Re: Newbie SQLite and LC learing problems

2012-08-24 Thread stephen barncard
Andre's DBlib is cool. LIKE takes care of 99% of most simple database needs with a couple lines of code. On Fri, Aug 24, 2012 at 11:39 AM, Andre Garzia wrote: > Hi Blair, > > Others have provided you with some links and I will provide you with some > more. First let me say that Petes software

Re: Newbie SQLite and LC learing problems

2012-08-24 Thread Andre Garzia
Hi Blair, Others have provided you with some links and I will provide you with some more. First let me say that Petes software SQLiteAdmin is my favorite SQLite admin software and I am using it a lot. Recommended! I created a simple SQLite access library that will help you with the common databas

Re: Newbie SQLite and LC learing problems

2012-08-24 Thread Peter Haworth
Hi Blair, Seems like you have two separate needs - figure out SQLite, then figure out how to use Livecode to access your SQLite database. Warren's link will show you hot to use Livecode with SQLite and as Bob mentioned, there are some LC add-ons that will help with that too. There are a number of

Re: Newbie SQLite and LC learing problems

2012-08-24 Thread Bob Sneidar
Hi Blair. I would search the web for sqLite syntax and sqLite primer. Tons of stuff out there. Be prepared for some kind of learning curve here, as SQL is like learning a new language, although not a very extensive one in the case of sqLite. Relationships are not what you would think coming fr

Re: Newbie SQLite and LC learing problems

2012-08-24 Thread Warren Samples
On 08/24/2012 11:53 AM, Warren Samples wrote: On 08/24/2012 11:43 AM, Blair Lewis wrote: I'm new to LC and am I am looking for help with using DB's with LC. I am coming from Filemaker and I am unable to find a decent tutorial on how to use SQLite that is either complete or useful. Does anyone h

Re: Newbie SQLite and LC learing problems

2012-08-24 Thread Warren Samples
On 08/24/2012 11:43 AM, Blair Lewis wrote: I'm new to LC and am I am looking for help with using DB's with LC. I am coming from Filemaker and I am unable to find a decent tutorial on how to use SQLite that is either complete or useful. Does anyone have a sample stack and DB that I can pull apa

Newbie SQLite and LC learing problems

2012-08-24 Thread Blair Lewis
I'm new to LC and am I am looking for help with using DB's with LC. I am coming from Filemaker and I am unable to find a decent tutorial on how to use SQLite that is either complete or useful. Does anyone have a sample stack and DB that I can pull apart to learn. I'm particularly having difficu