Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚDelphiʹÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿âµÄÎÊÌâ

СµÜÎÒÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿â£¬È»ºóÔÚDBGridÖÐÏÔʾ£¬ÏÖÔÚÏë°ÑÔÚDBGridÖвéѯµ½µÄÊý¾ÝiPlot×÷ͼ£¬ÇëÎÊÈçºÎʵÏÖÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¬¶Á³öµÄÊý¾ÝÊÇSTRINGÀàÐ͵ģ¬ÈçºÎÓÐЧµÄת±ä³ÉÊý¾Ý¿âÖÐËù´æ´¢µÄDOUBLEÀàÐÍ»æͼ£¬Íû¸æÖªÒ»¶þ£¬²»Ê¤¸Ð¼¤£¡
ÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¿
DBGrid.datasource.dataset.fieldbyname('xxx').asfloat

ÒýÓÃ
ÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¿
DBGrid.datasource.dataset.fieldbyname('xxx').asfloat

¶Á³öµÄÊý¾ÝʱԭÀ´Êý¾Ý¿âÖж¨ÒåµÄDOUBLEÀàÐÍÂð£¿
ÎÒÏë¶Á³öÌض¨µÄÊý¾Ý£¬È»ºó»æÖÆÊý¾ÝµÄÀúÊ·ÇúÏßͼ

DBGrid.datasource.dataset.fieldbyname('xxx').value

ÒýÓÃ
¶Á³öµÄÊý¾ÝʱԭÀ´Êý¾Ý¿âÖж¨ÒåµÄDOUBLEÀàÐÍÂð£¿
ÎÒÏë¶Á³öÌض¨µÄÊý¾Ý£¬È»ºó»æÖÆÊý¾ÝµÄÀúÊ·ÇúÏßͼ

¶Á³öµÄÊý¾ÝʱԭÀ´Êý¾Ý¿âÖж¨Òå¿ÉÒÔ²»ÊÇDOUBLEÀàÐÍ£¬µ«Äãת»»³ÉdoubleÐ͵Ļ°£¬ÐèÒªÊý¾Ý¿âÖеÄÄÚÈÝÒª·ûºÏdoubleÀàÐ͵ĹæÔò£¬·ñÔò¾Í»á³ö´í

DataSet.First;
while Not DataSet.Eof do
begin
With DataSet
  value:=DBGrid.datasource.dataset.fieldbyname('xxx').value;
end
DataSet.Next;
end;


Ïà¹ØÎÊ´ð£º

SQLÓï¾äЧÂÊÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / ÆäËûÊý¾Ý¿â

´ó¼Ò°ïæ¿´¿´Õâ2¸ösqlÓï¾äÄĸö²éѯµÄËٶȸü¿ìµã¡£Ð»Ð»°ïæ¡£±È½Ï׿±¡£ÔÚ×öÐÔÄܲâÊÔ¡£
select * from
  ±íA LEFT OUTER JOIN ±íB ON (±íA.id || ' ' =±íB.id) ,±íC , ±íD, ±íE
WhereÆäËûÌõ¼þ
select * ......

¾ÈÃü°¡£¡£¡JSPÁ¬½ÓSQL2000ÎÊÌ⣡

¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......

delphi ÔõÑù½«ucs2±àÂëת»»³ÉÖÐÎÄ

½ÓÊÕµ½µÄÎı¾ÄÚÈÝÊÇucs2±àÂë¸ñʽ£¬ÇëÎÊÔõÑùת»»³ÉÖÐÎÄ
°´ÎÒµÄÀí½â£¬UCS-2ÊÇ×Ö·û¼¯£¬¾ßÌåµÄ±àÂëÓÐUTF-8£¬UTF-16 (LE/BE)µÈ¡£
Èç¹ûÄãÓÃDelphi 2009¼°ÒÔÉÏ°æ±¾£¬¿ÉÒÔ¿´¿´TEncodingÀà¡£
btw. Äã˵µÄת»»³ÉÖÐÎÄÊÇɶÒâË ......

delphiÈçºÎµ÷ÓÃdllÎļþÖеÄexe

Çë½Ì¸÷·¸ßÊÖ¡£ÎäÁÖÇ°±²¡£ÎÒ½«B.EXE×ö³É×ÊÔ´Îļþ£¬È»ºó¼Óµ½123.dllÖС£ÓÃA.EXEÀ´µ÷ÓÃ123.dllÖеÄB.EXE
Çë¸÷λǰ±²°ïæָ½ÌÏ¡£A.exeÈçºÎÀ´µ÷ÓÃdllÖеÄexe£¿´úÂëÓÖ¸ÃÈçºÎд£¿


ÎÞÈ˻شð£¿

×ö³É×ÊÔ´Î ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×ֶΠ£¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ