Article View: cn.bbs.comp.database
Article #10059Re: Help
From: �����ϴ��
Date: Thu, 14 May 1998 00:00
Date: Thu, 14 May 1998 00:00
21 lines
1695 bytes
1695 bytes
> [1;36m==> Green_Hand(��Զ������) ˵��: [37;40m[0m
> ��������һ����ݳ�������SQL���Խ��в�Ѱʱ�����dz��?
> �һ������������ֶε�ԭ����VB PROJECT WIZARD ��ɵĴ����У�
> ������������ȷ�ģ�
> datSecondaryRS.RecordSource = "select [���ϴ���],[����] from [��Ʒ���ɱ�] where [��Ʒ����]='" & datPrimaryRS.Recordset![��Ʒ����] & "'" & " Order by [���ϴ���]"
> ����д�ģ�
> "select [��Ʒ����],[��Ʒ����],[����Ʒ��],[����Ʒ��],[ʱ��],[��ע] from [��Ʒ��]where [�������]='" & Code & "'" & "and [ʱ��]>=date1" & "and [ʱ��]<=date2" & " Order by [ʱ��]"
> ȴ���dz��?
> ��ʾ��
> ������ʧ����SQL����ʶ****�ֶΣ�����Ϣ���㡣������
����һ�£������Dz������ĵĶ��š�
--
-- �������¾ã��ε������顣
--- Smiling Banana :-)
�� ��Դ: �й�ƴ�BBSվ [bbs.ustc.edu.cn]
Technical Details
Message-ID:
<980515.ya1Fp$PBBS@bbs.ustc.edu.cn>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: 101948,34ae04277af29418,start X-Google-Attributes: gid101948,public From: Banana_Chen@bbs.ustc.edu.cn (�����ϴ��) Subject: Re: Help Date: 1998/05/14 Message-ID: <980515.ya1Fp$PBBS@bbs.ustc.edu.cn> X-Deja-AN: 353882729 Organization: �й�ƴ�BBSվ Newsgroups: cn.bbs.comp.database