摘要: Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->Public Sub SetSpreadStyle(AnySs As vaSpread, aFlg As Boolean) With AnySs If aFlg = True Then... 阅读全文
posted @ 2007-03-26 12:21 sekihin 阅读(615) 评论(0) 推荐(0)
摘要: Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->Public Sub InsertRow2(AnySs As vaSpread, ByVal Row&) AnySs.MaxRows = 6 AnySs.Row = Row An... 阅读全文
posted @ 2007-03-26 12:19 sekihin 阅读(431) 评论(0) 推荐(0)
摘要: Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->'スプレッドシートの行をクリアする。'' Syntax: Clear AnySs,Row&'' IN: AnySs 対象となるスプレッドシート' strRo... 阅读全文
posted @ 2007-03-26 11:47 sekihin 阅读(485) 评论(0) 推荐(0)
摘要: 参考资料http://blog.donews.com/shan/archive/2006/03/14/767314.aspxhttp://babyt.cnblogs.com/archive/2005/04/15/138214.html Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHig... 阅读全文
posted @ 2007-03-22 10:16 sekihin 阅读(468) 评论(0) 推荐(0)
摘要: SQL Server的Inner Join及Outer Join 一、NATURAL JOIN(自然连接) 两张表通过NATURAL JOIN连接的时候,相当于有个隐含的WHERE子句,对两张表中同名的对应列相比较看是否相等。 二、CROSS JOIN(创建笛卡尔积) 对两张表通过交叉联合产生第三张返回结果集的表。相当于普通的连接。 三、INNER JOIN(内连接) ... 阅读全文
posted @ 2007-03-21 15:21 sekihin 阅读(1263) 评论(2) 推荐(0)
摘要: update是单条记录的更新 一般用于单表 udatebatch是在用批次锁定游标时使用! 可以实现一批纪录同时更新到服务器 在有主表、明细表的情况,更新明细记录时使用! 阅读全文
posted @ 2007-03-21 08:38 sekihin 阅读(1114) 评论(0) 推荐(0)
摘要: Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->if {Table.PARDELKB} = '0' then "未发行"else if {Table.PARDELKB} = '1' then "已发行" else if {Ta... 阅读全文
posted @ 2007-03-16 18:01 sekihin 阅读(269) 评论(0) 推荐(0)
摘要: Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->Mid(CStr({Table.HINLCDCTDT}), 1, 4) & "/" & Mid(CStr({Table.HINLCDCTDT}), 5, 2) & "/" & Mid(CStr({Tabl... 阅读全文
posted @ 2007-03-16 17:58 sekihin 阅读(295) 评论(0) 推荐(0)
摘要: Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ -->maxGyo '每页显示的最大行数 Private Sub ActiveReport_FetchData(eof As Boolean) If DsoPrint.eof The... 阅读全文
posted @ 2007-03-02 15:07 sekihin 阅读(575) 评论(0) 推荐(0)
摘要: Reponse.Form("") 获得表单中的值Reponse("") 获得联接地址的值 阅读全文
posted @ 2007-02-15 16:16 sekihin 阅读(364) 评论(0) 推荐(0)