Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ability to update a SQL result
Message
From
17/03/2008 17:18:24
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Ability to update a SQL result
Miscellaneous
Thread ID:
01302815
Message ID:
01302815
Views:
51
Recently, I have created a thread about a situation I had where I needed to update the SQL result. Basically, the goal was to include some empty fields in the SQL command and scan thru the dataset after and update accordingly. With a VFP backend, I can do this. But, when I test that against a SQL Server backend, I get this message:

"Column ... is read only"

Basically, I do something like this:
SELECT Customer.Name,'' AS Place FROM Customer
Then, I scan this dataset and would like to do this:
loRow("Place")="Something"
How can I make my column writable?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Next
Reply
Map
View

Click here to load this message in the networking platform