Paramaterised Query To ORACLE Database - Not All Variables Bound
Feb 19, 2007
Hi
when I run this query against an Oracle 9 datasource I get a message saying 'not all variables bound'
select <some fields> from star
where nr_jahr_star = :Year
my datasource is correct as the same report runs fine if I just put in a fixed year and I have the Oracle client software on both my PC and the RS server
I've tried various combinations with the parameter settings also with no luck.
Thanks
Steven
View 1 Replies
ADVERTISEMENT
Aug 25, 2007
Hello Everyone,
I€™m trying to update my Target where the available value of each record is not equal to the Source records. But I€™m getting this error.
The code is below.
UPDATE "ADMINDB"."BED_VISIT"
SET "ADMIT_DATE" = ?,
"ADMIT_ELIG" = ?,
"ADMIT_LOCATION" = ?,
"ADMIT_TIME" = ?,
"ADMIT_TYPE" = ?,
"AVAILABILITY_CDE" = ?,
"BED_ARR_DATE" = ?,
"BED_ARR_TIME" = ?,
"BED_CLASS" = ?,
"BED_CLASS_DATE" = ?,
"BED_NO" = ?,
"BED_OUT_REASON" = ?,
"BED_READINESS" = ?,
"BED_SPECIALTY" = ?,
"CHIEF_COMPLAINT" = ?,
"CONFIDENTIAL" = ?,
"DIS_DATE_EST" = ?,
"DOCTOR_CODE" = ?,
"F_SOUNDEX" = ?,
"HOSP_BED_NO" = ?,
"HOSP_CODE" = ?,
"IN_OUT_DATE" = ?,
"IN_OUT_STATUS" = ?,
"INPUT_BY" = ?,
"INPUT_DATE" = ?,
"INPUT_TIME" = ?,
"ISOLATION_CODE" = ?,
"LENGTH_STAY_E" = ?,
"NO_OF_BEDS" = ?,
"NON_DIS_REASON" = ?,
"NURSE_STATION" = ?,
"ORIG_DIS_DATE" = ?,
"OUTSIDE_REF" = ?,
"PAT_ACC_FLAG" = ?,
"PHONE_EXT" = ?,
"PROB_SPECIALTY" = ?,
"REFER_DEPT" = ?,
"REFER_DOC" = ?,
"REFER_SOURCE" = ?,
"SMOKER_FLAG" = ?,
"SPEC_TRAN_DATE" = ?
WHERE "PATNO" = ?
AND "ADMIT_ELIG" != ?
AND "ADMIT_LOCATION" != ?
AND "ADMIT_TIME" != ?
AND "ADMIT_TYPE" != ?
AND "AVAILABILITY_CDE" != ?
AND "BED_ARR_DATE" != ?
AND "BED_ARR_TIME" != ?
AND "BED_CLASS" != ?
AND "BED_CLASS_DATE" != ?
AND "BED_NO" != ?
AND "BED_OUT_REASON" != ?
AND "BED_READINESS" != ?
AND "BED_SPECIALTY" != ?
AND "CHIEF_COMPLAINT" != ?
AND "CONFIDENTIAL" != ?
AND "DIS_DATE_EST" != ?
AND "DOCTOR_CODE" != ?
AND "F_SOUNDEX" != ?
AND "HOSP_BED_NO" != ?
AND "HOSP_CODE" != ?
AND "IN_OUT_DATE" != ?
AND "IN_OUT_STATUS" != ?
AND "INPUT_BY" != ?
AND "INPUT_DATE" != ?
AND "INPUT_TIME" != ?
AND "ISOLATION_CODE" != ?
AND "LENGTH_STAY_E" != ?
AND "NO_OF_BEDS" != ?
AND "NON_DIS_REASON" != ?
AND "NURSE_STATION" != ?
AND "ORIG_DIS_DATE" != ?
AND "OUTSIDE_REF" != ?
AND "PAT_ACC_FLAG" != ?
AND "PHONE_EXT" != ?
AND "PROB_SPECIALTY" != ?
AND "REFER_DEPT" != ?
AND "REFER_DOC" != ?
AND "REFER_SOURCE" != ?
AND "SMOKER_FLAG" != ?
AND "SPEC_TRAN_DATE" != ?
The error:
[OLE DB Command [20874]] Error: An OLE DB error has occurred. Error code: 0x80040E10. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80040E10 Description: "ORA-01008: not all variables bound".
Please help me in finding the solution out.
View 2 Replies
View Related
Jul 20, 2005
Hi,In our environment a database view is based on columns in a table from anoracle database.This is a linked server I believe.I am told that since we use this construction no where clause is possible.So we get to many rows in our database which we have to filter later on.How can we do this differently ?? Since it takes a lot of time to go throughthis process.Bye,Arno de Jong, The Netherlands.
View 2 Replies
View Related
Jun 5, 2008
Hi Guys, I am trying to manipulate an SQL statement based on the return from a menu with auto postback enabled.Simply I am working with dates, so I will declare variables for today, next week, last week and so on.How do I then use this in the SQL? I assumed that if I declared the following Dim my_today As String = Format(Date.Now(), "dd/MMM/yyyy")Then in the SQL I used SELECT * FROM my_table item_date = @my_todayI would get a result, but I get an error. What is the right way to do this? Many thanksSteve
View 7 Replies
View Related
Apr 29, 2008
I am using a Execute SQL Task which takes package variables and passes them to an Oracle SP as parameters:
{call oraclespname(?,?,?)}
where of course the parameters are set up as input parameters on the correct tab in the SQL Task.
Well the data that is being put into the table in Oracle has a CHR(0) or a null appended to the end of it. Of course this makes no sense. Does anyone have an idea of why this is happening or a way to fix it. The data becomes fairly useless as is without doing a RTRIM(data,CHR(0)) on it first which is a work around but kind of a hack.
View 2 Replies
View Related
Nov 20, 2006
Hi Everyone
This is the query and I am getting follwoing error message
"The multi-part identifier "InvDate.Account Reference" could not be bound."
SELECT MAX([DATE NOTE ADDED]) AS LASTDATE,
CC.[COMPANY],
CC.[ACCOUNT REFERENCE],
INVDATE.[LASTORDERDATE]
FROM CUSTOMERCONTACTNOTES AS CCN,
(SELECT *
FROM CUSTOMER) AS CC,
(SELECT MAX([INVOICE DATE]) AS LASTORDERDATE,
[ACCOUNT REFERENCE]
FROM INVOICEDATA
GROUP BY [ACCOUNT REFERENCE]) AS INVDATE
WHERE CCN.[COMPANY] = CC.[COMPANY]
AND CC.[ACCOUNT REFERENCE] COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS IN (SELECT DISTINCT ([ACCOUNT REFERENCE])
FROM INVOICEDATA)
AND CC.[ACCOUNT REFERENCE] COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS = INVDATE.[ACCOUNT REFERENCE]
GROUP BY CC.[COMPANY],CC.[ACCOUNT REFERENCE]
ORDER BY CC.COMPANY ASC
By the way its SQL Server 2005 Environment.
Mitesh
View 4 Replies
View Related
May 12, 2008
Using
- SQL Server 2005
- Management Studio Express.
Here's the SQL statement
Code Snippet
SELECT TOP 1000
[test].[CatalogStudioId],
[test].[CollectionId],
[test].[unique],
[test].[att1]
FROM CatalogStudioEntity.dbo.[test]
WHERE [test].[att1] LIKE '%1%'
Now, before you respond, allow me to say that I know using the table name to qualify the columns is redundant, and I know there are other options (such as aliasing the table). Don't respond to tell me this. However -- as far as I know -- this is a valid T-SQL statement and I should be able to get this query to run.
The interesting part is that if management studio is connected to the CatalogStudioEntity database, this query runs fine. If connected to the master database, I get the "multi-part identifier [x] could not be bound" error. The error is listed for every column.
My issue with this is that the table in the FROM clause is qualified with the database name, so whether I'm connected to that database or to "master" should not matter.
I have an application that generates select statements like the one above, and all of the machines so far that we've developed, beta tested and deployed this application on all don't have this problem. It's this one specific installation of SQL Server 2005 on this new machine where this problem arises.
Before I go back and retool the application to output whatever arbitrary syntax this specific machine seems to want, I want to try and troubleshoot and understand why it's acting like this.
Any ideas or thoughts would be greatly appreciated.
View 3 Replies
View Related
Jul 8, 2013
I have 2 requests for desperate Hélio..
1) is there any way to run a query over a query without having to create a table with the results of the first query? (would drop table work? If so, how?
2) how can i define input variables the same way i do in excel? I am trying to run a couple of simulations based on 2 core inputs (in excel i would just do a data table)
View 7 Replies
View Related
Sep 3, 2007
Hi ,
I am having 2 data store .
1. Oracle 10g
2 SQL server 2000
My requirement is that , i need to insert some data from sql server database table to oracle database using sql server query analyser or interface.
If there is any way ,plz let me know it
Thanks
Abraham
View 3 Replies
View Related
Oct 15, 2007
Hi,I'm new to SQL Server, but an experienced .Net developer. I'm tryingto accomplish a query the most efficient way possible. My question isif you can define a temporary variable within a query to store tablesor fields. (Like the LET clause of LINQ) My query makes use ofsubqueries which filter my table (WHEREs, not SELECTs) in the sameexact way. I'd like to have a subquery at the beginning of my queryto filter the table(s) once, and then SELECT off it of later in thequery.Here is an (utterly poor) example. No, this is not from my project.My filter is a little more complex than 'c=@p'.('c' is a column/field, 't' is a table', '@p' is a parameter)SELECT *FROM (SELECT COUNT(c) FROM t WHERE c=@p GROUP BY c)CROSS JOIN (SELECT c FROM t WHERE c=@p)Bottom line, would something like the following be possible?@v = (SELECT c FROM t WHERE a=@p)SELECT *FROM (SELECT COUNT(c) FROM @v GROUP BY c)CROSS JOIN (SELECT c FROM @v)I'd like to know if this is possible within a query, but I can move toa Stored Procedure if I must. (I'll still need help then.)Thank you all
View 3 Replies
View Related
Oct 3, 2007
Hi I'm a n00b at ASP.Net and C# but the company I work for requires me to know this and develop their website using these languages.
Anyway I've been doing pretty good so far I got the page looking as it should etc and databases all set up, now I've hit my first real problem... I am using Visual Studio 2005 and in the Web Developer section. I want to make a SELECT query using the <asp:LoginName> control as the where clause.
e.g. if admin logs in there is a welcome message : Welcome Admin now I want to use the 'Admin' <asp:LoginName> as the SELECT in my query i.e. SELECT * FROM tbla WHERE ([fldCustomerCode] = 'LoginName' )
I was just really wondering if that is in the .aspx file or the aspx.cs code behind file?
Thanks for any help given
View 4 Replies
View Related
Dec 24, 2003
I’ve reconfigured Microsoft’s IBS Store shopping cart to function within a small e-commerce website. What I am trying to do is to modify the code slightly in order to use a third party credit card processing center. The situation is this: once the customer clicks the final "check out" button, a stored procedure writes all of the product ordering information into the database. I, then, capture what they're wanting to purchase with the following SQL statement:
Dim strSQL as String = "Select orderID, modelNumber from orderDetails" & _
"where CustomerID = " & User.Identity.Name & _
"And orderid = (SELECT MAX(orderid)FROM orderDetails" & _
"where CustomerID = " & User.Identity.Name & ")"
What I would like to do is assign specific values to variables based off of the above query. For example:
Dim orderItem as String = (all of the modelNumbers from the query)
Dim orderIdItem as String = (all of the orderIDs from the query)
How do I do this?? Any help is much appreciated! Thanks in advance.
Ron
View 6 Replies
View Related
Dec 15, 2004
Hey guys,
I was wondering if there was a way to set a local variable from the results of a query or stored procedure.
For example, I have a stored procedure or a select statement that returns 1 row, with columns "a" "b" "c" "d"
I want to set my variable to be the value in column "b"
Is there a way to do that? I'm new to tsql, so any code would help.
I tried this, but I know my syntax is messed up
declare @myvar as integer
set @myvar = (execute mystoredProcedure).b
thanks
View 4 Replies
View Related
Mar 28, 2001
I'm trying to create a stored procedure with a dynamic update statement depending on the variables received. I receive a sql error "Incorrect syntax near the keyword 'WHERE'." although the variable, @tempvar, appears correct. Any ideas?
----
DECLARE @tempvar varchar(1025), @SolutionDetail varchar(1000), @hours varchar(12), @id int
if @SolutionDetail <> " "
set @tempvar = "SolutionDetail = " + "'" +@SolutionDetail + "'"
IF @hours <> " "
set @tempVar = @tempvar + ", hours = " + "'" + @hours +"'"
UPDATE WorkOrderTbl SET @tempvar
WHERE workorderid = @id
View 3 Replies
View Related
Jan 4, 2008
Hi all,
I was wondering if anyone can help me figure out how to insert a
variable into a query using Visual Studio 2005 with the SqlDataSource
control. I cant seem to be able to enter a var into the query
parameters.
this is my SqlDataSource:
<asp: SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:imLookinLikeConnectionString
%>" DeleteCommand="DELETE FROM [tblDiaryEntries] WHERE [DiaryEntryID] = @DiaryEntryID"
SelectCommand="SELECT tblDiaryEntries.DiaryEntryID,
tblDiaryEntries.EntryDate, tblDiaryEntries.Subject,
tblDiaryEntries.DiaryEntry, aspnet_Users.UserName FROM tblDiaryEntries
INNER JOIN aspnet_Users ON tblDiaryEntries.UserID = aspnet_Users.UserId
WHERE UserName=@UserName ORDER BY tblDiaryEntries.EntryDate DESC"
UpdateCommand="UPDATE [tblDiaryEntries] SET [DiaryEntry] = @DiaryEntry,
[EntryDate] = @EntryDate, [Subject] = @Subject WHERE [DiaryEntryID] =
@DiaryEntryID" InsertCommand="INSERT INTO tblDiaryEntries(UserID,
EntryDate, Subject, DiaryEntry) VALUES (@UserId, GETDATE(), @Subject,
@DiaryEntry)"> <DeleteParameters> <asp: Parameter Name="DiaryEntryID" Type="Int32" /> </DeleteParameters> <UpdateParameters> <asp: Parameter Name="DiaryEntry" Type="String" /> <asp: Parameter Name="EntryDate" Type="String" /> <asp: Parameter Name="Subject" Type="String" /> <asp: Parameter Name="DiaryEntryID" Type="Int32" /> </UpdateParameters> <InsertParameters> <asp: Parameter Name="DiaryEntry" Type="String" /> <asp: Parameter Name="EntryDate" Type="String" /> <asp: Parameter Name="Subject" Type="String" /> <asp: ProfileParameter DefaultValue="Anonymous" Name="UserName" PropertyName="UserName" /> <asp: Parameter Name="UserId" /> </InsertParameters> <SelectParameters> <asp: ProfileParameter DefaultValue="Anonymous" Name="UserName" PropertyName="UserName" /> </SelectParameters> </asp: SqlDataSource>
What I want to do is to tell the SqlDataSource that @UserName = this.User.Identity.Name, but I only know how to do that in
code-behind, not sure how to insert it into the code above.Any ideas?
View 3 Replies
View Related
Mar 19, 2006
Is it possible to use variable name to dynamically define a query in a stored procedure? EX:
@Column = 'COUNT(*)'
@Category = 'Products'
@Table = 'Items. + @Category
SELECT @Column
FROM @Table
View 1 Replies
View Related
Oct 28, 2004
Hi all,
If I have a query string that is to be stored in a database, for example
Code:
SELECT prod_id, prod_name, prod_desc FROM products WHERE prod_id = 'variable'
how can I put a variable identifier into this string so that when I need to run the query I call it from the database and simply insert the relevant variable in the correct place.
Is there an appropriate way of doing this in MS SQL Server?
Thanks
Tryst
View 1 Replies
View Related
Oct 10, 2006
When I want to user variable in the name of the database, I have an error. What's wrong with my code ?
DECLARE @BASE_SOURCE varchar (30),@BASE_DESTI varchar(30),@TEST varchar(30)
set @BASE_SOURCE='BASE1'
set @BASE_DESTI='BASE2'
select * from @BASE_SOURCE.dbo.FOURNISS
Msg*170, Niveau*15, État*1, Ligne*4
Ligne 4 : syntaxe incorrecte vers '.'.
View 2 Replies
View Related
Jul 20, 2005
Hello,I need to copy a table from an 8i oracle database to a sqlserver 2000 database.Is it possible to use the command "COPY FROM ... TO ..." ?So, what is the correct syntax ?Thanks for your helpCyril
View 1 Replies
View Related
Jul 13, 2004
Hi,
I think I'm just braindead or simply thick...since this shouldn't be that hard, but I'm stumped right now.
So, I'm trying to retrieve from a table, with a sql stored procedure with the sql like
"select height, width, depth from products where id=@idinput"
OK, so this part is easy, but if I wanted to say, return this to my code and assign height to a variable Ht, width to Wd and depth to Dp, how could I do that?
This is what I've got so far...
[code]
cmdSelect = New SqlCommand( "GetProd", connstr )
cmdSelect.CommandType = CommandType.StoredProcedure
dbcon.Open()
dbcon.Close()
[/code]
The main prob is just what to connect this record to in order to access the individual fields.
Thx :)
View 2 Replies
View Related
May 18, 1999
Hi!
Here is a snap form my code
declare @max_id int
declare @the_db varchar (30)
select @the_db = 'mydb'
exec ("select """ @max_id """ = max(id) from " + @the_db + "..mytable")
I got syntex error for the @max_id. The script is writen based on the sample given in MSSQL6.5 Book Online, chapter "Transaction-SQL Reference 6.0" section "C"->"Control-Flow Lang."->"Control-Flow Examples"
Can someone help me on how to assign a value to a local variable from a dynamic query.
Thank for any help in advance
Hank Lee
View 1 Replies
View Related
May 3, 2007
I am trying to create a database using variables, so that the variables can be passed in when the script is run. But when I run the code below I keep on getting an error - any clues what I have done wrong? I’ve not used variables before, so sorry if it is obvious.
(NB The script was creating using the auto-create functions within SQL server)
DECLARE @database varchar(30)
SET @database = 'TESTdb'
USE [master]
GO
CREATE DATABASE [@database] ON PRIMARY
( NAME = N''+@database+'_dat', FILENAME = N'D:Data'+@database+'.mdf' , SIZE = 1932672KB , MAXSIZE = UNLIMITED, FILEGROWTH = 20%)
LOG ON
( NAME = N''+@database+'_log', FILENAME = N'L:LOGS'+@database+'_log.LDF' , SIZE = 8653056KB , MAXSIZE = UNLIMITED, FILEGROWTH = 20%)
COLLATE Latin1_General_CI_AS
GO
EXEC dbo.sp_dbcmptlevel @dbname=N@database, @new_cmptlevel=90
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [@database].[dbo].[sp_fulltext_database] @action = 'disable'
end
GO
ALTER DATABASE [@database] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [@database] SET ANSI_NULLS OFF
GO
ALTER DATABASE [@database] SET ANSI_PADDING OFF
GO
ALTER DATABASE [@database] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [@database] SET ARITHABORT OFF
GO
ALTER DATABASE [@database] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [@database] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [@database] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [@database] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [@database] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [@database] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [@database] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [@database] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [@database] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [@database] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [@database] SET DISABLE_BROKER
GO
ALTER DATABASE [@database] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [@database] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [@database] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [@database] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [@database] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [@database] SET READ_WRITE
GO
ALTER DATABASE [@database] SET RECOVERY FULL
GO
ALTER DATABASE [@database] SET MULTI_USER
GO
ALTER DATABASE [@database] SET PAGE_VERIFY TORN_PAGE_DETECTION
GO
ALTER DATABASE [@database] SET DB_CHAINING OFF
View 2 Replies
View Related
Oct 15, 2001
Ho do I convert Oracle 8 database into SQL server 7.0 database ? Is it possible ? Please let me know at skbhaduri@rediffmail.com
View 1 Replies
View Related
Aug 18, 2004
I am brand spankin new to stored procedures and don't even know if what I want to do is possible. From everything I've read it seems like it will be. I have a table, punchcards. In this table are all the punch in/out times for a week. I want to create a stored proc to calculate how many hours a punchcard entry is.
Thats the dream.
The reality is that I can't even get a tinyint from a table to load to a variable and be printed out. I am using sql server 8.
Here is what I have as of this moment for my sp.
ALTER PROCEDURE usp_CalculatePunchcard
AS
DECLARE @dtPP DateTime
SET @dtPP = (SELECT thursday_in1
FROM punchcards
WHERE (punchcard_id = 1))
/*
Also tried....
SELECT @dtPP=thursday_in1
FROM punchcards
WHERE (punchcard_id = 1)
*/
PRINT @dtPP
RETURN
/*
for some reason i can't use GO ... even though every
document i've read on stored procedures has used GO
and none use RETURN
*/
The only output this is producing is ' Running dbo."usp_CalculatePunchcard". '
Any help would be greatly appreciated as I am about to kick someone/something.
Thanks
View 2 Replies
View Related
Oct 22, 2015
I am writing a custom query to determine if a legacy table exists or not. From My CMS Server I already have all the instances I have to query and I store the name of the instance in the @Instance variable. I cannot get those stubborn ticks to work right in my query. Below I am using the IF EXISTS statement to search the metadata for the legacy table.
DECLARE @Found tinyint
DECLARE @Instance varchar(100)
set @Instance = 'The Instance'
IF (EXISTS (SELECT a.*
FROM OPENROWSET('SQLNCLI', 'Server=' + @Instance + ';UID=DBAReader;PWD=DBAReader;','SELECT * FROM [DBA].INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = ''TheTable''') AS a))
SET @Found = 1
ELSE
SET @Found = 0
PRINT @Found
View 2 Replies
View Related
Apr 26, 2007
I have a SQL task that I want to execute a query like:
SELECT firstField FROM schema.table WHERE fieldName = 'M&M'
The problem is when I put that in, it won't run.
For SQL*Plus I can stick SET DEFINE OFF before it and it work, not so in Integration Services.
The issue apparently is that &M is treated by Oracle as a variable of some sort.
Any help is appreciated.
View 5 Replies
View Related
Nov 7, 2006
Within a VS 2003 BI project, I can create a parmeterized query against an Oracle 7 database by using a ? for the parameter(s).
Example:
SELECT LTrim(RTrim(SWO_ISS.REF)) ACCT, CUS_LOC.NAME CUSTOMER,
SWO_ISS.TRAN_DATE, SWO_ISS.ITEM, ITM_DESC.ITEM_DESCRIPTION, SWO_ISS.QTY, LSTPRC.AMT
FROM MYDB.SWO_ISS, MYDB.CUS_LOC, MYDB.ITM_DESC,
(SELECT LP.ITEM, LP.REVISION, LP.AMT FROM MYDB.LIST_PRC LP
WHERE LP.EFFEND > SYSDATE) LSTPRC
WHERE SWO_ISS.REF = CUS_LOC.CUS_LOC(+)
AND SWO_ISS.COMP_ITEM = ITM_DESC.ITEM(+)
AND SWO_ISS.COMP_ITEM = LSTPRC.ITEM(+)
AND SWO_ISS.COMP_REV = LSTPRC.REVISION(+)
AND SWO_ISS.REF = ?
AND SWO_ISS.TRAN_DATE >= TO_DATE(?,'MM/DD/YYYY')
AND SWO_ISS.TRAN_DATE <= TO_DATE(?,'MM/DD/YYYY')
Unfortunately, as soon as the dataset is saved or Layout view is selected the Field List disappears and all of the report objects lose their data binding.
Worse still, if you click the Generic Query Designer button while working with one of these queries Visual Studio will lock up.
This worked at one time and now has me stumped. What may be the cause of the change?
View 3 Replies
View Related
Nov 12, 2007
Hello.
I need to store 2 values that i retrive from a databse into variables so i can check them towards what is typed into the textboxes for my login script iv built. How can i do this?1 string myConnectionString = @"Data Source=.SQLEXPRESS;AttachDbFilename=C:UsersalhoDocumentsIntrapointWebApp_DataIntrapoint.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
2
3 SqlConnection myConnection = new SqlConnection(myConnectionString);
4 SqlCommand cmd = new SqlCommand("SELECT [username], [password] FROM [company] WHERE (([username] = @username) AND ([password] = @password))");
5 cmd.Parameters.AddWithValue("username", TextBoxUsername.Text);
6 cmd.Parameters.AddWithValue("password", TextBoxPassword.Text);
7
8 myConnection.Open();
9
10 //how do i pass the values retrived into variables, like string usrname and string password?
11
12 myConnection.Close();
View 13 Replies
View Related
Feb 4, 1999
I have an installation script and want to create a database based on some data in a table (config). Testing the script though I get a message:
Msg 170, Level 15, State 1
Line 12: Incorrect syntax near '@DBData'.
The relevant sql is:
declare @DBName varchar (40)
declare @DBData varchar (40)
declare @DBLog varchar (40)
declare @DBSize int
select @DBName = obj_txt from config where obj_nm='DBName'
select @DBData = @DBName + '_Data'
select @DBLog = @DBName + '_Log'
select @DBSize = obj_int from config where obj_nm='DBSize'
raiserror('Creating Database %s ....',0,1,@DBName) with nowait
Create Database @DBName
on @DBData = @DBSize
Log on @DBLog = @DBSize
I don't think there's anything wrong, apart from the fact I am using the local variables. Is this allowed on a Create Database statement? I haven't found anything in Technet that may help.
Here's hoping....
Thanks
Dan
View 1 Replies
View Related
Sep 4, 2006
Hi,
I am not comfortable with DTS 2000 but I need to execute a encapsulated DTS 2000 package from a SSIS package. The real problem is when I need to pass SSIS variables to DTS 2000 package. The DTS 2000 package have 3 global variables that I can identify on " Execute DTS 2000 Package Task Editor - Inner Variables ". I believe the SSIS variables must be mapped on " Execute DTS 2000 Package Task Editor - OuterVariables ". How can I associate the SSIS variables(OuterVariables ) to "Inner Variables"? How can I do it? Much Thanks.
João
View 8 Replies
View Related
Nov 2, 2006
Learning how to use SSIS...
I have a data flow that uses an OLEDB Source Component to read data from a table. The data access mode is SQL Command. The SQL Command is:
select lpartid, iCallNum, sql_uid_stamp
from call where sql_uid_stamp not in (select sql_uid_stamp from import_callcompare)
I wanted to add additional clauses to the where clause.
The problem is that I want to add to this SQL Command the ability to have it use a package variable that at the time of the package execution uses the variable value.
The package variable is called [User::Date_BeginningYesterday]
select lpartid, iCallNum, sql_uid_stamp
from call where sql_uid_stamp not in (select sql_uid_stamp from import_callcompare) and record_modified < [User::Date_BeginningYesterday]
I have looked at various forum message and been through the BOL but seem to missing something to make this work properly.
http://msdn2.microsoft.com/en-us/library/ms139904.aspx
The article, is the closest I have (what I belive) come to finding a solution. I am sure the solution is so easy that it is staring me in the face and I just don't see it. Thank you for your assistance.
...cordell...
View 4 Replies
View Related
Jan 24, 2006
Hi,
I would like to design a SSIS package, which have couple of variables. It loads a xls file specified in a variable [varExcelFileFullPath] .
I will run it by commands: exec xp_cmdshell 'dtexec /SQL ....' (pls see an example below).
It seems it does not get the values passed in for those variables. I deployed the package to a sql server.
are there any grammar errors here? I copied it from dtexecui. It worked inside Dtexecui not in dos command.
exec xp_cmdshell 'dtexec /SQL "LoadExcelDB" /SERVER test /USER *** /PASSWORD ****
/MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW
/LOGGER "{6AA833A1-E4B2-4431-831B-DE695049DC61}";"Test.SuperBowl"
/Set Package.Variables[User::varExcelFileName].Properties[Value];"TestAdHocLayer"
/Set Package.Variables[User::varExcelWorkbookName].Value;"Sheet1$"
/Set Package.Variables[User::varExcelFileFullPath].Value;"D: estshareTestAdHocLayer.xls"
/Set Package.Variables[User::varDestinationTableName].Value;"FeaturesTmp"
/Set Package.Variables[User::varPreSQLAction].Value;"delete from FeaturesTmp"
'
thanks,
Guangming
View 2 Replies
View Related
