Using SQLExec and Record Objects

使用SQLExec填充记录对象

最新推荐文章于 2022-04-16 10:54:01 发布

WTK870424

最新推荐文章于 2022-04-16 10:54:01 发布

阅读量457

点赞数

分类专栏： peoplesoft 文章标签： object user

peoplesoft 专栏收录该内容

203 篇文章

订阅专栏

本文介绍了一种使用SQLExec来填充记录对象的方法，这种方法不依赖于记录的关键字段。通过示例展示了如何为特定员工ID查找PSOPRDEFN记录，并自动加载所有字段，即使表结构发生变化也不影响代码的适用性。

Using SQLExec and Record Objects

Here is a quick code snippet to show how to use SQLExec to pull data into a record object not using the key fields of the record. It is not clear in PeopleBooks how to use Record objects with SQLExec. I use record objects all over the place in my peoplecode. Here is a quick way to do a select to populate a record object NOT using key fields.

In this example we will populate a record object for PSOPRDEFN for the user profile that has the employee id of “EE2343.” The only key field on PSORPDEFN is OPRID which we are trying to find.

Local Record &recO;
&recO = CreateRecord(Record.PSOPRDEFN);
SQLExec("%selectall(:1) WHERE PSOPRDEFN.EMPLID = :2", &recO, "EE2343", &recO);

The great thing about this is that it automatically pulls all the fields. If you later add or remove fields from the record you are selecting from you do not have to touch this code because “%selectall” will dynamically figure out the fields based on the record definition.