RE: java code help...

Question #1: the actual field name is probably "CUSNUM" and not "A.CUSNUM".

Question #2: if you want to use Java to display data in tabular format on
your PC screen, then you probably want to use a JTable from the Swing
components.  But it would take much more than a few minutes to explain that,
so I'll just point you towards a tutorial on that subject:
http://java.sun.com/docs/books/tutorial/uiswing/components/table.html

PC2

-----Original Message-----
From: Hatzenbeler, Tim [mailto:thatzenbeler@clinitech.net]
Sent: November 15, 2001 12:56
To: 'java400-l@midrange.com'
Subject: java code help...


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
I'm really trying to understand java, and right now, all I have are 2
examples, that I found out on the net...
And I got them to compile and run, on the PC, using the 400 toolbox jar..

I was wondering if someone could hold my hand for a few minutes, and offer
me a great big push in the right direction...

Question #1.  I have this code, and I have modified it, so I could attempt
to qualify the field names...  But it didn't work... Could someone please
correct my error.

ERROR Message at runtime: An undefined column name was detected.

    ResultSet rs = stmt.executeQuery ("SELECT * FROM QIWS.QCUSTCDT A ORDER
BY LSTNAM");
        while (rs.next ()) {
                String cusnum = rs.getString("A.CUSNUM");

Question #2,  Could someone please show me how to take the result set that I
get, and instead of printing it in a dos window, how would I place the data
in a real window on my pc, in a datasheet type view (similar to excel, or
when I do an SQL through ops nav)...

I offer many thanks,  tim...