luboshl / aseisql

Automatically exported from code.google.com/p/aseisql
0 stars 0 forks source link

Generate table DDL fail #18

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
*** What steps will reproduce the problem?
1. In the object browser, double click the table
2. Select Table DDL

*** What is the expected output? 
Previous versions show the output desired:
txt
create table dbo.empresa(
   codigo   varchar(10)  null,
   nomenc   varchar(10)  null,
   nombre   varchar(50)  null,
   direccion   varchar(50)  null,
   telefono1   varchar(15)  null,
   telefono2   varchar(15)  null,
   ruc   varchar(30)  null,
   cia_alt   varchar(20)  null,
   tipo_emp   varchar(10)  null,
   ftp   bit  not null,
   existencia   bit  not null,
   exi_farma   bit  not null,
   traslado   bit  not null,
   crear   bit  not null,
   listar   bit  DEFAULT  0   not null,
   lote   bit  DEFAULT  0  not null,
   ciaappx   varchar(4)  null,
   nnomenc   varchar(4)  null
)
alter table empresa lock allpages
go
create clustered index idx_empresa on dbo.empresa ( codigo ASC)

*** What do you see instead?
Trunk version shows an error and doesn't execute
-  Attempt to insert NULL value into column 'id_order', table '#tmp';
column does not allow nulls. Update fails.

*** What version of the product are you using?
Working version: AseIsql 2007-11-29
Non Working version: AseIsql Trunk.92 Build 2009-07-27

*** On what operating system?
Windows Vista home Premium SP1 32bit

*** Aditional information:
This only happens with some tables, not all.

Original issue reported on code.google.com by juliocro...@gmail.com on 30 Jul 2009 at 12:31

GoogleCodeExporter commented 9 years ago
fixed in revision #97

Original comment by daggett....@gmail.com on 2 Aug 2009 at 9:43

GoogleCodeExporter commented 9 years ago
Issue 24 has been merged into this issue.

Original comment by daggett....@gmail.com on 14 Aug 2009 at 3:53