Environment versions
Network:
Windows Server 2012 R2
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!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only