<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[桃花谷主]]></title><description><![CDATA[技术部落格]]></description><link>https://blog.youkuaiyun.com/thgz</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; thgz]]></copyright><item><title><![CDATA[vba中后台打开excel]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/6601610</link><guid>https://blog.youkuaiyun.com/thgz/article/details/6601610</guid><author>thgz</author><pubDate>Wed, 13 Jul 2011 00:54:37 +0800</pubDate><description><![CDATA[Dim cpApp As Excel.ApplicationSet cpApp = CreateObject("Excel.Application")cpApp.Visible = FalseSet wkb = cpApp.Workbooks.Open(sDir + "Outpu]]></description><category></category></item><item><title><![CDATA[Access中表名不要用transaction]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/6308155</link><guid>https://blog.youkuaiyun.com/thgz/article/details/6308155</guid><author>thgz</author><pubDate>Thu, 07 Apr 2011 08:30:00 +0800</pubDate><description><![CDATA[在C#中使用sql访问数据库时会提示语法错误，尽管在query中使用同样的sql不会出现问题。]]></description><category></category></item><item><title><![CDATA[C++ primer 读书笔记]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/6226499</link><guid>https://blog.youkuaiyun.com/thgz/article/details/6226499</guid><author>thgz</author><pubDate>Sat, 05 Mar 2011 18:55:00 +0800</pubDate><description><![CDATA[尽量避免使用using，以免命名冲突。]]></description><category></category></item><item><title><![CDATA[Excel中的美元符号$]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/6219609</link><guid>https://blog.youkuaiyun.com/thgz/article/details/6219609</guid><author>thgz</author><pubDate>Wed, 02 Mar 2011 16:02:00 +0800</pubDate><description><![CDATA[使用$可以固定行或列，即不让引用随单元格变化。  如果希望固定列把$放在整个引用之前（$A1),如果希望固定行放在数字之前字母之后（A$1), $A$1是绝对引用。]]></description><category></category></item><item><title><![CDATA[tnsping特别慢，连接数据库没反应]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/6186098</link><guid>https://blog.youkuaiyun.com/thgz/article/details/6186098</guid><author>thgz</author><pubDate>Tue, 15 Feb 2011 01:36:00 +0800</pubDate><description><![CDATA[http://polop777.blog.163.com/blog/static/82453986200901235257570/  sqlplus /nolog   connect sys/iit@marsi as sysdba    shutdown immediate    startup nomount    alter databse mount;    alter database file ‘alter database datafile 'E:/oracle/oradata/dbsvr/UN]]></description><category></category></item><item><title><![CDATA[Access insert]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/6026711</link><guid>https://blog.youkuaiyun.com/thgz/article/details/6026711</guid><author>thgz</author><pubDate>Mon, 22 Nov 2010 12:50:00 +0800</pubDate><description><![CDATA[<br />insert into hourlywindgeneration(ihour,generation) select ihour,generation from hourlywindgeneration  in "E:/Users/CaculateTypeGen/40Wind_2/40wind.mdb"]]></description><category></category></item><item><title><![CDATA[excel 2003 列标题显示不全]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/5889783</link><guid>https://blog.youkuaiyun.com/thgz/article/details/5889783</guid><author>thgz</author><pubDate>Fri, 17 Sep 2010 01:24:00 +0800</pubDate><description><![CDATA[似乎没有有效的解决方法，下面是两个连接可能会解决这个问题。http://support.microsoft.com/default.aspx?scid=kb;en-us;870698http://peltiertech.com/Excel/ChartsHowTo/AxisLabelCutOff.html]]></description><category></category></item><item><title><![CDATA[Selected   collating   sequence   not   supported   by   the   operating   system]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/5784033</link><guid>https://blog.youkuaiyun.com/thgz/article/details/5784033</guid><author>thgz</author><pubDate>Tue, 03 Aug 2010 02:32:00 +0800</pubDate><description><![CDATA[从access中select中数据时出现此错误，同样的程序在别处运行没有出现问题，使用access中的compact and repair功能后此错误消失.]]></description><category></category></item><item><title><![CDATA[C++编程经验]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/5782395</link><guid>https://blog.youkuaiyun.com/thgz/article/details/5782395</guid><author>thgz</author><pubDate>Mon, 02 Aug 2010 12:05:00 +0800</pubDate><description><![CDATA[头文件中只定义必要的内容如果能使用标准库中的算法实现所需功能，尽量使用标准库]]></description><category></category></item><item><title><![CDATA[Access根据现有表结构创建新表]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/5751287</link><guid>https://blog.youkuaiyun.com/thgz/article/details/5751287</guid><author>thgz</author><pubDate>Wed, 21 Jul 2010 03:27:00 +0800</pubDate><description><![CDATA[http://zhidao.baidu.com/question/129741296.html]]></description><category></category></item><item><title><![CDATA[C#和Access中的取模运算]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/5607172</link><guid>https://blog.youkuaiyun.com/thgz/article/details/5607172</guid><author>thgz</author><pubDate>Tue, 18 May 2010 22:15:00 +0800</pubDate><description><![CDATA[C#中取模运算为 % ， 30%9[=3  Access中的sql的取模为mod, 30 mode 9 =3]]></description><category></category></item><item><title><![CDATA[Excel行列倒置]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/5594113</link><guid>https://blog.youkuaiyun.com/thgz/article/details/5594113</guid><author>thgz</author><pubDate>Fri, 14 May 2010 13:48:00 +0800</pubDate><description><![CDATA[   选择要互换的数据     复制     右击     在弹出的菜单中选择选择性粘贴     在里面的选项里将转置这一项勾上再粘贴 ]]></description><category></category></item><item><title><![CDATA[CoWaitForMultipleHandles]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/5591909</link><guid>https://blog.youkuaiyun.com/thgz/article/details/5591909</guid><author>thgz</author><pubDate>Fri, 14 May 2010 01:29:00 +0800</pubDate><description><![CDATA[Visual Studio 2005 c++  Debug/Exception/Managed debugging Assistants,   Disable the ContextSwitchDeadlock option]]></description><category></category></item><item><title><![CDATA[vista 的remote desktop connection 不能远程连接server]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/5578192</link><guid>https://blog.youkuaiyun.com/thgz/article/details/5578192</guid><author>thgz</author><pubDate>Mon, 10 May 2010 23:00:00 +0800</pubDate><description><![CDATA[另一台xp的机子连接去没问题。以前一直连接好好的。  根据帮助，添加remote desktop到防火墙中，以致关闭本机防火墙，都不行。  升级本机remote desktop程序到最新7.0还是不行。  最后关掉路由中自带的防火墙才可以。看来是路由中的防火墙的问题，不过xp却能连接，而且一直以来vista连接也没问题，只是间歇会有不能连接的情况，同时大智慧也不能连接到服务器，关掉路由防火墙后一切]]></description><category></category></item><item><title><![CDATA[Access VBA Error 1004]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/5565368</link><guid>https://blog.youkuaiyun.com/thgz/article/details/5565368</guid><author>thgz</author><pubDate>Thu, 06 May 2010 16:53:00 +0800</pubDate><description><![CDATA[Error 1004: Application defined or object defined error.  The error is most due to the nonexistence of visiting data in script.  这个错误大部分情况是由于脚本中访问的数据不存所致。]]></description><category></category></item><item><title><![CDATA[sql case用法]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/5565362</link><guid>https://blog.youkuaiyun.com/thgz/article/details/5565362</guid><author>thgz</author><pubDate>Thu, 06 May 2010 16:47:00 +0800</pubDate><description><![CDATA[CASE 可能是 SQL 中被误用最多的关键字之一。虽然你可能以前用过这个关键字来创建字段，但是它还具有更多用法。例如，你可以在 WHERE   子句中使用 CASE。   在access中相应的语法为iif  iif(a is true,a,b) //if a is true then a else b     首先让我们看一下 CASE 的语法。在一般的 SELECT 中，其语法如下：   S]]></description><category></category></item><item><title><![CDATA[C++ delete[] heap corruption]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/5540759</link><guid>https://blog.youkuaiyun.com/thgz/article/details/5540759</guid><author>thgz</author><pubDate>Wed, 28 Apr 2010 09:22:00 +0800</pubDate><description><![CDATA[一般为地址越界造成的。  int *row;  row=new int[10];  如果程序中有row[i]=10;(i=10)的情况，最后delete[] row 都会报heap corruption的异常。  奇怪的是在row[i]=10;(i=10)时，编译器应该报错却没有。]]></description><category></category></item><item><title><![CDATA[9901]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/2089267</link><guid>https://blog.youkuaiyun.com/thgz/article/details/2089267</guid><author>thgz</author><pubDate>Tue, 12 Feb 2008 21:27:00 +0800</pubDate><description><![CDATA[ integrate the database between PowerGis and MarSI.  Beginning visual C# 2005 chapter 6-8  GRE-two word list    A painter hangs his or her finished pictures on a wall, and everyone can see it. A compo]]></description><category></category></item><item><title><![CDATA[Microsoft livewirter test]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/2087031</link><guid>https://blog.youkuaiyun.com/thgz/article/details/2087031</guid><author>thgz</author><pubDate>Sat, 09 Feb 2008 01:39:00 +0800</pubDate><description><![CDATA[livewriter test]]></description><category></category></item><item><title><![CDATA[Microsoft OLE DB Provider for ODBC Drivers error '80004005' 错误解决方法]]></title><link>https://blog.youkuaiyun.com/thgz/article/details/467696</link><guid>https://blog.youkuaiyun.com/thgz/article/details/467696</guid><author>thgz</author><pubDate>Mon, 29 Aug 2005 21:17:00 +0800</pubDate><description><![CDATA[]]></description><category></category></item></channel></rss>