<?xml version="1.0" encoding="UTF-8" ?>
<jsp:root
	xmlns:jsp="http://java.sun.com/JSP/Page"
	xmlns:c="http://java.sun.com/jsp/jstl/core"
	xmlns:og="hybs-taglib.tld"
	version="2.0">
<jsp:directive.page language="java" contentType="text/html; charset=UTF-8" />
<og:head headType="query" />
<jsp:directive.include file="/jsp/custom/query_info.jsp" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "GF7221"
	title	= "配置図/座席表配置"
	date	= "2015/09/14"
	author	= "K.Hasegawa"
	text	= ""
	version	= "001"
/>

<!-- 初期値設定しています。 -->
<og:value key="LOC_GRP" value="オーケストラ" />

<form method="GET" action="forward.jsp" target="RESULT" onSubmit="timeSet();">
	<!-- 変更はここから -->
	<table >
		<tr>
			<og:column name="SYSTEM_ID" value="{@SYS.SYSTEM_ID}"  readonly="true" size="5" />
			<og:column name="LOC_GRP"		size="10" must="true" />
			<og:column name="LOC_KEY"		aimai="V*" />
			<og:column name="NAME_JA"		editor="DBMENU" eventColumn="LOC_GRP"
				param="select NAME_JA from GE18 where SYSTEM_ID='{@SYS.SYSTEM_ID}' and LOC_GRP='{@LOC_GRP}' group by NAME_JA order by 1" />
	<!--	<og:column name="LABEL_NAME"	aimai="V*" />	-->
		</tr>
		<tr>
			<og:column name="R_KEY1"		editor="DBMENU" eventColumn="LOC_GRP"
				param="select R_KEY1 from GE18 where SYSTEM_ID='{@SYS.SYSTEM_ID}' and LOC_GRP='{@LOC_GRP}' group by R_KEY1 order by 1" />
			<og:column name="R_KEY2"		editor="DBMENU" eventColumn="LOC_GRP"
				param="select R_KEY2 from GE18 where SYSTEM_ID='{@SYS.SYSTEM_ID}' and LOC_GRP='{@LOC_GRP}' group by R_KEY2 order by 1" />
			<og:column name="R_KEY3"		editor="DBMENU" eventColumn="LOC_GRP"
				param="select R_KEY3 from GE18 where SYSTEM_ID='{@SYS.SYSTEM_ID}' and LOC_GRP='{@LOC_GRP}' group by R_KEY3 order by 1" />
	<!--	<og:column name="BIKO"			aimai="*V*" />	-->
		</tr>
	</table>

	<og:queryButton />
</form>

<jsp:directive.include file="/jsp/common/htmlend.jsp" />
</jsp:root>
