PL/SQL
Hi Experts, I would like to mentione here i was trying to test one package and found the package has a procedure named SET() which hav UPDATE on Report table and INSERT on A_R table in same transaction Both the above mentioned tables hav a tim_upt column which s given as systimestamp and strange it [...]

Answer Question   |  February 20, 2009  10:47 AM
INSERT statement, Oracle development, Oracle PL/SQL, PL/SQL, PL/SQL block, SQL, SQL Timestamp, Timestamp, UPDATE statement

Adobe 9 won’t print
Hello Installed adobe 9 some time ago. Its able to print from the internet, but not straight from the program. Please help Thank You

Answer Question   |  February 19, 2009  7:18 AM
Adobe, Printing

Microsoft Access 2007 – Code for connecting two related forms, bringing up same record?
:sigh: My database suddenly requires me to have my forms appear as read-only’s (since my employees are too stupid to NOT going flailing around, typing madly for no reason). However, we still need to be able to edit the information. I’ve created a second form, mirroring the original, to be my edit form. My problem [...]

Answer Question   |  June 8, 2012  3:44 AM
Access 2007, Database programming, Microsoft Access 2007, Microsoft Access 2007 permissions

Setting up PHP environment – CGI vs Module
what is the difference on setting up php environment as CGI or as a module to a web server

Answer Question   |  February 17, 2009  11:34 PM
Apache modules, CGI, PHP, PHP installation

Temporary recordset in MS Access VBA
Hi, I am using MS Access 2003 as a front end to 2 Oracle databases. I am trying to retrieve a recordset from a database through ADO/DAO, display that recordset in a Form for users to make changes, and then write the records that have been changed to a different database (i.e. I don’t need [...]

Answer Question   |  February 19, 2009  6:40 PM
Access 2003, ADO, DAO, Microsoft Access, MS Access 2003, MS Access VBA

Ensuring the same data is served when using multiple load balanced servers
I have a Web server and I need to add another Web server. We will use a load balancer to take care of distributing the load between the 2 Web servers. Users are capable of uploading files and data via FTP and HTTP. I need a technique that will help me make replication for these [...]

Answer Question   |  February 16, 2009  6:17 PM
Data Replication, FTP, HTTP, Load balancer, Load balancing, Storage management

request for code
I want create a web site, in which first i will ask for the emp.number of the person logged in, it will check whether it exists or not, if it exists , then it will show the details of the person, then it will ask for the qualification of the person then it will show [...]

Answer Question   |  February 17, 2009  4:15 PM
Application and Web development, Code, Scripts, Web development

SQL Server does not exist or Access Denied Error
I have a VB.Net app which connect to a SQL Server database, just recently the technical guys removed the DNS server from the network for maintenance. and now my application cannot see the SQL server. I can ping it using its IP address and it responds but even if I configure my application to use [...]

Answer Question   |  February 17, 2009  12:23 PM
Database connectivity, Error: Access Denied, SQL Server, VB.NET, Visual Basic .NET

Quantifying work in Test Automation
I would like to know whether there are any methods to quantify the work during the initial phases of Test Automation. During the inittial phases, a lot of effort goes into creation of the shared modules, deciding on the frame work and other things needed for running the test scripts. Projecting only the automated test [...]

Answer Question   |  February 19, 2009  7:03 AM
Automated Testing, Quality assurance, Test Automation, Test scripts, Testing

A Socket Connection was Attempted to an Unreachable Host
Hi, i am getting this Ureachable Exception when connecting From Pocket PC Application To Desktop Application through Scoket. But The same is Working with Wondows Form Application.Not Working with PockePC Application. I can’t Understand this. Please tell me How to solve This Problem

Answer Question   |  February 16, 2009  5:38 AM
Mobile development, Network connectivity, Pocket PC, Socket error, Unreachable host, Windows Forms

QTP Script for Data Driven Testing using Notepad
Set f=createobject(“scripting.filesystemobject”) Set f1=f.createtextfile(“d://file1.txt”) f1.writeline”Raju Rani” f1.writeline”King Queen” f1.writeline”Radha Krishna” f1.writeline”Thirupathi Gangula” f1.writeline”Bala Kishan” The above script creates a notepad in “d” drive with name file1 Raju Rani King Queen Radha Krishna Thirupathi Gangula Bala Kishan values are stored in file1.txt. Set f2=f.opentextfile(“d://file1.txt”) While f2.atendofstream<>true f3=f2.readline x=split(f3,” “) msgbox x(0) msgbox x(1) Wend The above [...]

Answer Question   |  September 29, 2010  10:42 AM
Data-driven testing, QTP, QTP script error handling, QTP Scripting, QuickTest Professional

How I can activate a Workflow event?
I have a great problem and I have tu activate a workflow event, directly in production I don’t know if I have to “reactivate” or I have to generate the event

Answer Question   |  February 16, 2009  2:59 AM
Workflow

Suggestions for VB.NET 2005 projects
helloo….i needed some ideas frm u all for a project that me nd ma members have to do within 2-4mnths…we came up wid ideas such a lan chat program,college mgt systems….do any1 else have any otha ideas or suggestion???we will be working on VB.Net….

Answer Question   |  June 28, 2010  12:03 PM
Requirements gathering, Software requirements, VB.NET 2005, Visual Basic, Visual Basic .NET

How can I pass tablename as a parameter in MySQL stored procedure?
my SQL stored procedure is like this…. ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = ‘Insert into ‘ + @_tablename + ‘(ImageID,Status) values (‘+ convert(nvarchar(5),@_ImageID) +’,'+ CONVERT(nvarchar(1),@_Stat) +’)’ –print @strTemp exec(@strTemp) end I want this stored procedure in MYSQL.

Answer Question   |  February 18, 2009  8:38 AM
Database programming, MySQL, MySQL Stored Procedures, SQL, SQL stored procedures, Stored Procedures

How do I populate an SQL table created on the fly in RPGLE?
I am writing a report program where I create a table that is then converted to an Excel spreadsheet using SQL2JXL. I am able to dynamically create a table with Execute Immediate but I have been unable to populate it. The problem is the table name is stored in a variable within the program and [...]

Answer Question   |  February 16, 2009  4:20 AM
Dynamic SQL, Microsoft Excel, RPG, RPGLE, RPGSQL, SQL, SQL2JXL

Conditional Formatting Excel 2003
I have three columns, Column 1 = Start Date Column 2 = End Date Column 3 = Close Date I need to place a conditional format or and “IF” statement on columns 2 and 3. Stating if column 2 is after or 1 month from today’s date highlight in RED. And column 3 should state [...]

Answer Question   |  February 20, 2009  5:26 PM
Conditional formatting, Excel 2003, Microsoft Excel

VB.NET app cannot login to SQL Server 2005 after upgrade from SQL Server 2000
I have a VB.Net application which connects to an SQL2000 database and I recently upgraded to SQL2005 and after the upgrade my app does not want to connect to SQL2005 using the same password I used to connect to SQL2000. if I change the login password to all uppercase characters in SQL2005 Management Studio my [...]

Answer Question   |  February 13, 2009  10:22 AM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server connectivity, VB.NET, Visual Basic, Visual Basic .NET

Multiple language support in SSRS 2005
I have to display my report in diffrent language viz French, German. SSRS 2005 Can support Multiple language? Thanks, NRoy

Answer Question   |  February 16, 2009  9:51 AM
Multilingual support, SQL Server 2005 Reporting Services, SQL Server Reporting Services, SSRS 2005

concatenating rows of a column in oracle 9i sql
how can i concatenate several rows of a column which is of datatype varchar taking group by of two other columns in oracle 9i sql??

Answer Question   |  February 16, 2009  10:17 PM
Concatenate, Oracle 9i, Oracle SQL

Running .NET Code to manipulate sql tables
is it possible to retrieve a table using .NET code manipulate in code e.g calculating formulas based on values stored in table retrieved and then pivoting it in code and putting it back into another table

Answer Question   |  February 12, 2009  8:52 PM
.NET, SQL Server 2005, SQL tables