InfoPath Dev

Hello,  My database design uses sql_variant.  When I go to try and submit data I get the following error:  Operand type clash: ntext is incompatible with sql_variant  Has anyone had success using the sql_variant datatype and InfoPath?  I’m using InfoPath 2007.  Thanks,  Brian  

My database stores a certain column as liters.  How can I setup my form for data entry but show the value in gallons?  Brian

Hi Michael, Unfortunately I never found a solution.  I you do, please let me know. Brian  

I now realize that it is all dates in my dataFields that have a default value of now() and “Update this value when the result of the formula is recalculated.” is unchecked.

Hello, I have repeating table with the date pickers in this table set to a default value of now() and “Update this value when the result of the formula is recalculated.” is unchecked. I also have a rule in the date picker to “Query using a data connection”. Now if I change the date picker value of a row and submit all the rows in the repeating ...

Hello, I am having trouble using the ''Convert Main Data Source'' functionality of InfoPath 2003 SP2. I want to add a new root element in my schema. When I do this about 1/3 of my controls become unbound. I can't see any pattern with the controls that are bound correctly vs the ones that are unbound. Any ideas? Thanks, Brian

Does anyone know if it is possible to dynamically toggle the ''Show on the View menu when filling out the form'' under ''View Properties...''? Depending on which view the user is currently in I would like a select set of views to be visible on the view menu. Brian

Franck, Thanks for your response. I'd like to but I'm having trouble finding reference material. I'm using JScript and would like to use the default submit functionality followed by a refresh. Thanks in advance, Brian

Hi Frank, Yes I'm aware of the ForceUpdate function, however I'm not sure were to put it. I want to use the default submit behavior. Thanks, Brian

How can I force my current view to refresh after the default submit command? Brian