Review the polls post, to see the origins of this fun little tool
http://www.3drad.com/forum/index.php?topic=4486.msg36780#msg36780
This is a fully working little database using 3D Rad. There is a small 483k dll that has sqLite built in, that provides full sql database management. no more text files.
It's lightning fast, and extremely powerful.
This is the demo release in a compiled project. As soon as the poll for this project closes (in 3 days of this posting), I'll release the source for the demo, as well as full instructions on how to use this fun toy.
To get you started (for the non-sql guys), you can type in the following commands to test it.
insert into test (name,surname) values ('Albert','Einstein');
insert into test (name,surname) values ('Doctor','Dolittle');
select from * from test;
create table players (name char(30), score char(10));
insert into players (name,score) values ('me','1000');
insert into players (name,score) values ('you','200');
select * from players;
select * from players where name = 'you';
delete from players where name = 'me';
select * from players;
drop table players;
That should be enough to get you started
Have fun.
Edit: for sql-guy... All data is stored as char(xxx) in this demo. numerics, blobs and other stores will be explained in the manual
hard coded limitations.(for game use). 1000chars per record, 500 max row reply for selects, 2048 length for sql requests... only 22 lines for display in 3D Rad, if you go over that, the Rad may fall over... remember this is just a demo.
http://www.3drad.com/forum/index.php?topic=4486.msg36780#msg36780
This is a fully working little database using 3D Rad. There is a small 483k dll that has sqLite built in, that provides full sql database management. no more text files.
It's lightning fast, and extremely powerful.
This is the demo release in a compiled project. As soon as the poll for this project closes (in 3 days of this posting), I'll release the source for the demo, as well as full instructions on how to use this fun toy.
To get you started (for the non-sql guys), you can type in the following commands to test it.
insert into test (name,surname) values ('Albert','Einstein');
insert into test (name,surname) values ('Doctor','Dolittle');
select from * from test;
create table players (name char(30), score char(10));
insert into players (name,score) values ('me','1000');
insert into players (name,score) values ('you','200');
select * from players;
select * from players where name = 'you';
delete from players where name = 'me';
select * from players;
drop table players;
That should be enough to get you started
Have fun.
Edit: for sql-guy... All data is stored as char(xxx) in this demo. numerics, blobs and other stores will be explained in the manual
hard coded limitations.(for game use). 1000chars per record, 500 max row reply for selects, 2048 length for sql requests... only 22 lines for display in 3D Rad, if you go over that, the Rad may fall over... remember this is just a demo.