Search results for query: *

Using Oracle 9i. I have a table that stores the records in the following fashion: prodID | sample | attribute | value ----------------------------------- 1445a | 1 | Thickness | 13.9 1445a | 2 | Thickness | 14 1445a | 3 | Thickness | 13.8 1445a | 1 | Drop | 0...

using Oracle 9. I'm trying to create a materialized view on a view but keep getting the following error. The view does exist. I'm under the assumption that creating a materialized view on a view is done the same way as on a table. ora-00942: table or view does not exist. CREATE...

When the .dll is being developed in Visual Studio, a vb form from that .dll appears one way, (textbox size, label placement, etc.) than when compiled and hosted in an application. Any suggestions as to what may cause this?

using IE 6.0. I have an app that produces a URL on the .aspx page. When this user clicks on the URL, IE attempts to open the Excel in the browser. Does not provide a Open-Save dialog. I've gone into File Types, (Under Folder Options) and set the options to the same as my computer, but still...

I have this app that is passing a dataset to an Excel writer. The database call in SourceData_Build() returns only about 10 rows of data but contains almost 200 columns. The app has no problem with Converting to Excel and saving a file on the webserver. The issue is that the Panel is never...

I have a page that contains a Panel with a few controls and one that is inherited(btnDownload) from the Master page. When the btnDownload is clicked, the code is going off and building a Dataset. This Dataset is built on a view which contains 200+ columns with only a few rows of data. I'm...

I'm trying to select records that have workdates greater than 4/1/2009. workdate is of type Date is stamped with sysdate when inserted so it contains Date & Time How can I achieve this? SELECT * FROM tb_my_table WHERE to_char(workdate, 'MM/DD/YYYY') > ('4/1/2009')

hello all. Using Excel 2002. I am trying to copy a worksheet from a workbook and I would like the formulas in this worksheet to reference the new workbook rather than the old one. -Worksheet1 has formulas that reference WorksheetABC -Copy Worksheet1 from Workbook1 -Insert Worksheet1 into...

Using XL 2002 I'm populating the first combobox w/o any problems using an array. Here is my prob: When the first combobox is changed, I want to call a function. That function will determine which product description was selected. Based on that product description, I want to populate the second...

Hello All, Using VS2005 & .NET 2.0 I have a list box on an .aspx page. This list box will contain numerous product entries. Is there a way to sort through it based on key entries from a user? e.g. a a1 a4 ac (#4) c (#5) c1 c2 etc... So if the user were to key in 'ac' it would highlight...

Hello all, I'm thinking of using 10g Express as my new database. I am currently using SQL Server Express and find it extremely painful to use. This is for a small web-app for a community organization...nothing too major, transaction wise, just to provide some lookups for users, around 100...

I'm using CR X with Visual Studio 2005. In the past, I've used CR 8 and really liked the ability to snap to grid..you know: when you put the tabs in the ruler and could line up the text and data fields to the same point and everything would line up neatly. Is this feature available in CR 10?

Using Oracle 9. I've got some data in a DATE field and right now it looks something like this: 10/18/0008 I would like to update all the records to take the records current Month, Day and update the year to 2008. As it is, all the data that I need to update is from 2008, if that helps. thanks.

Using CR 10. I've got a formula in a subreport in the Details section. The first two results are printing when the Sample equals 1 and 2. When Sample = 3, the transdate value is not printed. When I modify the code, so that Test is uncommented, it prints as well. The SQL used by this subreport...

using Oracle 9.2 I've got a table that has a field (Result) that is set to VarChar2. Occasionaly, the data in this field are characters but other times it's numbers. Is there a way to perform an AVG on this field eventhough sometimes it contains a character. For example Sample Parameter...

I've got some old crystal reports v8.5 that are currently launched from a vb6.0 application. We are currently upgrading the app to a vb.net application. Are there any concerns with using VB.net 2005 to trigger a CR v8.5 report? Thanks!

.Net 2.0 SQL Server Express 2005(you know, the free edition) I have a site which contains an Admin page by using the built-in Login control. Admin profiles and site security handled by buil-in administrator. I've configured an Admin user but when I access this page via the URL, I receive error...

I'm using SQL Server management studio express 2005. I have the database up and running fine on my server, which hosts my webpage. I can perform all my updates fine from home, when on that server but I was curious of how I can access this database remotely. How can I configure my laptop to...

Using ASP.NET 2.0 & VS 2005. Is there a way to change the color of one cell of a gridview? I'd like to change the colour of a cell in Column 2 depending on the value of a cell from column 1. Any ideas?

Visual Studio 2005 Crystal version 10?? I have a CR report which contains a subreport. I am passing 2 parameters to the subreport, group and subgroup. For each group, there can be mutliple subgroups. For example, Group A can have multiple subgroups of the same subgroup. Group Subgroup...