🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.lang.visual-basic
Article #20861

Re: ������access97�²�ѯʱ���sqlӦ�����д�� (ת��)

#20861
From: �׺�����
Date: Tue, 29 Jul 2003 16:00
17 lines
1610 bytes
�� �� xfgavin (�Ҿ��Ǹ����ˣ���ô�ţ���) �Ĵ������ᵽ: ��
: �� ��������ת���� Database ������ ��
: ������: xfgavin (�Ҿ��Ǹ����ˣ���ô�ţ���), ����: Database
: ��  ��: ������access97�²�ѯʱ���sqlӦ�����д��
: ����վ: BBS ˮľ�廪վ (Tue Jul 29 19:38:19 2003), ת��
: �ҵģ�
: sql = "select * from sometable where datacolumn=#" & datavalue(date) & "#"
: Ϊʲô�����أ�
: ���

1.datavalue function��ʲô?����Ҫstring
2.u can try in access 97 ��ѯ����try

--

�� ��Դ:��BBS ˮľ�廪վ smth.org��[FROM: 211.92.50.98]
Technical Details
Message-ID: <000000$4Ct@smth.org>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-05!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!maily.cic.tsinghua.edu.cn!SMTH

Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB
X-Google-Thread: 109fdd,e733f96c1dc81396
X-Google-Attributes: gid109fdd,public
X-Google-ArrivalTime: 2003-07-29 09:05:02 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-05!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!maily.cic.tsinghua.edu.cn!SMTH
From: henryl@smth.org (�׺�����)
Newsgroups: cn.bbs.comp.lang.visual-basic
Subject: Re: ������access97�²�ѯʱ���sqlӦ�����д�� (ת��)
Date: 29 Jul 2003 16:00:57 GMT
Organization: BBS ˮľ�廪վ
Message-ID: <000000$4Ct@smth.org>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: VisualBasic/c/M.1059494388.A0
Lines: 17