Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

primary key detection fails in mySQL for some tables

2 posts in DataWindow Last posting was on 2008-08-22 07:35:23.0Z
Chris Werner Posted on 2008-08-20 14:49:37.0Z
From: "Chris Werner" <cwAT{PleaseNoSpam}f-s.de>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: primary key detection fails in mySQL for some tables
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48ac2f01@forums-1-dub>
Date: 20 Aug 2008 07:49:37 -0700
X-Trace: forums-1-dub 1219243777 10.22.241.152 (20 Aug 2008 07:49:37 -0700)
X-Original-Trace: 20 Aug 2008 07:49:37 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87596
Article PK: 416852

Hi,

for some tables in a mySQL databases PowerBuilders primary
key detection fails. That isn't a show stopper in the IDE's
datawindow painter where I can change the update properties
manually. But dataobjects created at runtime using
SQLCA.syntaxFromSQL() and dw.create() don't work work
correctly. Any ideas how to solve that?

Using PB 10.5.2 Build 7611

TIA

Chris Werner
f+s software gmbh


Chris Werner Posted on 2008-08-22 07:35:23.0Z
From: "Chris Werner" <cwAT{PleaseNoSpam}f-s.de>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48ac2f01@forums-1-dub>
Subject: Re: primary key detection fails in mySQL for some tables
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48ae6c3b@forums-1-dub>
Date: 22 Aug 2008 00:35:23 -0700
X-Trace: forums-1-dub 1219390523 10.22.241.152 (22 Aug 2008 00:35:23 -0700)
X-Original-Trace: 22 Aug 2008 00:35:23 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87613
Article PK: 416869

Hi all,

the problem seems to be solved, my application runs again.
Investigating the tables which have the problem shows that
they have a primary key and an additional unique index on
the same column. After I drop the useless unique index the
primary key is found again.

Chris Werner
f+s software gmbh



"Chris Werner" <cwAT{PleaseNoSpam}f-s.de> schrieb im Newsbeitrag
news:48ac2f01@forums-1-dub...

> Hi,
>
> for some tables in a mySQL databases PowerBuilders primary
> key detection fails. That isn't a show stopper in the IDE's
> datawindow painter where I can change the update properties
> manually. But dataobjects created at runtime using
> SQLCA.syntaxFromSQL() and dw.create() don't work work
> correctly. Any ideas how to solve that?
>
> Using PB 10.5.2 Build 7611
>
> TIA
>
> Chris Werner
> f+s software gmbh
>