Reply to thread

Message

<blockquote data-quote="Big_Kev" data-source="post: 241953" data-attributes="member: 52102">That would do it... I will update to the latest SVN and check it out...KevThe code below adds the scheduled recordings[CODE]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;SQL-&gt;Clear();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;SQL-&gt;Add(&quot;insert into Schedule (idChannel, scheduleType, programName, startTime, endTime, maxAirings, quality, directory, priority, keepDate, preRecordInterval, postRecordInterval, canceled, recommendedCard, keepMethod) values (:IDCHANNEL, :SCHEDULETYPE, :PROGRAMNAME, :STARTTIME, :ENDTIME, :MAXAIRINGS, :QUALITY, :DIRECTORY, :PRIORITY, :KEEPDATE, :PRERECORDINTERVAL, :POSTRECORDINTERVAL, :CANCELED, :RECOMMENDEDCARD, :KEEPMETHOD)&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; TDateTime *Temp = new TDateTime(2000, 1, 1);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; int TChannel = Q-&gt;FieldByName(&quot;idChannel&quot;)-&gt;AsInteger;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;ParamByName(&quot;IDCHANNEL&quot;)-&gt;AsInteger = TChannel;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;ParamByName(&quot;PROGRAMNAME&quot;)-&gt;AsString = Q-&gt;FieldByName(&quot;title&quot;)-&gt;AsString;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;ParamByName(&quot;STARTTIME&quot;)-&gt;AsDateTime = Q-&gt;FieldByName(&quot;startTime&quot;)-&gt;AsDateTime;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;ParamByName(&quot;ENDTIME&quot;)-&gt;AsDateTime = Q-&gt;FieldByName(&quot;endTime&quot;)-&gt;AsDateTime;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;ParamByName(&quot;MAXAIRINGS&quot;)-&gt;AsInteger = 5;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;ParamByName(&quot;QUALITY&quot;)-&gt;AsInteger = 0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; [COLOR=&quot;Red&quot;][B]R-&gt;ParamByName(&quot;DIRECTORY&quot;)-&gt;AsString = &quot; &quot;;[/B][/COLOR]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;ParamByName(&quot;PRIORITY&quot;)-&gt;AsInteger = 0;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;ParamByName(&quot;PRERECORDINTERVAL&quot;)-&gt;AsInteger = FixedPreRecord;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;ParamByName(&quot;POSTRECORDINTERVAL&quot;)-&gt;AsInteger = FixedPostRecord;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;ParamByName(&quot;SCHEDULETYPE&quot;)-&gt;AsInteger = SchedType.ToIntDef(0);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;ParamByName(&quot;CANCELED&quot;)-&gt;AsDateTime = *Temp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; R-&gt;ParamByName(&quot;KEEPDATE&quot;)-&gt;AsDateTime = *Temp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; delete Temp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Q-&gt;Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Q-&gt;SQL-&gt;Clear();&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; Q-&gt;ParamByName(&quot;Channel&quot;)-&gt;AsInteger = TChannel;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Q-&gt;Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Q-&gt;First();&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; 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; 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; [COLOR=&quot;Red&quot;][B]R-&gt;ParamByName(&quot;DIRECTORY&quot;)-&gt;AsString = Q-&gt;FieldByName(&quot;recordingFolder&quot;)-&gt;AsString;[/B][/COLOR]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (R-&gt;ParamByName(&quot;DIRECTORY&quot;)-&gt;AsString.[COLOR=&quot;Red&quot;][B]IsEmpty[/B][/COLOR]())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; NonFatalMessage += Trans-&gt;Trans[[COLOR=&quot;Red&quot;][B]&quot;No recording folder has been set for this channel&quot;[/B][/COLOR]] + &quot;&lt;br&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; else&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 = -1;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NonFatalMessage += Trans-&gt;Trans[&quot;[COLOR=&quot;Red&quot;][B]No recommended card has been set for this channel[/B][/COLOR]&quot;] + &quot;&lt;br&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; if (R-&gt;ParamByName(&quot;DIRECTORY&quot;)-&gt;AsString.IsEmpty())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Q-&gt;Close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Q-&gt;SQL-&gt;Clear();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Q-&gt;SQL-&gt;Add(&quot;select * from card&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Q-&gt;Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Q-&gt;First();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while (!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; if (!Q-&gt;FieldByName(&quot;recordingFolder&quot;)-&gt;AsString.IsEmpty())&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;DIRECTORY&quot;)-&gt;AsString = Q-&gt;FieldByName(&quot;recordingFolder&quot;)-&gt;AsString;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NonFatalMessage += Trans-&gt;Trans[&quot;[COLOR=&quot;Red&quot;][B]The recording file has been set to[/B][/COLOR]&quot;] + &quot; &quot; + Q-&gt;FieldByName(&quot;recordingFolder&quot;)-&gt;AsString + &quot; &quot; + Trans-&gt;Trans[&quot;[COLOR=&quot;Red&quot;][B]as no recording file has been assigned to this card[/B][/COLOR]&quot;] + &quot;&lt;br&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; break;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Q-&gt;Next();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }[/CODE]The directory for recorded tv is initially null, then the card recommended for that channel is looked up and the directory is assigned.I have added code to check that a directory has been assigned.If it is not assigned, then the program looks through your list of cards and assigns the first non-null directory it finds.The error was being generated because no value was assigned to the recorded tv directory... so either the channel did not have a recommended card assigned, or the assigned card does not have a folder for recorded tv assigned to it.Please let me know how it goes, hopefully the new error messages will give a few more clues.Kev</blockquote>

[QUOTE="Big_Kev, post: 241953, member: 52102"] That would do it... I will update to the latest SVN and check it out... Kev The code below adds the scheduled recordings [CODE] R->Close(); R->SQL->Clear(); R->SQL->Add("insert into Schedule (idChannel, scheduleType, programName, startTime, endTime, maxAirings, quality, directory, priority, keepDate, preRecordInterval, postRecordInterval, canceled, recommendedCard, keepMethod) values (:IDCHANNEL, :SCHEDULETYPE, :PROGRAMNAME, :STARTTIME, :ENDTIME, :MAXAIRINGS, :QUALITY, :DIRECTORY, :PRIORITY, :KEEPDATE, :PRERECORDINTERVAL, :POSTRECORDINTERVAL, :CANCELED, :RECOMMENDEDCARD, :KEEPMETHOD)"); TDateTime *Temp = new TDateTime(2000, 1, 1); int TChannel = Q->FieldByName("idChannel")->AsInteger; R->ParamByName("IDCHANNEL")->AsInteger = TChannel; R->ParamByName("PROGRAMNAME")->AsString = Q->FieldByName("title")->AsString; R->ParamByName("STARTTIME")->AsDateTime = Q->FieldByName("startTime")->AsDateTime; R->ParamByName("ENDTIME")->AsDateTime = Q->FieldByName("endTime")->AsDateTime; R->ParamByName("MAXAIRINGS")->AsInteger = 5; R->ParamByName("QUALITY")->AsInteger = 0; [COLOR="Red"][B]R->ParamByName("DIRECTORY")->AsString = " ";[/B][/COLOR] R->ParamByName("PRIORITY")->AsInteger = 0; R->ParamByName("PRERECORDINTERVAL")->AsInteger = FixedPreRecord; R->ParamByName("POSTRECORDINTERVAL")->AsInteger = FixedPostRecord; R->ParamByName("SCHEDULETYPE")->AsInteger = SchedType.ToIntDef(0); R->ParamByName("CANCELED")->AsDateTime = *Temp; R->ParamByName("KEEPDATE")->AsDateTime = *Temp; delete Temp; 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; [COLOR="Red"][B]R->ParamByName("DIRECTORY")->AsString = Q->FieldByName("recordingFolder")->AsString;[/B][/COLOR] if (R->ParamByName("DIRECTORY")->AsString.[COLOR="Red"][B]IsEmpty[/B][/COLOR]()) { NonFatalMessage += Trans->Trans[[COLOR="Red"][B]"No recording folder has been set for this channel"[/B][/COLOR]] + " "; } } else { R->ParamByName("RECOMMENDEDCARD")->AsInteger = -1; NonFatalMessage += Trans->Trans["[COLOR="Red"][B]No recommended card has been set for this channel[/B][/COLOR]"] + " "; } if (R->ParamByName("DIRECTORY")->AsString.IsEmpty()) { Q->Close(); Q->SQL->Clear(); Q->SQL->Add("select * from card"); Q->Open(); Q->First(); while (!Q->Eof) { if (!Q->FieldByName("recordingFolder")->AsString.IsEmpty()) { R->ParamByName("DIRECTORY")->AsString = Q->FieldByName("recordingFolder")->AsString; NonFatalMessage += Trans->Trans["[COLOR="Red"][B]The recording file has been set to[/B][/COLOR]"] + " " + Q->FieldByName("recordingFolder")->AsString + " " + Trans->Trans["[COLOR="Red"][B]as no recording file has been assigned to this card[/B][/COLOR]"] + " "; break; } Q->Next(); } } [/CODE] The directory for recorded tv is initially null, then the card recommended for that channel is looked up and the directory is assigned. I have added code to check that a directory has been assigned. If it is not assigned, then the program looks through your list of cards and assigns the first non-null directory it finds. The error was being generated because no value was assigned to the recorded tv directory... so either the channel did not have a recommended card assigned, or the assigned card does not have a folder for recorded tv assigned to it. Please let me know how it goes, hopefully the new error messages will give a few more clues. Kev [/QUOTE]

Verification