Re: Error updating a single table view

Hello:
> Can anybody help? I'm having problems updating a single table view. 
> Whenever I do I get the following Dynamic SQL error, "Dynamic SQL 
> generation for the UpdateCommand is not supported against a 
> SelectCommand that does not return any key column information"
> Yes the one you get when you don't have a primary key set.  If I 
> change the dataset and code to update the table rather than the view 
> it works fine.  I have checked and the primary key is there in the 
> view too & the view is only made up of one table.  Any idea's?
If the file you have sent has a test db can you send it in zip format to 
my private email please ??
--
Carlos Guzmán Álvarez
Vigo-Spain

http://carlosga.blogspot.com/



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642