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.

Error 5005 when setting MasterFields of AdsTable in ObjectInspector

4 posts in DelphidotNet Last posting was on 2008-05-02 09:16:44.0Z
Wolfgang Hanke Posted on 2008-04-30 12:30:28.0Z
From: "Wolfgang Hanke" <whanke@visigate.de>
Newsgroups: Advantage.DelphidotNet
Subject: Error 5005 when setting MasterFields of AdsTable in ObjectInspector
Date: Wed, 30 Apr 2008 14:30:28 +0200
Lines: 16
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: 80.228.194.216
Message-ID: <4818650b@solutions.advantagedatabase.com>
X-Trace: 30 Apr 2008 06:24:43 -0700, 80.228.194.216
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!80.228.194.216
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:139
Article PK: 1108573

Hello,

I create a blank project with only one AdsTable specifiying the ADTDemoData
as DatabaseName, animals as TableName and a TDataSource with this Table as
dataset.
When I now create a second Table with this Datasource as Mastersource, i
cant choose a Masterfield cause I am getting Error 5005 (supplied buffer
insufficient, data may have been truncated) and nothing happens. Am i doing
something wrong? More complex examples with AdsConnection also do not work.

Version: Codegear RAD Studio 2007 December Update with ADS 9.0 (TDataset
Component for Delphi 2007 .NET)

Kind regards,
Wolfgang


Joachim Duerr (ADS) Posted on 2008-04-30 14:49:13.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Error 5005 when setting MasterFields of AdsTable in ObjectInspector
Newsgroups: Advantage.DelphidotNet
References: <4818650b@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.9
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 130.214.79.11
Message-ID: <481878d9@solutions.advantagedatabase.com>
Date: 30 Apr 2008 07:49:13 -0700
X-Trace: 30 Apr 2008 07:49:13 -0700, 130.214.79.11
Lines: 18
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:140
Article PK: 1108576


Wolfgang Hanke wrote in <4818650b@solutions.advantagedatabase.com>:

> I create a blank project with only one AdsTable specifiying the
> ADTDemoData as DatabaseName, animals as TableName and a TDataSource
> with this Table as dataset. When I now create a second Table with
> this Datasource as Mastersource, i cant choose a Masterfield cause I
> am getting Error 5005 (supplied buffer insufficient, data may have
> been truncated) and nothing happens. Am i doing something wrong? More
> complex examples with AdsConnection also do not work.

did you select proper indexes? Master/Detail in Delphi is implemented
via scopes - and scopes require indexes.

--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com


Wolfgang Hanke Posted on 2008-04-30 14:19:10.0Z
From: "Wolfgang Hanke" <whanke@visigate.de>
Newsgroups: Advantage.DelphidotNet
References: <4818650b@solutions.advantagedatabase.com> <481878d9@solutions.advantagedatabase.com>
In-Reply-To: <481878d9@solutions.advantagedatabase.com>
Subject: Re: Error 5005 when setting MasterFields of AdsTable in ObjectInspector
Date: Wed, 30 Apr 2008 16:19:10 +0200
Lines: 30
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: 80.228.194.216
Message-ID: <48187e86@solutions.advantagedatabase.com>
X-Trace: 30 Apr 2008 08:13:26 -0700, 80.228.194.216
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!80.228.194.216
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:141
Article PK: 1108575

i think so, yes, indices are correct. if i set the property "MasterField"
manually in my sourcecode everything works fine. but i cant set it in Object
Insepctor. if i click the dropdown icon in the inspector i get that annoying
error.
if i left out the mastersource property he tells me to correctly fill the
mastersource first when i click on masterfield dropdown. but if mastersource
is set, i only get that error message. cant even type in that field...


"Joachim Duerr (ADS)" <jojo.duerr@gmx.de> schrieb im Newsbeitrag
news:481878d9@solutions.advantagedatabase.com...

> Wolfgang Hanke wrote in <4818650b@solutions.advantagedatabase.com>:
>
>> I create a blank project with only one AdsTable specifiying the
>> ADTDemoData as DatabaseName, animals as TableName and a TDataSource
>> with this Table as dataset. When I now create a second Table with
>> this Datasource as Mastersource, i cant choose a Masterfield cause I
>> am getting Error 5005 (supplied buffer insufficient, data may have
>> been truncated) and nothing happens. Am i doing something wrong? More
>> complex examples with AdsConnection also do not work.
>
> did you select proper indexes? Master/Detail in Delphi is implemented
> via scopes - and scopes require indexes.
>
> --
> Joachim Duerr
> System Consultant (Advantage Database Server)
> Sybase iAnywhere
> advantagesupport[AT]ianywhere.com


Joachim Duerr (ADS) Posted on 2008-05-02 09:16:44.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Error 5005 when setting MasterFields of AdsTable in ObjectInspector
Newsgroups: Advantage.DelphidotNet
References: <4818650b@solutions.advantagedatabase.com> <481878d9@solutions.advantagedatabase.com> <48187e86@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.9
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 130.214.79.11
Message-ID: <481acdec@solutions.advantagedatabase.com>
Date: 2 May 2008 02:16:44 -0700
X-Trace: 2 May 2008 02:16:44 -0700, 130.214.79.11
Lines: 20
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!130.214.79.11
Xref: solutions.advantagedatabase.com Advantage.DelphidotNet:142
Article PK: 1108577


Wolfgang Hanke wrote in <48187e86@solutions.advantagedatabase.com>:

> i think so, yes, indices are correct. if i set the property
> "MasterField" manually in my sourcecode everything works fine. but i
> cant set it in Object Insepctor. if i click the dropdown icon in the
> inspector i get that annoying error. if i left out the mastersource
> property he tells me to correctly fill the mastersource first when i
> click on masterfield dropdown. but if mastersource is set, i only get
> that error message. cant even type in that field...

ooops - I've now seen that's in the DelphiDotNet ng, so I assume you
create a VCL.NET project!? Sorry, I don't have an installed RAD Studio
- using Delphi2007 only.
So anybody else should jump in to test it!

--
Joachim Duerr
System Consultant (Advantage Database Server)
Sybase iAnywhere
advantagesupport[AT]ianywhere.com