Valentina DB, SQLite and DBLib

[Mike Kerner]

The easiest way to try to do this (i.e. enforcing referential integrity,
maintain related tables, etc.), is to use triggers.  You have to tell the
DB what to do.  Even RDBMS's (4D is one I use all the time that comes to
mind) can't read your mind, but if you write triggers/stored
procedures/etc., it can at least do a lot of work for you automatically.


On Tue, Jul 2, 2013 at 6:47 AM, Pascal Lehner <tate83 at gmail.com> wrote:

> Hi everyone,
>
> Another rather n00b-ish question ;-)
>
> I have a SQLite database with about 15 tables. Some of them are
> obviously relational. Some of the tables will have a row added every
> 15 or 30 minutes, but only with 4-5 columns each, the others will be
> much smaller.
>
> I started to write my app using DBLib which works very nicely. I
> assumed that I have to handle the table-relations (update several
> fields in several tables if necessary) myself and remember to write
> the data everywhere where it is required.
>
> I installed Valentina Studio yesterday and see that Valentina actually
> can handle diagrams and automatically creates the connecting tables to
> handle m:m relations. Does that mean using the right command, I can
> also have the data automatically interlinked in these realtion tables?
>
> Now I'm wondering: Can I use Andre's DBLib to write the data to the
> database and get the relations handled automatically after I add some
> Valentina DB script to my stack? Or do I need to use the
> VDatabase-handles and probably loose the nice features like DBWhere
> from DBLIB? What would you do? Are there any VDatabase features that I
> just MUST have or use?
>
> I might also want to offer MySLQ and SQLite in the future for this app
> and make as less changes as possible.
>
> Best regards,
>
> Pascal
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."