Problem with Informix serial column in ADO

Article View: borland.public.cppbuilder.database.ado

Article #4551

Back to borland.public.cppbuilder.database.ado Previous Next

#4551

From: MaweRick
Date: Tue, 27 Nov 2001 04:56

22 lines
1500 bytes

Hi

I have problem, when using ADO connection && ADO Query with Informix OLE DB
provider

The Problem are:
Let SQL text in ADO Query be as follows: Select * from SomeTable
this select works fine but, if SomeTable consist field someID of Informix
type SERIAL (counter in Informix term),
then in result set there is no column someID as if SomeTable not consist
them.

If we change SQL text to: Select SomeID from SomeTable then program or Cpp
Builder will hang.

Hawe ANYONE any idea of what to do?

P.S. I've apply AdoUpdate1.
P.P.S Sory for BAAAD english, i'm russian englishman :)

See YOU later
MaweRick

Technical Details

Message-ID: <3c031f37_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!194.25.134.62!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,52e4bfe746b11ea4,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-11-26 21:08:36 PST
From: "MaweRick" <theMawe@Mail.Ru>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Problem with Informix serial column in ADO
Date: Tue, 27 Nov 2001 14:56:31 +1000
Lines: 24
Organization: Bank of Russia
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
NNTP-Posting-Host: 194.84.100.9
Message-ID: <3c031f37_1@dnews>
X-Trace: dnews 1006837559 194.84.100.9 (26 Nov 2001 21:05:59 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!194.25.134.62!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews