2012/05/29

Variant function: VarIsEmpty VS VarIsNULL

unassined :
if Not VarIsEmpty( DeltaDs.Fields[i].NewValue ) then ...

NULL :
if Not VarIsNULL( DeltaDs.Fields[i].NewValue ) then ...

資料來源:http://www.sql.ru/forum/actualthread.aspx?tid=329100

2012/05/25

使用 OLE 開啟 Excel 的小陷井

從MSDN上看到Workbook.Open函式是這樣寫的:
Workbook Open(
 [In] string Filename, 
 [In, Optional] object UpdateLinks, 
 [In, Optional] object ReadOnly, 
 [In, Optional] object Format, 
 [In, Optional] object Password, 
 [In, Optional] object WriteResPassword, 
 [In, Optional] object IgnoreReadOnlyRecommended, 
 [In, Optional] object Origin, 
 [In, Optional] object Delimiter, 
 [In, Optional] object Editable, 
 [In, Optional] object Notify, 
 [In, Optional] object Converter, 
 [In, Optional] object AddToMru, 
 [In, Optional] object Local, 
 [In, Optional] object CorruptLoad
);


一票網站在抄來抄去,除了第一個參數是Filename不變外,其它不是都沒給值,就是直接給EmptyParam

2012/05/07