<?xml version="1.0" ?>
<jsp:root
	xmlns:jsp="http://java.sun.com/JSP/Page"
	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   = "GE:エンジンサンプル"
	pgid     = "REP12"
	title    = "EXCELワーク参照"
	date     = "2007/12/12"
	author   = "K.HASEGAWA"
	text     = "ZZZZ"
	version  = "001"
/>

<form method="GET" action="forward.jsp" target="RESULT" onSubmit="timeSet();">

<!-- 変更はここから -->
<table summary="layout" >
<tr>
	<!-- SYSTEM_IDを検索するメニュー onChangeイベントで再呼び出し -->
	<og:select name="SYSTEM_ID" onChange="renew('query.jsp','QUERY'); " must="true">
		<og:option value="" lbl="" />
		<og:queryOption>
			select SYSTEM_ID from GE57 group by SYSTEM_ID order by SYSTEM_ID
		</og:queryOption>
	</og:select>

	<og:select name="TABLE_NAME" must="true">
		<og:queryOption>
				select HEADDBID AS TABLE_NAME from GE57
				where SYSTEM_ID = '{@SYSTEM_ID}'
				and   HEADDBID IS NOT NULL
				group by HEADDBID
				union
				select BODYDBID AS TABLE_NAME  from GE57
				where SYSTEM_ID = '{@SYSTEM_ID}'
				and   BODYDBID IS NOT NULL
				group by BODYDBID
	--			order by TABLE_NAME
				order by TABLE_NAME
		</og:queryOption>
	</og:select>

	<og:column name="YKNO" />
	<og:column name="SHEETNO" />
</tr>
</table>

<og:queryButton />
</form>

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