Ask a Question related to ASP Database, Design and Development.
-
Cecil Westerhof #1
Problem with deleting views solved (sort of)
The problem with drop view is solved by not using stored procedures anymore.
They where only used to limit the amount of records, but this can (in
FireBird) be done more efficient with 'SELECT FIRST N ...'. So I rewrote the
code and the problems where solved.
I still do not understand the problem. The code used ADODB.Command to get a
recordset. When the it was done with a view there was no problem. When it
was done on a stored procedure there where problems.
About the BeginTrans and CommitTrans that are used all the time. I am told
that this is necessary in FireBird.
About EmitError. This ends with Response.Redirect and Response.End. I still
need an exit then?
Cecil Westerhof Guest
-
IE problem with DIV/CSS, Firefox views fine
I recently completed the following page for a client: http://www.nomoreart.co.uk/mycontactlens/css/main_layout.css Thanks Glen -
Problems with deleting views
The application I have to maintain uses dynamical views. I have the following code: oOrgDbConn.BeginTrans DropStr = "DROP VIEW MV_22_"... -
Ado sort error-Ado Sort -Relate, Compute By, or Sort operations cannot be done on column(s) whose key length is unknown or exceeds 10 KB.
Ado Sort -Relate, Compute By, or Sort operations cannot be done on column(s) whose key length is unknown or exceeds 10 KB. hi, guys i have asp... -
Query Optimizer Problem with Views in where Clause
Hi! I am using Sql 7 SP3. I have noticed strange Query plan when using views. Here is the case: Table1 has Col1, Col2, Col3 .... etc. Col1 is... -
Views inside views, execution plan & external WHERE clause
Here's my situation: Step 1: select * from employees where dept_no=1 and employee_no=1 ; -
Astra #2 Re: Problem with deleting views solved (sort of)
Thanks Cecil
Do you know how to do transactions with ASP/Access?
Rgds
Laphan
"Cecil Westerhof" <someone@microsoft.com> wrote in message
news:%23PdcC4PMEHA.3712@TK2MSFTNGP11.phx.gbl...
The problem with drop view is solved by not using stored procedures anymore.
They where only used to limit the amount of records, but this can (in
FireBird) be done more efficient with 'SELECT FIRST N ...'. So I rewrote the
code and the problems where solved.
I still do not understand the problem. The code used ADODB.Command to get a
recordset. When the it was done with a view there was no problem. When it
was done on a stored procedure there where problems.
About the BeginTrans and CommitTrans that are used all the time. I am told
that this is necessary in FireBird.
About EmitError. This ends with Response.Redirect and Response.End. I still
need an exit then?
Astra Guest
-
Cecil Westerhof #3 Re: Problem with deleting views solved (sort of)
> Do you know how to do transactions with ASP/Access?
Is not an option. As I understand it Access can not be used with multiple
users. But more important: the database I have to work with is FireBird.
But I found a way round it. I do not understand what was happening. But this
is also not very important. I do not think I will write myself dynamic
stored procedures.
Cecil Westerhof Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
