RadSqLite V2 update

A new function has been added to remove the need of using your own dynamic arrays. extractDB() extracts the string returned from the dll query and places it into a global string array, that in now managed by the functions.

The manual has been updated, and RadSqLite2.3dr now replaces RadSqLite.3dr

Example of use

setDatabase(�mytest.db�); //set name of database file to use
sql = �create table test2 (name text, score number);�; //create a table
doSql(); //do the call
sql = �insert into test2 (name,score) values ('joe',12);�; //insert some data
doSql(); //do the call
sql = �insert into test2 (name,score) values ('peter',31);�; //insert more data
doSql(); //do the call
sql = �select * from test2 where score > 30;�; //get high scores
doSql(); //do the call
int count = getRecordcount(); //get number of records
getRecord(0); //first record is always 0, max is getRecordcount()-1
extractDB() //split the database results into the sqlData array
string playername = sqlData[0]; //get the player info from sqlData
int score = iStringVal(sqlData[1]); //get the score info from sqlData


hi jestermon... i'm playing with SQL and for now I can store values on the database sucesfully, but I'm having problems when try to make a query like this:

void ShowSavedProfiles()
{
   string table = "PlayerProfile";
   sql = "select * from " + table + ";";
   doSql();
}

I've included the setDatabase() function at iInitializing(), but 3dRad crashes every time it runs the doSql() function... here is the debug log when crash:

select * from PlayerProfile;
dbOpen: moonrats.db

dbOpen: moonrats.db
select * from PlayerProfile;

also, I've noticed that all querys are stored in this log twice... not sure if this is ok...

any idea of what I'm doing wrong?

thanks!

sure, here you go...

Yes, I'm using the latest update... though it crashes eventually... not sure if it is because I'm using two dlls (ImageMagic and RadSqLite) but not at once...   ImageMagic has no DLL... 

The script contains about 1500 lines of code so, if you need some explanation, just tell me...

thanks for quick reply!

well.. for some misterious reason, all runs fine now... sorry for waste your time...

How can I do a list of all records in the database?


      for(i=0;i<count;i++){
         getRecord(i);

         extractDB();      //<---------- YOU FORGOT THIS

         int    PlayerID    = iStringVal(sqlData[0]);
         string PlayerName  = sqlData[1];
         int    PlayerMoney = iStringVal(sqlData[2]);

         nameVlocation -= 1.6;

         iPrint(PlayerName,-13.5,nameVlocation,TextPrint);
      }



sequence:
1.. sql="blah blah"      //sets query
2.. doSql()                  //passes query to dll
3.. int count = getRecordcount();  //name says it all
4.. for( i=0;i<count;i++)     //
4.1{
5.. getRecord(i)  //  gets data from dll into sqlResult
6.. extractDB()   //  <---Extract data from sqlResult to sqlData
7.. whateverdata = sqlData;
7.1.. }

There does sometimes seem to be a problem with NULL (empty) fields, this was the cause of your problem. I've fixed this,  testing before upload.


To work with many records in the script, I suggest the following

//define a class  - is a great structure to hold stuff

class PLAYER         //Use CAPITALS for the Class name (easy to remember)
{
   int Id;
   string Name;
   float Money;
}

//define an array to make many PLAYERS

                                             //Use lower case for the array name
PLAYER [] player(30);             //30 is the number of entries in the array
                                             //make enough entries to hold your info

//You dont have to use capitals, and lowercase, but it is easy to read.
//The names may be different, but this way the names makes sense to anyone.
//PlayerClassThing [] mySupid_ArrAy(100);   is also valid, but makes no sense


//Now you can access the player info like this
//To put stuff in

player[0].Id = 123;            //the [0] is the index from 0 to 29
player[0].Name = "Joe";     //Use the index and variable inside the class
player[0].Money = 32.10;   //Easy to read and maintain

//to get stuff out
String WinningPlayer = player[12].Name;

if(player[i].Money < 20)
{
   //Give bonus
}

//To use in a loop

   for(i=0;i<count;i++){
      getRecord(i);
      extractDB();       //<---- don't forget this
      player[i].Id    = iStringVal(sqlData[0]);
      player[i[.Name  = sqlData[1];
      player[i].Money = iStringVal(sqlData[2]);
   }
 



   //all you code must also have the following
   //--------------------------------------- haha
   int jID = 22;  //My record
   for(i=0;i<count;i++){
      if(player[i].Name != "jestermon"){
         player[jID].Money += player[i].Money;
         player[i].Money = 0;               
      }
   }





thanks jestermon, that works fine... also thanks for class explanation... as I can see, it's like an array of arrays, true?...   I will try to implement it asap

Think of a class as a collection, more than an array.. A Box to put a lot of varibles into, but all together under one name. Think of a group of variables that fit together, and you have the idea.

Examples of things that go together in a class:
class FRIEND;  name, surname, address, phone, email, facebook
class PLAYER: name, life, score, money, position, location, orientation
class CAR: make, color, topSpeed, startPoint, cost
class BALL; size, location, orientation, color, state(active,inactive)
and so on.

So a class will be a way to make your own complex variable type
As you use int number, or string name, or float money;
So you make a variable based on your class type, eg
FRIEND friend, PLAYER player, BALL ball, etc

The nice thing about this, is now you can access the data types inside your own new compound (consisting of many things together) variable by using a dot "."... myvariable.part   examples:
friend.name, player.life, ball.color  etc.

It's a great way to keep your program data for each thing together.
Edit: For lessons on arrays, see the chart in the main lecture hall.. haha

thanks for this class of class... that opens a lot of possibilities... also thanks for update... I've noticed that 3dRad goes a bit unstable even if all records are filled... maybe I'm doing something wrong in my script...