At 11:00 AM 3/7/03, you wrote:

>Use a TIB_Query since it has buffering capabilities.

I got the same results using a TIB_Query with the same code above (minus
the cast to TIB_Cursor) - The form took in the data but never committed it
to the database. Here is the SQL_Monitor text (note - there is a refresh
called on another TTIB_Query after the insert by the calling procedure .)

I assume there is something in the SQL but I don't really see it in the
monitor text:

/*---
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
----*/


Ross Williams

[Non-text portions of this message have been removed]