1. eu data base enhancement

Rob, please consider on your EU date base the addition of a
'db_table_rename'  function. We can delete and add but not rename. This
would be quite useful at the end of the year to delete last year's history
table, rename this year's to last years and create this years again. this
way you can roll over history without having to read and write lots of
record  then erase..... what do you think? Inconvinent/mistaken names can be
corrected also.

...george

new topic     » topic index » view message » categorize

2. eu data base enhancement

Rob, continueing it could be used as follow.

db_erase("ar_history_last_year")
db_rename("ar_history_this_year", "ar_history_last_year")
db_create("ar_history_this_year")

this would save a lot of reads and writes...

...george

new topic     » goto parent     » topic index » view message » categorize

3. Re: eu data base enhancement

George Walters writes:
> Rob, please consider on your EU date base the addition of a
> 'db_table_rename'  function. 

Thanks for the suggestion.
It sounds reasonable, and not too hard.

Regards,
   Rob Craig
   Rapid Deployment Software
   http://www.RapidEuphoria.com

new topic     » goto parent     » topic index » view message » categorize

4. Re: eu data base enhancement

Why Have Rob do this?

Programming = codeing 

'not cut and pasting or useing someone elses material all the time.

Euman
euman at bellsouth.net

> Rob, please consider on your EU date base the addition of a
> 'db_table_rename'  function. We can delete and add but not rename. This
> would be quite useful at the end of the year to delete last year's history
> table, rename this year's to last years and create this years again. this
> way you can roll over history without having to read and write lots of
> record  then erase..... what do you think? Inconvinent/mistaken names can be
> corrected also.
> 
> ...george

new topic     » goto parent     » topic index » view message » categorize

5. Re: eu data base enhancement

On 29 Aug 2001, at 13:37, euman at bellsouth.net wrote:

> 
> Why Have Rob do this?
> 
> Programming = codeing 
> 
> 'not cut and pasting or useing someone elses material all the time.

Arrgg, you are right, here i have been using RDS's programming language 
instead of writing my own. And on an OS i didn't write too. Shoot, the puter 
boots with a bios i didn't write! We should have a totally new language written 
everytime you or i or David Cuny or Bernie or Derek or Chris or Igor writes a 
new include file, which should be scrambled and shrouded! I wonder how 
many new unique ways there are to reverse engineer puts(),, using Rob's 
code to print something to the screen has got to be the worst of laziness.


> Euman
> euman at bellsouth.net
> 
> > Rob, please consider on your EU date base the addition of a
> > 'db_table_rename'  function. We can delete and add but not rename. This
> > would be quite useful at the end of the year to delete last year's history
> > table, rename this year's to last years and create this years again. this
> > way
> > you can roll over history without having to read and write lots of record 
> > then erase..... what do you think? Inconvinent/mistaken names can be
> > corrected
> > also.

I agree, this is a basic functionality. Again, if we had dostring() in Eu, we 
could put code into the database, and possibly have it execute when read. 
To me, this is also basic functionality,, it's in other languages and database 
programs. Like this database entry for "time", for example, which works 
nicely:

time= <exec> /msg %haldef.chan <mirccolor12> The date and time here is: 
<mirccolor2> $gettok($asctime,1-3,32) $gettok($asctime,5,32) 
<mirccolor12> $atime

And i wrote it myself, euman!

Kat

new topic     » goto parent     » topic index » view message » categorize

Search



Quick Links

User menu

Not signed in.

Misc Menu