🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: 求救!VFP的GRID问题�

#10654
From: lzw
Date: Wed, 10 Dec 1997 00:00
18 lines
1716 bytes

>: >��ѧVFP5.0����GRID���⼸�ղ�����⡣
>: >1������GRID��RECORDSORCE��дSQL��䣺
>: >  SELECT * FROM TABLE1 WHERE TABLE1.FIELD1=VISIBLE1 INTO CURSOR TEMP
><: ����һ���Ϊ:
><: SELECT * FROM TABLE1 WHERE TABLE1.FIELD1=?VISIBLE1 INTO CURSOR TEMP
><: ��һ��.
>  �������Dz��С���SQL��䵥�����ж�����ȷ�ġ�����һ��Īչ����
Ϊʲô������?���г�����һ��,���������ʾ����:
��������һ��FORM��INIT�����ж�����һ��PUBLIC test ����,���丶ֵ
Ȼ����Grid������RecordSource=Select * from Mytable  into cursor tmp where
Mytable.field1 like test
RecordSourceType=4-SQL˵��
Ȼ������һ��OK.
�һ������select -sql���������,VFP��SQL������ȫ����ANSI SQL��׼.
��Щ������Ͳ������Զ�ת��,һ��Ҫע��,���ͬ���һ��SELECT�����ORACLE������
����VFP�򲻿�.�������ĵ���һ��,ף�����.
Technical Details
Message-ID: <66jsg7$d3o$1@clinux.ml.org>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <3M2Wk3$Z0G@clinux.ml.org>

Show Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB
X-Google-Thread: 101948,3179ea127485a9d4
X-Google-Attributes: gid101948,public
From: "lzw" <zhiweili@hotmail.com>
Subject: Re: 求救!VFP的GRID问题�
Date: 1997/12/10
Message-ID: <66jsg7$d3o$1@clinux.ml.org>
X-Deja-AN: 296641838
References: <3M2Wk3$Z0G@clinux.ml.org>
X-Server-Date: 9 Dec 1997 16:43:51 GMT
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Newsgroups: cn.bbs.comp.database