forum.vdsworld.com Forum Index forum.vdsworld.com
Visit VDSWORLD.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


Database DSU
Goto page 1, 2  Next
 
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> Visual DialogScript 5 Units
View previous topic :: View next topic  
Author Message
Skit3000
Admin Team


Joined: 11 May 2002
Posts: 2166
Location: The Netherlands

PostPosted: Tue Jan 20, 2004 4:35 pm    Post subject: Database DSU Reply with quote

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>
 



Database.zip
 Description:
The Database DSU file, complete with an example and a help file.

Download
 Filename:  Database.zip
 Filesize:  36.61 KB
 Downloaded:  2404 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
View user's profile Send private message
Boo
Valued Contributor
Valued Contributor


Joined: 31 Oct 2003
Posts: 599
Location: Gulf Breeze, Florida USA

PostPosted: Tue Jan 20, 2004 4:38 pm    Post subject: Reply with quote

Cool! This will be very useful!
Back to top
View user's profile Send private message
LiquidCode
Moderator Team


Joined: 05 Dec 2000
Posts: 1751
Location: Space and Time

PostPosted: Wed Jan 21, 2004 1:04 am    Post subject: Reply with quote

Yes. This DSU will be very userfull. If you need a beta tester, let me know. Wink
_________________
Chris
Http://theblindhouse.com
Back to top
View user's profile Send private message Send e-mail Visit poster's website
SK
Newbie


Joined: 29 Dec 2003
Posts: 14

PostPosted: Wed Jan 21, 2004 10:15 am    Post subject: Reply with quote

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 Embarassed

_________________
SK
Back to top
View user's profile Send private message Send e-mail
Vic D'Elfant
Past Contributor
Past Contributor


Joined: 26 Jun 2002
Posts: 673
Location: The Netherlands

PostPosted: Wed Jan 21, 2004 10:19 am    Post subject: Reply with quote

SK wrote:
...sorry for my not-so-good english Embarassed

Don't worry about that... we all make typos here Very Happy
And I probably make the most of them Wink

Vic

_________________
phpBB Development Team
Back to top
View user's profile Send private message Visit poster's website
Serge
Professional Member
Professional Member


Joined: 04 Mar 2002
Posts: 1480
Location: Australia

PostPosted: Wed Jan 21, 2004 12:02 pm    Post subject: Reply with quote

sounds like a great addition to the vds repertoire, skit

serge

_________________
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Skit3000
Admin Team


Joined: 11 May 2002
Posts: 2166
Location: The Netherlands

PostPosted: Wed Jan 21, 2004 4:17 pm    Post subject: Reply with quote

SK, that's a good idea, but I don't think I can implent that right now... Sad 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... Smile
_________________
[ Add autocomplete functionality to your VDS IDE windows! ]
Voor Nederlandse beginners met VDS: bekijk ook eens deze tutorial!
Back to top
View user's profile Send private message
SK
Newbie


Joined: 29 Dec 2003
Posts: 14

PostPosted: Thu Jan 22, 2004 7:39 am    Post subject: Reply with quote

Yeah, you are right, at some point you have to say 'stop', before you are entering to 'infinite loop' with improvments & additional features... Very Happy Anyway i belive it will be a great unit...

If you need a beta testers - count me too.

_________________
SK
Back to top
View user's profile Send private message Send e-mail
Skit3000
Admin Team


Joined: 11 May 2002
Posts: 2166
Location: The Netherlands

PostPosted: Mon Feb 16, 2004 8:45 pm    Post subject: Reply with quote

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
View user's profile Send private message
Aslan
Valued Contributor
Valued Contributor


Joined: 31 May 2001
Posts: 589
Location: Memphis, TN USA

PostPosted: Mon Jan 10, 2005 4:07 am    Post subject: Reply with quote

I can't find the Database DSU nor does the link to it work.

Is it still available?
Back to top
View user's profile Send private message Send e-mail
JRoza
Contributor
Contributor


Joined: 17 Aug 2003
Posts: 182
Location: Netherlands

PostPosted: Mon Jan 10, 2005 10:19 am    Post subject: Reply with quote

Speaking of beta-testers for database.dsu ........
For some months now I'm already making a simple yet versatile database program which uses database.dsu as its engine.
This dsu works great!

The program allows users to define their own databse structures (with a max. of 20 fields per database).

What I miss in the database.dsu is the ability to define the structure of the database, so I programmed that bit myself.

Attached you can see what can be achieved by this unit (and those of Codescript and Dr Dread of course).

Hope this demo is a good example for Skits unit.


Laughing
Jan



SilentBase.zip
 Description:

Download
 Filename:  SilentBase.zip
 Filesize:  396.56 KB
 Downloaded:  1933 Time(s)

Back to top
View user's profile Send private message Visit poster's website
JRoza
Contributor
Contributor


Joined: 17 Aug 2003
Posts: 182
Location: Netherlands

PostPosted: Mon Jan 10, 2005 10:24 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
Skit3000
Admin Team


Joined: 11 May 2002
Posts: 2166
Location: The Netherlands

PostPosted: Mon Jan 10, 2005 11:42 am    Post subject: Reply with quote

Woh Jan, that's a real good example!

Aslan, you are right that the DSU can't be found at VDSWORLD itself anymore, I can't seem to upload it properly... Sad But, I have uploaded the DSU file with the first post in this topic, so you will be able to download it there... Smile

http://forum.vdsworld.com/download.php?id=55

_________________
[ Add autocomplete functionality to your VDS IDE windows! ]
Voor Nederlandse beginners met VDS: bekijk ook eens deze tutorial!
Back to top
View user's profile Send private message
JRoza
Contributor
Contributor


Joined: 17 Aug 2003
Posts: 182
Location: Netherlands

PostPosted: Mon Jan 10, 2005 11:47 am    Post subject: Reply with quote

Thanks Skit!

But always remember it's the tools that make the programmer and you made the tool.

Razz

Jan
Back to top
View user's profile Send private message Visit poster's website
Dr. Dread
Professional Member
Professional Member


Joined: 03 Aug 2001
Posts: 1065
Location: Copenhagen, Denmark

PostPosted: Tue Jan 11, 2005 7:33 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> Visual DialogScript 5 Units All times are GMT
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
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

Twitter@vdsworld       RSS

Powered by phpBB © 2001, 2005 phpBB Group