Thread View: cn.bbs.comp.database
4 messages
4 total messages
Started by ����
Sun, 07 Dec 1997 00:00
��ȣ�VFP��GRID����
Author: ����
Date: Sun, 07 Dec 1997 00:00
Date: Sun, 07 Dec 1997 00:00
18 lines
1249 bytes
1249 bytes
��ѧVFP5.0����GRID���⼸�ղ�����⡣ 1������GRID��RECORDSORCE��дSQL��䣺 SELECT * FROM TABLE1 WHERE TABLE1.FIELD1=VISIBLE1 INTO CURSOR TEMP ���GRIDһƬ�հס���ʹ����VISIBLE1Ϊȫ�ֱ����������¡� ����SELECT * FROM TABLE1 WHERE TABLE1.FIELD1="XX" INTO CURSOR TEMP ��ɡ� ͬ��SELECT * FROM TABLE1 WHERE TABLE1.FIELD1=THISFORM.SPINNER1.VALUE INTO CURSOR TEMPҲ���С� ��֪�ιʣ� 2��GRID��ˢ�¡�����THISFORM.GRID1.REFRESH��ô���У�GRIDһƬ�հ�ʲô���ޡ� ���λVFP���־ȼ��� �м������� -- [m[1;31m�� ��Դ:���ı�躹� bbs.clinux.ml.org��[FROM: 202.96.182.148][m
Re: 求救！VFP的GRID问题�
Author: lzw
Date: Sun, 07 Dec 1997 00:00
Date: Sun, 07 Dec 1997 00:00
15 lines
1093 bytes
1093 bytes
���� wrote in message <3M2Wk3$Z0G@clinux.ml.org>... >��ѧ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 ��һ��. > ���GRIDһƬ�հס���ʹ����VISIBLE1Ϊȫ�ֱ����������¡� > ����SELECT * FROM TABLE1 WHERE TABLE1.FIELD1="XX" INTO CURSOR TEMP > ��ɡ�
Re: 求救！VFP的GRID问题�
Author: lzw
Date: Sun, 07 Dec 1997 00:00
Date: Sun, 07 Dec 1997 00:00
11 lines
994 bytes
994 bytes
���� wrote in message <3M2Wk3$Z0G@clinux.ml.org>... >��ѧ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 ��һ��. > ���GRIDһƬ�հס���ʹ����VISIBLE1Ϊȫ�ֱ����������¡�
Re: 求救！VFP的GRID问题�
Author: lzw
Date: Wed, 10 Dec 1997 00:00
Date: Wed, 10 Dec 1997 00:00
18 lines
1716 bytes
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��.�������ĵ���һ��,ף�����.
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads