The following command:
cmd.CommandText = "create temporary table temp" & _
" select tool_id, min(start_time) as start_time, end_time, user_id " & _
" from tool_reservations" & _
" where start_time > Now()" & _
" group by tool_id" & _
" order by start_time asc;" & _
" select a.id, a.name, a.max_users, a.current_users, a.control_type, a.enabled, a.control_enabled, a.property_string, temp.start_time, temp.end_time, temp.user_id" & _
" from tools a" & _
" left join temp" & _
" on temp.tool_id = a.id" & _
" left join tools_per_user b" & _
" on a.id = b.tool_id" & _
" where b.user_id = '" & Username & "'"
results in a the following error:
Check the manual that corresponds to your MySQL server version for the right syntax to use near '; select a.id, a.name, a.max_users, a.current_users, a.control_
I know the syntax is correct; using a different module to query from a regular Windows XP application returns the proper result. Is this due to the 6-column limitation of the trial version of this code, or is this a bug? Or does the MySQLDirect.Net Mobile not support multiple queries in a single command like that one?
Thanks in advance,
Jerod