Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate Fails because of Field Order
Message
From
21/03/2000 17:45:20
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00348614
Message ID:
00348632
Views:
25
What is the SQL that created the view? I could be off here but I'm thinking that a view created with SELECT * would be susceptible to this where SELECT myfield1,myfield2 would not as long as your structural changes didn't eliminate fields that existed in the base table.

>Has anyone seen the Field Ordering affect a TableUpdate() from being successful?
>
>I am modifying my table structures on the fly out in the field for an update and apparantly if the Views are in a different field layout order the TableUpdate fails. Am I doing something wrong here or what? I am totally baffled! The ARRORS() shows an Error 107. Data type mismatch.
>
>TIA
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform