Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error converting varchar value to a column of type bit
Message
From
20/02/2006 15:04:20
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Error converting varchar value to a column of type bit
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP3
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01097591
Message ID:
01097591
Views:
69
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
Next
Reply
Map
View

Click here to load this message in the networking platform