<?xml version="1.0" encoding="UTF-8" ?>
<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	= "GF:エンジンサンプル"
	pgid	= "DOC03"
	title	= "属性クラス定義"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>

<og:value command="SQL">
	select max(VERNO) MAXVERNO from GF21
</og:value>

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

	<!-- 変更はここから -->
	<table summary="layout" >
		<tr>
			<og:column name="VIEW" addNoValue="false"  />
			<og:select name="VALUENAME" onChange="renew('index.jsp','CONTENTS');" >
				<og:option lbl="" value="" />
				<og:queryOption>
						SELECT VALUENAME,SEQ,VALUENAME
						FROM GF25
						<og:appear startKey="WHERE VERNO = " value="'{@VERNO}'" defaultVal="'{@MAXVERNO}'" />
						GROUP BY VALUENAME,SEQ,VALUENAME
						ORDER BY 2
				</og:queryOption>
			</og:select>
			<og:column name="DESCRIPTION" aimai="*V*" />
		</tr>
		<tr>
			<og:select name="VERNO" >
				<og:option lbl="" value="" />
				<og:queryOption defaultVal="{@MAXVERNO}">
						SELECT VERNO FROM GF25 GROUP BY VERNO ORDER BY VERNO DESC
				</og:queryOption>
			</og:select>
			<og:select name="ATTKEY" onChange="submit();" >
				<og:option lbl="" value="" />
				<og:queryOption>
						SELECT ATTKEY FROM GF25
						<og:appear startKey="WHERE VERNO = " value="'{@VERNO}'" defaultVal="'{@MAXVERNO}'" />
						AND   VALUENAME = '{@VALUENAME}'
						GROUP BY ATTKEY ORDER BY ATTKEY
				</og:queryOption>
			</og:select>
			<og:column name="CONTENTS" aimai="*V*" />
			<!-- Oracle Textの検索は、ORACLE のみ。引数がnull の場合は、検索条件から消える。 -->
			<og:column name="TEXT_DATA" size="30" type="search" caseKey="{@DBF.NAME}" caseVal="ORACLE" help="/help/oracletext-ja.pdf" />
		</tr>
	</table>

	<og:queryButton>
		<og:select name="ORDER_BY" lbl="ORDER_BY" td="no">
			<og:option value="VERNO,SEQ,ATTKEY"	lbls="SEQ,ATTKEY"	/>
			<og:option value="VERNO,ATTCLASS"	lbl="ATTCLASS"		/>
			<og:option value="DESCRIPTION"		lbl="DESCRIPTION"	/>
		</og:select>
	</og:queryButton>
</form>

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