Reply to thread

Message

<blockquote data-quote="sjevtic" data-source="post: 857370" data-attributes="member: 118214">Sorry, I don't have MySQL running here, not to mention having a TV-Server database in it, so I can't readily test a mysql command, and it would definitely take a few tries to get it right.&nbsp;In the case of the sqlcmd command I proposed earlier, the logic of where to find the channel configuration information is all embedded in the query. The fields you need to update (videoSource and audioSource) are in a table called TuningDetail. Literally everything in the query after the first WHERE clause serves to restrict the channels that will be modified so that you don't inadvertently update the videoSource and audioSource for a channel associated with another card.&nbsp;The web is full of great introductions, tutorials, and references to the SQL data manipulation language that are worth taking a look at--I am not ashamed to admit that I use them on a pretty regular basis, since my SQL skills are usually on the rusty side. Access is also a great tool for helping you gain proficiency with the language. You can create some pretty involved queries in the GUI's query designer, and then switch over to SQL view to see the SQL statement representation of your query for inspection or even modification, and then quickly go to data view to see the effects of your work.&nbsp;Sasha</blockquote>

[QUOTE="sjevtic, post: 857370, member: 118214"] Sorry, I don't have MySQL running here, not to mention having a TV-Server database in it, so I can't readily test a mysql command, and it would definitely take a few tries to get it right. In the case of the sqlcmd command I proposed earlier, the logic of where to find the channel configuration information is all embedded in the query. The fields you need to update (videoSource and audioSource) are in a table called TuningDetail. Literally everything in the query after the first WHERE clause serves to restrict the channels that will be modified so that you don't inadvertently update the videoSource and audioSource for a channel associated with another card. The web is full of great introductions, tutorials, and references to the SQL data manipulation language that are worth taking a look at--I am not ashamed to admit that I use them on a pretty regular basis, since my SQL skills are usually on the rusty side. Access is also a great tool for helping you gain proficiency with the language. You can create some pretty involved queries in the GUI's query designer, and then switch over to SQL view to see the SQL statement representation of your query for inspection or even modification, and then quickly go to data view to see the effects of your work. Sasha [/QUOTE]

Verification