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, need advice

3 posts in Delphi Last posting was on 2003-08-29 20:20:59.0Z
Jacques Savoie Posted on 2003-08-29 13:13:05.0Z
Reply-To: "Jacques Savoie" <jsavoie24@hotmail.com>
From: "Jacques Savoie" <jsavoie24@hotmail.com>
Newsgroups: advantage.delphi
Subject: Error 5005, need advice
Date: Fri, 29 Aug 2003 10:13:05 -0300
Lines: 10
Organization: OAOT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 207.179.134.207
Message-ID: <3f4f51c4@solutions.advantagedatabase.com>
X-Trace: 29 Aug 2003 07:14:44 -0700, 207.179.134.207
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!207.179.134.207
Xref: solutions.advantagedatabase.com Advantage.Delphi:13807
Article PK: 1107242

In Data Architect, when trying to open my dictionary I received this error
"Error 5005 : The Supplied buffer was insufficient for the information
returned" It was not doing that before, my dictionary is quite big with at
least 30 tables and 30 views.

Is there a setting I can change somewhere to get a bigger buffer??.

Thanks.


Karl Perry Posted on 2003-08-29 13:59:55.0Z
From: "Karl Perry" <kaperry@NOSPAMcablespeed.com>
Newsgroups: advantage.delphi
References: <3f4f51c4@solutions.advantagedatabase.com>
Subject: Re: Error 5005, need advice
Date: Fri, 29 Aug 2003 06:59:55 -0700
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 64.122.99.34
Message-ID: <3f4f5d29@solutions.advantagedatabase.com>
X-Trace: 29 Aug 2003 08:03:21 -0700, 64.122.99.34
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!64.122.99.34
Xref: solutions.advantagedatabase.com Advantage.Delphi:13808
Article PK: 1107244


"Jacques Savoie" <jsavoie24@hotmail.com> wrote in message
news:3f4f51c4@solutions.advantagedatabase.com...
> In Data Architect, when trying to open my dictionary I received this error
> "Error 5005 : The Supplied buffer was insufficient for the information
> returned" It was not doing that before, my dictionary is quite big with
at
> least 30 tables and 30 views.
>
> Is there a setting I can change somewhere to get a bigger buffer??.

Jacques,

I've a strong hunch that this is error message is talking about a buffer for
a specfiic string value, not for tables etc.

Did you just resize a table's fields or something? What changed with your
database that resulted in this error?

Also, this is the .Delphi group. Better to put these questions in the
.Utilities group in future.

Karl Perry


Brian Posted on 2003-08-29 20:20:59.0Z
From: "Brian" <NoEmail@NoEmail.com>
Newsgroups: advantage.delphi
References: <3f4f51c4@solutions.advantagedatabase.com>
Subject: Upper and Lower case in ADT
Date: Fri, 29 Aug 2003 15:20:59 -0500
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4920.2300
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4920.2300
NNTP-Posting-Host: 216.152.27.55
Message-ID: <3f4fb62b@solutions.advantagedatabase.com>
X-Trace: 29 Aug 2003 14:23:07 -0700, 216.152.27.55
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!216.152.27.55
Xref: solutions.advantagedatabase.com Advantage.Delphi:13816
Article PK: 1107253

Am using D5 Ent v5.01 and ADS/ALS v6.2.

We have a customer that has an ADT that has both upper and mixed case
entries for many of the fields in the table. My SELECT statement is, SELECT
* FROM myTable WHERE UPPER(firstname) LIKE '+QuotedStr(Edit1.Text+'%').

Problem is, the UPPER statement is cause the query to take too long to
return the result.

I have removed the UPPER statement from my query and changed the index to
UPPER(firstname).

Now I can seem to get any of the records that are mixed or lower case in my
result. Anyone have any ideas?

Regards,

Brian