{"id":395,"date":"2010-12-09T18:14:16","date_gmt":"2010-12-09T10:14:16","guid":{"rendered":"http:\/\/blog.infinity.idv.tw\/index.php\/2010\/12\/09\/delphi-7-%e4%bd%bf%e7%94%a8ado%e5%85%83%e4%bb%b6%e5%af%ab%e5%85%a5%e8%b3%87%e6%96%99%e5%ba%ab%e5%bc%b7%e5%88%b6%e5%9b%9b%e6%8d%a8%e4%ba%94%e5%85%a5%e5%b0%8f%e6%95%b8%e5%88%b0%e7%ac%ac%e5%9b%9b\/"},"modified":"2011-04-07T10:54:56","modified_gmt":"2011-04-07T02:54:56","slug":"delphi-7-%e4%bd%bf%e7%94%a8ado%e5%85%83%e4%bb%b6%e5%af%ab%e5%85%a5%e8%b3%87%e6%96%99%e5%ba%ab%e5%bc%b7%e5%88%b6%e5%9b%9b%e6%8d%a8%e4%ba%94%e5%85%a5%e5%b0%8f%e6%95%b8%e5%88%b0%e7%ac%ac%e5%9b%9b","status":"publish","type":"post","link":"http:\/\/blog.infinity.idv.tw\/?p=395","title":{"rendered":"DELPHI 7 \u4f7f\u7528ADO\u5143\u4ef6\u5beb\u5165\u8cc7\u6599\u5eab\u5f37\u5236\u56db\u6368\u4e94\u5165\u5c0f\u6578\u5230\u7b2c\u56db\u4f4d\u554f\u984c"},"content":{"rendered":"

DELPHI 7 \u4f7f\u7528ADO\u5143\u4ef6\u5beb\u5165\u8cc7\u6599\u5eab\u5f37\u5236\u56db\u6368\u4e94\u5165\u5c0f\u6578\u5230\u7b2c\u56db\u4f4d\u554f\u984c<\/p>\n

parameters.parambyname(‘tmpprice’).datatype\uff1a=ftFloat;   <==\u5beb\u5165\u8cc7\u6599\u524d\u5148\u5c07\u6b04\u4f4d\u8a2d\u5b9a\u6210 Float \u578b\u614b\u5373\u53ef\u89e3\u6c7a\u6b64\u554f\u984c\u3002<\/p>\n

\u53c3\u8003:http:\/\/jzinfo.javaeye.com\/blog\/432853<\/a><\/p>\n

    \n
  1. var   <\/li>\n
  2.     adoquery1:Tadoquery;   <\/li>\n
  3. begin   <\/li>\n
  4.     adoquery1:=Tadoquery.create(nil);   <\/li>\n
  5.     try   <\/li>\n
  6.        if not DM.adonconnection1.connected then   <\/li>\n
  7.            DM.adoconnection1.connected:=true;   <\/li>\n
  8.        adoquery1.connection:=DM.adoconnection1;   <\/li>\n
  9.        adoquery1.enableBCD:=False;       \/\/\u7981\u7528bcd\u7c7b\u578b   <\/li>\n
  10.        with adoquery1 do   <\/li>\n
  11.        begin   <\/li>\n
  12.            close;   <\/li>\n
  13.            sql.clear;   <\/li>\n
  14.            sql.add(‘insert into materialInfo values(:tmppno,:tmpvendor,:tmpdesc,:tmpprice)’);   <\/li>\n
  15.            parameters.parambyname(‘tmppno’).value:=trim(edit1.text);   <\/li>\n
  16.            parameters.parambyname(‘tmpvendor’).value:=trim(edit2.text);   <\/li>\n
  17.            parameters.parambyname(‘tmpdesc’).value:=trim(edit3.text);   <\/li>\n
  18.            parameters.parambyname(‘tmpprice’).datatype\uff1a=ftFloat;       \/\/\u8bbe\u7f6e\u4e0b\u6570\u636e\u7c7b\u578b   <\/li>\n
  19.            parameters.parambyname(‘tmpprice’).value:=trim(edit4.text);   <\/li>\n
  20.            execsql;   <\/li>\n
  21.        end;   <\/li>\n
  22.     finally   <\/li>\n
  23.         adoquery1.free;   <\/li>\n
  24.     end;   <\/li>\n
  25. end;  <\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    DELPHI 7 \u4f7f\u7528ADO\u5143\u4ef6\u5beb\u5165\u8cc7\u6599\u5eab\u5f37\u5236\u56db\u6368\u4e94\u5165\u5c0f\u6578\u5230\u7b2c\u56db\u4f4d\u554f\u984c<\/p>\n

    parameters.parambyname(‘tmpprice’).datatype\uff1a=ftFloat;   <==\u5beb\u5165\u8cc7\u6599\u524d\u5148\u5c07\u6b04\u4f4d\u8a2d\u5b9a\u6210 Float \u578b\u614b\u5373\u53ef\u89e3\u6c7a\u6b64\u554f\u984c\u3002<\/p>\n

    \u53c3\u8003:http:\/\/jzinfo.javaeye.com\/blog\/432853<\/p>\n

    var  
    \n    adoquery1:Tadoquery;  
    \nbegin  
    \n    adoquery1:=Tadoquery.create(nil);  
    \n    try  
    \n       if not DM.adonconnection1.connected then  
    \n           DM.adoconnection1.connected:=true;  
    \n       adoquery1.connection:=DM.adoconnection1;  
    \n       adoquery1.enableBCD:=False;       \/\/\u7981\u7528bcd\u7c7b\u578b  
    \n       with adoquery1 do  
    \n       begin  
    \n           close;  
    \n           sql.clear;  
    \n           sql.add(‘insert into materialInfo values(:tmppno,:tmpvendor,:tmpdesc,:tmpprice)’);  
    \n           parameters.parambyname(‘tmppno’).value:=trim(edit1.text);  
    \n           parameters.parambyname(‘tmpvendor’).value:=trim(edit2.text);  
    \n           parameters.parambyname(‘tmpdesc’).value:=trim(edit3.text);  
    \n           parameters.parambyname(‘tmpprice’).datatype\uff1a=ftFloat;       \/\/\u8bbe\u7f6e\u4e0b\u6570\u636e\u7c7b\u578b  
    \n           parameters.parambyname(‘tmpprice’).value:=trim(edit4.text);  
    \n           execsql;  
    \n       end;   […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3,34],"tags":[358],"_links":{"self":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/395"}],"collection":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=395"}],"version-history":[{"count":2,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/395\/revisions"}],"predecessor-version":[{"id":560,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/395\/revisions\/560"}],"wp:attachment":[{"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=395"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.infinity.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}