[:#] Problems Viewing The Custom Sql Statement In The Gridview Control
Hi,
I really need some help trying to figure out why my gridview is not working when I create a custom sql statement. It "executes" the query, but gives me an error message when I "test the query". Here is the error message: "There was an error executing the query. Please check the syntax of the command and if present, the types and values of the parameters and ensure they are correct. Syntax error: Expecting '.', identifier or quoted identifier."
Here is my sql statement:
SELECT TBLPROJECTS.NAME, TBLPROJECTTYPES.NAME AS PROJECTTYPE, TBLPROJECTS.DESCRIPTION, TBLUSERS_1.LOGIN AS OWNERNAME,
TBLUSERS.LOGIN AS MANAGERNAME, TBLPROJECTS.START_DATE, TBLPROJECTS.END_DATE, TBLAOI.NAME AS AREAOFINTEREST,
TBLPROJECTS.MANPOWER, TBLUNITS.NAME AS MANPOWERUNIT
FROM TBLPROJECTS INNER JOIN
TBLAOI ON TBLPROJECTS.AOI_ID = TBLAOI.ID INNER JOIN
TBLPROJECTTYPES ON TBLPROJECTS.PROJECTTYPE_ID = TBLPROJECTTYPES.ID INNER JOIN
TBLUNITS ON TBLPROJECTS.MANPOWERUNITS_ID = TBLUNITS.ID INNER JOIN
TBLUSERS ON TBLPROJECTS.MANAGER_ID = TBLUSERS.ID INNER JOIN
TBLUSERS TBLUSERS_1 ON TBLPROJECTS.OWNER_ID = TBLUSERS_1.ID
I have tested it on a new project and still it does not work, I cannot find any problem, please help!!!!!!!!!!!!!!!!!!!!!!!!
View Complete Forum Thread with Replies
Related Forum Messages:
Error In Viewing Datetime Value In Gridview Itemtemplate
Hi! I am trying to show the StartTime and the EndTime in one column. Start - End 9:00:00 - 10:00:00 I tried the following code, but it is returning an error. <asp:TemplateField HeaderText="Start - End"> <ItemTemplate> <asp:Literal ID="litTimeRange" runat="server" Text='<%# Eval("timeRange") %>'> </asp:Literal> </ItemTemplate> </asp:TemplateField> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ScheduleConnectionString %>" SelectCommand="SELECT ID, ([StartTime]+ ' - ' + [EndTime]) as timeRange, CompanyName, Purpose, AccountManager, Presenter, ColorCode, Status, Comments FROM Demo_Theatre_DB WHERE (StartTime >= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0)) AND (StartTime <= DATEADD(day, DATEDIFF(day, 0, GETDATE()), 1))"> </asp:SqlDataSource> The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. [SqlException (0x80131904): The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932 System.Data.SqlClient.SqlDataReader.HasMoreRows() +150 System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +212 System.Data.SqlClient.SqlDataReader.Read() +9 System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) +153 System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) +153 System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) +170 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +175 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +50 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041 Your will be appreciated. Thanks!
View Replies !
.net Based Control For Viewing OLAP Data
Hi, We are tryign to build web based custom applications to provide our OLAP data to users. I am looking at various products to do this. The objective is to use existing cubes on Analysis server and provide drill downs with data and chart. 1. Business Intelligence Portal from Microsoft. (buggy and not much customisable) 2. Visual Studio .NET Web Control for Business Intelligence http://www.microsoft.com/downloads/details.aspx?FamilyId=4599B793-B3C6-4ED5-ACB3-820D0E832151&displaylang=en (I could never get this control to work) 3. http://www.intellimerce.com/Snowflake.html If anyone has experience with similar application, will you pelase share? Thanks,
View Replies !
Setting Up Dynamic WHERE Conditions For A Gridview Control
I have a simple gridview control set up that contains a single ControlParameter (a DropDownList) whose value is used in my SqlDataSource's SelectCommand: SelectCommand="SELECT * FROM [Wood_table] WHERE [wood_type] = ISNULL(@wood_type, [wood_type])" The ISNULL check is so that I can select "ALL" from my dropdown and get all the rows with null values. Everything works fine. Now what I'd like to do is exclude a specific wood_type value from the query if a checkbox control is selected. So what I'd like my select query to be when it's checked is something like SelectCommand="SELECT * FROM [Wood_table] WHERE [wood_type] = ISNULL(@wood_type, [wood_type]) AND @wood_type <> 'pine' " So I'd like the option of excluding that certain type of wood from the default query (all rows). I thought it might be better to just have a value in the dropdown list that was "ALL except pine" but that doesn't seem like it would work, what would I bind that to? I fooled around with having the CheckBox oncheckchanged event set a global based on the checked status, easy enough, but then how can I modify my SelectCommand? Should I just access the SqlDataSource object programmatically in my CheckBox handler and fiddle with the SelectCommand property? I tried this and it works, but this seems messy, now if I modify my GridView in Design mode I need to remember to update my SelectCommand strings in the CheckBox handler too. Is this the best way to do this?
View Replies !
Error While Using Database Procedure In A Gridview Control
Dear Forum, I have a gridview control which is associated to a storedprocedure with a parameter(Customer Number) to be supplied. In the Define Custom Statement or stored procedure section I selected stored procedure and selected the stored procedure. The Define Parameter window I defaulted the Parameter Source as 'none' and default value as '%'. In the next screen, I do a test query which retuns the following error There was an error executing the query. Please check the syntax of the command and if present, the type and values of the parameters and ensure that they are correct. [Error 42000] [Microsoft][ODBC SQL Server Drive][SQL Server] Procedure 'SP_TransactionDetails' expects parameter '@cnum' which was not supplied. I am using SQL server studio 2005 version2.0. But the same procedure, if I use as SQL Statement, it works. Can somebody help me. Thanks, Hidayath
View Replies !
Access All Records From Bound GridView Control
I am using the Visual Web Developer Express, C#.I have a query that is bound to a GridView object with record paging enabled.For purposes of displaying a map, I need the ability to loop through the paged record set (just the 10 current records) and send the address, city, state, and zipcode to a function. Using the GridView, I can access any of the records that are visible in the gridview. See code below. for (int i = 0; i < GridView1.Rows.Count; i++) { GridViewRow row = GridView1.Rows[i]; count++; _addr = row.Cells[3].Text.ToString(); _city = row.Cells[4].Text.ToString(); _state = row.Cells[5].Text.ToString(); lblMapJS.Text += Get_Map_Point(_addr, _city, _state, count); }Annoyingly, I am unable to access the rest of the fields in the recordset, namely the records that are not being displayed the in the GridView. How can I gain access to all fields, but just the current recordset?
View Replies !
Need Suggestions For GridView Custom Paging
Hi All, I am using row_number() in my sql query, so i am passing @StartRowNumber and EndRowNumber as a parameter to my query retrieve 50 records at a time.(Because i have set grid view page size to 50). So in this case query result return only 50 records, but in grid page navigation links will not display.(Offcourse because their is no more records according to query result but there are thousand or records i need to show by retrieving 50 records at a time). But i want to send parameter values for next 50 records by clicking navigation links. I am using below code to calculate parameter values in GridView1_PageIndexChanging event int CurrentPage = GridView1.PageIndex + 1; int TotalPageSize = GridView1.PageSize; int StartRowNumber = (CurrentPage - 1) * TotalPageSize + 1; int EndRowNumber = (CurrentPage * TotalPageSize); Please give me suggestions regarding above problem. Thanks in advance Shivaprakasha
View Replies !
Issue Inserting Null Value Into A Formview/gridview Control
Hi, My formview or gridview control stops updating or deleting a record once the record has a null value. I have table tblTest with the following pkID int NOT NULL **IDENTITY COLUMN** string1 varchar(30) string2 varchar(30) I then create a SqlDataSource with the statement: Select * From [tblTest] I have the insert, update and delete statements generated, and choose optimistic concurrency. I add a couple records of dummy data. I then drag a Formview control onto the page, and bind it to the SqlDataSource I just created. I then fire it up in my browser, and I can then update, insert and delete records. However, as soon as I update a record with a null value, I can no longer update or delete that record. So, if I had a record in my FormView like: string1: foo string2: bar I can update and delete normally. And when I update to: string1: foo string2: the database correctly inserts a null value into string2. However, once that null is in the record, I can't change anything about the record. If I try to delete the record, the FormView will then display the previous record, but I can still page to the record that should have been deleted, and it still exists in the db. If I try to update the record, the edits I make will not keep and the process will fail silently. What am I doing wrong? Should i be binding to a different object? Regards, Chris
View Replies !
Issue With Getting Values From Child Controls In A Gridview, To Use For The Update Using A SQLDataSource Control
Hi all, I have a gridview bound with a SQLDataSource. I am using the Update feature of the SQLDataSource to update a SQL Server database with values entered into the gridview. However I am not getting it to work. I believe this is due to the controls that contain the user entries are not the gridview itself, but rather child controls within the gridview. I have been using the names of the actual controls but nothing happens. Upon submit, the screen returns blank, and the database is not updated. Here is some code: <asp:GridView ID="GridEditSettlement" runat="server" AutoGenerateColumns="False" BackColor="Navy" BorderColor="IndianRed" BorderStyle="Solid" Font-Names="Verdana" Font-Size="X-Small" DataSourceID="SqlDataSource_grid" AllowPaging="True" AllowSorting="True" ForeColor="White" DataKeyNames="legid"> <Columns> <asp:CommandField ShowEditButton="True" CancelImageUrl="~/App_Graphics/quit.gif" CancelText="" EditImageUrl="~/App_Graphics/EditGrid.GIF" EditText="" UpdateImageUrl="~/App_Graphics/save.gif" UpdateText="" ButtonType="Image" /> <asp:BoundField DataField="StartDate" HeaderText="Start Date" ReadOnly="True" /> <asp:BoundField DataField="EndDate" HeaderText="End Date" ReadOnly="True" /> <asp:BoundField DataField="CounterpartDealRef" HeaderText="CP Deal Ref" ReadOnly="True" /> <asp:TemplateField HeaderText="Preliminary Settlement Price" ><ItemTemplate> <asp:Label ID=lblPreliminary runat=server Text='<%# Bind("PrimarySettlementPrice") %>' /> </ItemTemplate> <EditItemTemplate> <asp:TextBox runat="server" ID=txtPrimaryPrice Text='<%# Bind("PrimarySettlementPrice") %>'></asp:TextBox> </EditItemTemplate></asp:TemplateField> <asp:TemplateField HeaderText="Agreed Settlement Price"><ItemTemplate> <asp:Label ID=lblAgreed runat=server Text='<%# Bind("AgreedSettlementPrice") %>' /> </ItemTemplate> <EditItemTemplate> <asp:TextBox runat="server" ID=txtAgreedPrice Text='<%# Bind("AgreedSettlementPrice") %>'></asp:TextBox> </EditItemTemplate></asp:TemplateField> <asp:BoundField DataField="Volume" HeaderText="Volume" ReadOnly="True" /> <asp:BoundField DataField="Price" HeaderText="Price" ReadOnly="True" /> <asp:BoundField DataField="TotalVolume" HeaderText="Total Volume" ReadOnly="True" /> <asp:BoundField DataField="InstrumentName" HeaderText="Instrument" ReadOnly="True" /> <asp:BoundField DataField="NominalValue" HeaderText="Nominal Value" ReadOnly="True" /> <asp:BoundField DataField="Strike" HeaderText="Strike" ReadOnly="True" /> <asp:BoundField DataField="DeliveryDate" HeaderText="Delivery Date" ReadOnly="True" /> <asp:TemplateField HeaderText="LegId" SortExpression="LegId"> <ItemTemplate> <asp:Label ID="lblLegID" runat="server" Text='<%# Bind("LegId") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox runat="server" ID=txtLegID Text='<%# Bind("LegId") %>'></asp:TextBox> </EditItemTemplate> </asp:TemplateField> </Columns> <RowStyle BackColor="#FFFF66" ForeColor="#333333" /> <EditRowStyle BackColor="#FFFF66" Font-Names="Verdana" Font-Size="X-Small" ForeColor="#333333" /> <PagerStyle ForeColor="White" /> <AlternatingRowStyle BackColor="White" ForeColor="#333333" /> </asp:GridView> <br /> <asp:SqlDataSource ID="SqlDataSource_grid" runat="server" ConnectionString="<%$ ConnectionStrings:DealCaptureDev %>" SelectCommand="sp_get_single_deal" SelectCommandType="StoredProcedure" UpdateCommand="Update trDealLeg Set PrimarySettlementPrice=@primarysettlement, AgreedSettlementprice=@agreedsettlement, LastUpdate=GetDate(), LastUpdateBy=Session('userid') Where LegID=@legid" EnableCaching="True" ConflictDetection="CompareAllValues" ProviderName="System.Data.SqlClient"> <SelectParameters> <asp:QueryStringParameter DefaultValue="" Name="dealnum" QueryStringField="deal" Type="String" /> </SelectParameters> <UpdateParameters> <asp:ControlParameter ControlID="txtLegId" PropertyName="Text" Name="legId" /> <asp:ControlParameter ControlID="txtPrimarySettlement" Name="primarysettlement" PropertyName="Text" /> <asp:ControlParameter ControlID="txtAgreedSettlement" Name="agreedsettlement" PropertyName="Text"/> <asp:SessionParameter DefaultValue="" Name="userid" SessionField="userid" /> </UpdateParameters> </asp:SqlDataSource> As seen above, controls such as txtPrimarySettlement are referenced but the update is not successful. The text boxes are within the GridEditSettlement gridview. In the .aspx code I cannot use FindControl (at least I don't think it will work). So the questions are: Is it possible to reference the child controls, if so - how? Is there another way to do this, such as in the vb code behind - in the either the gridview's RowUpdating event or the SQLDataSource's Updating event. What is the best approach? Anyone come up against this issue before? Thanks, KB
View Replies !
Custom Filter Control
I have a treeview in my aspx page. Districts Schools Classes and all levels have a checkbox so I can select multiple items from different levels. Is it possible to have a filter control like that in rdl? regards
View Replies !
Error While Viewing Reports &&"Unable To Locate Control SSRS 2005: OReportCell&&"
Hello Friends, I have created few reports in SSRS 2005 on Windows 2003 Standard. Previouly I was not able to view reports from my .ASPX page which contained a ReportViewer, after going throuhg some other threads I was able to create a snap-shot for my reports . But still I'm not able to view reports, each time I try to view the page I get a message box with a error as : "Unable to locate control SSRS 2005: oReportCell" the same error is displayed when i try to access my reports from "http://localhost/reports.....". But the funny thing is I'm able to view the reports when I use the following URL: "http://localhost/reportserver/pages/reportviewer.aspx?/<report>". I have applied all the Hotfixes & installed the latest Service packs. Any suggestions ???????
View Replies !
How Do You Place A Variable In Your Gridview Sql Statement?
I have the below select command in my gridview that uses a library name.table approach in the sql. I created a label on the page and want to pass the label in where i have the libarary1 text in the select statement. This will allow me to swap out the production library with my development library when im working on the site (thru the use of a site variable) <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:as400con %>"ProviderName="<%$ ConnectionStrings:as400con.ProviderName %>" SelectCommand="SELECT * from library1.table WHERE COMPANY = ? and ack = ? and HORZN_DATE <= ?"> <selectparameters><asp:controlparameter name="company" controlid="accts" propertyname="SelectedValue"/><asp:controlparameter name="ack" controlid="podropdown" propertyname="SelectedValue"/><asp:controlparameter name="dt" controlid="htoday" propertyname="Text"/></selectparameters> How would I insert a label.text value into the select statement replacing the library1 ? I tried to use the asp:controlparameter adding the text and placing a ? mark in place of the library1 but it failed. Thanks for any help you can lend on this, Todd
View Replies !
Custom Control Flow Item Issue
I've been using Konesan's FileWatcher control-flow item successfully in design-mode on my PC, which runs the package on a remote server. I have installed the Konesan's FileWatcher on the remote SQLServer machine. I then imported the package to the server (Files System folder). I then select the package, right-click 'Run Package', then Execute, and receive the error: "Error: The task 'File Watcher Task' cannot run on this edition of Integration Services. It requires a higher level edition" ..in the 'Package Execution Progeress' dialog. All other validation seem to be ok. (Note, I'm executing the above steps using SQLServer Mgt Studio from my PC ; I'm not doing it from the SQLServer machine itself...not sure if this matters or not.) The SSIS version installed on the server is 9.0.3054. It shouldn't be an "SSIS version issue", as it is the same SQLServer that I used (successfully) from my PC in design mode... Thanks, Allen
View Replies !
Custom Task With PropertyGrid Control SSIS - Not Able To See Properties In GUI
Hello All Experts, I have created one custom task with PropertyGrid Control and two button on it. I have everything under one class library project. Problem I am facing is when i load task and clik on Edit I can not see those properties into that GUI and even functionlity of those two buttons (OK and Cancel) not working but I am able to see those properties in default property window. If I create this GUI as a seperate window application then I am able to see those properties in GUI and buttons also working but in SSIS I am not able to load the task. After reading on internet about SSIS they suggest to create everything under one project which I did. Basically I am trying to populate connection managers like Source Connection and Destination Connection when I load this task and there are much more backend functionlity but at first step i m stuck and not able to see those properties in GUI. Please help and give your input on it. I was following "Increment Task" example given by MSDN. If you need more info let me know. Thanks
View Replies !
Custom SSIS Control Flow Task Implemented In C++
Hi Guys, This is a question to the SSIS development team. I would like to know what are the requirements to implement custom SSIS Control Flow task in C++ . There is a documentation describing the process when implementing a managed task, but no such documentation exists for implementing a task in C++. Thank you, Ivan
View Replies !
Need Gridview To Display Different Columns Based On New SELECT Statement
I have built an Advanced Search page which allows users to select which columns to return (via checkbox) and to enter search criteria for any of the selected columns (into textboxes). I build the SQL statement from the properties of the controls. Works great. My problem is getting my gridview control to play nicely. At first I used a SqlDataReader and bound the gridview to it, thus giving me the ability to run new SQL statements through it (with different columns each time). Worked nicely. But, per Microsoft, sorting can only be done if the gridview is bound to a datasource control like the SqlDataSource. So I wrote the code to handle sorting. No big deal; worked nicely. But I could not adjust the column widths programmatically unless bound to a datasource control like the SqlDataSource. And could not figure out a work around. So, I decided to use the SqlDataSource. Works great. Except, I cannot figure out how to run a new SELECT statement through the SQLDataSource and have the gridview respond accordingly. If I try to return anything other than the exact same columns defined declaratively in the html, it pukes. But I need to be able to return a new selection of columns each time. For example, first time through the user selects columns 1,2,3,4 – the gridview should show those 4 columns. The second time the user selects columns 2,5,7 – the gridview should those 3 columns (and ONLY those 3 columns). Plus support selection and sorting. I am desperate on this. I've burned 2.5 days researching and testing. Does anyone have any suggestions? Thanks, Brad
View Replies !
Error Using Web Report Viewver Control With Custom Security Extension
We did implement ssrs 2005 to work with forms authentication. we have no problem login into report manager or report server. when we try to use the report viewer control in our web apps to access reports, we get the following error message. Error : System.Net.WebException was unhandled by user code Message="The request failed with the error message: -- <html><head><title>Object moved</title></head><body> <h2>Object moved to <a href="/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportExecution2005.asmx">here</a>.</h2> </body></html> the code in our web apps. looks like : Dim sReportServerURL1 As String = "http://servername/ReportServer" ' Report server location 'Dim sReportServerpath As String '= "/Reports_directory/report_name" ' Path of report on the server ReportViewer1.EnableViewState = True ReportViewer1.ServerReport.ReportServerCredentials = New ReportViewerCredentials("username", "password", "") ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote ReportViewer1.ServerReport.ReportServerUrl = New Uri(sReportServerURL1) ReportViewer1.ServerReport.ReportPath = sReportServerpath ... ReportViewer1.ServerReport.Refresh() ==================================== We also implemented IreportServerCredentials : Public Function GetFormsCredentials(ByRef authCookie As System.Net.Cookie, ByRef userName As String, ByRef password As String, ByRef authority As String) As Boolean Implements Microsoft.Reporting.WebForms.IReportServerCredentials.GetFormsCredentials userName = password = authority = Nothing Dim cookie As HttpCookie = HttpContext.Current.Request.Cookies("sqlAuthCookie") If cookie Is Nothing Then HttpContext.Current.Response.Redirect("login.aspx") End If Dim netCookie As Cookie = New Cookie(cookie.Name, cookie.Value) If cookie.Domain Is Nothing Then netCookie.Domain = HttpContext.Current.Request.ServerVariables("SERVER_NAME").ToUpper End If netCookie.Expires = cookie.Expires netCookie.Path = cookie.Path netCookie.Secure = cookie.Secure authCookie = netCookie Return True End Function ========================================= Does , anyone know how to get the web viewver control to work with custom authentication ? any help or guide lines is welcome. chi
View Replies !
.NET Permissions Error In Reporting Services When Not Using A Custom Assembly (Smiley Faces Are Not Under My Control)
.NET Permissions Error in Reporting Services when not using a custom assembly: I need help resolving a permissions error I€™m taking in a SQL RS 2005 report. I have a report that that is includes the following code fragment in Report Properties -> Code: Function rtf2text(ByVal rtf As String) As String Dim rtfcontrol As New System.Windows.Forms.RichTextBox Try rtfcontrol.Rtf = rtf Return rtfcontrol.Text Catch ex as Exception Return ex.Message End Try End Function I reference the .NET System.Windows.Forms DLL under Report Properties -> References -> References, Assembly Name (heading): System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 I have a text box with the following expression: =code.rtf2text(First(Fields!EndingQuoteComment.Value, "QuoteHeader")) And I€™ve verified, by removing the code.rtf2text command that is populated with the following: { tf1ansiansicpg1252deff0deflang1033{fonttbl{f0fromanfprq2fcharset0 Times New Roman;}{f1fnilfcharset0 Arial;}} viewkind4uc1pardif0fs32 ** Ending Quote Comments **par 0i0f1fs17par } When I run the preview in Visual Studio is correctly strips the RTF and displays just €œ** Ending Quote Comments **€?. When I €˜RUN€™ locally or deploy to a SQL RS 2005 Server and run the report I take the following error: Request for the permission of type 'System.Security.Permissions.UIPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. I€™ve tried everything that I can think of on the server to make this work. I finally put together a Win 2003 box with SQL 2005, IIS, and RS 2005 running on it in a virtual machine to be 100% sure I had a standard clean install and deployed the report and I€™m getting the same error. Below I€™ve included a basic standalone RDL file that demonstrates my issue. I get the error referenced above when I deploy the RDL below. Any ideas or suggestions are greatly appreciated? <?xml version="1.0" encoding="utf-8"?> <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"> <BottomMargin>0.25in</BottomMargin> <RightMargin>0.25in</RightMargin> <PageWidth>7.75in</PageWidth> <rdrawGrid>true</rdrawGrid> <InteractiveWidth>7.75in</InteractiveWidth> <rdnapToGrid>true</rdnapToGrid> <Body> <ReportItems> <Textbox Name="textbox21"> <Left>0.25in</Left> <Top>0.25in</Top> <rdefaultName>textbox21</rdefaultName> <Width>6.375in</Width> <Style> <PaddingLeft>2pt</PaddingLeft> <PaddingBottom>2pt</PaddingBottom> <FontSize>7.5pt</FontSize> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <CanGrow>true</CanGrow> <Height>1.375in</Height> <Value>=code.rtf2text("{ tf1ansiansicpg1252deff0deflang1033{fonttbl{f0fromanfprq2fcharset0 Times New Roman;}{f1fnilfcharset0 Arial;}} viewkind4uc1pardif0fs32 ** Ending Quote Comments **par 0i0f1fs17par } ")</Value> </Textbox> </ReportItems> <Height>5.25in</Height> </Body> <rd:ReportID>8804486c-882f-493c-8dfb-b2f778a24b21</rd:ReportID> <LeftMargin>0.25in</LeftMargin> <CodeModules> <CodeModule>System.Windows.Forms, Version=2.0.50727.42, Culture=neutral, PublicKeyToken=b77a5c561934e089</CodeModule> </CodeModules> <Code>Function rtf2text(ByVal rtf As String) As String Dim rtfcontrol As New System.Windows.Forms.RichTextBox Try rtfcontrol.Rtf = rtf Return rtfcontrol.Text Catch ex as Exception Return ex.Message End Try End Function </Code> <Width>7.25in</Width> <InteractiveHeight>10in</InteractiveHeight> <Language>en-US</Language> <TopMargin>0.25in</TopMargin> <PageHeight>10in</PageHeight> </Report>
View Replies !
GridView Based On SQLServerDataSource Using A Select Union Statement, Impacts On Update And Insert?
I have a GridView dispalying from a SQLServerDataSource that is using a SQL Select Union statement (like the following): SELECT FirstName, LastNameFROM MasterUNION ALLSELECT FirstName, LastNameFROM CustomORDER BY LastName, FirstName I am wondering how to create Update and Insert statements for this SQLServerDataSource since the select is actually driving from two different tables (Master and Custom). Any ideas if or how this can be done? Specifically, I want the Custom table to be editable, but not the Master table. Any examples or ideas would be very much appreciated! Thanks, Randy
View Replies !
Want Error Message To Appear When No Database Results Were Returned In GridView, Also Other GridView Issues.
Hi, I am seeking a hopefully easy solution to spit back an error message when a user receives no results from a SQL server db with no results. My code looks like this What is in bold is the relevant subroutine for this problem I'm having. Partial Class collegedb_Default Inherits System.Web.UI.Page Protected Sub submit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles submit.Click SqlDataSource1.SelectCommand = "SELECT * FROM [college_db] WHERE [name] like '%" & textbox1.Text & "%'" SqlDataSource1.DataBind() If (SqlDataSource1 = System.DBNull) Then no_match.Text = "Your search returned no results, try looking manually." End If End Sub Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load SqlDataSource1.SelectCommand = "SELECT * FROM [college_db] ORDER BY [name]" SqlDataSource1.DataBind() End Sub Protected Sub reset_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles reset.Click SqlDataSource1.SelectCommand = "SELECT * FROM [college_db] ORDER BY [name]" SqlDataSource1.DataBind() End SubEnd Class I'm probably doing this completely wrong, I'm a .net newb. Any help would be appreciated. Basically I have GridView spitting out info from a db upon Page Load, but i also have a search bar above that. The search function works, but when it returns nothing, I want an error message to be displayed. I have a label setup called "no_match" but I'm getting compiler errors. Also, next to the submit button, I also have another button (Protected sub reset) that I was hoping to be able to return all results back on the page, similar to if a user is just loading the page fresh. I'd think that my logic would be OK, by just repeating the source code from page_load, but that doens't work.The button just does nothing. One final question, unrelated. After I set this default.aspx page up, sorting by number on the bottom of gridview, ie. 1,2,3,4, etc, worked fine. But now that paging feature, as long with the sorting headers, don't work! I do notice on the status bar in the browser, that I receive an error that says, "error on page...and it referers to javascript:_doPostBack('GridView1, etc etc)...I have no clue why this happened. Any help would be appreciated, thanks!
View Replies !
IF Statement Out Of Control
I've got an IF Statement with a mind of it's own. Code associated with IF statement ALWAYS RUNS??? ALWAYS passing PostParentID = 0 into SP. ALWAYS SKIPS Print Statement #2 in Messages Window. Don€™t know if this is helpful€¦ --************* Insert Comment Summary Table Record **************************** PRINT 'PRINT STATEMENT #1' PRINT @PostParentID IF (@PostParentID > 0) --AND (@CommentSummaryID = 0 OR LEN(@CommentSummaryID) = 0 OR @CommentSummaryID IS NULL) PRINT 'PRINT STATEMENT #2' PRINT @PostParentID DECLARE @CommentCount int SET @CommentCount = 1 DECLARE @LastUpdate DATETIME SET @LastUpdate = GETDATE() INSERT INTO [syl_CommentSummaries] VALUES( @PostID, @CommentCount, @LastUpdate) SET @CommentSummaryID = (SELECT CommentSummaryID FROM syl_CommentSummaries WHERE PostID = @PostID) SELECT @CommentSummaryID UPDATE syl_Posts SET CommentSummaryID = @CommentSummaryID WHERE PostID = @PostID Message Window Output: PRINT STATEMENT #1 0 0 (1 row(s) affected) (1 row(s) affected)
View Replies !
SELECT Statement Beyond My Control!
I have been struggling with a query for sometime now, so I though I would see if anyone could help me out.Here is what I am trying to accomplish: I have a reservation page that has a dropdown list control on it. I am trying to populate the dropdown list with the available areas that have not already been reserved for the day. I have two tables, one of them contains the list of all of the areas that can be reserved. The second table contains the current reservations.Please let me know if I have not explained myself well enough and i will try to do expound better.Here is what I have so far, but it seems to give me results for the entire table, not just that day in particular. SELECT tbl_Hunting_Area.Area, tbl_Hunting_Area.Area_ID, tbl_Blinds.Area_ID, tbl_Blinds._DateFROM tbl_Hunting_Area CROSS JOIN tbl_BlindsWHERE (tbl_Hunting_Area.Area_ID <> tbl_Blinds.Area_ID) AND tbl_Hunting_Area.Area_ID NOT IN (SELECT tbl_Blinds.Area_ID FROM tbl_Blinds AS tbl_Blinds_1 WHERE (tbl_Blinds._DATE = '8-11-2005'))Here are the results that I receive from this query:Goose Field #2 2 1 2005-08-09 00:00:00.000Goose Field #3 3 1 2005-08-09 00:00:00.000Goose Field #4 4 1 2005-08-09 00:00:00.000Pond #1 - Pit Blind 5 1 2005-08-09 00:00:00.000Pond #1 - Shore Blind 6 1 2005-08-09 00:00:00.000Pond #2 7 1 2005-08-09 00:00:00.000Goose Field #1 1 6 2005-08-09 00:00:00.000Goose Field #2 2 6 2005-08-09 00:00:00.000Goose Field #3 3 6 2005-08-09 00:00:00.000Goose Field #4 4 6 2005-08-09 00:00:00.000Pond #1 - Pit Blind 5 6 2005-08-09 00:00:00.000Pond #2 7 6 2005-08-09 00:00:00.000Goose Field #1 1 7 2005-08-11 00:00:00.000Goose Field #2 2 7 2005-08-11 00:00:00.000Goose Field #3 3 7 2005-08-11 00:00:00.000Goose Field #4 4 7 2005-08-11 00:00:00.000Pond #1 - Pit Blind 5 7 2005-08-11 00:00:00.000Pond #1 - Shore Blind 6 7 2005-08-11 00:00:00.000Goose Field #1 1 5 2005-08-11 00:00:00.000Goose Field #2 2 5 2005-08-11 00:00:00.000Goose Field #3 3 5 2005-08-11 00:00:00.000Goose Field #4 4 5 2005-08-11 00:00:00.000Pond #1 - Shore Blind 6 5 2005-08-11 00:00:00.000Pond #2 7 5 2005-08-11 00:00:00.000
View Replies !
Problem With Flow Control Statement In UDF
Greetings, I have run into a problem while creating a simple UDF on SQL Server 2000. Code Snippet CREATE FUNCTION [dbo].[GetSectionNum] (@section varchar(4)) RETURNS varchar(2) AS BEGIN DECLARE @sTemp varchar(2),@s char DECLARE @count int DECLARE @length int set @length = LEN(@section) set @count = 1 WHILE (@count <= @length) BEGIN SET @s = SUBSTRING(@section,@count,1) IF(ISNUMERIC(@s)) BEGIN SET @sTemp = @sTemp + @s END SET @count = @count + 1 END IF(LEN(@sTemp) = 1) BEGIN SET @sTemp = '0' + @sTemp END RETURN @sTemp ENDWhen I perform a syntax check I receive and error about "Error 156: incorrect syntax near keyword 'BEGIN'. I have narrowed the problem to the IF statement inside the While block. If I remove the IF statement the syntax check is successful. This is the first UDF I have written so I'm swimming in uncharted water. Thanks ahead of time for your help.
View Replies !
How To Create A Custom SQL Statement.
im creating a custom sql statement where my code starts like tt.. its a double query and how do i link the 2nd part to the first part (select * from PO where 1=1)?<script runat="server"> protected void CheckBox1_CheckedChanged(object sender, EventArgs e) { strquery += " and PO between " + textbox1.text + " and " + textbox2.text; } protected void CheckBox2_CheckedChanged(object sender, EventArgs e) { strquery += " and Dlvdate between " + textbox3.text + " and " + textbox4.text; }</script> im a serious newbie with C#
View Replies !
Custom Function In SQL Statement?
In MS Access, I could write a function in a module, then just call that function as part of the SQL statement. For example, "SELECT RemoveDashes([SS_No]) AS SSN FROM Employee" with "RemoveDashes" being the name of the function. I'm trying to do the same with an asp.net page and sql server. I have a custom function in the code behind that I call in the SQL statement, but I get the error, "not a recognized function name". What do I need to do to make this work? All help is greatly appreciated! Lynnette
View Replies !
Cannot Build This Custom Select Statement...
I am trying to allow a user the ability to search a database and select from various fields to search, such as Keywords and Filename. I tried building something like this: SELECT filenameFROM pictableWHERE (@searchby LIKE @searchwords) It allows me to enter the two varables (keywords and test), but returns no rows. If I simply replace @searchby with 'keywords' (ensuring no spelling errors), then I get a return of one row. So this works: SELECT filenameFROM pictableWHERE (keywords LIKE @searchwords) Can someone tell me what is going on? I have tried all sorts of quotes and parens to no avail. Thanks in advance.
View Replies !
UPDATE Statement Syntax Help Required C# && SqlDataSource Control
Hi, I need to UPDATE the IP Address of a newly created user into a table (the value is currently set to default - " Not Available"), and I really dont know the syntax required to do this. So far I've derived all the variables needed using the following code: protected void ContinueButton_Click(object sender, EventArgs e) { //Get the ip address and put it into the customer table - (the instance of this user now exists) MembershipUser _membershipUser = Membership.GetUser(); Guid UserId = (Guid)_membershipUser.ProviderUserKey;<--------------------------------------------------------------I can see the UserId here if I pause the prog SqlDataSource customerDataSource = new SqlDataSource(); customerDataSource.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); customerDataSource.UpdateParameters.Add("IPAddress", Request.UserHostAddress.ToString());<---------------------------------------I can see the IPAddress here customerDataSource.UpdateCommandType = SqlDataSourceCommandType.Text; what next I've not got a clue as to what to write next. There is a try / catch statement after this using : rowsAffected = customerDataSource.Update(); which remains at 0 no matter what I try. Any help greatly appreciated.
View Replies !
SqlDataSource Custom SQL Statement Vs Stored Procedure Permission Problem
PLEASE PLEASE PLEASE...... I did not get a single response for the last 6 hours... And during this time I was searching and trying to understand the problem but I am really stuck. If this is the wrong forum to ask this question, please redirect me. Really begging for replies...[:'(] If I use the custom SQL statements in SqlDataSource, the application runs fine within the development environment (VS2005) but errors out if I publish the web site and access outside of the environment. In order to find-out the problem, I made the following test: I created a select statement in one SqlDataSource to fill-in a GridView. I used the exact same statement to create a stored procedure and used that SP in second SqlDataSource and I fill a second GridView. When I debug or run the application, both grids are filled OK and everything works fine. However, when I publish the web site and try to do same only the stored procedure works fine and when I try to fill the grid using the built-in SQL, the page gives error. The error mesage is as follows when I use the address 'localhost': Server Error in '/' Application. The SELECT permission was denied on the object 'Contacts', database 'Homer', schema 'dbo'. 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.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'Contacts', database 'Homer', schema 'dbo'.Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [SqlException (0x80131904): The SELECT permission was denied on the object 'Contacts', database 'Homer', schema 'dbo'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +859322.......da da da ....... If I access the page using the IP address the message chages to below but it is not the issue, I just give it if it helps to find the problem: Server Error in '/' Application. Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off". My SqlDataSource s are like this: <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:HomerConnectionString %>" SelectCommand="TestRemoteAccess" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:ControlParameter ControlID="TextBox1" Name="Param1" PropertyName="Text" Type="Int32" /> </SelectParameters> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:HomerConnectionString %>" SelectCommand="SELECT FirstName, LastName, Business FROM Contacts WHERE (ContactID = @Param1)"> <SelectParameters> <asp:ControlParameter ControlID="TextBox2" Name="Param1" PropertyName="Text" /> </SelectParameters> </asp:SqlDataSource> Environment: SQL Server 2005, VS2005, Vista
View Replies !
Error When Using A Create Table Execute SQL Task Statement In Control Flow Prior To Using An OLE DB Destination Container...
SSIS Newbie Question: I have a simple Control Flow setup that checks to see if a particular table exists. If the table does not exists, the table is created in an alternate path, if it does exist, the table is truncated before moving to a file import Data Flow that uses an OLE DB Destination to output the imported data. My problem is, that I get OLE DB package errors if the table the OLE DB Destination Container references does not exist when I load the package. How can I over come this issue? I need to be able to dynamically create the table in an earlier step, then use that table to import data into in a later step in the workflow. Is there a switch I can use to turn off checking in the OLE DB Destination Container so that it will allow me to hook up the table creation step? Seems like this would be a common task... Steps: 1. Execute SQL Task to see if the required table exists 2. Use expresions to test a variable to check the results of step 1 3. If table exists, truncate the table and reload it from file in Data Flow using OLE DB Destination 4. If table does not exist, 1st create it, then follow the normal Data Flow Can someone help me with this? Signed: Clueless with a deadline approaching...
View Replies !
Changing Viewing Size When Viewing Report On Report Server
When the report is deployed to the report server, a user selects their report parameters, then clicks view report, the window in which the report displays is approximately 2x2 inches and the report is squeezed left-right into this 2 inch window. How and where do I change this setting so that when the users wish to view the report it it displays approximately 8.5x11 inches in accordance to how it was designed? Thank you.
View Replies !
Displaying Custom Properties For Custom Transformation In Custom UI
Hi, I am creating a custom transformation component, and a custom user interface for that component. In my custom UI, I want to show the custom properties, and allow users to edit these properties similar to how the advanced editor shows the properties. I know in my UI I need to create a "Property Grid". In the properties of this grid, I can select the object I want to display data for, however, the only objects that appear are the objects that I have already created within this UI, and not the actual component object with the custom properties. How do I go about getting the properties for my transformation component listed in this property grid? I am writing in C#.
View Replies !
Is There A Way To Set A Variable In A Data Flow From A SQL Statement (like In Control Flow)
I'm currently setting variables at the package level with an ExecuteSQL task. This works fine. However, I'm now starting to think about restartability midway through a package. It would be nice to have the variable(s) needed in a data flow set within the data flow so that I only have to restart that task. Is there a way to do that using an SQL statement as the source of the value in a data flow? OR, when using checkpoints will it save variable settings so that they are available when the package is restarted? This would make my issue a moot point.
View Replies !
Expression Issue With Custom Data Flow Component And Custom Property
Hi, I'm trying to enable Expression for a custom property in my custom data flow component. Here is the code I wrote to declare the custom property: public override void ProvideComponentProperties() { ComponentMetaData.RuntimeConnectionCollection.RemoveAll(); RemoveAllInputsOutputsAndCustomProperties(); IDTSCustomProperty90 prop = ComponentMetaData.CustomPropertyCollection.New(); prop.Name = "MyProperty"; prop.Description = "My property description"; prop.Value = string.Empty; prop.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY; ... } In design mode, I can assign an expression to my custom property, but it get evaluated in design mode and not in runtime Here is my expression (a file name based on a date contained in a user variable): "DB" + (DT_WSTR, 4)YEAR( @[User::varCurrentDate] ) + RIGHT( "0" + (DT_WSTR, 2)MONTH( @[User::varCurrentDate] ), 2 ) + "\" + (DT_WSTR, 4)YEAR( @[User::varCurrentDate] ) + RIGHT( "0" + (DT_WSTR, 2)MONTH( @[User::varCurrentDate] ), 2 ) + ".VER" @[User::varCurrentDate] is a DateTime variable and is assign to 0 at design time So the expression is evaluated as: "DB189912189912.VER". My package contains 2 data flow. At runtime, The first one is responsible to set a valid date in @[User::varCurrentDate] variable. (the date is 2007-01-15) The second one contains my custom data flow component with my custom property that was set to an expression at design time When my component get executed, my custom property value is still "DB189912189912.VER" and I expected "DB200701200701.VER" Any idea ?
View Replies !
How To Dynamically Generate Drop Down Values For Custom Property In Custom Component
Need help in custom component with custom property. I have seen examples on how to have an enumeration for custom property value selection; however, the enumeration is pre-set. In my case, I will need to generate the values for a drop down list at custom component design time. Specifically, I will need the input column names in the drop down list for the user to select as the custom component is configured. I have no idea how to pass the collection of input column names and the user selected value back and forth to my UITypeEditor subclass. How can I achieve that? Thanks in advance for any input, Yan Yi
View Replies !
Expression Editor On Custom Properties On Custom Data Flow Component
Hi, I've created a Custom Data Flow Component and added some Custom Properties. I want the user to set the contents using an expression. I did some research and come up with the folowing: Code Snippet IDTSCustomProperty90 SourceTableProperty = ComponentMetaData.CustomPropertyCollection.New(); SourceTableProperty.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY; SourceTableProperty.Name = "SourceTable"; But it doesn't work, if I enter @[System:ackageName] in the field. It comes out "@[System:ackageName]" instead of the actual package name. I'm also unable to find how I can tell the designer to show the Expression editor. I would like to see the elipses (...) next to my field. Any help would be greatly appreciated! Thank you
View Replies !
Custom Task - Custom Property Expression
I am writing a custom task that has some custom properties. I would like to parameterize these properties i.e. read from a varaible, so I can change these variables from a config file during runtime. I read the documentation and it says if we set the ExpressionType to CPET_NOTIFY, it should work, but it does not seem to work. Not sure if I am missing anything. Can someone please help me? This is what I did in the custom task customProperty.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY; In the Editor of my custom task, under custom properties section, I expected a button with 3 dots, to click & pop-up so we can specify the expression or at least so it evaluates the variables if we give @[User::VaraibleName] Any help on this will be very much appreciated. Thanks
View Replies !
Reporting Services From WebBrowser Control - Print = &&"unable To Load Client Print Control&&"
UPDATE #2: When it said "Do you want to install Microsoft SQL Server" I said "yes" and that caused it to work. I exited and re-ran and now the print runs w/o the "install SQL Server" (If the prompt had said "Do you want to install the print dialog" we wouldn't be having this discussion...) UPDATE: After posting this i discovered that the same thing occurs when attempting to print the report direct from IE6: First a dialog pops up "Do you want to install this software?" Name: Microsoft SQL Server. When I click "Don't Install" I get the dialog "unable to load client print control." Since this happens direct from IE6 I suspect it's browser settings. I'll resume tomorrow and post a followup. My WinForm C# app integrates Reporting Services by calling them from WebBrowser controls. The problem is attempts to print cause a dialog: "unable to load client print control." I've read prior posts that say "enable Active-X in your browser" - I don't know how to do that from a WebBrowser control. Any ideas how to support Reporting Services "Print" from within a WebBrowser control? RELATED THREADS http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=332145&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=264478&SiteID=1
View Replies !
Viewing SQL Currently Being Ran
Hi all, I'm very new to SQL Server having previously worked with Oracle 10g for the last couple of years. Anyway, in Oracle there is a view called V$SQL that provides information about SQL that is or has recently been executed. I'm trying to find a similar sort of functionality in SQL Server. Basically, what I'd like to do is list all of the SQL statements that are running at a given moment. Or even better would be a way of listing all statements that have run in the last 10 minutes. Appreciate any help for a newbie. We're on SQL Server 2000 8.00.194 Cheers Kloid
View Replies !
Viewing Data
I just installed SQL Server on my 2003 box. Up till now I've been using MS Access for all my database needs. When I wanted to work on fields in a table, all I had to do was open Access and there you go. How do I view and modify Fields in SQL? Chill
View Replies !
Viewing A Table From Another Db
Holy MOLY I've been banging my head up against the wall on this matter for months now. I have two databases and I need to be able to see the tables from different different databases. Usually I create a view like this LicensingActions.dbo.License_Suspensions But it wasnt working kept telling me that the License_Suspensions table didnt exsist and at the time the name was in all caps. So I decided to change the name, and low and BEHOLD IT WORKS. The funny was that I wasnt having that problem any of the other tables just that one. Well live and learn. Just thought I'd share that with you guys
View Replies !
Viewing The Transaction Log
How can I view the transaction log for a particular database. We are trying to track down when a delete occurred and wanted to look there to find it, unless there is a better place to look. Thanks
View Replies !
|
TRACKER
