| T O P I C R E V I E W |
| rcdba |
Posted - 06/08/2005 : 07:37:20
We have a column called insert_time in on of the tables. If I do a 'select * from that table' I can see this column in the result set. However if I try 'select insert_time from table A', nothing is retrieved. Same sql in Query Analyser works fine.
Is insert_time a reserved word? Any tips?
RC |
| 10 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 06/15/2005 : 20:19:54
Ravi,
The SQL you supply must return a recordset. What are you trying to accomplish by running INSERT, UPDATE or DELETE queries?
|
| ravibala |
Posted - 06/15/2005 : 07:38:02
The Error I got while running the following test queries in SQL Report Design mode:
INSERT INTO QueryFolder (FolderName,IsPublic,ApproveType) VALUES ('Test Reports',0,1)
UPDATE QueryFolder FolderName='Test' WHERE FolderName='Test Reports'
DELETE FROM QueryFolder WHERE FolderName='Test'
[
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
Line 162:<%End If%>
Line 163:
Line 164:<%=CreateTable(sSqlSource, Request.Form.Item("orderBy"))%>
Line 165:
Line 166:</form>
Source File: D:\App\Web\ReportPortal\sql\query.aspx Line: 164
]
-Ravi. |
| admin |
Posted - 06/14/2005 : 19:28:10
In build #44 Report Portal no longer tries to suppress queries with insert, delete and update word in them. You would have to use SQL server security to restrict such access if you want to.
What is the error that you get now? |
| ravibala |
Posted - 06/14/2005 : 15:49:32
Igor - the build #44 allows to insert or delete or update the data through the SQL design window in "Design SQL Report". It throws error while testing these queries but insertion, deletion, updation are done before throwing error.
-Ravi. |
| admin |
Posted - 06/12/2005 : 16:04:57
Try the latest Build 44. |
| ravibala |
Posted - 06/10/2005 : 09:12:09
Any SQL query that contains the word with insert, update, delete (like updatedby,deletedby,insertedby, insert_time,updateTime) are not supported by ReportPortal. The code i_query.asp or SqlReport.vb restricts them. Please consider this scenario while you release next version.
-Ravi. |
| admin |
Posted - 06/09/2005 : 19:36:34
I understand your frustration. The next build will not have such a restriction. |
| rcdba |
Posted - 06/09/2005 : 06:30:44
I created a table Test with 2 columns called A and insert_time. Select * from Test works but not select insert_time from Test. Is insert_time a reserved word for report portal?
Rc |
| rcdba |
Posted - 06/09/2005 : 06:16:19
Igor
The word used here is INSERT_TIME. Also the sql works fine in query analyzer.
Thx |
| admin |
Posted - 06/08/2005 : 19:21:03
Yes, delete, update and insert are prohibited words. This rule is defined in CreateTable() in SqlReport.vb |
Report Portal
