15.04.2013, 01:10
hi guys got a wee bit of an issue. I'm not fantastically familliar with SQLite in pawn and This kinda works but not really...
basically on inspection the GM hangs up at 56 ID's written to the database then it just stops dead.
What I don't need is a diatribe on why i should use MySQL etc and anyone that does that gets negative rep...
The only thing i would like any advice on is why it's hanging - I'm going to assume it's due to me doing this inside a loop. Anyone with superior knowledge on the issue of SQLite please feel free to make suggestions or comments.
before anyone asks I've gone through multiple tutorials and I think my query string is formatted correctly - I've also looked through a number of tutorials on SQLite and can't really see an issue.
Any helpful comments are much appreciated, Thanks Guys!
pawn Код:
new Query[256];
for(new varID=1;varID<=2001;varID++) {
format(Query,sizeof(Query), "INSERT INTO `VEHICLES` (`LINEIDENT`,`VALID`, `INFO`) VALUES('%d', '0','invalid')", varID);
db_query(Database, Query);
}
What I don't need is a diatribe on why i should use MySQL etc and anyone that does that gets negative rep...
The only thing i would like any advice on is why it's hanging - I'm going to assume it's due to me doing this inside a loop. Anyone with superior knowledge on the issue of SQLite please feel free to make suggestions or comments.
before anyone asks I've gone through multiple tutorials and I think my query string is formatted correctly - I've also looked through a number of tutorials on SQLite and can't really see an issue.
Any helpful comments are much appreciated, Thanks Guys!