Re: Oprettelse af tabel

Article View: dk.edb.database

Article #15179

#15179

From: Kristian Damm Jensen
Date: Tue, 03 Jul 2001 10:07

29 lines
2006 bytes

"Ren� Holmkvist Pedersen" wrote:

<snip>

> NU vil jeg gerne kunne fylde div. tabeller i den nyoprettet database, det
> g�r jeg p� f�lgende m�de:
> 
> sql = " create table MIN_tabel1"
> db1.execute(sql)
> 
> Tabellen MIN_tabel bliver oprettet, MEN ikke i den korrekt database.
> Tabellen bliver placeret i databasen: master (den defaulte database)
> 
> Jag kan ikke lukke current database og �bne en ny
> 
> Har pr�ver "OPEN, CLOSE, CLEAR, SET ovs."
> 
> ER er nogen der har en stymp kode der kan lukke for den akutelle
> database(master) og �ben den nyoprettet database (MIN_DataBase), s� jeg kan
> inds�tte div. tabeller.

Du skal ikke lukke forbindelsen, du skal bare skifte database. Se
use-kommandoen.

<snip>

--
Kristian Damm Jensen              | Feed the hungry. Go to 
kristian-damm.jensen@capgemini.dk | http://www.thehungersite.com

Technical Details

Message-ID: <3B419968.31FC153C@REMOVEcapgemini.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!not-for-mail

References: <9hp2bi$qof$1@sunsite.dk>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,5f56ed30879ee97e
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-03 22:12:57 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!not-for-mail
From: Kristian Damm Jensen <kristian-Damm.Jensen@REMOVEcapgemini.dk>
Newsgroups: dk.edb.database
Subject: Re: Oprettelse af tabel
Date: Tue, 03 Jul 2001 12:07:36 +0200
Organization: CAP Gemini Danmark A/S
Lines: 31
Sender: kristian-damm.jensen@cgey2.capgemini.se
Message-ID: <3B419968.31FC153C@REMOVEcapgemini.dk>
References: <9hp2bi$qof$1@sunsite.dk>
NNTP-Posting-Host: cgey2.capgemini.se
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: sunsite.dk 994223522 12212 193.234.247.51 (4 Jul 2001 05:12:02 GMT)
X-Complaints-To: news@sunsite.dk
NNTP-Posting-Date: Wed, 4 Jul 2001 05:12:02 +0000 (UTC)
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
X-Accept-Language: en,da
X-Authenticated: kristian-damm.jensen@capgemini.dk

Reply to Parent Message