Reply to thread

Message

<blockquote data-quote="ltpr" data-source="post: 857050" data-attributes="member: 120818">For quick edits, the change can be made right from the command line without even bothering with Access, using the sqlcmd (SQL Server) or mysql (MySQL) command line utilities. Consider the former, as an example. Simply remove the &quot;dbo_&quot; prefixes from all the table names that Access likes to add, and pack everything into a single command line:&nbsp;[CODE]sqlcmd -d MpTvDb -Q &quot;UPDATE TuningDetail SET videoSource = 10, audioSource = 9 WHERE idChannel IN (SELECT Channel.idChannel FROM Channel INNER JOIN ChannelMap ON Channel.idChannel = ChannelMap.idChannel WHERE (((ChannelMap.idCard)=1)));&quot;[/CODE]&nbsp;==================&nbsp;I ran the sql and ran into this error...Thoughts? Thank you!&nbsp; [ i use navicat premium]&nbsp;======[SQL] sqlcmd -d MpTvDb -Q &quot;UPDATE TuningDetail SET videoSource = 10, audioSource = 9 WHERE idChannel IN (SELECT Channel.idChannel FROM Channel INNER JOIN ChannelMap ON Channel.idChannel = ChannelMap.idChannel WHERE (((ChannelMap.idCard)=4)));&quot;&nbsp;[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sqlcmd -d MpTvDb -Q &quot;UPDATE TuningDetail SET videoSource = 10, audioSource = 9 W' at line 1</blockquote>

[QUOTE="ltpr, post: 857050, member: 120818"] For quick edits, the change can be made right from the command line without even bothering with Access, using the sqlcmd (SQL Server) or mysql (MySQL) command line utilities. Consider the former, as an example. Simply remove the "dbo_" prefixes from all the table names that Access likes to add, and pack everything into a single command line: [CODE] sqlcmd -d MpTvDb -Q "UPDATE TuningDetail SET videoSource = 10, audioSource = 9 WHERE idChannel IN (SELECT Channel.idChannel FROM Channel INNER JOIN ChannelMap ON Channel.idChannel = ChannelMap.idChannel WHERE (((ChannelMap.idCard)=1)));" [/CODE] ================== I ran the sql and ran into this error...Thoughts? Thank you! [ i use navicat premium] ====== [SQL] sqlcmd -d MpTvDb -Q "UPDATE TuningDetail SET videoSource = 10, audioSource = 9 WHERE idChannel IN (SELECT Channel.idChannel FROM Channel INNER JOIN ChannelMap ON Channel.idChannel = ChannelMap.idChannel WHERE (((ChannelMap.idCard)=4)));" [B][COLOR=#ff0000][Err] 1064[/COLOR][/B] - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sqlcmd -d MpTvDb -Q "UPDATE TuningDetail SET videoSource = 10, audioSource = 9 W' at line 1 [/QUOTE]

Verification