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...

bbofin, Thanks Your last comment concerning the use of SQL Scripts from VS2005 Server Express Explorer Window. I cannot enter more than 1 command line in the SQL Query Window. Can you tell me how to enter a group of commands to run sequentially? I've tried putiting GO in between and that...

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...

Here is the code again. Corrected.... Dim txtChar1 as String Dim cmd As New SqlClient.SqlCommand txtChar1 = "sometext" ' set txtChar1 to an integer and it works ' set txtChar1 to a stringvalue like "sometext" if fails cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = "pr_test"...

Here is the code again. Dim txtChar1 as String Dim cmd As New SqlClient.SqlCommand txtChar1 = "sometext" ' set txtChar1 to an integer and it works ' set txtChar1 to a stringvalue like "sometext" if fails cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = "pr_test"...

I did some further testing with this problem today. 2-22-2006. Instead of passing in TEXT values I passed an integer to the VARCHAR(32) variable. The VB program worked fine passing the value to the store procedure. However, if I pass text into the varchar variable "sometext" it tries to...

Response to Ruffnekk With my integer test, I verified that it writes to the database the correct value. I have used the debugger to verify that the varchar contains a string value of whatever I put into it. So when it sends it to SQL server this is when it definitely gets the error. I have...

Response to Ruffnekk thanks for reviewing. Yes, I think the insert is correct. CharacteristicID - is a Varchar(32) I probably should have call it txtCharacteristic cmd4 should have been cmd in my post. I agre I think I should be able to use txtChar1 w/o formatting or casting. Remember: This is...

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...

Thanks, Everyone suggestions helped.