Date:         Tue, 24 Jun 2003 02:15:41 -0400
Reply-To:     Tony <hztangli@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Tony <hztangli@YAHOO.COM>
Subject:      Re: SAS/htmSQL and AppDevStudio 1.2 not running

Hello Pawel,
Try the following:
1.
{query server="yourserver:port"}
{sql}
select myfield, myfield as myfield_formatted_value format=myFormat.
from libref.yourTable ...
or
2.select myfield, put(myfield,myFormat.) as myfield_formatted_value
from ...

There are a lot of bugs and some patchs for AppDev Studio version 1.2.
I suggest you contact your SI sales Rep. and get at least 2.0 version(not
sure license policy).Version 2.0 is much better than 1.2,but your JRE from
J2SDK 1.4.1_02 could still cause you problem(2.0.1 needs JRE 1.3.0_01,for
example).

Regards,
Tony

On Sat, 21 Jun 2003 16:05:06 +0200, =?iso-8859-2?Q?Pawe=B3_Piaskowy?=
<sandworm@BOX43.GNET.PL> wrote:

>Hi to all!
>
>Is posiblle to apply formats to fields fetched from dataset in htmSQL
page?
>Is there any function to do that? (I can not find any) If answer is true,
>please tell me how :-)
>
>I would like to get something like that (assume query executed
successfully
>and myfield exsits):
><select name="gender" size="1">
>{eachrow}<option {&myfield_value}>{&myfield_formatted_value}
>{/eachrow}
></select>
>where {&myfield_value} is field value and {&myfield_formatted_value} is
>formatted field value.
>
>I have also another question.
>
>We have got SAS/AppDevStudio (1.2) license. I read somewhere that there is
>version 3.x. Can we download it from the web? (or get updates)
>Unfortunately our version is not working (reinstalled few times without
>effect). WebAF shows splash-screen when starting and nothing else happens
>(it quits unexpectedly without any warning, javalog, etc.). WebEIS
generates
>Windows OS exception when starting ("java.exe generated errors and will be
>closed by Windows. Please rerun program. Log is being generated" - I have
>localized version of Windows so it is my translation of exception). The
most
>funny thing is that there are not any new entries in java and/or Windows
>logs. I have J2SDK 1.4.1_02 installed and it is working fine. Is it Java
>issue? (i recall SAS Online Help and IE6SP1 issue) Are there any patches
>available?
>Operating system: Windows 2000 Proffesional SP3, IE 6 SP1 and other IE an
>W2000 fixpacks
>SAS 8.02 TS Level 02M0 with few updates
>
>Thanks in advance.
>Pawel Piaskowy