- Код: Выделить всё
Player = InputBox("", "Enter Player Nick")
Set rs = db.Execute("SELECT game_players.real_player_id AS PID " & _
"FROM players INNER JOIN game_players ON players.player_id = game_players.player_id " & _
"Where (((players.screen_name) = "" & Player & "")) " & _
"GROUP BY game_players.real_player_id;")
MsgBox rs.Fields("PID")
По разному пробовал, выдает разные ошибки. В общем запрос работает в таком виде
- Код: Выделить всё
'Player = InputBox("", "Enter Player Nick")
Set rs = db.Execute("SELECT game_players.real_player_id AS PID " & _
"FROM players INNER JOIN game_players ON players.player_id = game_players.player_id " & _
"Where (((players.screen_name) = ""Scrolt3"")) " & _
"GROUP BY game_players.real_player_id;")
MsgBox rs.Fields("PID")
Никак не хочет в первый запрос вставить текстовую переменную. Что тут с синтаксисом? Я не профи, подскажите
