• Replies 4 replies
  • Subscribers 583 subscribers
  • Views 371 views
  • Users 0 members are here
Options
Related

SQL, how t write correctly a query on cicode

Agostino

Hello,

I received from database manager the request to create this query to cicode to copy data between twp SQL table on the same Database. I cannot find the correct way to write it on cicode,  and other problem, Citect respond me that query is too long.. Someone can help me?

INSERT INTO [_PIZZA_PARAMETRI_RICETTE_HISTORY]

      (PPR_MAC_NUM
      ,PPR_NUMERO_ORDINE
      ,PPR_DATETIME
      ,PPR_RICETTA
      ,PPR_PARAMETRO
      ,PPR_VALORE_A
      ,PPR_VALORE_N)
SELECT
      PPR_MAC_NUM
      ,PPR_NUMERO_ORDINE
      ,PPR_DATETIME
      ,PPR_RICETTA
      ,PPR_PARAMETRO
      ,PPR_VALORE_A
      ,PPR_VALORE_N
  FROM [dbo].[_PIZZA_PARAMETRI_RICETTE]
  WHERE  PPR_MAC_NUM = 1

Thank you

Parents
  • Ok. Thank you, I resolved writing the query like below:

    hRec_MA = SQLSet(hSQL, "INSERT INTO [_PIZZA_PARAMETRI_RICETTE_HISTORY](PPR_MAC_NUM,PPR_NUMERO_ORDINE,PPR_DATETIME,PPR_RICETTA,PPR_PARAMETRO,PPR_VALORE_A,PPR_VALORE_N)");

    //Add parameters to the query
    SQLAppend(hSQL, " SELECT PPR_MAC_NUM,PPR_NUMERO_ORDINE,PPR_DATETIME,PPR_RICETTA,PPR_PARAMETRO,PPR_VALORE_A,PPR_VALORE_N FROM [dbo].[_PIZZA_PARAMETRI_RICETTE] WHERE PPR_MAC_NUM =1");
    //Execute the query
    SQLExec(hSQL, "");
    //the locally created query is disposed
    SQLQueryDispose(hSQL);
Reply
  • Ok. Thank you, I resolved writing the query like below:

    hRec_MA = SQLSet(hSQL, "INSERT INTO [_PIZZA_PARAMETRI_RICETTE_HISTORY](PPR_MAC_NUM,PPR_NUMERO_ORDINE,PPR_DATETIME,PPR_RICETTA,PPR_PARAMETRO,PPR_VALORE_A,PPR_VALORE_N)");

    //Add parameters to the query
    SQLAppend(hSQL, " SELECT PPR_MAC_NUM,PPR_NUMERO_ORDINE,PPR_DATETIME,PPR_RICETTA,PPR_PARAMETRO,PPR_VALORE_A,PPR_VALORE_N FROM [dbo].[_PIZZA_PARAMETRI_RICETTE] WHERE PPR_MAC_NUM =1");
    //Execute the query
    SQLExec(hSQL, "");
    //the locally created query is disposed
    SQLQueryDispose(hSQL);
Children
No Data
© 2025 AVEVA Group Limited or its subsidiaries. All Rights Reserved.