🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #10092

delphi��SQL�ù�

#10092
From: Stray
Date: Tue, 14 Apr 1998 00:00
18 lines
1415 bytes

ǰЩ����delphi 1.0 д��һ����ݿ����,��һ�����������SQL,����:
   select Sale.TicketNo,Sale.oringin,Sale.Type
   from Sale,StoredTicketNo
   where Sale.TicketNo=StoredTicketNo.TicketNo
����������ݽ���ʱ(100������),û�κ�����,�ɳ���һ������ʱ,
Delphi��Ȼ��TicketNo�ֶ����ΪTicketNo_1,��ʵ�ڲ���Ϊʲô
��¼���ٲ�һ��ʱ,��Query��SQL�õ����ֶ���Ϊ�β�ͬ.(��ʵ��
��ʹ��¼��ʱ,������ͬ�������BDB��SQL�еõ����ֶ���ҲΪTicketNo.)
��Ȼ�������İ취Ҳ�Ǽ򵥵�,�ɸ�Ϊ
      select Sale.TicketNo TicketNo ,Sale.oringin,Sale.Type
      from Sale,StoredTicketNo
      where Sale.TicketNo=StoredTicketNo.TicketNo
����ʵ����֪�������ԭ��,����ݿⰮ���߰�æ.

--
�� ��Դ: �й�ƴ�BBSվ [bbs.ustc.edu.cn]
Technical Details
Message-ID: <980414.yOvgc$PBBS@bbs.ustc.edu.cn>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB
X-Google-Thread: 101948,b0a6781cad572cb7,start
X-Google-Attributes: gid101948,public
From: Li_Heng@bbs.ustc.edu.cn (Stray)
Subject: delphi��SQL�ù�
Date: 1998/04/14
Message-ID: <980414.yOvgc$PBBS@bbs.ustc.edu.cn>
X-Deja-AN: 343987226
Organization: �й�ƴ�BBSվ
Newsgroups: cn.bbs.comp.database