insertrow.stm

来自「数据库操作软件Powerbuilder实用代码集」· STM 代码 · 共 35 行

STM
35
字号
<HTML>
<TITLE>插入销售记录</TITLE>

<!--script
  var str = site.Include("head.ssc");
  document.writeln(str);
-->


<CENTER>
<FONT FACE=楷体_GB2312 SIZE=5><I>
<!--SCRIPT
    
    isbn = "'"+document.value.isbn+"'";
    cust_id = "'"+document.value.cust_id+"'";
    sales_amount = document.value.sales_amount;
    str = "insert into sales_transact (isbn,sales_amount,sales_date,cust_id)&
           values ("+isbn+","+sales_amount+","+"today()"+","+cust_id+")"

    myconn=site.GetConnection("<default>");
    qu = myconn.CreateQuery(str);
    if (qu != null){
    if ( qu.GetErrorCode() != 0 )
        document.writeln("订单录入失败,");
    else
        document.writeln("订单录入成功,");
    }
    document.writeln( " <a href='ord_enter.stm'>单击这里继续。 </a>")
       
-->

</FONT>
</CENTER>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?