internal SQL queries
Viktoras Didziulis
viktoras at ekoinf.net
Sat Jul 22 00:37:11 EDT 2006
Thanks for your replies ! I was asking because I used to create and
SQL-query relational structures from delimited text tables in some projects.
But this is only possible through ODBC text drivers and has a limited
implementation of SQL. But I expected an existing functionality of Rev like
that of PerlDBD:RAM where user can read and preload any arbitrary files ,
arrays, hashes and data structures into RAM and do SQL queries nearly at a
speed of light. This would be a very useful option in the Rev too ;-)
Thanks again and all the best!
Viktoras
-------Original Message-------
From: Dan Shafer
Date: 07/22/06 04:01:03
To: How to use Revolution
Subject: Re: internal SQL queries
SQL is designed ONLY to query databases. As Mark says, you can use SQLite
and the database files it creates are not standard SQL files, but you could
not use SQL queries, e.g., on a straight text file with arbitrary
delimiters.
On 7/21/06, Mark Schonewille <m.schonewille at economy-x-talk.com> wrote:
>
> With AltSqlite you can store data in a local file, without database
> engine etc.
>
> Best,
>
> Mark
>
> --
>
> Economy-x-Talk
> Consultancy and Software Engineering
> http://economy-x-talk.com
> http://www.salery.biz
>
> Download ErrorLib at http://economy-x-talk.com/developers.html and
> get full control of error handling in Revolution.
>
>
>
> Op 21-jul-2006, om 22:01 heeft Viktoras Didziulis het volgende
> geschreven:
>
> > Dear group,
> >
> > is it possible to query [tab] delimited data stored in fields or
> > containers
> > within a stack using SQL? e.g. without any external database engine or
> > database files or connections...
> >
> > All the best!
> > Viktoras
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Dan Shafer, Information Product Consultant and Author
http://www.shafermedia.com
Get my book, "Revolution: Software at the Speed of Thought"
>From http://www.shafermediastore.com/tech_main.html
_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
More information about the use-livecode
mailing list