At 01:16 PM 3/7/03, you wrote:

>No, what does the SQL trace monitor reveal when you do the insert?

Here is the monitor - I think it includes the refresh of the query used for
viewing data.

>How about the transaction isolation you are looking for the evidence of the
>insert in?

I am using committed on everything I think. But the data does not show up
in the database using any tool.


/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 20790312

SECONDS = 0.059
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 20790312
STMT_HANDLE = 20790120
PARAMS = [ Version 1 SQLd 1 SQLn 1
[PMEDIAID] = <NULL> ]

SECONDS = 0.020
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 20790312
STMT_HANDLE = 20789992
PARAMS = [ Version 1 SQLd 20 SQLn 20
MEDIA.MEDIAID = <NULL>
MEDIA.TARGET_CIT[TARGETCITY] = <NULL>
MEDIA.CONTACT[REPORTER] = <NULL>
MEDIA.ORGANIZATI[MEDIAOUTLET] = 'test'
MEDIA.ADDRESS[ADDRESS] = <NULL>
MEDIA.CITY = 'teset'
MEDIA.STATE = <NULL>
MEDIA.ZIP = <NULL>
MEDIA.AREA___MAI = <NULL>
MEDIA.AREA___NEW = <NULL>
MEDIA.AREA_CODE = <NULL>
MEDIA.MAIN_PHONE = <NULL>
MEDIA.NEWS_PHONE[PHONE] = <NULL>
MEDIA.AREA_MAINF = <NULL>
MEDIA.AREA_NEWSF = <NULL>
MEDIA.FAX_AREA = <NULL>
MEDIA.MAIN_FAX = <NULL>
MEDIA.NEWS_FAX = <NULL>
MEDIA.EMAIL[EMAIL] = 'test'
MEDIA.TYPECOL[MEDIATYPE] = <NULL> ]

INSERT COUNT: 1

SECONDS = 0.020
----*/
/*---
COMMIT
TR_HANDLE = 20790312

SECONDS = 0.021
----*/
/*---
COMMIT
TR_HANDLE = 20717684
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 20717684

SECONDS = 0.010
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 20717684
STMT_HANDLE = 20717492
PARAMS = [ Version 1 SQLd 2 SQLn 2
[PTARGETCITY] = '%'
[PMEDIAOUTLET] = '%' ]

SECONDS = 0.080
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 20717684
STMT_HANDLE = 20717492
PARAMS = [ Version 1 SQLd 2 SQLn 2
[PTARGETCITY] = '%'
[PMEDIAOUTLET] = '%' ]

SECONDS = 0.079
----*/