Re: INSERT DATE type

Article View: borland.public.interbase.sql

Article #987

Back to borland.public.interbase.sql Previous Next

#987

From: aleplgr
Date: Wed, 04 Apr 2007 18:30

20 lines
1602 bytes

"Bill Todd" <no@no.com> wrote:
>aleplgr wrote:
>
>
>There is no debugger for stored procs and triggers built into
>InterBase. I assume you are using some third party tool that simulates
>execution of the code and the third party debugger is in an infinitely
>recursive loop. This is not an IB problem because IB is not being used
>to debug the code.
>
>-- 
>Bill Todd (TeamB)

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...

Technical Details

Message-ID: <4613e0c5$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <4613c3ad$1@newsgroups.borland.com> <4613cb93$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-7-bit
From: "aleplgr" <aleplgr@yahoo.es>
Sender: "aleplgr" <aleplgr@yahoo.es>
Reply-To: "aleplgr" <aleplgr@yahoo.es>
Subject: Re: INSERT DATE type
Newsgroups: borland.public.interbase.sql
X-User-Info: 80.58.205.38     
X-Forwarded-For: 80.25.195.180, 192.168.1.66
References:  <4613c3ad$1@newsgroups.borland.com> <4613cb93$1@newsgroups.borland.com>
NNTP-Posting-Host: 207.105.83.66
Message-ID: <4613e0c5$1@newsgroups.borland.com>
Date: 4 Apr 2007 10:30:45 -0800
X-Trace: newsgroups.borland.com 1175707845 207.105.83.66 (4 Apr 2007 10:30:45 -0800)
Lines: 20
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message