Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Ability to update a SQL result
Message
 
 
À
17/03/2008 17:18:24
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01302815
Message ID:
01302819
Vues:
10
>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?

I believe the answer I gave you still remains the same. You can do it through updatable views. I started to read on views when I saw your first question, but I think this is the direction you should be heading.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform