le roy arnaud wrote:
> CREATE TABLE ACH_FAM (
> FAC_CODE SMALLINT NOT NULL,
> FAC_NOM VARCHAR(30),
> FAC_SELECTION SMALLINT
> );
>
> when i create a tableadpter with this sql command :
> "SELECT FAC_CODE,FAC_NOM,FAC_SELECTION FROM ACH_FAM".
> All the command are generated but if i create a tableadapter with :
> "SELECT FAC_CODE,FAC_NOM FROM ACH_FAM".
> The insert command it's not generated.
IMHO it's because FAC_SELECTION doesn't have default value, so VS is not
able to be 100% sure whether the insert will be OK (i.e. generator in
trigger can "fix" this, but VS doesn't know this).
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-------------------------------------------------------------------------
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
