Article View: borland.public.jbuilder.database
Article #172Re: picklist will not populate from database
From: Peter Wetjens
Date: Sat, 22 Apr 2006 08:16
Date: Sat, 22 Apr 2006 08:16
52 lines
3265 bytes
3265 bytes
Sorry, see below
database1.setConnection(new ConnectionDescriptor(
"jdbc:mysql://10.0.0.199:3306/rooster", "user", "password",
false,
"com.mysql.jdbc.Driver"));
jdbTable1.setDataSet(queryDataSet1);
jdbStatusLabel1.setText("jdbStatusLabel1");
dBDisposeMonitor1.setDataAwareComponentContainer(this);
queryDataSet1.setQuery(new
com.borland.dx.sql.dataset.QueryDescriptor(
database1, "SELECT * FROM USER", null, true, Load.ALL));
queryDataSet2.setQuery(new QueryDescriptor(database1,
"SELECT TEMPLATE_NAME FROM TEMPLATE", null, true,
Load.ALL));
column1.setColumnName("USER_TEMPLATE");
column1.setDataType(com.borland.dx.dataset.Variant.STRING);
column1.setPickList(new com.borland.dx.dataset.PickListDescriptor(
queryDataSet2, new String[] {"TEMPLATE_NAME"},
new String[] {"TEMPLATE_NAME"},
new String[] {"USER_TEMPLATE"}, null, false));
column1.setPrecision(30);
column1.setTableName("USER");
column1.setServerColumnName("USER_TEMPLATE");
column1.setSqlType(12);
contentPane.add(jdbStatusLabel1, java.awt.BorderLayout.SOUTH);
contentPane.add(jdbNavToolBar1, java.awt.BorderLayout.NORTH);
contentPane.add(jScrollPane1, java.awt.BorderLayout.CENTER);
jScrollPane1.getViewport().add(jdbTable1, null);
queryDataSet1.setColumns(new Column[] {column1});
"Kevin Dean [TeamB]" <NkOdSePaAnM@datadevelopment.com> schreef in bericht
news:xn0el8ypl3m92t000-kdean@www.teamb.com...
> Peter Wetjens wrote:
>
>>Below I included my code, because I don't understand your question. My
>>guess, the answer is "yes".
>
> There's no code in your post.
>
> --
> Kevin Dean [TeamB]
> Dolphin Data Development Ltd.
> http://www.datadevelopment.com/
>
> NEW WHITEPAPERS
> Team Development with JBuilder and Borland Enterprise Server
> Securing Borland Enterprise Server
> http://www.datadevelopment.com/papers/index.html
>
> Please see Borland's newsgroup guidelines at
> http://info.borland.com/newsgroups/guide.html
Technical Details
Message-ID:
<4449e667$0$3655$ba620dc5@nova.planet.nl>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news4.google.com!news.glorb.com!feeder.enertel.nl!nntpfeed-01.ops.asmr-01.energis-idc.net!newsfeeder.wxs.nl!divide.nova.planet.nl!posting.nova.planet.nl!not-for-mailReferences:
<44468e94$1@newsgroups.borland.com> <xn0el7k2whrik001-kdean@www.teamb.com> <444902b7@newsgroups.borland.com> <xn0el8ypl3m92t000-kdean@www.teamb.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 1073da,31f881c625ff6d88 X-Google-Attributes: gid1073da,public X-Google-Language: ENGLISH,ASCII-7-bit Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news4.google.com!news.glorb.com!feeder.enertel.nl!nntpfeed-01.ops.asmr-01.energis-idc.net!newsfeeder.wxs.nl!divide.nova.planet.nl!posting.nova.planet.nl!not-for-mail From: "Peter Wetjens" <peterwetjens@planet.nl> Newsgroups: borland.public.jbuilder.database References: <44468e94$1@newsgroups.borland.com> <xn0el7k2whrik001-kdean@www.teamb.com> <444902b7@newsgroups.borland.com> <xn0el8ypl3m92t000-kdean@www.teamb.com> Subject: Re: picklist will not populate from database Date: Sat, 22 Apr 2006 10:16:29 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Response Lines: 54 Message-ID: <4449e667$0$3655$ba620dc5@nova.planet.nl> NNTP-Posting-Host: 80.61.249.52 X-Trace: 1145693799 nova.planet.nl 3655 80.61.249.52:35764 X-Complaints-To: abuse@planet.nl