常见问题解决办法.htm

来自「里面的内容包括：基盘存管理本信息管理库存管理入库管理出库管理等功能」· HTM 代码 · 共 939 行 · 第 1/2 页

HTM
939 行
字号
12
	text-justify:inter-ideograph;
	text-indent:21.25pt;
	line-height:15.6pt;
	mso-pagination:none;
	font-size:10.5pt;
	mso-bidi-font-size:10.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:宋体;
	mso-font-kerning:1.0pt;}
p.ab, li.ab, div.ab
	{mso-style-name:文本框;
	mso-style-update:auto;
	margin:0cm;
	margin-bottom:.0001pt;
	text-align:center;
	line-height:15.6pt;
	mso-pagination:none;
	punctuation-wrap:simple;
	font-size:7.5pt;
	mso-bidi-font-size:10.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:宋体;
	mso-font-kerning:1.0pt;}
p.ac, li.ac, div.ac
	{mso-style-name:小标题;
	mso-style-update:auto;
	margin:0cm;
	margin-bottom:.0001pt;
	text-align:justify;
	text-justify:inter-ideograph;
	text-indent:21.25pt;
	line-height:15.6pt;
	mso-pagination:none;
	font-size:10.5pt;
	mso-bidi-font-size:10.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:黑体;
	mso-font-kerning:1.0pt;}
p.ad, li.ad, div.ad
	{mso-style-name:空;
	mso-style-parent:文本框;
	margin:0cm;
	margin-bottom:.0001pt;
	text-indent:10.0pt;
	mso-char-indent-count:2.0;
	mso-char-indent-size:5.0pt;
	mso-line-height-alt:0pt;
	mso-pagination:none;
	punctuation-wrap:simple;
	font-size:5.0pt;
	mso-bidi-font-size:10.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:宋体;
	mso-font-kerning:1.0pt;}
p.7, li.7, div.7
	{mso-style-name:标题7;
	margin-top:0cm;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:63.8pt;
	margin-bottom:.0001pt;
	text-indent:-21.25pt;
	line-height:15.6pt;
	mso-pagination:none;
	mso-list:l14 level1 lfo17;
	tab-stops:list 63.8pt;
	mso-layout-grid-align:none;
	text-autospace:none;
	font-size:10.5pt;
	mso-bidi-font-size:10.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:宋体;
	mso-font-kerning:1.0pt;}
p.ae, li.ae, div.ae
	{mso-style-name:程序底端;
	mso-style-parent:程序;
	mso-style-next:正文;
	margin-top:0cm;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:21.25pt;
	margin-bottom:.0001pt;
	text-align:justify;
	text-justify:inter-ideograph;
	text-indent:21.25pt;
	line-height:13.0pt;
	mso-line-height-rule:exactly;
	mso-pagination:none;
	border:none;
	mso-border-bottom-alt:solid windowtext .25pt;
	padding:0cm;
	mso-padding-alt:0cm 0cm 1.0pt 0cm;
	font-size:9.0pt;
	mso-bidi-font-size:10.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:宋体;
	mso-font-kerning:1.0pt;}
p.af, li.af, div.af
	{mso-style-name:程序顶端;
	mso-style-parent:程序;
	mso-style-next:程序;
	margin-top:0cm;
	margin-right:0cm;
	margin-bottom:0cm;
	margin-left:21.25pt;
	margin-bottom:.0001pt;
	text-align:justify;
	text-justify:inter-ideograph;
	text-indent:21.25pt;
	mso-char-indent-count:2.36;
	mso-char-indent-size:9.0pt;
	line-height:13.0pt;
	mso-line-height-rule:exactly;
	mso-pagination:none;
	border:none;
	mso-border-top-alt:solid windowtext .25pt;
	padding:0cm;
	mso-padding-alt:1.0pt 0cm 0cm 0cm;
	font-size:9.0pt;
	mso-bidi-font-size:10.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:宋体;
	mso-font-kerning:1.0pt;}
 /* Page Definitions */
@page
	{mso-page-border-surround-header:no;
	mso-page-border-surround-footer:no;
	mso-footnote-separator:url("./常见问题解决办法.files/header.htm") fs;
	mso-footnote-continuation-separator:url("./常见问题解决办法.files/header.htm") fcs;
	mso-endnote-separator:url("./常见问题解决办法.files/header.htm") es;
	mso-endnote-continuation-separator:url("./常见问题解决办法.files/header.htm") ecs;
	mso-facing-pages:yes;}
@page Section1
	{size:521.65pt 26.0cm;
	margin:65.2pt 55.3pt 62.35pt 55.3pt;
	mso-header-margin:42.55pt;
	mso-footer-margin:42.55pt;
	mso-title-page:yes;
	mso-even-header:url("./常见问题解决办法.files/header.htm") eh1;
	mso-header:url("./常见问题解决办法.files/header.htm") h1;
	mso-paper-source:0;
	layout-grid:15.6pt;}
div.Section1
	{page:Section1;}
 /* List Definitions */
@list l0
	{mso-list-id:-132;
	mso-list-type:simple;
	mso-list-template-ids:-1097690734;}
@list l0:level1
	{mso-level-tab-stop:102.0pt;
	mso-level-number-position:left;
	margin-left:102.0pt;
	text-indent:-18.0pt;}
@list l1
	{mso-list-id:-131;
	mso-list-type:simple;
	mso-list-template-ids:1180233058;}
@list l1:level1
	{mso-level-tab-stop:81.0pt;
	mso-level-number-position:left;
	margin-left:81.0pt;
	text-indent:-18.0pt;}
@list l2
	{mso-list-id:-130;
	mso-list-type:simple;
	mso-list-template-ids:-2064373082;}
@list l2:level1
	{mso-level-tab-stop:60.0pt;
	mso-level-number-position:left;
	margin-left:60.0pt;
	text-indent:-18.0pt;}
@list l3
	{mso-list-id:-129;
	mso-list-type:simple;
	mso-list-template-ids:170545154;}
@list l3:level1
	{mso-level-tab-stop:39.0pt;
	mso-level-number-position:left;
	margin-left:39.0pt;
	text-indent:-18.0pt;}
@list l4
	{mso-list-id:-128;
	mso-list-type:simple;
	mso-list-template-ids:1100139164;}
@list l4:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F06C;
	mso-level-tab-stop:102.0pt;
	mso-level-number-position:left;
	margin-left:102.0pt;
	text-indent:-18.0pt;
	font-family:Wingdings;}
@list l5
	{mso-list-id:-127;
	mso-list-type:simple;
	mso-list-template-ids:1138386572;}
@list l5:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F06C;
	mso-level-tab-stop:81.0pt;
	mso-level-number-position:left;
	margin-left:81.0pt;
	text-indent:-18.0pt;
	font-family:Wingdings;}
@list l6
	{mso-list-id:-126;
	mso-list-type:simple;
	mso-list-template-ids:1990514968;}
@list l6:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F06C;
	mso-level-tab-stop:60.0pt;
	mso-level-number-position:left;
	margin-left:60.0pt;
	text-indent:-18.0pt;
	font-family:Wingdings;}
@list l7
	{mso-list-id:-125;
	mso-list-type:simple;
	mso-list-template-ids:813702446;}
@list l7:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F06C;
	mso-level-tab-stop:39.0pt;
	mso-level-number-position:left;
	margin-left:39.0pt;
	text-indent:-18.0pt;
	font-family:Wingdings;}
@list l8
	{mso-list-id:-120;
	mso-list-type:simple;
	mso-list-template-ids:975354106;}
@list l8:level1
	{mso-level-tab-stop:18.0pt;
	mso-level-number-position:left;
	margin-left:18.0pt;
	text-indent:-18.0pt;}
@list l9
	{mso-list-id:-119;
	mso-list-type:simple;
	mso-list-template-ids:741769826;}
@list l9:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F06C;
	mso-level-tab-stop:18.0pt;
	mso-level-number-position:left;
	margin-left:18.0pt;
	text-indent:-18.0pt;
	font-family:Wingdings;}
@list l10
	{mso-list-id:113520776;
	mso-list-type:simple;
	mso-list-template-ids:-45292118;}
@list l10:level1
	{mso-level-number-format:bullet;
	mso-level-text:\F06C;
	mso-level-tab-stop:42.55pt;
	mso-level-number-position:left;
	margin-left:42.55pt;
	text-indent:-21.3pt;
	font-family:Wingdings;}
@list l11
	{mso-list-id:362488226;
	mso-list-template-ids:580420818;}
@list l11:level1
	{mso-level-style-link:图上字;
	mso-level-text:%1;
	mso-level-tab-stop:21.25pt;
	mso-level-number-position:left;
	margin-left:21.25pt;
	text-indent:-21.25pt;}
@list l11:level2
	{mso-level-text:"%1\.%2";
	mso-level-tab-stop:49.6pt;
	mso-level-number-position:left;
	margin-left:49.6pt;
	text-indent:-1.0cm;}
@list l11:level3
	{mso-level-suffix:space;
	mso-level-text:"%1\.%2\.%3";
	mso-level-tab-stop:none;
	mso-level-number-position:left;
	margin-left:0cm;
	text-indent:0cm;}
@list l11:level4
	{mso-level-text:"%1\.%2\.%3\.%4";
	mso-level-tab-stop:99.2pt;
	mso-level-number-position:left;
	margin-left:99.2pt;
	text-indent:-35.4pt;}
@list l11:level5
	{mso-level-text:"%1\.%2\.%3\.%4\.%5";
	mso-level-tab-stop:127.55pt;
	mso-level-number-position:left;
	margin-left:127.55pt;
	text-indent:-42.5pt;}
@list l11:level6
	{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6";
	mso-level-tab-stop:163.0pt;
	mso-level-number-position:left;
	margin-left:163.0pt;
	text-indent:-2.0cm;}
@list l11:level7
	{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7";
	mso-level-tab-stop:191.35pt;
	mso-level-number-position:left;
	margin-left:191.35pt;
	text-indent:-63.8pt;}
@list l11:level8
	{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8";
	mso-level-tab-stop:219.7pt;
	mso-level-number-position:left;
	margin-left:219.7pt;
	text-indent:-70.9pt;}
@list l11:level9
	{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.%9";
	mso-level-tab-stop:255.1pt;
	mso-level-number-position:left;
	margin-left:255.1pt;
	text-indent:-85.0pt;}
@list l12
	{mso-list-id:560605600;
	mso-list-type:simple;
	mso-list-template-ids:-1798041342;}
@list l12:level1
	{mso-level-number-format:bullet;
	mso-level-style-link:项目;
	mso-level-text:\F06C;
	mso-level-tab-stop:42.55pt;
	mso-level-number-position:left;
	margin-left:42.55pt;
	text-indent:-21.3pt;
	font-family:Wingdings;}
@list l13
	{mso-list-id:997878427;
	mso-list-type:simple;
	mso-list-template-ids:334426564;}
@list l13:level1
	{mso-level-number-format:bullet;
	mso-level-style-link:"标题 6";
	mso-level-text:\F06C;
	mso-level-tab-stop:42.55pt;
	mso-level-number-position:left;
	margin-left:42.55pt;
	text-indent:-21.3pt;
	font-family:Wingdings;}
@list l14
	{mso-list-id:1289361798;
	mso-list-type:simple;
	mso-list-template-ids:-118981464;}
@list l14:level1
	{mso-level-number-format:bullet;
	mso-level-style-link:标题7;
	mso-level-text:\F0D8;
	mso-level-tab-stop:63.8pt;
	mso-level-number-position:left;
	margin-left:63.8pt;
	text-indent:-21.25pt;
	font-family:Wingdings;}
ol
	{margin-bottom:0cm;}
ul
	{margin-bottom:0cm;}
-->
</style>
</head>

<body lang=ZH-CN style='tab-interval:21.25pt;text-justify-trim:punctuation'>

<div class=Section1 style='layout-grid:15.6pt'>

<p class=a3><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>在本系统的开发过程中经常出现以下的问题。</span><span
lang=EN-US style='mso-fareast-font-family:宋体'><o:p></o:p></span></p>

<p class=MsoNormal style='text-indent:21.1pt;mso-char-indent-count:2.01;
mso-char-indent-size:10.45pt'><span lang=EN-US>1</span><span style='font-family:
宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'>．在设置并执行</span><span
lang=EN-US>SQL</span><span style='font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>语句时，如果设置的</span><span lang=EN-US>SQL</span><span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>语句有语法错误，则显示错误信息，如下图所示。此时无法判断</span><span lang=EN-US>SQL</span><span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>语句的错误所在，解决的办法是</span><span style='mso-bidi-font-size:10.5pt;
font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>在应用程序调试阶段，在程序中使用</span><span lang=EN-US style='mso-bidi-font-size:
10.5pt'>MsgBox</span><span style='mso-bidi-font-size:10.5pt;font-family:宋体;
mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'>语句显示要执行的</span><span
lang=EN-US style='mso-bidi-font-size:10.5pt'>SQL</span><span style='mso-bidi-font-size:
10.5pt;font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>语句，供用户鉴别。如果用户鉴别不出来</span><span lang=EN-US style='mso-bidi-font-size:
10.5pt'>SQL</span><span style='mso-bidi-font-size:10.5pt;font-family:宋体;
mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'>语句错误原因或者该语句是否正确时，可以使用</span><span
lang=EN-US style='mso-bidi-font-size:10.5pt'>SQL Server</span><span
style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>的查询分析器验证这条</span><span lang=EN-US
style='mso-bidi-font-size:10.5pt'>SQL</span><span style='mso-bidi-font-size:
10.5pt;font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>语句。在</span><span lang=EN-US style='mso-bidi-font-size:10.5pt'>SQL
Server</span><span style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>的查询分析器中，如果</span><span
lang=EN-US style='mso-bidi-font-size:10.5pt'>SQL</span><span style='mso-bidi-font-size:
10.5pt;font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>语句有错误，可以看到错误的详细信息。</span></p>

<p class=MsoNormal align=center style='text-align:center'><span lang=EN-US><!--[if gte vml 1]><v:shapetype
 id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t"
 path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
 <v:stroke joinstyle="miter"/>
 <v:formulas>
  <v:f eqn="if lineDrawn pixelLineWidth 0"/>
  <v:f eqn="sum @0 1 0"/>
  <v:f eqn="sum 0 0 @1"/>
  <v:f eqn="prod @2 1 2"/>
  <v:f eqn="prod @3 21600 pixelWidth"/>
  <v:f eqn="prod @3 21600 pixelHeight"/>
  <v:f eqn="sum @0 0 1"/>
  <v:f eqn="prod @6 1 2"/>
  <v:f eqn="prod @7 21600 pixelWidth"/>
  <v:f eqn="sum @8 21600 0"/>
  <v:f eqn="prod @7 21600 pixelHeight"/>
  <v:f eqn="sum @10 21600 0"/>
 </v:formulas>
 <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
 <o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:264pt;
 height:132.75pt'>
 <v:imagedata src="./常见问题解决办法.files/image001.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=352 height=177
src="./常见问题解决办法.files/image002.jpg" v:shapes="_x0000_i1025"><![endif]></span></p>

<p class=MsoNormal><span lang=EN-US>2</span><span style='font-family:宋体;
mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'>．在</span><span
lang=EN-US>Visual Basic</span><span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>中，当重复打开数据库连接时，将显示错误信息，如下图所示。为了避免在该系统中多次重复打开数据库连接，应该首先判断该数据库连接对象是否处于连接状态，如果没有连接，则根据当前的数据库连接字符串，连接数据库。</span></p>

<p class=MsoNormal align=center style='text-align:center'><span lang=EN-US><!--[if gte vml 1]><v:shape
 id="_x0000_i1026" type="#_x0000_t75" style='width:264pt;height:132.75pt'>
 <v:imagedata src="./常见问题解决办法.files/image003.png" o:title=""/>
</v:shape><![endif]--><![if !vml]><img width=352 height=177
src="./常见问题解决办法.files/image004.jpg" v:shapes="_x0000_i1026"><![endif]></span></p>

<p class=MsoNormal><span lang=EN-US>3</span><span style='font-family:宋体;
mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'>．在</span><span
lang=EN-US>Visual Basic</span><span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>中当</span><span
style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>构造</span><span lang=EN-US
style='mso-bidi-font-size:10.5pt'>SQL</span><span style='mso-bidi-font-size:
10.5pt;font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>语句时，如果存储数据存在单引号的话，将意外截断字符并造成</span><span lang=EN-US
style='mso-bidi-font-size:10.5pt'>SQL</span><span style='mso-bidi-font-size:
10.5pt;font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>语法错误。解决的办法是使用</span><span lang=EN-US style='mso-bidi-font-size:
10.5pt'>Replace(</span><span style='mso-bidi-font-size:10.5pt;font-family:宋体;
mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"'>函数来过滤掉存储数据中的单引号</span><span
style='font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"'>。例如使用语句</span><span lang=EN-US style='mso-bidi-font-size:
10.5pt'>Replace(strOrigional, &quot;'&quot;, &quot;''&quot;)</span><span
style='mso-bidi-font-size:10.5pt;font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"'>。</span></p>

</div>

</body>

</html>
12

常见问题解决办法.htm - 源码说明

本页面展示了「里面的内容包括：基盘存管理本信息管理库存管理入库管理出库管理等功能」中的 常见问题解决办法.htm 源码文件，采用 HTM 编程语言编写，共 939 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与信息管理相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?