im having trouble displaying a blob field in a console game i made.
here is the function:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
int
look(void)
/* inspect current room */
{
short loc;
sqlite3_stmt *statement;
const char *tail;
chrptr=&player[usrnum];
loc = chrptr->location;
sprintf(sqlbuf,"select * from 'rooms' where rowid=%d limit 0,%d",loc,numroom);
if(sqlite_prepare_v2(database,sqlbuf,strlen(vdatmp),&statement,&tail)==SQLITE_OK)
{
while(sqlite3_step(statement)==SQLITE_ROW)
{
pmlt("\r%s\r",sqlite3_column_blob(statement,1));
outmlt(usrnum);
}
sqlite3_finalize(statement);
}
return(1);
}
|
it does everything i want it to except it adds spaces between each line of text.
when i originall wrote this game back in the 90's i used dbase V and had no problem displaying my memo fields, since porting it all over to sqlite it all works great with the exception of my memo fields printing all wierd.
example:
You're in a newly created room
==============================
you are in a newly created room.
a small road leads to the north.
there is a sign on a large oak tree.
prints like this:
You're in a newly created room
==============================
you are in a newly created room.
a small road leads to the north.
there is a sign on a large oak tree.
any help would be appreciated.