Reply to thread

Message

<blockquote data-quote="Big_Kev" data-source="post: 283170" data-attributes="member: 52102">Hi Dave,The MP Tv database is set up so that no new rows can be added with null fields. The &quot;directory&quot; column gets its value from the recording directory defined for the TV Card.I think you need to make sure that all of your TV Cards have a recording folder defined.I am not currently on a PC with MP installed, so all I can go off is the code for the interface...[CODE]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Q-&gt;Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Q-&gt;SQL-&gt;Clear();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Q-&gt;SQL-&gt;Add(&quot;select * from channelmap a, card b where idChannel = :Channel and a.idCard = b.idCard&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Q-&gt;ParamByName(&quot;Channel&quot;)-&gt;AsInteger = TChannel;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Q-&gt;Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Q-&gt;First();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; if (!Q-&gt;Eof)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; R-&gt;ParamByName(&quot;RECOMMENDEDCARD&quot;)-&gt;AsInteger = Q-&gt;FieldByName(&quot;idCard&quot;)-&gt;AsInteger;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; R-&gt;ParamByName(&quot;PRIORITY&quot;)-&gt;AsInteger = Q-&gt;FieldByName(&quot;priority&quot;)-&gt;AsInteger;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [B][COLOR=&quot;Red&quot;]R-&gt;ParamByName(&quot;DIRECTORY&quot;)-&gt;AsString = Q-&gt;FieldByName(&quot;recordingFolder&quot;)-&gt;AsString;[/COLOR][/B]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }[/CODE]Have a look at your TV Server configuration at the options for the TV Cards. I am not in front of it right now, so I cant tell you exactly where to find the right page...RegardsKev</blockquote>

[QUOTE="Big_Kev, post: 283170, member: 52102"] Hi Dave, The MP Tv database is set up so that no new rows can be added with null fields. The "directory" column gets its value from the recording directory defined for the TV Card. I think you need to make sure that all of your TV Cards have a recording folder defined. I am not currently on a PC with MP installed, so all I can go off is the code for the interface... [CODE] Q->Close(); Q->SQL->Clear(); Q->SQL->Add("select * from channelmap a, card b where idChannel = :Channel and a.idCard = b.idCard"); Q->ParamByName("Channel")->AsInteger = TChannel; Q->Open(); Q->First(); if (!Q->Eof) { R->ParamByName("RECOMMENDEDCARD")->AsInteger = Q->FieldByName("idCard")->AsInteger; R->ParamByName("PRIORITY")->AsInteger = Q->FieldByName("priority")->AsInteger; [B][COLOR="Red"]R->ParamByName("DIRECTORY")->AsString = Q->FieldByName("recordingFolder")->AsString;[/COLOR][/B] }[/CODE] Have a look at your TV Server configuration at the options for the TV Cards. I am not in front of it right now, so I cant tell you exactly where to find the right page... Regards Kev [/QUOTE]

Verification