Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data not refreshed on data bounded form controls
Message
From
16/11/2006 20:31:40
 
 
To
16/11/2006 17:42:34
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01170171
Message ID:
01170541
Views:
10
Thank you for your reply Sir. The update method did succeed. I tried issuing "browse" command and it did display the correct data. I could also see it by debugging it and browsing its data through the Data Sessions pane with the correct "no data".

My objective is to clear the data however this coding should be generic, the table from the XMLAdapter object does not contain any data. Though I appended a table with no data to the current cursor.

select (lcAlias)
browse && Displayed the cursor with data
delete all
browse && It did mark the data to be deleted
llAppend = .t.
oXMLAdapter.Tables[1].ToCursor(llAppend,lcAlias)
browse && Displayed new data that were appended
tableupdate(.t.,.t.,lcAlias)
browse && Updated the cursor displaying only the new data/or no data if the table appended has no data.

The weird thing also, because of issuing "browse", the data objects were cleared.
Previous
Reply
Map
View

Click here to load this message in the networking platform