STRQMQRY in batch on i5
Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen

Answer Question   |  October 20, 2009  4:16 PM
CL, SQL, SQL development, STRQMQRY

VBA Looping In Access
I have a report in Access which pulls from one table in an Access databse.  In the table there is one record for each “Region” and when I run my Access report it then creates one big pdf file containing a one page report for each region.  How can I write a peice of VBA code that [...]

Answer Question   |  October 19, 2009  4:10 PM
Access, Looping, VBA

store image to sql server
would you please give me a code to store and retrieve an image in SQL Server 2000, using Visual Basic 6.0 on the front end

Answer Question   |  January 23, 2010  8:28 AM
SQL Server 2000, SQL Server Image Store, VB 6.0, Visual Basic, Visual Basic 6.0

flash memory progrming in microcontroler
how to flash memory progrming in microcontroler using c?

Answer Question   |  October 19, 2009  4:30 AM
C programming, Flash memory, Microcontroller

Display array in list box VB 2008
Hi all, How do I display a whole array in one list box? (I want it to be displayed in the form load event…is that possible?)  For example I want to display these: ============================   mstrMonths(0) = ”January”   mstrMonths(1) = “February”   mstrMonths(2) = “March”   mstrMonths(3) = “April”  ============================  in a list box. I tried doing this: ======================================================== [...]

Answer Question   |  October 19, 2009  2:33 PM
VB, VB 2008, Visual Basic 08

I NEED SQL COMMAND TO EXTRACT THE NUMERIC VALUSE IN BETWEEN THE STRINGS
VCH:FR:AUD/120.18/51.26YQAC/1.35QKAD/14.47QRCO/14.47QREB/1.35QKSB/6.00WGSE/20.91UOVZ I NEED TO EXTRACT THE VALUES IN THE ABOVE STRING AND SUMM ALL THE VALUES USING SQL COMMAND EX:120.18+51.26+1.35…..IN THE ABOVE GIVEN REFRENCE

Answer Question   |  January 23, 2010  5:21 AM
SQL, SQL commands

Why do multiple requests fail in my .NET Web Service?
I have a web service whose only exposed method instantiates a DLL.  The DLL’s only job is to query a database to get a filepath to an image then return the image base64′d. I also have a test client to make requests to the web service.  It has a field in which the user enters [...]

Answer Question   |  October 16, 2009  8:04 PM
.NET Framework 2.0, VB.NET, Web services

aspect oriented && service oriented
what is the differnt between object oriented & aspect oriented& service oriented? what is the strength and limitation of object oriented & aspect oriented& service oriented? where we can apply these methodology?

Answer Question   |  October 16, 2009  7:34 PM
Software development methodologies, Software engineering

Most popular blog posts this week
10. Removing old hardware after a P2V conversion Eric Siebert shares a long-held best practice regarding old server management. 9. The challenge of managing risk when IT budgets tighten Linda Tucci explains the challenges of a down economy — and offers some tips on coming out ahead. 8. Ellison commits to the hardware business Find [...]

Answer Question   |  October 16, 2009  2:53 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

calling trigger in oracle db 10g
hi all! I do have a table called customers. I want to delete and update rows in this table. But I want to keep rows’ history before operations into another table. I know this will be performed with help of a trigger. How I could do this? I’m waiting for your help.                   Thanks!

Answer Question   |  October 16, 2009  7:32 AM
ASP.NET 2.0, C#, Oracle 10g, Oracle Database, Oracle Database 10g, Oracle developers

SQL related tables
I have 2 tables one with all my products and their accociated details and another with comments on the products. Product table 1 prodID, title, description, price Comments table 2 commID, prodID, comment I would like to export this to a single XML file, thus an XML element for each product from table 1 with [...]

Answer Question   |  October 19, 2009  7:10 AM
MySQL, MySQL 5.0, PHP, SQL Related Tables, SQL tables

VB
Hi Experts in VB 6.0 Please Tell me how I code for combo just like Access form eg. In Access Form’s Combo — when we start type any letter then nearest matching data should be selected and auto also showing during typing in the combo box Question : Please give any idea for VB 6.0 [...]

Answer Question   |  October 21, 2009  4:26 AM
Microsoft Access, VB, VB 6.0, Visual Basic

Attaching a Default Icon to .exe file
Ok, I know how to change an icon, through the properties tag, but my question is this. How does one attach an icon to a program coded in Visual Basic with a default icon, instead of the one that is always there? Like if I make my own Icon.ico file, how do I make that [...]

Answer Question   |  October 21, 2009  11:52 PM
VB4, Visual Basic, Visual Basic 4

Print to file and getting Un-Readable data.
I’m trying to print out my Visual Basic 4 code to a file, and get un-read-a-ble code, but if I print it out to my Printer it’s very readable, why can’t I get readable data when printing to file?

Answer Question   |  October 23, 2009  8:59 PM
VB4, Visual Basic, Visual Basic 4, Visual Basic developers

DataGridView – just clicking in a cell causes DataTable getChanges to report changes
Hi, I want to know if values in a DataGridView have been changed. But it seems that just by clicking in a cell (without changing any values) causes DataTable getChanges to indicate that changes have been made. How can I know that “real” changes have been made ? Thanks, docw

Answer Question   |  October 15, 2009  6:37 PM
DataGridView, DataTable, getchanges, modifed, rows

Community Announcement: Cash in your Knowledge Points for an Amazon gift card
Members who have earned over 1,000 Knowledge Points in the community by December 15th have the opportunity to cash in their points for Amazon gift cards — just e-mail us at contactus -AT- itknowledgeexchange.com with your handle when you choose to cash out. You can also post here in the discussion area when you’d like [...]

Answer Question   |  April 3, 2012  2:32 PM
AS/400, CIO, CRM, DataCenter, Development, Exchange, Giveaways, ITKE, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, Virtualization, VoIP

Tree View Control
i am trying 2 make and explorer using the tree view control in my project using VB 6, SQL Server 2000 and crystal reports. in the looping statements i had inculed the details and all. i need 2 display the results in the Grid Box when click the nodes in the Tree control. please provide [...]

Answer Question   |  October 15, 2009  8:55 AM
Crystal Reports, SQL Server 2000, Tree View control, VB 6, Visual Basic

Please tell me the Correct mechanism to determine the testing is Completed as per Specification
Hi, All test Cases are execuated & all bugs are Closed. This stage application is ready to go for UAT . At this Stage if Software Tester / Test Engineer want mechanism to Determine Application will  working Fine in UAT

Answer Question   |  February 18, 2011  7:14 AM
Software Manual Testing, Software testing, UAT

How to Write the Effiecent & Effective Test Cases based on SRS ( use Cases) / Mocks / SDD
Hi, I am only doing the Functional Manual Testing .so please tell me how to Write a Effeiecnt & Effective Test Cases based on Use Cases ,Mocks OR SDD.  

Answer Question   |  October 16, 2009  6:50 AM
Software Manual Testing, Software testing

SQLRPGLE
I’ve Report to print using SQLRPGLE The Report criteria screen has around 15-20 select conditions…based on the conditions entered by the user, I build a query of type Select * from emp1 where val1 = ? and val2 =? and val3 = ? and……….. This is the first time I’m dealing with so many select [...]

Answer Question   |  October 21, 2009  10:05 PM
RPGLE, SQL, SQLRPGLE