View previous topic :: View next topic |
Author |
Message |
Skit3000 Admin Team
Joined: 11 May 2002 Posts: 2166 Location: The Netherlands
|
Posted: Tue Jan 20, 2004 4:35 pm Post subject: Database DSU |
|
|
I am making a (little?) DSU which can handle text based databases. Below, there is a list with all current functions and the functions yet to come. Does anybody have any suggestions? It will be a free DSU, which can be used next to the "list" command.
Code: |
Commands:
database load,<database number>,<file>
database save,<database number>,<file>
database refresh,<database number>,<file>
database close,<database number>
database insert,<database number>,<line number>,<value>
database update,row,<database number>,<line number>,<column>,<value>
database update,column,<database number>,<line number>,<column>,<value>
database add,<database number>,<string>
database new,<database number>,<header1@tab()header2@tab()header3@tab()etc.>
database clear,<database number>
Functions:
@database(item,<database number>,<line number>,{<column>})
@database(count,<database number>)
@database(text,<database number>,{<column>})
@database(headers,<database number>)
Todo:
- @database(match,row,<database number>,<value>,{EXACT})
- @database(match,column,<database number>,<column>,<value>,{EXACT})
- @database(query,<database number>,<header>=<value> AND <header>=<value>)
- database delete,<database number>,<line number>
- database convert,<database number>,<current seperator>,<new seperator>
|
Description: |
The Database DSU file, complete with an example and a help file. |
|
Download |
Filename: |
Database.zip |
Filesize: |
36.61 KB |
Downloaded: |
2416 Time(s) |
_________________ [ Add autocomplete functionality to your VDS IDE windows! ]
Voor Nederlandse beginners met VDS: bekijk ook eens deze tutorial!
Last edited by Skit3000 on Mon Jan 10, 2005 11:36 am; edited 1 time in total |
|
Back to top |
|
|
Boo Valued Contributor
Joined: 31 Oct 2003 Posts: 599 Location: Gulf Breeze, Florida USA
|
Posted: Tue Jan 20, 2004 4:38 pm Post subject: |
|
|
Cool! This will be very useful!
|
|
Back to top |
|
|
LiquidCode Moderator Team
Joined: 05 Dec 2000 Posts: 1751 Location: Space and Time
|
Posted: Wed Jan 21, 2004 1:04 am Post subject: |
|
|
Yes. This DSU will be very userfull. If you need a beta tester, let me know.
_________________ Chris
Http://theblindhouse.com |
|
Back to top |
|
|
SK Newbie
Joined: 29 Dec 2003 Posts: 14
|
Posted: Wed Jan 21, 2004 10:15 am Post subject: |
|
|
Looks great!
Just suggestion about following commands:
Code: | database new,<database number>,<header1@tab()header2@tab()header3@tab()etc.>
database convert,<database number>,<current seperator>,<new seperator> |
Maybe it is a good idea to define separator previously to database creation:
Code: | database sep,<database number>,@tab()
database new,<database number>,<header1>,<header2>,<header3> |
Than you can embed it to database file:
Code: | format:
sep = @tab()
head:
header1
header2
header3
.
.
.
data:
.
.
.
|
And with function
Code: | @database(getsep,<database number>) |
you could obtain a database separator.
...sorry for my not-so-good english
_________________ SK |
|
Back to top |
|
|
Vic D'Elfant Past Contributor
Joined: 26 Jun 2002 Posts: 673 Location: The Netherlands
|
Posted: Wed Jan 21, 2004 10:19 am Post subject: |
|
|
SK wrote: | ...sorry for my not-so-good english |
Don't worry about that... we all make typos here
And I probably make the most of them
Vic
_________________ phpBB Development Team |
|
Back to top |
|
|
Serge Professional Member
Joined: 04 Mar 2002 Posts: 1480 Location: Australia
|
Posted: Wed Jan 21, 2004 12:02 pm Post subject: |
|
|
sounds like a great addition to the vds repertoire, skit
serge
_________________
|
|
Back to top |
|
|
Skit3000 Admin Team
Joined: 11 May 2002 Posts: 2166 Location: The Netherlands
|
Posted: Wed Jan 21, 2004 4:17 pm Post subject: |
|
|
SK, that's a good idea, but I don't think I can implent that right now... I have already made a lot of 'repeat' and 'while' loops, which I can't really change anymore. The "convert" parameter will only be there to convert databases from, for example, Microsoft Outlook, to the "VDS Table Element" format...
_________________ [ Add autocomplete functionality to your VDS IDE windows! ]
Voor Nederlandse beginners met VDS: bekijk ook eens deze tutorial! |
|
Back to top |
|
|
SK Newbie
Joined: 29 Dec 2003 Posts: 14
|
Posted: Thu Jan 22, 2004 7:39 am Post subject: |
|
|
Yeah, you are right, at some point you have to say 'stop', before you are entering to 'infinite loop' with improvments & additional features... Anyway i belive it will be a great unit...
If you need a beta testers - count me too.
_________________ SK |
|
Back to top |
|
|
Skit3000 Admin Team
Joined: 11 May 2002 Posts: 2166 Location: The Netherlands
|
Posted: Mon Feb 16, 2004 8:45 pm Post subject: |
|
|
I just uploaded the DSU file. Here is a list with all commands and functions:
Code: | database new,<database number>,<header1@tab()header2@tab()etc.>
database load,<database number>,<file>
database save,<database number>,<file>,{<compressed>}
database refresh,<database number>,<file>
database clear,<database number>
database close,<database number>
database add,<database number>,<string>
database insert,<database number>,<line number>,<value>
database update,line,<database number>,<line number>,<value>
database update,column,<database number>,<line number>,<column>,<value>
database delete,<database number>,<line number>
database convert,<database number>,<current separator>,<new separator>
@database(item,<database number>,<line number>,{<column>})
@database(text,<database number>,{<column>})
@database(count,<database number>)
@database(headers,<database number>)
@database(match,row,<database number>,<string>,{<exact>})
@database(match,column,<database number>,<column>,<string>,{<exact>}) |
You can download the Database DSU [ here ].
_________________ [ Add autocomplete functionality to your VDS IDE windows! ]
Voor Nederlandse beginners met VDS: bekijk ook eens deze tutorial!
Last edited by Skit3000 on Mon Jan 10, 2005 11:38 am; edited 1 time in total |
|
Back to top |
|
|
Aslan Valued Contributor
Joined: 31 May 2001 Posts: 589 Location: Memphis, TN USA
|
Posted: Mon Jan 10, 2005 4:07 am Post subject: |
|
|
I can't find the Database DSU nor does the link to it work.
Is it still available?
|
|
Back to top |
|
|
JRoza Contributor
Joined: 17 Aug 2003 Posts: 182 Location: Netherlands
|
|
Back to top |
|
|
JRoza Contributor
Joined: 17 Aug 2003 Posts: 182 Location: Netherlands
|
Posted: Mon Jan 10, 2005 10:24 am Post subject: |
|
|
I see from your summary that what I was missing is now already in the database.dsu (the NEW command option).
So i'm going to be very happy soon!
|
|
Back to top |
|
|
Skit3000 Admin Team
Joined: 11 May 2002 Posts: 2166 Location: The Netherlands
|
|
Back to top |
|
|
JRoza Contributor
Joined: 17 Aug 2003 Posts: 182 Location: Netherlands
|
Posted: Mon Jan 10, 2005 11:47 am Post subject: |
|
|
Thanks Skit!
But always remember it's the tools that make the programmer and you made the tool.
Jan
|
|
Back to top |
|
|
Dr. Dread Professional Member
Joined: 03 Aug 2001 Posts: 1065 Location: Copenhagen, Denmark
|
Posted: Tue Jan 11, 2005 7:33 am Post subject: |
|
|
Hey Jan!
Tried to check out your proggie but I just get a strange debug message from Windows (bad English too, he-he) :
"The instruction at ""xxxxxxx" referred memory at "xxxxxxx". Memory could not "written".
Greetz
Dread
_________________ ~~ Alcohol and calculus don't mix... Don't drink and derive! ~~
String.DLL * advanced string processing |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You can attach files in this forum You can download files in this forum
|
|