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.

Database reference

4 posts in Delphi Last posting was on 2011-11-21 19:58:42.0Z
Luis Daniel Taballione Posted on 2011-11-18 17:40:50.0Z
From: "Luis Daniel Taballione" <ldtaballione@datafull.com>
Newsgroups: Advantage.Delphi
Subject: Database reference
Date: Fri, 18 Nov 2011 14:40:50 -0300
Lines: 1
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
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8117.416
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8117.416
NNTP-Posting-Host: 190.136.133.55
Message-ID: <4ec6985b@solutions.advantagedatabase.com>
X-Trace: 18 Nov 2011 09:39:39 -0700, 190.136.133.55
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25541
Article PK: 1109123

Hi everyone,
first, my english is not good. Sorry

What can I reference a DB in Advantage Data Architect SQL Utility? I want to
insert all records from one table in some database into another table in
other one.
Some help will be appreciated.
Regards
Luis


Joachim Duerr (ADS) Posted on 2011-11-18 21:08:04.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: Database reference
Newsgroups: Advantage.Delphi
References: <4ec6985b@solutions.advantagedatabase.com>
Date: Fri, 18 Nov 2011 22:08:04 +0100
User-Agent: XanaNews/1.19.1.269
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 95.114.104.49
Message-ID: <4ec6c8c6@solutions.advantagedatabase.com>
X-Trace: 18 Nov 2011 13:06:14 -0700, 95.114.104.49
Lines: 33
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25543
Article PK: 1109121


Luis Daniel Taballione wrote:

>What can I reference a DB in Advantage Data Architect SQL Utility? I
>want to insert all records from one table in some database into
>another table in other one. Some help will be appreciated.

if you're using a data dictionary on both ends:

EXECUTE PROCEDURE
sp_CreateLink (
'anyname',
'relative\path\to\the\other\database.add',
TRUE,
FALSE, //if path to the other one is static
(c:\anypath\anidic.add) set it true
FALSE, //active user? no ... use adssys
'adssys',
''/* YOUR PASSWORD GOES HERE */ );


then
insert into mytable select * from anyname.mytable

__OR__

if you're using free tables and the same table type:

insert into mytable select * from [..\otherdir\moredir\].mytable

--
Joachim Duerr, Advantage Presales
*** NEW *** Advantage Pocket Guide released *** NEW ***
http://pocketguide.jd-engineering.de


Luis Daniel Taballione Posted on 2011-11-21 19:58:42.0Z
From: "Luis Daniel Taballione" <ldtaballione@datafull.com>
Newsgroups: Advantage.Delphi
References: <4ec6985b@solutions.advantagedatabase.com> <4ec6c8c6@solutions.advantagedatabase.com>
In-Reply-To: <4ec6c8c6@solutions.advantagedatabase.com>
Subject: Re: Database reference
Date: Mon, 21 Nov 2011 16:58:42 -0300
Lines: 1
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
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8117.416
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8117.416
NNTP-Posting-Host: 190.31.212.199
Message-ID: <4ecaad26@solutions.advantagedatabase.com>
X-Trace: 21 Nov 2011 11:57:26 -0700, 190.31.212.199
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25544
Article PK: 1109125

I'm using free tables. Thanks Joachim

"Joachim Duerr (ADS)" <jojo.duerr@gmx.de> wrote in message
news:4ec6c8c6@solutions.advantagedatabase.com...
> Luis Daniel Taballione wrote:
>
>>What can I reference a DB in Advantage Data Architect SQL Utility? I
>>want to insert all records from one table in some database into
>>another table in other one. Some help will be appreciated.
>
> if you're using a data dictionary on both ends:
>
> EXECUTE PROCEDURE
> sp_CreateLink (
> 'anyname',
> 'relative\path\to\the\other\database.add',
> TRUE,
> FALSE, //if path to the other one is static
> (c:\anypath\anidic.add) set it true
> FALSE, //active user? no ... use adssys
> 'adssys',
> ''/* YOUR PASSWORD GOES HERE */ );
>
>
> then
> insert into mytable select * from anyname.mytable
>
> __OR__
>
> if you're using free tables and the same table type:
>
> insert into mytable select * from [..\otherdir\moredir\].mytable
>
> --
> Joachim Duerr, Advantage Presales
> *** NEW *** Advantage Pocket Guide released *** NEW ***
> http://pocketguide.jd-engineering.de


Pascal Boivin Posted on 2011-11-18 18:01:04.0Z
From: "Pascal Boivin" <pascal.boivin@nbautomation.com>
Subject: Re: Database reference
Newsgroups: Advantage.Delphi
References: <4ec6985b@solutions.advantagedatabase.com>
User-Agent: XanaNews/1.19.1.320
Message-ID: <xn0hlr610dznxc000@devzone.advantagedatabase.com>
X-Ref: DevZone.AdvantageDatabase.com ~XNS:000000D3
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 69.70.11.19
Date: 18 Nov 2011 11:01:04 -0700
X-Trace: 18 Nov 2011 11:01:04 -0700, 69.70.11.19
Lines: 5
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.Delphi:25542
Article PK: 1109122

Hi

What kind of tables are you using (DBF or ADT)? Are you using a
dictionnary?