Comments (14)
Original comment by [email protected]
on 21 May 2009 at 2:03
- Changed state: Accepted
from aseisql.
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 [email protected]
on 22 Jun 2009 at 2:23
from aseisql.
[deleted comment]
from aseisql.
[deleted comment]
from aseisql.
[deleted comment]
from aseisql.
[deleted comment]
from aseisql.
[deleted comment]
from aseisql.
[deleted comment]
from aseisql.
[deleted comment]
from aseisql.
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 [email protected]
on 24 Jun 2009 at 4:03
from aseisql.
Hi
Attached are the requested files.
Regards Glen
Original comment by [email protected]
on 30 Jun 2009 at 12:11
Attachments:
from aseisql.
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 [email protected]
on 30 Jun 2009 at 7:42
from aseisql.
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 [email protected]
on 1 Jul 2009 at 12:28
from aseisql.
fixed in revision 66
new installer published
Original comment by [email protected]
on 1 Jul 2009 at 7:55
- Changed state: Fixed
from aseisql.
Related Issues (20)
- Version 15 client compatibility HOT 4
- From aseisql be able to save (as excel) all results tabs at once.
- Unable to launch HOT 9
- Profiles are continuing to disappear HOT 1
- code completion
- Infinite loop when a .sql file is renamed from explorer HOT 1
- Table DDL shows DEFAULT along with create index command HOT 1
- Application failed to initialize properly (0xc0000005) HOT 4
- Problem with very large stored procedure HOT 3
- Open Procedure shortcut throwing error HOT 1
- datepart problem
- Save Result Set HOT 1
- Unable to launch HOT 2
- connection dead, new hotkey to reconnect&execute ? HOT 2
- No server dropdown for Sybase ASE Logon dialog box
- Support for long table/column/procedure names
- Stubs.sql ( <Menu\Table DDL> ) error on tables with "sp_bindefault"
- After executing dbcc checkdb
- Table DDL generation fails in UTF8 database
- The execution doesn't end when a numeric value is returned in exponential format. Only on Win7
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from aseisql.