Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange behavior of table data
Message
From
08/11/2013 19:57:27
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Strange behavior of table data
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01587612
Message ID:
01587612
Views:
47
I have a table Table1 with one numeric field Field1 (length 1), which has only two rows with values 1 and 0 (first row = 1, second row = 0).
I am trying to put values from Table1.Field1 into Table2.Field2.

In a Form I have created ComboBox that has
ControlSource = Table2.Field2
RowSource = Table1.Field1
RowSourceType = Fields.

When I select value 0 from ComboBox then VFP writes number 2 into Table2.Field2 but it shows 0 in ComboBox!?
Why?
When I select value 1, then it writes 1, but 0 is not 0 in table, but instead is 2!?
Next
Reply
Map
View

Click here to load this message in the networking platform