Re: filling a db on CD, what happens?

2008-02-09 Thread Kay C Lan
On Feb 9, 2008 2:33 PM, Ruslan Zasukhin <[EMAIL PROTECTED]> wrote: > > Also we have meet even more complex ideas, when play a third db which is > online under Valentina Server. > Hadn't thought that far in advance but good to know that such flexibility is possible. Thanks ___

Re: filling a db on CD, what happens?

2008-02-08 Thread Ruslan Zasukhin
On 9/2/08 6:04 AM, "Kay C Lan" <[EMAIL PROTECTED]> wrote: Hi Kay, > On Feb 7, 2008 2:02 PM, Ruslan Zasukhin <[EMAIL PROTECTED]> wrote: > >> >> In general case Databases (w.g. SqlLite or Valentina) will not allow you >> do >> this on CD. You will get exception/error on the first attempt to do >>

Re: filling a db on CD, what happens?

2008-02-08 Thread Kay C Lan
On Feb 7, 2008 2:02 PM, Ruslan Zasukhin <[EMAIL PROTECTED]> wrote: > > In general case Databases (w.g. SqlLite or Valentina) will not allow you > do > this on CD. You will get exception/error on the first attempt to do > INSERT/UPDATE/DELETE ... CREATE/ALTER TABLE > But what about a case where A

Re: AW: AW: filling a db on CD, what happens?

2008-02-07 Thread Andre Garzia
Oops... my bad... :D On 2/6/08, Luis <[EMAIL PROTECTED]> wrote: > That'd be Structured Query Language, don't be that kind to it... > > Cheers, > > Luis. > > > Andre Garzia wrote: > > Tiemo, > > > > I've been using both RDBMS and flat files. A quick opinion is that > > with SQL you don't need to re

AW: filling a db on CD, what happens?

2008-02-07 Thread Tiemo Hollmann TB
n- > [EMAIL PROTECTED] Im Auftrag von viktoras didziulis > Gesendet: Donnerstag, 7. Februar 2008 08:44 > An: How to use Revolution > Betreff: Re: filling a db on CD, what happens? > > what about storing data to an external database on a remote server ?.. > Or is the data too user s

Re: filling a db on CD, what happens?

2008-02-06 Thread viktoras didziulis
what about storing data to an external database on a remote server ?.. Or is the data too user specific or privacy sensitive (or how is it called correctly in English?..) and there is no point to save it at all? What about using usb flashdrive instead of CD ? Or simply putting the application o

Re: filling a db on CD, what happens?

2008-02-06 Thread Ruslan Zasukhin
On 7/2/08 8:15 AM, "Joe Lewis Wilkins" <[EMAIL PROTECTED]> wrote: > Question: If you were to use a Writable CD would it be possible to > save the Data? No :-) -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information h

Re: filling a db on CD, what happens?

2008-02-06 Thread Joe Lewis Wilkins
Question: If you were to use a Writable CD would it be possible to save the Data? Joe Wilkins On Feb 6, 2008, at 10:02 PM, Ruslan Zasukhin wrote: On 6/2/08 7:32 PM, "Derek Bump" <[EMAIL PROTECTED]> wrote: Hi All, In general case Databases (w.g. SqlLite or Valentina) will not allow you do

Re: filling a db on CD, what happens?

2008-02-06 Thread Ruslan Zasukhin
On 6/2/08 7:32 PM, "Derek Bump" <[EMAIL PROTECTED]> wrote: Hi All, In general case Databases (w.g. SqlLite or Valentina) will not allow you do this on CD. You will get exception/error on the first attempt to do INSERT/UPDATE/DELETE ... CREATE/ALTER TABLE In the same time, you can with Valentina

Re: AW: AW: filling a db on CD, what happens?

2008-02-06 Thread Luis
That'd be Structured Query Language, don't be that kind to it... Cheers, Luis. Andre Garzia wrote: Tiemo, I've been using both RDBMS and flat files. A quick opinion is that with SQL you don't need to reinvent the wheel and this is specially good when you're going to do cross references and s

Re: AW: AW: AW: filling a db on CD, what happens?

2008-02-06 Thread Derek Bump
Tiemo, When it comes to huge databases with records in the thousands then yes, I do resort to other database engines. But as of yet, I have not been involved in projects that large. Most of my projects involve small databases, usually with records well under 1,000. So flat-file is the way

Re: AW: AW: filling a db on CD, what happens?

2008-02-06 Thread Andre Garzia
Tiemo, I've been using both RDBMS and flat files. A quick opinion is that with SQL you don't need to reinvent the wheel and this is specially good when you're going to do cross references and searching. SQL stands for Simple Query Language, it's really easy to make queries with SQL. With flat fil

AW: AW: AW: filling a db on CD, what happens?

2008-02-06 Thread Tiemo Hollmann TB
Hi Derek, > > Like I said though, it depends entire upon the type of database you are > working with. I don't use SQL as I find it to be rather bulky. I use > Flat Files, and I write all of my own database handlers, so my coding is > not dependent on SQL or some other type of database and it's

Re: AW: AW: filling a db on CD, what happens?

2008-02-06 Thread Derek Bump
Tiemo, It depends on how the Database is handled. You will have to either test it out, or read the documentation for the database type you are working with. The other solutions presented are definitely the best way to go. Create your "default" database and burn it to CD. When the program

AW: AW: filling a db on CD, what happens?

2008-02-06 Thread Tiemo Hollmann TB
Hi Derek, > When you open a file or program, it is placed into memory. From there, > you can fill variables, fields, properties, etc. You just can't save > those changes back to the file on the CD. yes, but isn't this the same with a database, as long, as I don't want to save the changes? Or i

Re: AW: filling a db on CD, what happens?

2008-02-06 Thread Derek Bump
ble on CD and what I wouldn't need. Thanks Tiemo -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:use-revolution- [EMAIL PROTECTED] Im Auftrag von Eric Chatonet Gesendet: Mittwoch, 6. Februar 2008 12:19 An: How to use Revolution Betreff: Re: filling a db on CD, what happens? Hi

AW: filling a db on CD, what happens?

2008-02-06 Thread Tiemo Hollmann TB
d. Thanks Tiemo > -Ursprüngliche Nachricht- > Von: [EMAIL PROTECTED] [mailto:use-revolution- > [EMAIL PROTECTED] Im Auftrag von Eric Chatonet > Gesendet: Mittwoch, 6. Februar 2008 12:19 > An: How to use Revolution > Betreff: Re: filling a db on CD, what happens? > >

Re: filling a db on CD, what happens?

2008-02-06 Thread Eric Chatonet
Hi Tiemo, A CD is read-only so you can't modify any file on it. But you can copy a file to the user HD in the temporary folder, use and modify it and delete it when finished. Le 6 févr. 08 à 12:01, Tiemo Hollmann TB a écrit : Hello, perhaps a dumb question, I havn't worked with DBs yet. Fo

filling a db on CD, what happens?

2008-02-06 Thread Tiemo Hollmann TB
Hello, perhaps a dumb question, I havn't worked with DBs yet. Following scenario: - running a rev app with a sqlite db from CD - delivering the CD with an empty db, all datas kept "hidden" in a stack - filling the db with the stack datas when launching the app -