> yes and more over i have the same problem with sql server for exemple > try to create a tableadapter on an asp net sql server 2005 database > with this request : > > ex : > > "SELECT ApplicationName, ApplicationId FROM dbo.aspnet_Applications" > Only the insert statement is not defined but if i try with this : > > "SELECT ApplicationName, LoweredApplicationName, ApplicationId FROM > dbo.aspnet_Applications" > all command is defined. > > So it's very strange because on this table there is one key on > ApplicationID > > if someone can try this ? >
Ok i think i found the problem, in fact VS detect when a column don't accept null and if one of this column is not present in the select VS don't generate the insert command. But there is a problem when you use a calculate column because the column don't accept null but we can't add any data in this column so How we can use tableadapter on a table that have calculated column ? Thanks ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
