Hyroshima Posted November 3, 2018 Group: Members Topic Count: 34 Topics Per Day: 0.01 Content Count: 159 Reputation: 58 Joined: 07/11/14 Last Seen: 17 hours ago Share Posted November 3, 2018 Hello again! xD I'm having a problem when using the SQL SHOW command. I created two columns in the login table and using the command below displays the following error: query_sql "SHOW COLUMNS FROM `login` LIKE 'magic_shop%'",.@rtn$; return getarraysize(.@rtn$); ERRO: Thank you very much xD Quote Link to comment Share on other sites More sharing options...
0 Emistry Posted November 3, 2018 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10013 Reputation: 2346 Joined: 10/28/11 Last Seen: April 6 Share Posted November 3, 2018 it return more than 1 field. you need to provide the array to store other fields that returned from the query. query_sql("SHOW COLUMNS FROM `login` LIKE 'magic_shop%'", .@field$, .@type$, .@null$, .@key$, .@default$, .@extra$); return getarraysize(.@field$); 1 Quote Link to comment Share on other sites More sharing options...
0 Hyroshima Posted November 3, 2018 Group: Members Topic Count: 34 Topics Per Day: 0.01 Content Count: 159 Reputation: 58 Joined: 07/11/14 Last Seen: 17 hours ago Author Share Posted November 3, 2018 3 hours ago, Emistry said: it return more than 1 field. you need to provide the array to store other fields that returned from the query. query_sql("SHOW COLUMNS FROM `login` LIKE 'magic_shop%'", .@field$, .@type$, .@null$, .@key$, .@default$, .@extra$); return getarraysize(.@field$); Thanks again Emistry, I did not know I needed to specify the other column outputs. Quote Link to comment Share on other sites More sharing options...
Question
Hyroshima
Hello again! xD
I'm having a problem when using the SQL SHOW command.
I created two columns in the login table and using the command below displays the following error:
ERRO:
Thank you very much xD
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.