Subject | Re: [IBO] Inserts using TIB_Cursor |
---|---|
Author | Jason Wharton |
Post date | 2003-03-07T21:16:49Z |
No, what does the SQL trace monitor reveal when you do the insert?
How about the transaction isolation you are looking for the evidence of the
insert in?
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
-- We may not have it all together --
-- But together we have it all --
How about the transaction isolation you are looking for the evidence of the
insert in?
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
-- We may not have it all together --
-- But together we have it all --
----- Original Message -----
From: "Ross Williams" <ross@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, March 07, 2003 1:59 PM
Subject: Re: [IBO] Inserts using TIB_Cursor
> Here is the SQL for the Query, is there something in this that might be
> causing the problem?
>
> SELECT ORGANIZATI AS MEDIAOUTLET
> , CONTACT AS REPORTER
> , NEWS_PHONE as PHONE
> , TARGET_CIT as TARGETCITY
> , TYPECOL as MEDIATYPE
> , ADDRESS
> , CITY
> , STATE
> , ZIP
> , AREA___MAI
> , AREA___NEW
> , AREA_CODE
> , MAIN_PHONE
> , AREA_MAINF
> , AREA_NEWSF
> , FAX_AREA
> , MAIN_FAX
> , NEWS_FAX
> , MEDIAID
> FROM MEDIA
> WHERE MEDIAID = ?pMEDIAID
>
>
> UPDATE MEDIA SET
> MEDIAID = :MEDIAID,
> TARGET_CIT = :TARGET_CIT,
> CONTACT = :CONTACT,
> ORGANIZATI = :ORGANIZATI,
> ADDRESS = :ADDRESS,
> CITY = :CITY,
> STATE = :STATE,
> ZIP = :ZIP,
> AREA___MAI = :AREA___MAI,
> AREA___NEW = :AREA___NEW,
> AREA_CODE = :AREA_CODE,
> MAIN_PHONE = :MAIN_PHONE,
> NEWS_PHONE = :NEWS_PHONE,
> AREA_MAINF = :AREA_MAINF,
> AREA_NEWSF = :AREA_NEWSF,
> FAX_AREA = :FAX_AREA,
> MAIN_FAX = :MAIN_FAX,
> NEWS_FAX = :NEWS_FAX,
> EMAIL = :EMAIL,
> TYPECOL = :TYPECOL
> WHERE
> MEDIAID = :OLD.MEDIAID
>
> INSERT INTO MEDIA(
> MEDIAID,
> TARGET_CIT,
> CONTACT,
> ORGANIZATI,
> ADDRESS,
> CITY,
> STATE,
> ZIP,
> AREA___MAI,
> AREA___NEW,
> AREA_CODE,
> MAIN_PHONE,
> NEWS_PHONE,
> AREA_MAINF,
> AREA_NEWSF,
> FAX_AREA,
> MAIN_FAX,
> NEWS_FAX,
> EMAIL,
> TYPECOL)
> VALUES (
> :MEDIAID,
> :TARGET_CIT,
> :CONTACT,
> :ORGANIZATI,
> :ADDRESS,
> :CITY,
> :STATE,
> :ZIP,
> :AREA___MAI,
> :AREA___NEW,
> :AREA_CODE,
> :MAIN_PHONE,
> :NEWS_PHONE,
> :AREA_MAINF,
> :AREA_NEWSF,
> :FAX_AREA,
> :MAIN_FAX,
> :NEWS_FAX,
> :EMAIL,
> :TYPECOL)
>