blamberty
2009-06-23T22:24:00Z
Loading and storing between Outlook contacts and a Visual FoxPro database works fine, except for Outlook varchar fields that map to FoxPro char fields that do not allow nulls. I don't see a way to specify that an Outlook field value of null should be converted to an empty string ("" or '') to store to the database. The conversion button is not enabled when the Outlook field is of type varchar and the FoxPro field is of type char. We cannot force the FoxPro database to accept nulls, because of the way the application handles the strings for output. Any help on this would be appreciated.
Administrator
2009-06-24T00:59:00Z
Hello,

in most database systems you can specify a default value, ( '' empty string in your case), is it possible in foxpro?
blamberty
2009-06-24T02:21:00Z
Yes, '' is an empty string. What I can't figure out is how to specify this in a conversion in the GeniusConnect Folder Items window using the Conversion button or some other technique. What I want to specify in GeniusConnect is something like the isnull() sql function, e.g., isnull(Department,'') so that GeniusConnect checks the value of the Outlook Department field and submits to the database the value of the field if it is not null, and the empty string ('') if is is null.
Administrator
2009-06-24T02:22:00Z
Hello,

Please see 'Handling empty mandatory char,varchar columns during INSERT,UPDATE'
in GeniusConnect 4.0.0.8SP2 BETA 4:
http://support.geniusconnect.com/Posts/t222- 

Please let us know if this solves your problem.
blamberty
2009-07-02T00:33:00Z
Thanks, Admin. The new version works perfectly to insert the empty string, not nulls, when I set the fields as mandatory keys.
Similar Topics