Search results for query: *

I was tasked with combining data from separate tables that contain text, date and numbers. The customer wants it in a single column. So I did a union of the three tables. So I chose to union the 3 tables into a single column and cast each type to a universal type. For dates and text that was...

I was tasked with combining data from separate tables that contain text, date and numbers. The customer wants it in a single column. So I did a union of the three tables. So I chose to union the 3 tables into a single column and cast each type to a universal type. For dates and text that was...

The generate_unique() does pretty good. But I would like to have server create a truly unique key since I would not want a user to RESET his internal processing date and create problems creating a duplicate key Is there any solution for this??

Can anyone help me I'm using DB2 to select date range and the column header was defined with a colon. this doesn't seem to work below???? select db2admin."v_QISDBGARRY"."DATE:D" from DB2ADMIN."v_QISDBGARRY" where "DATE:D" between '2004-11-30' AND '2005-01-01'

I populated a datagridview with some rows from a view. It works great. I would like to rebuild the view dynamically depending on which Table Name I select from my other grid. The view correctly contains the rows from the new table. Now I am working on the data grid view in the form. HOW do I...

I would like to create a text box entry method that positions my grid column cell focus to the first occurence of the set of characters in the grid column that matches the characters I am typing. I've seen this behavior with many programs such as MSDN Search. Does VB.NET Grid View Column...

Hi, I'm working at a site that has SQL 2005 Express and VS 2005. I am experienced using SQL Query Analyzer and in the Oracle world using TOAD. My question is this. I can't find how to save my SQL scripts to my hard drive or load them from my SQL library and run them. I've tried to issue more...

Environment: Windows XP Using MS Visual Studio 2005 SQL Server 2000 My Question: I decided to change an integer column in my SQL server table to a VARCHAR(32). I changed my SQL server stored procedure to accept a varchar(32) input parameter and I changed the VB.net application to correctly Add...

Can someone provide a snippet for calculating Tomorrow and also Yesterday? Having trouble with this - not as simple as I thought??

I have a Parameter which uses a table to get its values. An example is a parameter based on the Cuatomer Table or a Order ID Parameter base on the Orders table. I use a SQL expression that gets raw data from an Oracle table. As you are aware when looking at the DB Expert, SQL expression shows...

The parameters are not presenting themselves in the order that I wish. I have a start date, end date and customer ID parameter. At one time they presented themselve in order as I wished, but now I noticed it now is present in alphabetical order. I used the move up and move down option to put...

I crafted a simple report using a SQL Command. This is where you create a sql command and can use input parameters. Once I save the report, the command now appears under the database tab with the variables that I specified. Fine, this is expected. Now I noticed that SQL Expression Group is...

I'm trying to find a good example of using SQL Expression. I also have a SQL query example here and would like to get idea of best way to solve it. I may need a "Paradigm Shift" here. I originally thought I could drop the SQL query directly into the SQL expression and "Viola" it would work as...

I'm using Crystal 9 with Oracle database. I have a report with 2 subreports all using the start and end date. I link the 2 subreports to main report using the start dates as the link. Now I'm prompted for 6 dates - (2 for each report). Thats nice if I each of the reports were different, but...

I am having problems with not being able to update the business logic that I have put into Functions in my Crystal Repository. This is on an Oracle Server. I have put in a thread for reponse from the community. Do you think the Crystal HotFix will solve my Problem? How often does Crystal put...

I have a crystal report that works fine from the Oracle Server or on my local client machine. I am using Crystal report 9.2.2.634 with oracle 10g. I ported the applicaiton to Eportfolio - Crystal Enterprise Report Server. When I run the report on demand. It runs to about 38% per the status bar...

Cannot save changes "%1s" in the repository. I thought I had this under control. I changed from using the Access Repository on my hard drive to using the Oracle Repository on the server. I added all my functions to the repository. I went to update one of the functions to make a simple change in...