📄 6222.html
字号:
<html>
<head>
<title>Re: about defin field</title>
</head>
<body bgcolor="#FFFFFF" vlink="#808080">
<center>
<h1>Re: about defin field</h1>
</center>
<hr size=7 width=75%>
<hr size=7 width=75%><p>
Posted by AndyLin on October 03, 1998 at 09:33:18:<p>
In Reply to: <a href="6219.html">Re: about defin field</a> posted by jen on October 03, 1998 at 00:40:16:<p>
<br>: : : 请问各位 VB 高手, 如何在 输入时, 定义栏位<p>: : : 例 :<br>: : : 新增时, idno 自动编号, idno 编码方式 = 年月日+流水号<p>: : : <br>: : : 承蒙赐教, 不胜感激 !!!!<br>: : : <br>: : 我通常有2种作法<br>: : 1 再设计一个 table 用来纪录其他 table 目前编号到多少<br>: : 2 直接在你所要异动之 table 找出最大值然后再加一<p>: <br>: Sorry, 意思表达有些不对<p>: Yes, I am create a table , 记录目前的 record number<p>: but, I don't know how to assign on vb6 <p>: when I use foxpro , command like it :<p>: select 1<br>: use a<br>: mmno = no<br>: if substr(mmno,1,6) = substr(dtoc(date()),1,2)+; substr(dtoc(date()),4,2)+;<br>: substr(dtoc(date()),7,2)<br>: mmno = str(val(mmno)+1)<br>: else<br>: mmno = substr(dtoc(date()),1,2)+; substr(dtoc(date()),4,2)+;<br>: substr(dtoc(date()),7,2)+"0001"<br>: endif<br>: select 2<br>: use b<br>: replace no with mmno<p>: <br>: Plase tell me <p>: thanks and sorry again !!!<p>假设你是透过 DAO 之方式存取 Database 试试以下作法<br>dim rst as recordset<br>dim AutoNum as integer<br>set rst=database.openrecordset("select numfield from numtable where 过滤条件")<br>if rst,eof then <br> autonum=1<br> else<br> autonum=rst("numfield")+1 <br>end if<p>如此即可取得流水号之值,再自行将其转换成你所要之字串<br>: <br>: <br>: <br>: <p><br>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 6222-->
<!--top: 6242--><li><a href="6242.html">Re: about defin field</a> <b>jen</b> <i>23:29:24 10/04/98</i>
(<!--responses: 6242-->0)
<ul><!--insert: 6242-->
</ul><!--end: 6242-->
</ul><!--end: 6222-->
<br><hr size=7 width=75%><p>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -