¹ØÓÚdelphi ADOquery - Delphi / Êý¾Ý¿âÏà¹Ø
´úÂëÊÇÕâÑùµÄ: ADOQuery2.Close; ADOQuery2.SQL.Clear; ADOQuery2.SQL.Add('insert into jsj615_ORDER_TEMP values( '''+edit1.Text+''', strtoint(combobox3.Text), strtoint(edit3.Text) ) '); ADOQuery2.Open; ´íÎóÊÇ: ÔÚ´ËÉÏÏÂÎÄÖв»ÔÊÐíʹÓÃÃû³Æ"combobox3.Text".ÓÐЧ±í´ïʽ°üÀ¨³£Á¿¡¢³£Á¿±í´ïʽºÍ±äÁ¿£¨ÔÚijЩÉÏÏÂÎÄÖУ©¡£²»ÔÊÐíʹÓÃÁÐÃû¡£ ÕâÊÇΪºÎ£¿°ïæ½â¾öÏ£¬£¬Ð»Ð»ÁË
1¡¢SQLÓï¾ä¡°Æ´½Ó¡±²»¶Ô 2¡¢insert/updateÓï¾ä²»ÄÜÓÃOpen·½·¨À´Ö´ÐÐ Delphi(Pascal) code: //¼ÙÉè×Ö¶ÎÃûΪf1-×Ö·ûÐÍ¡¢f2-ÊýÖµÐÍ¡¢f3-ÊýÖµÐÍ //¼Ù¶¨ÊýÖµÐÍÊäÈëÒÑ×÷ÈÝ´íÐÔÅÐ¶Ï ADOQuery2.Close; ADOQuery2.SQL.Clear; ADOQuery1.SQL.Add('insert into jsj615_ORDER_TEMP(f1, f2, f3) values(' + QuotedStr(edit1.Text) + ', ' + combobox3.Text + ', ' + edit3.Text); ADOQuery2.ExecSQL; 3¡¢³ýÁËʹÓÃADOQuery.ExecSQLÀ´Ìá½»SQLÓï¾ä£¬Ò²¿ÉÒÔʹÓÃADOConnection.Execute('insert ....'); Â¥ÉÏÕý½â£¬Ö»ÊDZÊÎóÁËÒ»´¦¡£ÒýÓà 1¡¢SQLÓï¾ä¡°Æ´½Ó¡±²»¶Ô 2¡¢insert/updateÓï¾ä²»ÄÜÓÃOpen·½·¨À´Ö´ÐÐ Delphi(Pascal) code //¼ÙÉè×Ö¶ÎÃûΪf1-×Ö·ûÐÍ¡¢f2-ÊýÖµÐÍ¡¢f3-ÊýÖµÐÍ //¼Ù¶¨ÊýÖµÐÍÊäÈëÒÑ×÷ÈÝ´íÐÔÅÐ¶Ï ADOQuery2.Close; ADOQuery2.SQL.Clear; ADOQuery2[color=#FF0000][/color].SQL.Add('insert into jsj615_ORD¡¡<
Ïà¹ØÎÊ´ð£º
Ò»Ö±ÏëʹÓÃdll£¬µ«delphiµÄdll×Ó´°Ìå¾³£Óи÷ÖÖÎÊÌ⣬±ÈÈçÖ÷´°¿ÚÓëdll×Ó´°¿ÚµÄ½¹µãÎÊÌ⣬×Ó´°¿ÚÖпؼþµÄtab¼ü¡¢Èȼü¡¢enter¼üµÈµÄÎÊÌ⣬×Ó´°¿ÚÍ˳öµÄÎÊÌ⡢ƽÃæ°´Å¥ÎÊÌâµÈµÈ£¬ÍøÕ¾ÉϽøÐÐÁËËÑË÷£¬Ã»ÓбȽÏÍêÃÀµÄ½â¾ö· ......
select * from shuju.DB where ¿ªÅ̼Û-ÊÕÅ̼Û<=0.02 ¿ªÅÌ¼Û ÓëÊÕÅÌ¼Û ÊÇÊý¾Ý¿âÀïµÄ×ֶΠselect * from aTableName where ((¿ªÅ̼Û-ÊÕÅ̼Û) <=0.02 ) ¿ªÅ̼۱ÈÊÕÅ̼۵ÍÁ½·ÖÒÔϵÄÇé¿ö Mark!!!!!! se ......
var FXmlDoc:IXMLDomDocument; begin ʹÓÃFXmlDoc.save('Îļþ·¾¶')£» ½á¹û·¢ÏÖ±£´æºóµÄ¸ÃÎļþÖÐÎÄÈ«²¿ÎªÂÒÂ룬ÈçºÎ½â¾ö end£» ²Î¿¼Õâ¸ö http://blog.csdn.net/jiangnanandi/archive/2008/11/28/3399804.aspx ......
ÓÐûÓа취ʵÏÖ¸úQQÓÊÏäÒ»ÑùµÄЧ¹û£¬µã»÷×ó±ßµÄ²Ëµ¥£¬ÓÒ±ßˢУ¬¶à¸öÒ³Ãæ¼äÇл»£¬¶ø×ó±ßµÄ²Ëµ¥À¸²»±ä Óкܶà¿Ø¼þ¿ÉÒÔʵÏÖ µÈÄã·Ö¼Ó·Ö£¬ÎÒ¸øÄãд¸öÔ´Âë¡£Õâµã·ÖʵÔÚûÓж¯Á¦»Ø´ð¡£ ExpressBars ¿´¿´¡£ Ò ......
µ½¹«Ë¾ÐÂѧdelphi£¬ÏëÎÊÒ»ÏÂcomboboxµÄÏÂÀ¿òÓÐÁ½¸öÖµ1ºÍ2£¬µ±Ñ¡Ôñ1»ò2ʱÔÚcomboboxÖÐÏÔʾΪÄлòÅ®¸ÃÔõô×ö ÄãÖ±½Ó°ÑComboBox1.ItemsÉèÖÃΪÄС¢Å®¾ÍÐÐÁË°¡ ½¨ÒéÕÒһЩ´úÂëÀý×Ó¿´Ò»¿´£¬È»ºó¶à¶¯ÊÖÁ·Ï° ÎÒ²ÂËûÊ ......