Board index » delphi » Problem with field bigger than 255 characters in Delphi5 and SQLServer 7.0

Han Nguyen

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Problem with field bigger than 255 characters in Delphi5 and SQLServer 7.0

I have problem with field bigger than 255 characters.  I think BDE has
something to do with this problem.  Is there any solution for this?  If any
one know how to sovlve this problem, please help.

I am using Delphi 5, BDE5.11, and SQLServer 7.0.

Tina

 
Euan Garde

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem with field bigger than 255 characters in Delphi5 and SQLServer 7.0


BDE uses dblib which was not enhanced in SQL7 to support new or larger
datatypes.

Use ADO or an ODBC plug in.

-Euan

Quote
"Han Nguyen" <hngu...@deutschco.com> wrote in message news:38f20612@dnews...
> I have problem with field bigger than 255 characters.  I think BDE has
> something to do with this problem.  Is there any solution for this?  If
any
> one know how to sovlve this problem, please help.

> I am using Delphi 5, BDE5.11, and SQLServer 7.0.

> Tina

balan..

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem with field bigger than 255 characters in Delphi5 and SQLServer 7.0


DB: Oracle8
BDE: 5.01
Delphi: 5
But I have exactly the same problem while I am using Oracle8? I was
thinking of upgrading my BDE. But Now I will wait to hear from somebody.
Han could you let us know your progress.
Thanks
Bala

In article <8cumcr$fc...@bornews.borland.com>,
  "Euan Garden" <euan.gar...@spicedham.gte.net> wrote:

Quote
> BDE uses dblib which was not enhanced in SQL7 to support new or larger
> datatypes.

> Use ADO or an ODBC plug in.

> -Euan

> "Han Nguyen" <hngu...@deutschco.com> wrote in message

news:38f20612@dnews...

Quote
> > I have problem with field bigger than 255 characters.  I think BDE
has
> > something to do with this problem.  Is there any solution for this?
 If
> any
> > one know how to sovlve this problem, please help.

> > I am using Delphi 5, BDE5.11, and SQLServer 7.0.

> > Tina

Sent via Deja.com http://www.deja.com/
Before you buy.
bala

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem with field bigger than 255 characters in Delphi5 and SQLServer 7.0


DB: Oracle8
Delphi: 5.0
BDE: 5.01
I have exactly the same problem with Oracle8. I was thinking of upgrading BDE.
Now I wait to hear from somebody. I am using TQuery and UpdateSQL.
You are not alone :-)
Bala
Quote
Han Nguyen wrote:
> I have problem with field bigger than 255 characters.  I think BDE has
> something to do with this problem.  Is there any solution for this?  If any
> one know how to sovlve this problem, please help.

> I am using Delphi 5, BDE5.11, and SQLServer 7.0.

> Tina

bala

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem with field bigger than 255 characters in Delphi5 and SQLServer 7.0


DB: Oracle8
Delphi: 5.0
BDE: 5.01
I have exactly the same problem with Oracle8. I was thinking of upgrading BDE.
Now I wait to hear from somebody. I am using TQuery and UpdateSQL.
You are not alone :-)
Bala
Quote
Han Nguyen wrote:
> I have problem with field bigger than 255 characters.  I think BDE has
> something to do with this problem.  Is there any solution for this?  If any
> one know how to sovlve this problem, please help.

> I am using Delphi 5, BDE5.11, and SQLServer 7.0.

> Tina

bala

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem with field bigger than 255 characters in Delphi5 and SQLServer 7.0


DB: Oracle8
Delphi: 5.0
BDE: 5.01
I have exactly the same problem with Oracle8. I was thinking of upgrading BDE.
Now I wait to hear from somebody. I am using TQuery and UpdateSQL.
You are not alone :-)
Bala
Quote
Han Nguyen wrote:
> I have problem with field bigger than 255 characters.  I think BDE has
> something to do with this problem.  Is there any solution for this?  If any
> one know how to sovlve this problem, please help.

> I am using Delphi 5, BDE5.11, and SQLServer 7.0.

> Tina

Robert Cern

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem with field bigger than 255 characters in Delphi5 and SQLServer 7.0


It has problems only with new char types (like NCHAR, NVARCHAR,...).
Simply use standard VARCHAR or LONG VARCHAR and you should not have any
problems.
Otherwise switch to a BDE alternative (ADO, DOA, SQL Direct).

--
----------------------
Regards
Robert Cerny
Remove both qwe when replying
email: robert.qwe.ce...@neosys.xrs.qwe.si

No questions via email, unless explicitly invited.

Quote
bala wrote in message <3917FC31.BCC32...@yahoo.com>...
>DB: Oracle8
>Delphi: 5.0
>BDE: 5.01
>I have exactly the same problem with Oracle8. I was thinking of upgrading
BDE.
>Now I wait to hear from somebody. I am using TQuery and UpdateSQL.
>You are not alone :-)
>Bala

>Han Nguyen wrote:

>> I have problem with field bigger than 255 characters.  I think BDE has
>> something to do with this problem.  Is there any solution for this?  If
any
>> one know how to sovlve this problem, please help.

>> I am using Delphi 5, BDE5.11, and SQLServer 7.0.

>> Tina

balan..

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Problem with field bigger than 255 characters in Delphi5 and SQLServer 7.0


after creating a primary key, everything started moving as it should.
Thank you all. Sorry for a lot of messages, it just did not seem to go
thro'.
Bala

In article <8f9ofe.2p...@neosys.xrs.si>,
  "Robert Cerny" <robert.qwe.ce...@neosys.xrs.qwe.si> wrote:

Quote
> It has problems only with new char types (like NCHAR, NVARCHAR,...).
> Simply use standard VARCHAR or LONG VARCHAR and you should not have
any
> problems.
> Otherwise switch to a BDE alternative (ADO, DOA, SQL Direct).

> --
> ----------------------
> Regards
> Robert Cerny
> Remove both qwe when replying
> email: robert.qwe.ce...@neosys.xrs.qwe.si

> No questions via email, unless explicitly invited.
> bala wrote in message <3917FC31.BCC32...@yahoo.com>...
> >DB: Oracle8
> >Delphi: 5.0
> >BDE: 5.01
> >I have exactly the same problem with Oracle8. I was thinking of
upgrading
> BDE.
> >Now I wait to hear from somebody. I am using TQuery and UpdateSQL.
> >You are not alone :-)
> >Bala

> >Han Nguyen wrote:

> >> I have problem with field bigger than 255 characters.  I think BDE
has
> >> something to do with this problem.  Is there any solution for this?
 If
> any
> >> one know how to sovlve this problem, please help.

> >> I am using Delphi 5, BDE5.11, and SQLServer 7.0.

> >> Tina

Sent via Deja.com http://www.deja.com/
Before you buy.

Other Threads

1. Cannot retrieve MS-SQLServer VARCHAR(n>255) or TEXT field in Delphi program

2. Cannot retrieve the data from a MS-SQLServer VARCHAR(n>255) or TEXT field

3. sqlserver varchar field truncated to 255

4. field truncated to 255 characters - why?

5. 255 character limit in Paradox alpha fields

6. Field contents truncated to 255 characters - why ?

7. MSSQL Varchar Fields beyond 255 characters

8. Retriving MSSQL char fields larger than 255 characters with delphi

9. Reading VARBINARY fields > 255 characters

10. network broadcast to 255.255.255.255 or x.x.x.255 doesn't work