Re: SQL Create Table with Double type field

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

Article #2147

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

#2147

From: Daniel
Date: Fri, 24 Oct 2003 00:32

20 lines
1876 bytes

Thanks Viatcheslav,

for some reason I was getting errors when using the
"ALTER TABLE tablename ADD field field_type"
only when using the Float field_type so I thought it was a Access DB thing.
Adding other field_types were all working.

But after playing further, I went back to my previous attempt and the FLOAT
started working.  as far as I know, I made no changes to the SQL string, so
I'm guessing I must have had a fault somewhere else which just happen to
only show itself when adding a Float field_type???

Anyway, its all working, so thanks for your help.


"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:3f97a9aa$1@newsgroups.borland.com...
> Could you provide code you are using to create table?
>
>

Technical Details

Message-ID: <3f987337@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<3f8f3925$1@newsgroups.borland.com> <3f8fafca@newsgroups.borland.com> <3f9321e3$1@newsgroups.borland.com> <3f937652@newsgroups.borland.com> <3f95c6f9$1@newsgroups.borland.com> <3f9775ca@newsgroups.borland.com> <3f97a9aa$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,d7d2d8886914c651
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-10-23 17:39:09 PST
From: "Daniel" <admin@netcomm.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3f8f3925$1@newsgroups.borland.com> <3f8fafca@newsgroups.borland.com> <3f9321e3$1@newsgroups.borland.com> <3f937652@newsgroups.borland.com> <3f95c6f9$1@newsgroups.borland.com> <3f9775ca@newsgroups.borland.com> <3f97a9aa$1@newsgroups.borland.com>
Subject: Re: SQL Create Table with Double type field
Date: Fri, 24 Oct 2003 10:32:53 +1000
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 202.174.228.150
Message-ID: <3f987337@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1066955575 202.174.228.150 (23 Oct 2003 17:32:55 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message