《计算机二级考试培训班关联》由会员分享，可在线阅读，更多相关《计算机二级考试培训班关联（11页珍藏版）》请在金锄头文库上搜索。
1、关联 Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.一对多关联 父表中有一个记录通过关联字段与子表中 一个记录对应 Evaluation only.Evaluation only. Cr
2、eated with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.操作步骤 选择工作区 打开子表 建立索引 选择另一个工作区 打开父表 发出关联命令SELE 1 USE 选课 INDEX ON 学号 TO XH SELE 2 USE 学生 SET RELATION TO 学号
3、 INTO A建立关联后，父表的指针能够带动子表指针移动；反之，不行。Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.建立程序文件建立程序文件 文件/新建/程序 或在命令窗口输入 : Mo
4、dify command 文件名Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.一对多关联一对多关联Evaluation only.Evaluation only. Created wit
5、h Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.SELE 1 USE 成绩 INDEX ON SUBSTR(学号,3) TAG XH SELE 2 USE 学生 SET RELATION TO 学号 INTO ALIST 学号,姓名,A.学号,A.课程号,A.成绩SET SK
6、IP TO AEvaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd. SET SKIP TO 工作区号 用在“一对多”关联时，指向子表为“多”的一方 Evaluation only.Evalua
7、tion only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.SET SKIP TO SET SKIP TO别名别名功能：功能：创建表与表之间的一对多关系。创建表与表之间的一对多关系。当记录指针在父表中移动时，子表中的记录指针也移动到第一个对应的
8、记录上当记录指针在父表中移动时，子表中的记录指针也移动到第一个对应的记录上。如果对于父表中每一个记录都建立了一对一的关系，记录指针将移到子表中。如果对于父表中每一个记录都建立了一对一的关系，记录指针将移到子表中第一个相匹配的记录上。如果在子表中找不到相匹配的记录，则记录指针移到第一个相匹配的记录上。如果在子表中找不到相匹配的记录，则记录指针移到表尾。表尾。很多情况下，父表中的一个记录通常在子表中有多个记录与之对应。很多情况下，父表中的一个记录通常在子表中有多个记录与之对应。SET SET SKIP SKIP 允许在父表的一个记录与子表的多个记录之间建立一对多关系。当浏览父允许在父表的一个记录与
9、子表的多个记录之间建立一对多关系。当浏览父表时，父表的记录指针将一直保持不动，直到记录指针移过子表中所有相关的表时，父表的记录指针将一直保持不动，直到记录指针移过子表中所有相关的记录为止。记录为止。Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyri
10、ght 2004-2011 Aspose Pty Ltd.多对一关联 将”一”作为子表,所以不需要设置 Set skip to Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.三表关联三表
11、关联可以看作两次两表关联Evaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.select 1 use 学生 INDEX ON 学号 TAG XH SELECT 2 USE 课程 INDEX O
12、N 课程号 TAG KCH SELECT 3 USE 选课 SET RELATION TO 学号 INTO A,课程号 INTO B LIST LIST A.学号,A.姓名,B.课程号,B.课程名ADDITIVEEvaluation only.Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0.Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd.Copyright 2004-2011 Aspose Pty Ltd.
