Article View: borland.public.interbase.sql
Article #891Re: Insert / Update to Array Field
From: Martijn Tonies
Date: Thu, 21 Jun 2007 08:49
Date: Thu, 21 Jun 2007 08:49
31 lines
1551 bytes
1551 bytes
> 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) You cannot, you have to use some weird API function. My advice: avoid arrays. -- Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com
Technical Details
Message-ID:
<467a3b6c@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<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 From: "Martijn Tonies" <m.tonies@upscene.removethis.com> Newsgroups: borland.public.interbase.sql References: <467a1a9c@newsgroups.borland.com> Subject: Re: Insert / Update to Array Field Date: Thu, 21 Jun 2007 10:49:33 +0200 Lines: 33 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1807 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896 NNTP-Posting-Host: 212.238.159.172 Message-ID: <467a3b6c@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1182415724 212.238.159.172 (21 Jun 2007 01:48:44 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail