Re: [V. Vassiliev] ADO data transformations

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

Article #970

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

#970

From: Vladimir Stefanovic
Date: Sat, 19 Feb 2005 15:03

23 lines
1817 bytes

"Viatcheslav V. Vassiliev" wrote

> If you can consider to not concat values from table lang2 and
> get result as [...]

Yes, I will definitely try the concept you suggested.


> If you must follow your design (with concat) - from tables lang1
> and lang2 you need only 2 columns - ID and Word. Fetch both
> tables into TStringList (string is for column Word, object - for
> ID), sort these string list by ID (using custom sort) and work
> with these string lists (search needed id using sort order) - execute
> only inserts into database using TableDirect = true and server-side
> cursor, or using TADOCommand.

Ok, thanks a lot for your help. I'll try this concept too.



-- 
Best regards,
Vladimir Stefanovic

Technical Details

Message-ID: <42175557@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!feeder2.on.meganewsservers.com!meganewsservers.com!textfeed1.on.meganewsservers.com!38.119.100.83.MISMATCH!news-out.nntp.be!propagator2-sterling.newsfeeds.com!news-in.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

References: <4214e840@newsgroups.borland.com> <42174e6a@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,a5d8d3ecd557e2fa
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Vladimir Stefanovic" <antivari@po.sbb.co.yu>
Newsgroups: borland.public.cppbuilder.database.ado
References: <4214e840@newsgroups.borland.com> <42174e6a@newsgroups.borland.com>
Subject: Re: [V. Vassiliev] ADO data transformations
Date: Sat, 19 Feb 2005 16:03:51 +0100
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 82.117.212.65
Message-ID: <42175557@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1108825431 82.117.212.65 (19 Feb 2005 07:03:51 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!feeder2.on.meganewsservers.com!meganewsservers.com!textfeed1.on.meganewsservers.com!38.119.100.83.MISMATCH!news-out.nntp.be!propagator2-sterling.newsfeeds.com!news-in.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message