set location of the database in the crystal report version 8.5 through vb 6.0 program
I have developed small system in vb 6.0 and using crystal reports 8.5 as reporting tool, if i have prepared the report format in crystal report the location of the database ( MS Access 2003 ) is set after selecting the database name. I would like to set the location of the database through vb [...]
Answer Question
| February 25, 2011 4:59 PM
Crystal Reports 8.5, VB 6.0
I have developed small system in vb 6.0 and using crystal reports 8.5 as reporting tool, if i have prepared the report format in crystal report the location of the database ( MS Access 2003 ) is set after selecting the database name. I would like to set the location of the database through vb [...]
Answer Question
| February 25, 2011 4:59 PM
Crystal Reports 8.5, VB 6.0
Language Migration: COBOL to JAVA conversion, mapping help
Hi All, Im looking for an idea or suggestion on the COBOL group variable conversion to equivalent conversion approach in Java equivalent: Background: The conversion tool currently im working on demands the tool to convert COBOL programs to .NET platform wherein all COBOL code needs to have an equivalent code in JAVA language. Inspite of [...]
Answer Question
| February 24, 2011 2:25 PM
COBOL, Java, Variable declaration mapping from COBOL to JAVA
Hi All, Im looking for an idea or suggestion on the COBOL group variable conversion to equivalent conversion approach in Java equivalent: Background: The conversion tool currently im working on demands the tool to convert COBOL programs to .NET platform wherein all COBOL code needs to have an equivalent code in JAVA language. Inspite of [...]
Answer Question
| February 24, 2011 2:25 PM
COBOL, Java, Variable declaration mapping from COBOL to JAVA
Rolling back Windows Server 2003 to a restore point
We need to roll back 23 windows server 2003 to a restore point. Can this be automated?
Answer Question
| February 24, 2011 9:31 PM
Automation, Backup and restore, Restore Points, Windows Server 2003, Windows Server 2003 Backup
We need to roll back 23 windows server 2003 to a restore point. Can this be automated?
Answer Question
| February 24, 2011 9:31 PM
Automation, Backup and restore, Restore Points, Windows Server 2003, Windows Server 2003 Backup
Open IT Forum: What cloud concern do you need addressed?
Will all of the buzz surrounding the cloud – no doubt amplified by Vivek Kundra’s push to the cloud – are you feeling left out at all? I recently spoke to an operations manager who feels that SMBs are excluded from the discussion because of fewer resources. What information would you like to know about [...]
Answer Question
| December 30, 2011 8:23 PM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Will all of the buzz surrounding the cloud – no doubt amplified by Vivek Kundra’s push to the cloud – are you feeling left out at all? I recently spoke to an operations manager who feels that SMBs are excluded from the discussion because of fewer resources. What information would you like to know about [...]
Answer Question
| December 30, 2011 8:23 PM
AS/400, Channel, CIO, Cloud Computing, Cloud Security, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
How to start *admin in HTTP Server.
It has been scheduled to start STRTCPSVR but in HTTP the *ADMIN is not started. Only the default Apache is active. HTTP server unable to start. Initialization errors were detected. Failed to bind and listen on port 80. HTTP server unable to start. Configuration errors were detected. HTTP Server instance APACHEDFT is already active.
Answer Question
| March 16, 2011 11:42 AM
HTTP, STRTCPSVR, V5R1
It has been scheduled to start STRTCPSVR but in HTTP the *ADMIN is not started. Only the default Apache is active. HTTP server unable to start. Initialization errors were detected. Failed to bind and listen on port 80. HTTP server unable to start. Configuration errors were detected. HTTP Server instance APACHEDFT is already active.
Answer Question
| March 16, 2011 11:42 AM
HTTP, STRTCPSVR, V5R1
Looping in SQL
dear, i have one table with more than (16000) rows. now i should add on column with “computed column” as a result for other columns, so i already create the new column with correct statment but how can i make this statment excute for all pervious rows. to be exact: the new column should contain [...]
Answer Question
| February 23, 2011 7:18 AM
.NET Framework 3.5, Looping, SQL Server, SQL Server 2005
dear, i have one table with more than (16000) rows. now i should add on column with “computed column” as a result for other columns, so i already create the new column with correct statment but how can i make this statment excute for all pervious rows. to be exact: the new column should contain [...]
Answer Question
| February 23, 2011 7:18 AM
.NET Framework 3.5, Looping, SQL Server, SQL Server 2005
Free IT Book: The RAILS 3 Way
It’s been called “The Bible for Ruby on Rails Application Development.” To get your copy of the book that “strips complexity from the development process,” answer one of five questions and post the link to your answer in the discussion section below. Recovering Oracle 10g Express data SQL 2000 database recovery How to connect Oracle [...]
Answer Question
| September 27, 2011 2:34 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
It’s been called “The Bible for Ruby on Rails Application Development.” To get your copy of the book that “strips complexity from the development process,” answer one of five questions and post the link to your answer in the discussion section below. Recovering Oracle 10g Express data SQL 2000 database recovery How to connect Oracle [...]
Answer Question
| September 27, 2011 2:34 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
SQL reporting
I am using sql server 2005. I have a report with 2 columns.one for report name and the other for status.I want that when a user clicks on a report’s status column,the corresponding report should be opened. i am using the following code in the navigation tab–>jump to report. =Iif(Fields!SUB_REPORT.Value=”GFM_FX_EXPOSURE$”,”www.google.co.in”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_EXP$”,”GFM_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_MV$”,”GFM_INST_TYPE_MV”, Iif(Fields!SUB_REPORT.Value=”GSS_FX_EXPOSURE$”,”GSS_FX_EXPOSURE”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_EXP$”,”GSS_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_MV$”,”GSS_INST_TYPE_MV”, [...]
Answer Question
| February 22, 2011 8:07 AM
SQL Reports, SQL Server 2005, SQL Server reporting, Visual Studio 2005
I am using sql server 2005. I have a report with 2 columns.one for report name and the other for status.I want that when a user clicks on a report’s status column,the corresponding report should be opened. i am using the following code in the navigation tab–>jump to report. =Iif(Fields!SUB_REPORT.Value=”GFM_FX_EXPOSURE$”,”www.google.co.in”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_EXP$”,”GFM_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GFM_INST_TYPE_MV$”,”GFM_INST_TYPE_MV”, Iif(Fields!SUB_REPORT.Value=”GSS_FX_EXPOSURE$”,”GSS_FX_EXPOSURE”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_EXP$”,”GSS_INST_TYPE_EXP”, Iif(Fields!SUB_REPORT.Value=”GSS_INST_TYPE_MV$”,”GSS_INST_TYPE_MV”, [...]
Answer Question
| February 22, 2011 8:07 AM
SQL Reports, SQL Server 2005, SQL Server reporting, Visual Studio 2005
C++ const correctly use
I have this sample code ( below ), whatever1() method works with no problem, whatever2() is similar but I must force const_char to make it compile, although I consider as whatever1() method is not needed, whatever2() would be not needed either. My question is, how can I modify add() method to make both compile or [...]
Answer Question
| February 23, 2011 12:00 AM
C++, Visual Studio, Visual Studio Test Edition
I have this sample code ( below ), whatever1() method works with no problem, whatever2() is similar but I must force const_char to make it compile, although I consider as whatever1() method is not needed, whatever2() would be not needed either. My question is, how can I modify add() method to make both compile or [...]
Answer Question
| February 23, 2011 12:00 AM
C++, Visual Studio, Visual Studio Test Edition
Passing an array parameter from crystal reports to a sql stored procedure
Hi All, I am having a problem in Crystal Reports with an array parameter. The user can select one warehouse code or multiple warehouse codes. I just need to display the detail from each warehouse selected (one, multiple or ALL). Right now I’m getting duplicates. I’m not sure how to set this up in SQL [...]
Answer Question
| February 22, 2011 10:56 PM
Array Parameters, Crystal Reports, Crystal Reports 10, SQL, SQL Server
Hi All, I am having a problem in Crystal Reports with an array parameter. The user can select one warehouse code or multiple warehouse codes. I just need to display the detail from each warehouse selected (one, multiple or ALL). Right now I’m getting duplicates. I’m not sure how to set this up in SQL [...]
Answer Question
| February 22, 2011 10:56 PM
Array Parameters, Crystal Reports, Crystal Reports 10, SQL, SQL Server
I learned PHP syntax, where to get real-world experience now?
Hello, I have read few books for PHP and i think i know syntax well. Now my question is where to move on now? I should probably start coding projects of my own(CMS or something like that) but i have trouble with getting ideas or thinking “nahhh i cant do that”. What can you recommend [...]
Answer Question
| March 6, 2012 8:46 PM
IT careers, PHP, PHP Coding
Hello, I have read few books for PHP and i think i know syntax well. Now my question is where to move on now? I should probably start coding projects of my own(CMS or something like that) but i have trouble with getting ideas or thinking “nahhh i cant do that”. What can you recommend [...]
Answer Question
| March 6, 2012 8:46 PM
IT careers, PHP, PHP Coding
Find AS/400 string
hi all my requirement is find out string that which object contain,that object name,type,libery name,source file name.find all data and store this data into one physical file. physical file contain fields R rec objname 10A objType 10A Libraryname 10A source-pf 10A Ex:-my string is empdetails this string scan all the objects [...]
Answer Question
| February 22, 2011 5:49 PM
AS/400, AS400 physical file, Physical Files, String testing
hi all my requirement is find out string that which object contain,that object name,type,libery name,source file name.find all data and store this data into one physical file. physical file contain fields R rec objname 10A objType 10A Libraryname 10A source-pf 10A Ex:-my string is empdetails this string scan all the objects [...]
Answer Question
| February 22, 2011 5:49 PM
AS/400, AS400 physical file, Physical Files, String testing
SQL concatenate results
Hi Need help here:- I am running this sql on business object and when I prompt for the Outlet Code, I need the results to automatically add in the % on the result field like the one in the example. How can i do this? SELECT FDDWHD20.DCOUT1, FSDWHE01.FSSHIP, FDDWHD20.DCNAME, FDDWHD20.DCMKDS, FDDWHD20.DCOTD1, FDDWHD20.DCOTD2, FDDWHD20.DCOTD3, FDDWHD20.DCOUT3, FDDWHD20.DCOUT2, [...]
Answer Question
| February 23, 2011 11:31 AM
Concatenate, SQL, SQL Server
Hi Need help here:- I am running this sql on business object and when I prompt for the Outlet Code, I need the results to automatically add in the % on the result field like the one in the example. How can i do this? SELECT FDDWHD20.DCOUT1, FSDWHE01.FSSHIP, FDDWHD20.DCNAME, FDDWHD20.DCMKDS, FDDWHD20.DCOTD1, FDDWHD20.DCOTD2, FDDWHD20.DCOTD3, FDDWHD20.DCOUT3, FDDWHD20.DCOUT2, [...]
Answer Question
| February 23, 2011 11:31 AM
Concatenate, SQL, SQL Server
Create a macro in Excel 2007 to disable save
I need to create a macro in Excel 2007 to disable save
Answer Question
| March 11, 2011 6:01 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Macros
I need to create a macro in Excel 2007 to disable save
Answer Question
| March 11, 2011 6:01 AM
Excel 2007, Excel 2007 functions, Excel 2007 macros, Macros
Limiting character input in specific cells on a DataGridView in Visual Basic.
I’m making a gradebook program (for a project) but I haven’t touched VB in years. Given it is a simple language, there’s still plenty of things I don’t know about it. At the moment I’m trying to figure out how to limit the characters a user is allowed to input in each specific cell (20) in a [...]
Answer Question
| February 21, 2011 3:34 AM
DataGridView, VB 2008, Visual Basic, Visual Basic 2008
I’m making a gradebook program (for a project) but I haven’t touched VB in years. Given it is a simple language, there’s still plenty of things I don’t know about it. At the moment I’m trying to figure out how to limit the characters a user is allowed to input in each specific cell (20) in a [...]
Answer Question
| February 21, 2011 3:34 AM
DataGridView, VB 2008, Visual Basic, Visual Basic 2008
Software deployment policy
I have made one soft. depl. policy (publish and assign both one by one) of Ms office 2007 on win 2008 Ent. So, when i m trying to install msword from the user side then getting Error 25004: Per user installation not supported. Hence, please help me out to sort out this bug
Answer Question
| February 22, 2011 8:30 PM
Group Policy, Software deployment, Windows Server 2008, Windows Server 2008 Enterprise x64 Edition, Windows Server 2008 Group Policy Objects
I have made one soft. depl. policy (publish and assign both one by one) of Ms office 2007 on win 2008 Ent. So, when i m trying to install msword from the user side then getting Error 25004: Per user installation not supported. Hence, please help me out to sort out this bug
Answer Question
| February 22, 2011 8:30 PM
Group Policy, Software deployment, Windows Server 2008, Windows Server 2008 Enterprise x64 Edition, Windows Server 2008 Group Policy Objects
How to remove spaces from text lines in Visual Basic script
I have a script that reads a text file and replaces a character string with a new string. The problem is that the data following the new string has spaces that are causing a problem. For example, here is how my data looks prior to running the script Joe Manager Bob Eric Manager Freddy What [...]
Answer Question
| February 18, 2011 6:26 PM
VB script, Visual Basic, Visual Basic Script
I have a script that reads a text file and replaces a character string with a new string. The problem is that the data following the new string has spaces that are causing a problem. For example, here is how my data looks prior to running the script Joe Manager Bob Eric Manager Freddy What [...]
Answer Question
| February 18, 2011 6:26 PM
VB script, Visual Basic, Visual Basic Script
Need to do Conditional Redirects in Lotus Domino
I need to detect the host_name of users hitting my public site as the page loads, then redirect certain host_names to different URLs as appropriate. The redirects will be in my application, not on the server itself. I speak LotusScript fluently and a little Javascript. Thanks! Mike
Answer Question
| February 22, 2011 2:15 PM
Conditional values, Java, LotusScript, LotusScript conditional statements, Redirects
I need to detect the host_name of users hitting my public site as the page loads, then redirect certain host_names to different URLs as appropriate. The redirects will be in my application, not on the server itself. I speak LotusScript fluently and a little Javascript. Thanks! Mike
Answer Question
| February 22, 2011 2:15 PM
Conditional values, Java, LotusScript, LotusScript conditional statements, Redirects
How to send packets in peer-to-peer networking
hello.. i’m still new in IT field.. i want to ask some question about networking.. how do i want to send tcp and udp packet in peer to peer network environment which is without any server in my topology. i don’t know what software should i use. after send both packet, i have to capture [...]
Answer Question
| February 19, 2011 11:18 AM
Advanced Peer-to-Peer Networking, Packets, Peer-to-Peer, TCP, UDP
hello.. i’m still new in IT field.. i want to ask some question about networking.. how do i want to send tcp and udp packet in peer to peer network environment which is without any server in my topology. i don’t know what software should i use. after send both packet, i have to capture [...]
Answer Question
| February 19, 2011 11:18 AM
Advanced Peer-to-Peer Networking, Packets, Peer-to-Peer, TCP, UDP
Update a subquery with different tables
I am trying to update a table and use a subquery for the argument. I think I have both queries correct but since but since they are from two tables I am not tying together correctly. Can you tell me what I need to do? update MVXJDTA.MITMAS set MMSTAT =’01′ where MVXJDTA.MITMAS.MMITNO = MVXJDTA.MITSTA.MHITNO (Select [...]
Answer Question
| February 18, 2011 8:04 PM
SQL Query, SQL tables, Subquery
I am trying to update a table and use a subquery for the argument. I think I have both queries correct but since but since they are from two tables I am not tying together correctly. Can you tell me what I need to do? update MVXJDTA.MITMAS set MMSTAT =’01′ where MVXJDTA.MITMAS.MMITNO = MVXJDTA.MITSTA.MHITNO (Select [...]
Answer Question
| February 18, 2011 8:04 PM
SQL Query, SQL tables, Subquery
