Passing a Memory Variable from a Form to a Reprt in Access 2007
In Microsoft Access, I am using a Form to set up parameters and run reports from a single database. One of the parameters is a report title. Within the Form, I have set up VBA code for running the reports. I am using a memory variable (strReportName) to store the title for each report, rather [...]

Answer Question   |  March 31, 2012  4:50 AM
Variables

Concatenate many *CHAR variables.
Is it possible to Concatenate many *CHAR variable in one same type variable. I’ve created a CL who will read records from one file and concatenate them in one varaible which i will use after in my CL. But after exiting the loop i got a varaible with the last record value so the concatenation [...]

Answer Question   |  October 7, 2010  4:30 PM
AS/400, CL variables, Concatenate, Variables

not a valid Query Management variable.
Hi, can someone please help me, I am trying to use the QMQRY function to run an update statement. I pass it a variable from the program. Get the following error. is not a valid Query Management variable. Error found on STRQMQRY command. Function check. CPF0001 unmonitored by PGMFCTSEC at statement 3500, instruction X’0021′. Can [...]

Answer Question   |  October 8, 2009  11:32 AM
CL, CL programming, CL variables, QMQRY, Query Management Facility, STRQMQRY, V5R4, Variables

Truncating parameters!
I haev a 6 position alpha variable that has a value of ’12345 ‘ (a trailing blank). When I submit a job that does a CALL to a pgm with that variable as a parm, the submitted job has the value of that parm as ’12345′ with no trailing blank. Both pgms declare the variable [...]

Answer Question   |  September 10, 2009  8:10 PM
CLP, parameter values, Variables

Add variable to document. object
I am trying to fill an input field from previou input field value if user click the check box next to it. The problem I am having was document.form_two will not take other variable. For example, document.form_two.ckb_iCount.value will not take iCount value. It suppose to be… document.form_two.ckb_2.value, but it prints out as document.form_two.ckb_iCount.value Is there [...]

Answer Question   |  April 3, 2009  11:40 PM
Variables

How to combine variables
In my data set, I have four variables that have the same codes in them. The four variables relate to the same question that was given four different times to the same people. How do I get all of their responses under one variable so that I can work with it

Answer Question   |  November 12, 2009  6:52 AM
Data analysis, Datasets, Variables

How to call a procedure in VB 6 depending on variable
i have some procedure in vb 6.0 like sub a_on msgbox”A” end sub Sub b_on msgbox”B” End sub dim str as string ‘str may be a_on or b_on str=”a_on” i m planning to call procedure a_on or b_on based on the variable str how to call the procedure a_on or b_on depending on variable

Answer Question   |  July 10, 2011  12:53 PM
Variables, VB 6, Visual Basic, Visual Basic 6

QMQRY not a valid Query Management variable.
Hi there, I am trying to pass parameters to QMQRY but get the following error. CALL PGM(JCCSTREP2) PARM(C165) ‘C165′ is not a valid Query Management variable. Error found on STRQMQRY command. CPF0001 received by JCCSTREP2 at 2800. (C D I R) the CL pgm that call the query is as follows: PGM PARM(&JOBX) DCL VAR(&JOBX) [...]

Answer Question   |  February 23, 2009  7:12 AM
CL, CL programming, CL variables, QMQRY, STRQMQRY, Variables

VC++: int keyword gives different results in Oracle 9i and 10g
In my code i am using a structure with integer variable and this variable is used to accept values from generic VC++ 6.0 functions, the value which got filled to the variable is from a table field whose datatype is NUMBER(10), in oracle 10g it runs fine but in oracle 9i it always returns 0, [...]

Answer Question   |  December 24, 2008  9:09 AM
Data Type behaviour, int keyword, Integer variable, NUMBER datatype, Oracle 10g, Oracle 9i, Oracle development, Variables, VC++, Visual C++, Visual C++ 6.0

SQL Server 2000 connection to multiple databases using variables
I have a fairly simple select statement that joins three tables from two SQL Server 2000 databases. It works fine, but now I need to run the stored procedure against different servers, so my hardcoded reference to the second database (currently coded as “secondDB.tableName.columnName”) needs to be changed to “@Variable.tableName.columnName” except SQL Server doesn’t like [...]

Answer Question   |  October 9, 2008  11:20 PM
Multiple databases, SQL Server 2000, Variables

Accessing another database using a variable
I have a select like this: SELECT a.part_id, a.descript, b.location from PART_MASTER a, anotherdatabase.INVENTORY b where a.part_id = b.part_id Is it possible to use a @variable to identify the other database, rather than hard coding it? (I’ve tried @db2.INVENTORY b) but SQL SERVER 2000 doesn’t like that.

Answer Question   |  October 10, 2008  4:22 PM
SELECT statement, SQL Server 2000, SQL Server database, Variables

Adding a number to a variable title
I am writing a program at work to help me design some irrigation equiptment. I have a section where I select which number span I am working on and then set it’s dia. with a drop combobox and then it’s length with a drop combobox. the values of these comboboxes are to go into labels [...]

Answer Question   |  September 19, 2008  7:11 AM
Software development, Variables

%SST
Hi, Im traying to get out put of this below mention simple logic code.But im geting out of different.(im trying with my laptop trhough my company server. DCL &FIELD1 *CHAR 10 VALUE(‘TCS AS/400′) DCL &FIELD2 *CHAR 10 CHGVAR(%SST(&FIELD2 1 10))(%SST(&FIELD1 10 1) Can you tell me the value of field2 after excuted of CHGVAR command.

Answer Question   |  July 30, 2008  10:06 AM
AS/400 Client Access, CHGVAR, CL, CL/400, RPG, RPG/400, Variables

where does in memory the contant variable in C get store?
Like global,static and local variables get store in data area and stack area respectively,where does the variable qualified as const get placed.Thanks in advance.

Answer Question   |  July 8, 2008  11:25 AM
C++, Const statement, Variables

How do I get a macro to move between workbooks?
I have a template (workbook #1) that I would like to copy data out of and paste into the workbook that I run the macro from (workbooks 2, 3, 4, 5…). The problem is that when I record the macro from workbook, excel codes the name of that workbook, making the macro unusable in workbooks [...]

Answer Question   |  June 20, 2008  1:19 AM
Macros, Microsoft Excel, Variables, VBA, Workbooks

Trying to achieve form data (variables) to be sent from one system (PHP) to another (ASP) via a GET Request
On the PHP system, there is an existing form to collect user data; name, email, phone, etc. My ASP guy has created an asp page to receive the variables http://aspsite.com/regiser.asp The problem is that the PHP guy doesn’t know what to do. Below are the variables: id (required) (MD5 Hash) email (required) password (required) (MD5 [...]

Answer Question   |  June 2, 2008  1:54 PM
ASP, HTTP GET, PHP, Variables

Is there a way to Call a Lotus Notes agent from Access code and pass Variables?
I’m on a Windows XP Pro System using M.S. Access 2003 and Lotus Notes 6.5. I provide adhoc and ancillary reports to our user community. We now have to send a hotspot to the users to inform them where their Excel files can be found. I created an agent that will send an email to [...]

Answer Question   |  January 31, 2008  3:13 PM
Lotus hotspot, Lotus Notes, Microsoft Access, Variables, Windows XP