Tamar,

Of course, you were right! The VFP Select on the RV did not retrieve the new rec BUT the SQLEXEC() did! I don't think the filter was the problem.

The new record created seems to put NULLS in blank fields and the Logical/Bit is BLANK when the converted data has "False" in it. When I manually entered 'False' in SSMS in all Logical fields the record was retrieved. VFP must have an issue with this.

The Promatrix Framework does the insert record. Any ideas about the NULL issue and the Logicals? I didn't realize that could be an issue. Still not 100% sure about it but I think I'm on the right track.

Thanks much.

Bill

UPDATE: I found that the Filter fields that had NULL when created may be the problem, maybe not the Logicals. Everytime I reference a character filed with a NUL there is an issue. Must make Char NOT NULL. I must keep testing!