oops!... still having problems... sorry if I'm loud but there's the same syntax error in the debug file (attached)... I think there are no errors in the script, anyway, here is the code I'm using to make the query:
void CreateProfile() {
string table = "PlayerProfile"; //the name of the table
sql = "select * from " + table + ";";
doSql();
extractDB();
int count = getRecordcount();
PlayerID = (count+1);
PlayerMoney = 50000;
//set current player
CurrPlayer = PlayerID;
//make this player active
PlayerActive = 1;
//disable all other players
SetInactivePlayers();
sql = "insert into " + table + " (";
//fields
sql += "Player_id,";
sql += "Player_active,";
sql += "Player_name,";
sql += "Player_money,";
sql += "Player_gamemode,";
sql += "Settings_sound_sfxvolume,";
sql += "Settings_sound_gamevolume,";
sql += "Settings_sound_menuvolume,";
sql += "Settings_sound_track,";
sql += "Settings_display_arrows,";
sql += "Settings_display_map,";
sql += "Settings_display_speed,";
sql += "Settings_display_hud,";
sql += "Settings_controls_slide,";
sql += "Settings_controls_device,";
sql += "Car_CurrentCar,";
sql += "Car_SetupBrake,";
sql += "Car_SetupSpeed,";
sql += "Car_SetupAcc,";
sql += "Car_SetupReverse,";
sql += "Car_SetupBrakePower,";
sql += "Car_SetupFGrip,";
sql += "Car_SetupFGripLat,";
sql += "Car_SetupRGrip,";
sql += "Car_SetupRGripLat,";
sql += "Car_Owner1,";
sql += "Car_Owner2,";
sql += "Car_Owner3,";
sql += "Car_Owner4,";
sql += "Car_Owner5,";
sql += "Car_Owner6,";
sql += "Car_Owner7,";
sql += "Car_Active1,";
sql += "Car_Active2,";
sql += "Car_Active3,";
sql += "Car_Active4,";
sql += "Car_Active5,";
sql += "Car_Active6,";
sql += "Car_Active7,";
sql += "ArcadeCurrMoon,";
sql += "ArcadeCurrTrack,";
sql += "ArcadeCurrTrackMode,";
sql += "ArcadeCurrDifficulty,";
sql += "ArcadeMoonActive1,";
sql += "ArcadeMoonActive2,";
sql += "ArcadeMoonActive3,";
sql += "ArcadeMoonActive4,";
sql += "ArcadeMoonActive5,";
sql += "ArcadePosA01,";
sql += "ArcadePosA02,";
sql += "ArcadePosA03,";
sql += "ArcadePosA04,";
sql += "ArcadePosA05,";
sql += "ArcadePosA06,";
sql += "ArcadePosA07,";
sql += "ArcadePosA08,";
sql += "ArcadePosA09,";
sql += "ArcadePosA10,";
sql += "ArcadePosA11,";
sql += "ArcadePosA12,";
sql += "ArcadePosA13,";
sql += "ArcadePosA14,";
sql += "ArcadePosA15,";
sql += "ArcadePosB01,";
sql += "ArcadePosB02,";
sql += "ArcadePosB03,";
sql += "ArcadePosB04,";
sql += "ArcadePosB05,";
sql += "ArcadePosB06,";
sql += "ArcadePosB07,";
sql += "ArcadePosB08,";
sql += "ArcadePosB09,";
sql += "ArcadePosB10,";
sql += "ArcadePosB11,";
sql += "ArcadePosB12,";
sql += "ArcadePosB13,";
sql += "ArcadePosB14,";
sql += "ArcadePosB15";//<-- last field!!
sql += ") values (";
//values
sql += PlayerID + ",";
sql += "1,";
sql += "'" + PlayerName + "'" + ","; //strings fields must have "'"
sql += PlayerMoney + ",";
sql += PlayerGameMode + ",";
sql += settings_sound_sfx_volume + ",";
sql += settings_sound_game_volume + ",";
sql += settings_sound_menu_volume + ",";
sql += settings_sound_soundtrack + ",";
sql += settings_display_arrows + ",";
sql += settings_display_map + ",";
sql += settings_display_speed + ",";
sql += settings_display_hudop + ",";
sql += settings_controls_slide + ",";
sql += settings_controls_device + ",";
sql += car_current_car + ",";
sql += car_setup_brake + ",";
sql += car_setup_speed + ",";
sql += car_setup_acc + ",";
sql += car_setup_reverse + ",";
sql += car_setup_brakepower + ",";
sql += car_setup_fgrip + ",";
sql += car_setup_fgriplat + ",";
sql += car_setup_rgrip + ",";
sql += car_setup_rgriplat + ",";
sql += car_owner1 + ",";
sql += car_owner2 + ",";
sql += car_owner3 + ",";
sql += car_owner4 + ",";
sql += car_owner5 + ",";
sql += car_owner6 + ",";
sql += car_owner7 + ",";
sql += car_active1 + ",";
sql += car_active2 + ",";
sql += car_active3 + ",";
sql += car_active4 + ",";
sql += car_active5 + ",";
sql += car_active6 + ",";
sql += car_active7 + ",";
sql += ArcadeCurrMoon + ",";
sql += ArcadeCurrTrack + ",";
sql += ArcadeCurrTrackMode + ",";
sql += ArcadeCurrDifficulty + ",";
sql += ArcadeMoonActive1 + ",";
sql += ArcadeMoonActive2 + ",";
sql += ArcadeMoonActive3 + ",";
sql += ArcadeMoonActive4 + ",";
sql += ArcadeMoonActive5 + ",";
sql += ArcadePosA01 + ",";
sql += ArcadePosA02 + ",";
sql += ArcadePosA03 + ",";
sql += ArcadePosA04 + ",";
sql += ArcadePosA05 + ",";
sql += ArcadePosA06 + ",";
sql += ArcadePosA07 + ",";
sql += ArcadePosA08 + ",";
sql += ArcadePosA09 + ",";
sql += ArcadePosA10 + ",";
sql += ArcadePosA11 + ",";
sql += ArcadePosA12 + ",";
sql += ArcadePosA13 + ",";
sql += ArcadePosA14 + ",";
sql += ArcadePosA15 + ",";
sql += ArcadePosB01 + ",";
sql += ArcadePosB02 + ",";
sql += ArcadePosB03 + ",";
sql += ArcadePosB04 + ",";
sql += ArcadePosB05 + ",";
sql += ArcadePosB06 + ",";
sql += ArcadePosB07 + ",";
sql += ArcadePosB08 + ",";
sql += ArcadePosB09 + ",";
sql += ArcadePosB10 + ",";
sql += ArcadePosB11 + ",";
sql += ArcadePosB12 + ",";
sql += ArcadePosB13 + ",";
sql += ArcadePosB14 + ",";
sql += ArcadePosB15 + ");";//<-- last field!!
doSql();
}
also, I have the debugOn() function inactive (it's commented at iInitializing) but the debug file still appears in the 3dRad folder... is this usual?
thanks in advance!
RadSqLite.rar
