Closed GoogleCodeExporter closed 8 years ago
Original comment by daggett....@gmail.com
on 21 May 2009 at 2:03
I need additional information on this issue:
please do the following steps
- start new session of the aseisql connect to the database where problematic
object
is located
- open "object browser" and go into stubs page
- rightclick on "select stubs/menu/table ddl" and select "paste"
- specify a table name when prompted
- execute the script
- attach here the script and the error log (rightclick on the log and select
"Copy
All" while pressing Ctrl)
Original comment by daggett....@gmail.com
on 22 Jun 2009 at 2:23
[deleted comment]
[deleted comment]
[deleted comment]
[deleted comment]
[deleted comment]
[deleted comment]
[deleted comment]
I need errors only after first execution
Please provide full log ( Ctrl + Copy all )
And please attach them as a files, so format will remain.
(i will delete your previous posts)
Original comment by daggett....@gmail.com
on 24 Jun 2009 at 4:03
Hi
Attached are the requested files.
Regards Glen
Original comment by glen.w.k...@gmail.com
on 30 Jun 2009 at 12:11
Attachments:
could you please generate DDL of this table using sybase central or something
else
and publish it here.
--
the only thing that i can say now, ddl code have to be reviewed..
Original comment by daggett....@gmail.com
on 30 Jun 2009 at 7:42
Okay something really weird. I could not actually remember what table I was
looking
at the generate the query_sql.txt file. It was something 'block' and a 'b'.
I thought I would look at the query_sql.txt to get the table name so I could
get the
ddl from Sybase Central. The query_sql.txt refers to the table 'b_block' except
we
do not have a table in our database with the name 'b_block'.
We only have tables named 'block_b' and another table named 'a_block_b'.
I cannot be sure but I am pretty confident the table I used before was
'block_b' and
the ddl generated from Sybase Central is
USE traindb
GO
CREATE TABLE dbo.block_b (
report_id "linkno" NOT NULL,
firs_premise_no "linkno" NOT NULL,
circuit_no "tiny_line" NULL,
location_of_detector "firs_code" NULL,
level_of_detector "firs_code" NULL,
type_of_detector "firs_code" NULL,
type_of_alarm_call "firs_code" NULL,
alarm_no "alarm" NULL,
premises_name "short_line" NOT NULL,
entry_server "srvname" NULL,
row_no "rowno" NOT NULL,
"timestamp" timestamp NULL
)
LOCK allpages
WITH max_rows_per_page=0, exp_row_size=0, reservepagegap=0, identity_gap=0
ON 'default'
GO
EXEC sp_bindefault 'dbo.server_def','block_b.entry_server'
GO
EXEC sp_bindefault 'dbo.rowno_def','block_b.row_no'
GO
GRANT references ON dbo.block_b TO appadm
GO
GRANT select ON dbo.block_b TO appadm
GO
GRANT insert ON dbo.block_b TO appadm
GO
GRANT delete ON dbo.block_b TO appadm
GO
GRANT update ON dbo.block_b TO appadm
GO
GRANT references ON dbo.block_b TO appuser
GO
GRANT select ON dbo.block_b TO appuser
GO
GRANT insert ON dbo.block_b TO appuser
GO
GRANT delete ON dbo.block_b TO appuser
GO
GRANT update ON dbo.block_b TO appuser
GO
GRANT select ON dbo.block_b TO appview
GO
GRANT references ON dbo.block_b TO frsuser
GO
GRANT select ON dbo.block_b TO frsuser
GO
GRANT insert ON dbo.block_b TO frsuser
GO
GRANT delete ON dbo.block_b TO frsuser
GO
GRANT update ON dbo.block_b TO frsuser
GO
GRANT references ON dbo.block_b TO level1
GO
GRANT select ON dbo.block_b TO level1
GO
GRANT insert ON dbo.block_b TO level1
GO
GRANT delete ON dbo.block_b TO level1
GO
GRANT update ON dbo.block_b TO level1
GO
GRANT references ON dbo.block_b TO sysadmin
GO
GRANT select ON dbo.block_b TO sysadmin
GO
GRANT insert ON dbo.block_b TO sysadmin
GO
GRANT delete ON dbo.block_b TO sysadmin
GO
GRANT update ON dbo.block_b TO sysadmin
GO
Regards Glen
Original comment by glen.w.k...@gmail.com
on 1 Jul 2009 at 12:28
fixed in revision 66
new installer published
Original comment by daggett....@gmail.com
on 1 Jul 2009 at 7:55
Original issue reported on code.google.com by
glen.w.k...@gmail.com
on 15 May 2009 at 6:06