Subject Re: [IBO] Inserts using TIB_Cursor
Author Jason Wharton
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 --


----- 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
> , EMAIL
> , 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)
>