Re: create access table with ado sql (cannot change table properties)
From: Brian Hollister (bhollisterATfuturaintlDOTcom)
Date: 03/24/05
- Next message: ercan: "Re: create access table with ado sql (cannot change table properties)"
- Previous message: Marco Monti: "Accesing nvarchar in SQL Server"
- In reply to: ercan: "create access table with ado sql (cannot change table properties)"
- Next in thread: ercan: "Re: create access table with ado sql (cannot change table properties)"
- Reply: ercan: "Re: create access table with ado sql (cannot change table properties)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 24 Mar 2005 08:13:33 -0500
Hello,
You'll want to use an ALTER statement on an existing table to change its
design.
hth,
brian
-- Got a big event coming up? Let us help coordinate your event. For more visit www.kissemgoodbye.com "ercan" <ercanaktin@pcm.com.tr> wrote in message news:4242a743$1@newsgroups.borland.com... > we have an access database and we want to modify the table field > properties.like format of double field to Currency . > is it possible to do it with sql ado.if yes how? > that works: > ADOCommand1.CommandText := > > 'CREATE TABLE MUSTERI_ODEME ' + > > ' ( ' +' NAME TEXT(20) WITH COMP NOT NULL' + > > ' )'; > > ADOCommand1.Execute; > > but this one gives error : > > ADOCommand1.CommandText := > > 'CREATE TABLE MUSTERI_ODEME ' + > > ' ( ' + > > ' NUMBER DOUBLE WITH FORMAT "CURRENCY" ' + > > ' )'; > > ADOCommand1.Execute; > >
- Next message: ercan: "Re: create access table with ado sql (cannot change table properties)"
- Previous message: Marco Monti: "Accesing nvarchar in SQL Server"
- In reply to: ercan: "create access table with ado sql (cannot change table properties)"
- Next in thread: ercan: "Re: create access table with ado sql (cannot change table properties)"
- Reply: ercan: "Re: create access table with ado sql (cannot change table properties)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
