Re: Insert / Update to Array Field

Article View: borland.public.interbase.sql

Article #744

Back to borland.public.interbase.sql Previous Next

#744

From: Quinn Wildman (CodeGear Develope...
Date: Thu, 21 Jun 2007 16:30

24 lines
1576 bytes

You've had some very good advice. Let me add one more point. Most apps 
connect via some driver (IBX, ODBC, DBX, etc). None of them support 
arrays...

Imam Chalimi wrote:
> I create table as following :
> 
> create table test_array
> (
>   id integer not null,
>  data varchar(25) [1:3]
> );
> 
> select id,data[1],data[2] from test_array => ok
> 
> but
> 
> insert into test_array(id,data[1]) values (1,'test') => error
> 
> how to insert or update to array field using sql command ? (not using App)
> 
> Thanks
> 
>

Technical Details

Message-ID: <467aa7c1$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feeder6.cambrium.nl!feed.tweaknews.nl!xlned.com!feeder1.xlned.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <467a1a9c@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,27db24532422845f
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Thu, 21 Jun 2007 09:30:59 -0700
From: "Quinn Wildman (CodeGear Developer Support)" <qwildman@nospam.codegear.com>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: Insert / Update to Array Field
References: <467a1a9c@newsgroups.borland.com>
In-Reply-To: <467a1a9c@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.143.19.108
Message-ID: <467aa7c1$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1182443457 10.143.19.108 (21 Jun 2007 09:30:57 -0700)
Lines: 24
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feeder6.cambrium.nl!feed.tweaknews.nl!xlned.com!feeder1.xlned.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message