Article View: borland.public.interbase.sql
Article #988Re: INSERT DATE type
From: Wayne Niddery [TeamB]
Date: Thu, 05 Apr 2007 14:42
Date: Thu, 05 Apr 2007 14:42
16 lines
1592 bytes
1592 bytes
aleplgr wrote: > > Yes you are right, I'm using SQL Manager > http://www.sqlmanager.net/en/products/ibfb/manager > I was missing one column in the INSERT, should be like this: > INSERT INTO TEMP (CLIENTID,MYDATE,FLAG,ID) VALUES > (:MYCLIENT,:MYDATE,0,1); So now I have an infinite loop, I'm trying > to find why... It is SQLManager that is getting into an infinite loop then - executing a simple insert statement in IB cannot do such a thing. -- Wayne Niddery - Winwright, Inc (www.winwright.ca) "Reality is that which, when you stop believing in it, doesn't go away." � Philip K. Dick
Technical Details
Message-ID:
<46150ae2$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<4613c3ad$1@newsgroups.borland.com> <4613cb93$1@newsgroups.borland.com> <4613e0c5$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,8417dee86f0635f8 X-Google-Attributes: gid114a0e,public X-Google-Language: ENGLISH,ASCII Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> Newsgroups: borland.public.interbase.sql References: <4613c3ad$1@newsgroups.borland.com> <4613cb93$1@newsgroups.borland.com> <4613e0c5$1@newsgroups.borland.com> Subject: Re: INSERT DATE type Date: Thu, 5 Apr 2007 10:42:41 -0400 Lines: 18 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-RFC2646: Format=Flowed; Original NNTP-Posting-Host: 69.17.170.228 Message-ID: <46150ae2$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1175784162 69.17.170.228 (5 Apr 2007 07:42:42 -0800) Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail