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
I possess a K7N2-L with chipset nFORCE 2 and vi something in software SANDRA 2004 that it did not please me very. I verified exactly that the access to the hard disk is carried through in 16bits instead of 32bits, with qualified IDE BLOCK. It would l [More]
Hi, I have one smartlist with 200 songs in itunes. After I sync with my iphone and the same smartlist have 190 songs inside the phone. The files listen ok in itunes and in the iphone (in other lists). Can be a bug of itunes? Is not the first time tha [More]
Hi all, Is it possible to change the colour of path segments/strokes in PS CC in order to make them more visible when used in eg B&W pictures?? Thanks in advance! [Moving to Photoshop forum... JTS]No.. It is not possible in scripts.. In scripts u can [More]
I get this error when trying to access HDR tone mapping.   Can anyone help.If the error is showing up, when doing a training series, I need to ask: Does that training series come with Images, etc., to be used in the training? Some come with 3rd party [More]
We have a "satisfied" RTF template used in 11.15.9. But it no longer works in 11.5.10.2. We would like to try what metalink note#305307.1 suggested. Has anyone done template conversion from RTF or XSL-FO to PDF? Thanks.Hi You should not have a p [More]
Hi everyone! Is there anyone who can tell me where I can find some information about the usage of the FTP adapter included in BPEL PM 10.1.2. Thanks!Hi! By the using of the beta FTP guide I have solved my doubts about the configuration of the adapter [More]
This problem have dogged me for one week but cant seem to know where the problem is. i am creating an enterprise with war, ejb and jar. i want both web clients and application client to share the code in ejb to ease maintainablility. i have a jsf bac [More]
Hi! Our OWB Version is 10.1.0.3.0 - DB Version 9.2.0.7.0 - OWF Version 2.6.2 Clients and server are running on Windows. Database contains target schemas as well as OWB Design and Runtime, plus OWF repositories. The source files to load reside on the [More]
Is this possible not changing my constant objects e.g. header or my logo or some stripes etc ( reload again on my next pages) I would like to reload only content, not the whole page again and again. Maybe someone html guru knows how. Thanks for the f [More]
Hi how can I sort my contacts by name?They're either already sorted by first name, or last name.   The setting is under Settings - Mail, Contacts, CalendarsRead other 2 answers [More]