Reply to thread

Message

bionicdonkey

After I removed your mods I tried a little experiment.

Using the SQLLite DB browser I ran some local SQL to renumber the sort fields (I think one was iSort and I can't remember the other --- I'm at the office) so that their values would be the same as the "channel numbers" that I'm looking for. I did this by setting these fields from the iChannelNr or ExternalChannel fields as appropriate.

I was hoping that one of these 'sort' fields was the one used in in the current "direct access/database index" method. I then ran MP and tried going to a specific channel and the results were the same as before, it still goes to the "wrong" channel. Absent examining the code, from this it almost appears that the current direct access method is to go to the actual row in the database and get the channel information from there --- but that doesn't really make sense.

Frankly I think I must have made some other mistake or the database didn't get saved properly after I made the changes because I can't see that it would actually do it that way, but one never knows...

Anyway the search for direct channel access continues ... ;-)

<blockquote data-quote="Anonymous" data-source="post: 11776">bionicdonkeyAfter I removed your mods I tried a little experiment. Using the SQLLite DB browser I ran some local SQL to renumber the sort fields (I think one was iSort and I can't remember the other --- I'm at the office) so that their values would be the same as the &quot;channel numbers&quot; that I'm looking for. I did this by setting these fields from the iChannelNr or ExternalChannel fields as appropriate. I was hoping that one of these 'sort' fields was the one used in in the current &quot;direct access/database index&quot; method. I then ran MP and tried going to a specific channel and the results were the same as before, it still goes to the &quot;wrong&quot; channel. Absent examining the code, from this it almost appears that the current direct access method is to go to the actual row in the database and get the channel information from there --- but that doesn't really make sense.Frankly I think I must have made some other mistake or the database didn't get saved properly after I made the changes because I can't see that it would actually do it that way, but one never knows...Anyway the search for direct channel access continues ... ;-)</blockquote>

[QUOTE="Anonymous, post: 11776"] bionicdonkey After I removed your mods I tried a little experiment. Using the SQLLite DB browser I ran some local SQL to renumber the sort fields (I think one was iSort and I can't remember the other --- I'm at the office) so that their values would be the same as the "channel numbers" that I'm looking for. I did this by setting these fields from the iChannelNr or ExternalChannel fields as appropriate. I was hoping that one of these 'sort' fields was the one used in in the current "direct access/database index" method. I then ran MP and tried going to a specific channel and the results were the same as before, it still goes to the "wrong" channel. Absent examining the code, from this it [b]almost appears[/b] that the current direct access method is to go to the actual row in the database and get the channel information from there --- but that doesn't really make sense. Frankly I think I must have made some other mistake or the database didn't get saved properly after I made the changes because I can't see that it would actually do it that way, but one never knows... Anyway the search for direct channel access continues ... ;-) [/QUOTE]