Reply to thread

Message

<blockquote data-quote="rede96" data-source="post: 141057" data-attributes="member: 28720">[USER=47745]IcePickrg[/USER]I think it's a 'Can't remember more numbers' think for me!<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin&nbsp; &nbsp; :D" loading="lazy" data-shortname=":D" />Anyway, I've been having a play around with SQL Console. Although I can't find a way to use channel numbers, I think I may have found a work around. I am going to create some 'dummy' channels to fill is the missing gaps. My provider has channel numbers that go up to 999 but there are only 240 at present. So I need to create another 759 but hide them in MyTV.It's not too difficult, I'll just create the info in Excel or Access and then copy and paste in the SQL table. I'll have to create some new dummy channels in the tuning table as well so the id's match.If this works then I can sort my channels into whatever order I want and use the sort order as the channel number.[USER=47745]IcePickrg[/USER]I find that 3 digits work fine as long as you are watching TV in full mode, not in a window in MP. I can use my remote to switch to any 3 digit channel in my setup.Anyway, I'll post the results latter. [USER=24102]ocram[/USER]I am very familiar with access databases but I've not used SQL before. How do you sort the info in the tables?Cheers Red</blockquote>

[QUOTE="rede96, post: 141057, member: 28720"] [USER=47745]IcePickrg[/USER] I think it's a 'Can't remember more numbers' think for me!:D Anyway, I've been having a play around with SQL Console. Although I can't find a way to use channel numbers, I think I may have found a work around. I am going to create some 'dummy' channels to fill is the missing gaps. My provider has channel numbers that go up to 999 but there are only 240 at present. So I need to create another 759 but hide them in MyTV. It's not too difficult, I'll just create the info in Excel or Access and then copy and paste in the SQL table. I'll have to create some new dummy channels in the tuning table as well so the id's match. If this works then I can sort my channels into whatever order I want and use the sort order as the channel number. [USER=47745]IcePickrg[/USER] I find that 3 digits work fine as long as you are watching TV in full mode, not in a window in MP. I can use my remote to switch to any 3 digit channel in my setup. Anyway, I'll post the results latter. [USER=24102]ocram[/USER] I am very familiar with access databases but I've not used SQL before. How do you sort the info in the tables? Cheers Red [/QUOTE]

Verification