Development Questions


asked by:
5 pts.

How to use API’s , SNDDTAQ & RCVDTAQ ?
I would like to know how can we send data to a Data Queue and Receive data from a Data Queue ? Can any one give code for both the cases ?

Answer Question   |  June 8, 2009  5:34 PM
API, RCVDTAQ, RcvDtaQMsg, SNDDTAQ
asked by:
95 pts.

error detected by database DLL
please explain this error message in crystal reports

Answer Question   |  October 3, 2010  3:31 PM
Crystal Reports, Crystal Reports Database, DLL
asked by:
5 pts.

Oracle SP syntax issues
We have a linked server from SQL to Oracle and successfully ran Oracle stored procedures from SQL to insert data. I am attempting to run a different SP that returns data but can’t seem to get the syntax correct. My call includes a couple of date fields as parameters and a cursor is returned. Are [...]

Answer Question   |  June 5, 2009  2:42 PM
Oracle, Oracle stored procedures, SQL Server, Syntax errors
2,585 pts.

VB.NET – Can’t insert data into database.
I used insert command it worked successfully that ur data has updated.But it is not showing in the database Plz look in the below code and tell me where iam wrong Imports System Imports System.Collections Imports System.Data Imports System.IO Imports System.Xml.Serialization Imports System.Windows.Forms Imports System.Data.SqlClient Public Class SAdmission Shared WithEvents con As SqlConnection Shared Sub [...]

Answer Question   |  June 11, 2009  10:40 AM
SQL Server 2005, VB.NET, Visual Basic .NET
asked by:
255 pts.

Problem with ++ string operator in VB.NET
command3 = New Data.SqlClient.SqlCommand(“UPDATE Products SET Stock=” + numU + ” Where ProductName=’” + proName + “‘”, connection3) At the code snippet above, numU is integer and when i execute it in insert at sql server as a double so it throws me an error and says me that its a double and you try [...]

Answer Question   |  December 15, 2010  9:19 AM
Integer, SQL, VB .NET, Visual Basic .NET
asked by:
5 pts.

How to export meta-data
I am charged with archiving data from a legacy AS400 packaged system. I can export the data using attachmate and a few tricks to get it into XML on my LAN. However, the FDF info is not good as metadata, so I need to retrieve the field level that is available thru ‘file commands”display file [...]

Answer Question   |  June 7, 2009  1:29 AM
AS/400, AS/400 backup, AS/400 database, AS400 Data Definitions, AS400 Data Model Export, AttachMate and AS400, Metadata, XML
asked by:
5 pts.

MYOB open macro causes ‘macro disable’ messages when Office documents opened
On a system that has MYOB installed every time a Office file is opened a message box appears saying that macros are disabled. I understand that the problem is due to the location that MYOB has used to store their macros. Can I move them and avoid this issue ?

Answer Question   |  October 25, 2009  12:57 AM
Macros, Microsoft Office VBA, MYOB, VBA
asked by:
5 pts.

SQL2005 SP3
Hi, I recently applied Service Pack 3 to SQL2005 64 bit and my server performance has been very slow since. The statistics have been updated on my databases, but that has not made a difference. Has anyone else experienced such behaviour post SP3 install? Thanks, Lakshmi

Answer Question   |  June 4, 2009  3:46 PM
SQL 2005, SQL 2005 Service pack 3, SQL 2005 SP3, SQL performance
asked by:
5 pts.

asked by:
25 pts.

How to work with JavaBeans in Oracle Forms 10g
I’ve downloaded “First Bean” Demo but i dont understand how to use/implement it. I dont know much about Java Programming.In Forms 10g, when i draw a bean and give “oracle.forms.demo.canvasproperty” in Implemantation Class property of bean, an error occurs FRM-13008: Cannot find java bean with name oracle.forms.demo…. Please help.

Answer Question   |  March 16, 2010  10:51 AM
FRM-13008, Java, JavaBeans, Oracle 10g, Oracle 10g error messages, Oracle Forms 10g
asked by:
25 pts.

Delete variable file in SQLRPG
How can I use any variable file in an instruction SQL of DELETE in SQLRPG?

Answer Question   |  June 4, 2009  9:01 AM
DELETE statement, SQL, SQL variables, SQLRPG
asked by:
5 pts.

understanding and detecting sql performance situation with abnormal 400 shutdown
Need help in understanding and detecting situation with logical files built for sql rpgle performance and abnormal shutdown. Our system went down due to ups failure. All of a sudden the rpgle sql program is a resource hog because it is not selecting the lf that was built specifically for performance issues. LF is intact [...]

Answer Question   |  June 5, 2009  2:32 PM
DB2, RPGLE, SQL, SQL performance
asked by:
540 pts.

Getting error in this VB 6 code
Sr No Crop Varity Psize Pkts 1 Fodder NG-1788 1 kg 180 2 Sf SN-85 2 Kg 100 3 Beet B-885 1 kg 100 4 Beet B-885 1 kg 150 5 Beet B-885 1 kg 200 6 Beet B-885 1 kg 250 7 Beet B-885 1 kg 300 8 Beet B-885 1 kg 350 9 [...]

Answer Question   |  June 3, 2009  11:26 AM
DataGrid, VB 6, Visual Basic 6
asked by:
25 pts.

Leak rate trigger
If I have a cell that has >=50 AND another that has >=15 then I want the cell with this formula to read YES, if either of the two cells are not >= those numbers then the cell should read NO.

Answer Question   |  June 3, 2009  9:49 PM
Conditional expressions, Crystal Reports, Formula Workshop
asked by:
5 pts.

Project management advice: executing an implementation schedule
I am planning to implement a campus wireless network in my organization. The work has been awarded to a contractor. How do I go about the implementation schedule? Can I prepare any chart to keep track of the implementation schedule?

Answer Question   |  June 2, 2009  2:52 PM
Contract management, Networking, Project management, Wireless Network Implementation, Wireless networking
asked by:
1,545 pts.

Unable to add web parts within Edit Item
Helping a colleague with implementing a project tracker within SP. I have seen the ability to add web parts within the Edit Item page (using Edit Page). The issue is Edit Page within the Edit Item does not appear for me. Does anyone know why or how it can be enabled for me to use?

Answer Question   |  June 2, 2009  1:35 PM
Project Tracker, SP, Web Parts
asked by:
5 pts.

login failed
when i start debugging project,sql connection will be closed,before that it will be open .Iam using sql which comes along with vb.net 2005.Iam using sqlconnetion in login form also there its not giving error when i used sql connetion code in another form its giving error login failed .iam tried up of this error.plz help

Answer Question   |  June 2, 2009  12:31 PM
SQL, SQL Debugging, VB.NET, VB.NET 2005
asked by:
255 pts.

QAQQINI File
What is the QAQQINI file? Does it have to be in every library? I saw someone mention ignore_derived_index and setting it to yes. My files don’t even have that value. I have the file in QSYS, QUSRSYS, and one of our test libraries. Are there any other options I should worry about? Currently, any option [...]

Answer Question   |  January 21, 2012  12:23 PM
Database, iSeries, QAQQINI, SQL, V5R4
asked by:
465 pts.

RPC over HTTPS in Exchange 2003
I want to setup RPC proxy over HTTPS server in my exchange server. WE have taken following steps, but still not working. Present environment. Windows Domain Controller 2000 server – Active directory Windows 2003 server SP2 with Exchange 2003 Server service pack2 installed. We have now SSL certification, SSL port 443 is open in my [...]

Answer Question   |  June 19, 2009  8:10 AM
Exchange 2003, Exchange 2003 configuration, HTTPS, RPC, RPC over HTTP/S
asked by:
5 pts.