Cetin,

Thanks! I haven't gotten anywhere on this yet. I will look at the view properties as you suggested and get back to you.

Regards,
David Schlesinger

>>I am getting an error loading my form.
>>Error loading form or the data environment
>>Syntax error converting varchar value _1qe15hq16 to a column of data type bit.
>>
>>Here is the scenario:
>>1) Using Visual accountmate accounting software - sql605 (for those of you who know accountmate
>>2) Create a sales order in the system (sales order form is modified from the native (form is sotsord.scx)
>>3) save the sales order
>>4) run another form (sotrsgb.scx) I have created for expediting SO backorders.
>>5) Upon running SOTRSGB.scx I get the above error. But I only get this error AFTER running the create sales order routine.
>>6) The system uses SQL remote views and sql passthrough.
>>
>>I know how to debug this problem when there is a problem with a grid definition or similar... but here I am lost.
>>
>>Any help wold be greatly appreciated.. this is a system I am trying to put into production.. and fixing this error is eluding me.
>>
>>Thanks,
>>David Schlesinger
>
>David,
>(I have no idea about accountmate).
>Syntax error converting varchar value _1qe15hq16 to a column of data type bit
>According to message it sounds a column which has sys(2015) value is mapped to a logical field.
>I'd check view's properties.
>Cetin