The following Query string , when executed does not give an Error, even
though the table Tbl_Billing_Data is not present.

QueryToPopulateTemp := ''INSERT INTO Tmp_Conference(ConferenceType,
CallManagerId, ClusterId, DestConversationId, ConnectDate,
FinalDestination)''+'' SELECT 2, Global_CallId_CallManagerId,
globalCallId_ClusterID, DestConversationID, StartDate = MIN
(Connect_Date), Final_Destination ''+'' FROM Tbl_Billing_Data'';

PERFORM QueryToPopulateTemp;

I some how feel that the Query is not getting executed at all, otherwise
its sure to give an error.

So can you please comment what would have gone wrong?

Regards,
Sumita



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
          • Re:... Sumita Biswas
          • Re:... Sumita Biswas
            • ... V i s h a l Kashyap @ [Sai Hertz And Control Systems]
          • Re:... Sumita Biswas
            • ... V i s h a l Kashyap @ [Sai Hertz And Control Systems]
            • ... Tom Lane
              • ... Sumita Biswas
              • ... Tom Lane
              • ... Sumita Biswas
              • ... Sumita Biswas
              • ... Sumita Biswas
              • ... Michael Chaney
              • ... Sumita Biswas
              • ... Sumita Biswas (sbiswas)
              • ... Sumita Biswas (sbiswas)
              • ... Sumita Biswas (sbiswas)
              • ... Sumita Biswas
              • ... Sumita Biswas
  • FW: [SQL] Function Sumita Biswas (sbiswas)

Reply via email to