delphi È¡oracleϵͳ±ísys.aud$ÎÊÌâ
ÊÖÍ·ÓÐÒ»¸öÀϵIJúÆ·£¬delphi 6Á¬½Óoracle,È¡sys.aud$ϵͳ±íÀïÃæµÄÊý¾Ý
ÓÃAdoconnection+adodataset,
ÓÃsystemÓû§£¬Adoconnection Á¬½Ó³É¹¦£¬µ«Èç¹ûÔÚadodatasetÀïÃæд:
SELECT * from SYS.AUD$
Ö±½Ó²»¿ÉÒÔ£¬±¨´í: Data Type is not supported,
Èç¹û¸Ä³É²éѯÓû§½¨±í: SELECT * from T
¾Í¿ÉÒÔͨ¹ý£¬
ÇëÎÊÈçºÎÔÚADODATASETÀïÃæ²éѯ sys.aud$?
Çë¸÷Ϊ´óϺ°ïæ
ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!
Ïà¹ØÎÊ´ð£º
ÈÕÇ°ÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
SQL.Add('SELECT formula,val(DMAF) as i from Åä·½Õï¶Ï±í where 1=1 and formula ='''+Combobox3.Text+''' and formula ='''+Combobox4.Text+'''');
Õ ......
delphiÄÚÖõļÓÃܽâÃܵ¥ÔªÊÇÄĸö£¿
DelphiÓÐÄÚÖüÓÃܽâÃܵ¥Ôª£¿
delphiÀïÓиö¼ÓÃܺͽâÃܵĵ¥Ôª
ÒýÓÃ
delphiÀïÓиö¼ÓÃܺͽâÃܵĵ¥Ôª
ÊÇÄĸö£¿
windowsµÄapi£¿
±ê×¼¼ÓÃܵÄÔ´´úÂ룬ÍøÉÏ ......
ÓÉÓÚÎÒÉè¼ÆµÃ²»¹»ÍêÉÆ£¬ÔÚ¸øForm1·ÅÉÏͼƬµÄʱºò£¬ÓÉÓÚButtonµÄµ×É«ÊÇ°×É«£¬ºÍÎÒͼƬµÄÑÕÉ«²»·û£¬Ôõô°ÑButtonµÄµ×É«¸Ä³ÉͼƬµÄ
button²»ÄܸÄÑÕÉ«µÄ,µ«¿ÉÒÔÓÃÈçÏ·½·¨±äͨһÏÂ:
1 Ìí¼ÓÒ»¸öpanel²¢¸Ä±äÑÕÉ«; ......