Sitemap

Amicuk Programming Answers

Using WHERE command in property loader SQL query

2015-10-11   Views:1

Advertisement

Hello All, Hopefully this will be a fairly straight forward question. I am attempting to use Property Loader to read in test limits from a SQL database. There are many types of models that need to be tested, each having a unique set of limits. I want

Hello All,
Hopefully this will be a fairly straight forward question.
I am attempting to use Property Loader to read in test limits from a SQL database. There are many types of models that need to be tested, each having a unique set of limits. I want to be able to retrieve the appropriate limits for the model of product under test.
To do this I have the product model number available in a FileGlobal. The database contains a table with the test limit information with an identifying 'ModelNumber_Number' column.
I have written the following SQL query achieve this:
"SELECT *  FROM TESTLIMITS WHERE ModelNumber_Number=+ FileGlobals.ModelNumber"
However, this is where I am confused. I'm not sure on the syntax for accessing a variable in the SQL command. I receive the following error:
The multi-part identifier "FileGlobals.ModelNumber" could not be bound.
Can someone please provide guidence on how to do this?
Many thanks,
Cam.
Solved!
Go to Solution.

The replay answer
Advertisement
Thank you very much for your reply.
Upon changing the query to as you suggest, I am presented with the following:
Error In SQL Statement Expression. "SELECT *  FROM TESTLIMITS WHERE ModelNumber_Number = " + FileGlobals.ModelNumber
Specified value does not have the expected type.
The type of FileGlobals.ModelNumber is a numeric represented as a double precision 64 bit signed integer.
The database column is also of type int 64.
Can you suggest a solution?
Many thanks.

Go to See the other 4 answers

Using WHERE command in property loader SQL query

Category:DefaultRelease time:2015-10-11Views:130

Hello All, Hopefully this will be a fairly straight forward question. I am attempting to use Property Loader to read in test limits from a SQL database. There are many types of models that need to be tested, each having a unique set of limits. I want[More]

How to use property file - sql query define in property file

Category:DefaultRelease time:2015-10-11Views:130

Hi All, Anybody please tell me how to use property file. I have placed sql query in propery file and I have to access this in my file. well so far this is my code but don't know how to implement in the following ... pstmt = con.prepareStatement("sele[More]

Loading SQL query File

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I created all of my tables and constraints into a notepad document, and then when I was finished I named it proj4.sql so it could be loaded into oracle and automatically create my tables and constraints all at once. The problem is, I forgot the c[More]

Using Forumlas in (Command) SQL Query

Category:DefaultRelease time:-0001-11-30Views:130

We're trying to optimize the record returns on some reports and recently discovered the ability to apply a Command to specify the SQL Query. One of the things we do with our reports is actually pass in some values so the user doesn't have to enter so[More]

How to modify a SQL query?

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I am using Crystal Reports version 10. I have a number of reports that have been written by a software vendor wherby the name of the database they were connected to when the report was written is coded into the FROM command of the reports SQL[More]

SQL Query report region that only queries on first load

Category:DefaultRelease time:2015-10-11Views:130

Hello all, Is there any way in which you can prevent a SQL Query report region from quering data after every refresh? I would like to make a report that queries on the first load, but then I would like to change the individual values, and reload to s[More]

Command the execute sql query and does not clean up data in Table

Category:DefaultRelease time:2015-10-11Views:130

Hi Team I have an SP, which writes source and target data to Temp Tables and runs except query to get mismatch details I am using Exec command to execute source query that writes data to Temp Table, once I execute query using Exec, data is written an[More]

SQL Dev 2.1:Ability to save and load visual query models?

Category:DefaultRelease time:-0001-11-30Views:130

At SQL Dev 2.1, do we now have the ability to save and load visual query models as with TOAD? Or has that functionality been rolled into the for-pay Data Modeler extension? Seemed strange to hide the functionality deep within SQL Worksheet, then not[More]

How do i get a output in CSV of a SQL query executed via SQL Command prompt

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I have a question with reference to SQL command prompt. I have a sql query which runs properly and gives proper execution in SQL Management console in GUI. This report is used to pull the free disk space report of our servers As i want to sch[More]

Handling property name with spaces in SQL query

Category:DefaultRelease time:-0001-11-30Views:130

Hello, I have some JSON that looks like this:     "SystemId": "112234",     "Parameter": {         "Total Hours": [                 "timestamp": "2015-03-15T15:20:00Z",                 "item[More]

Error in SQl Query - SQl Command not properly ended

Category:DefaultRelease time:-0001-11-30Views:130

Hi All I have this SQL query that returns the following error when I run it in TOAD: SELECT VC.CAMPAIGN_NUMBER,VC.CAMPAIGN_TITLE,VC.CAMPAIGN_DESC, VCV.START_DATE, VCV.END_DATE,VC.CAMPAIGN_TYPE,VC.APPLICABILITY, VC.CAMPAIGN_PRIORITY      FROM      VM_[More]

Hot
Hello, I want to pass value from Excel to Custom Program being called in the Custom Integrator and i am using the Import in the Importer section but it is not getting passed. Please advise and i am on R12.1.3. ThanksPl do not post duplicates - Concur [More]
There is a requirement to change the font size at the application level for ease of readability. Is there an easy way to accomplish this requirement in APEX 3.0? Please advise. Thank you. ~PhyllisAh, alright so then the font does not have to change s [More]
Just recently I tried to click on a link in my email on my Ipad Air, click on menu headings did not respond? This is a new problem! Stores send me emails on sales with menu headings to access "Clearances", "Men's Wares", etc. I click o [More]
Hi all, I'm working on a method that will return a Shape from a BufferedImage that has transparent values, much like the one that dfgstg developed in [this thread|http://forums.sun.com/thread.jspa?messageID=9809317] . I'm having trouble understanding [More]
This QuickTime video-only file consists of a single frame divided into 255 rectangles (17 across by 15 down), each containing a different 8-bit luminance level (0 to 254 inclusive): http://www.rtr.myzen.co.uk/steps255.mov When imported by almost any [More]
after upgrading to the newest version of itunes 8.2.0.23... now when i go to itunes there is nothing in it. NO SONGS! NO PLAYLISTS! NO PICTURES! NO IPHONE APPS! NO PODCASTS! ***!!! i am extremely ******! spent a lot of time downloading stuff. Message [More]
I recently went to Italy and loaded my digital photos into iPhoto. My wife loaded the same CF card so I now have hundreds of duplicates. Any ideas on how to find the duplicates other than looking at each photo individually?bob Check out Duplicate Ann [More]
Hi, We have a 2node 11gR2(11.2.0.3) oracle RAC node. We are seeing huge number of idle connection(more than 5000 in each node) on both the nodes and increasing day by day. All the idle connections are from VIP and loopback address(127.0.0.1.47971 ) n [More]
Hi! Does anybody know API for SCSI programming in Windows Server 2008 and 2012?Hi, About the develop question please post to the MSDN forum. MSDN forum Developer Network http://social.msdn.microsoft.com/Forums/en-US/home?forum=WAVirtualMachinesVirtua [More]
In the motion XML, what is skewX and skewY? The spec says "shearing along X" and "shearing along Y". However, according to my research, equal shearing along X and Y does not result in rotation(although that's what the spec says about s [More]