Auditing users of STRSQL
I want to audit the SQL statements of users who use STRSQL. I know if you press F13, you can change the interactive SQL Session Services. If you choose option 4 it will save all SQL statements into a file. But I was wondering if it is possible if we setup this as default when [...]

Answer Question   |  February 18, 2010  9:02 PM
SQL, SQL audit, STRSQL

Auto-Populate an Access form using a table of values
I’m having a little bit of a dilema. I don’t even know if it can be done, but I thought I’d give it a shot. I’m pretty new to Access so I’ll try to be as clear as I can be, but I think this will get confusing. I have Multiple tables and a form for adding [...]

Answer Question   |  February 17, 2010  8:56 PM
Access 2003, Access forms, Microsoft Access

SQL Access Query
I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the  word “Udate”     Why would that be?  CREATE TABLE Manufacture ( ManufactureID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL, CompanyName CHAR (50) NOT NULL, [...]

Answer Question   |  February 16, 2010  11:00 AM
Access Datasheet, Access query, Microsoft Access, SQL, SQL Access, SQL Query

Help detecting packet loss in java
Hi, I need to make a program in java which can detect packet over in TCP/IP on specific ports. I know this is possible yet I cannot find a RFC or any way to do this on the internet. Can someone give me an idea of how to do this? To be more specific, I’ve [...]

Answer Question   |  September 25, 2011  1:03 PM
Java, Packet Loss, RFC, TCP/IP, Visual Studio 2008

Multiple databases on a server – SQL
My queries Can PostgreSQL(as database for a Jboss application) and MS SQL(as database for a tomcat application).Are there any known conflicts/issues ? Best regards

Answer Question   |  February 15, 2010  5:23 AM
PostgreSQL, SQL, SQL Database, SQL Server databases

about oracle with Java
What is future of Oracle with Java regarding jobs for freshers and distance learners. Why I am asking this because I am learning oracle from SQL star tutorial in delhi and doing MCA from Sikkim Manipal University in distance learning.

Answer Question   |  February 15, 2010  7:52 PM
Java, Oracle Careers, Oracle developers, Oracle with Java, SQL, SQL Plus

Multiple objects in the handles of a sub – Visual Studio
I’m trying to detect if the mouse is down over a group of objects. Doing this individually for each object is not an option. I was thinking it would look like “Handles ______[1-512].MouseDown”, but nothing I tried worked, and google didn’t return anything useful.

Answer Question   |  February 15, 2010  9:13 PM
Visual Studio, Visual Studio 2008

Activex Control
want to sav and show video in database from ocx control

Answer Question   |  February 15, 2010  2:42 PM
ActiveX, ActiveX Controls, OCX

I am looking at developing clinical messaging or specialist tools for the united states
I am looking at developing clinical messaging for the united states. I am not looking at billing or accounts, as I believe than can be implemented as separate systems , Is there a comprehensive checklist or requirements list I can access to see what is required by the United States in order to provide software [...]

Answer Question   |  February 15, 2010  2:54 AM
Enterprise messaging, Software development

Help with embedded SQL in RPG. Dang thing hates the delete statement?
 H OPTION(*NODEBUGIO:*SRCSTMT)                             *******************************************************  FWRLDSHP   IF   E             DISK                       FWRLDSHP1  O  A E           K DISK                       D*******************************************************  D*  Working Variables                                    D*******************************************************  D                SDS                                     D PGMNAME                 1     10                       D*                                                       D myDS            ds                   occurs(60)        DXORDNU                          7a    varying           DXHIPDT                          7a                      DXSHPIN                         30a                      D*                                                       D i               s             20i 0 inz                D*                                                       D*INVDETL        E DS                  EXTNAME(WRLDSHP1)  C*                                                       C/EXEC SQL                                               C+ Set Option                                           [...]

Answer Question   |  February 17, 2011  7:55 PM
RPG ILE, SQL

Hide macro
I want to use a macro that will hide rows in the range of 17 to 61 where a value in column B is 0 on a protected sheet.  This has to be automatic (multi-user friendly) rather than using advanced filtering.

Answer Question   |  March 16, 2010  5:58 PM
Excel macros, Macros, Microsoft Excel macros

varchar(max) size limit
I have defined a table field with datatype of varchar(max) but it only stores upto 8k characters, I thought (max) upped this limit to 2g character. How can I get it to store more than 8k characters?

Answer Question   |  February 12, 2010  4:49 PM
SQL Server, VARCHAR

how to code the parameters for API QUSRSPLA
i want to get the last print file generated from a job which was created AFTER the time the program producing the print file ran. my methodology was to 1. rtvsysval qtime 2. execute the program 3. execute the api qusrspla 4. test the create time and determine if it was greater than the time [...]

Answer Question   |  February 12, 2010  3:55 PM
API, qusrspla, Spool files

How to print and report in VB 6.0
I can report data from M.s Access in VB 6.0, But my hard copy in Certificate in Landscape Paper. so I can’t do. I want to ask! How print Data from Access to VB 6.0 that can change position of Paper (Portriat and Landscape). I think in Crystal Report, but I can’t. Please help me.

Answer Question   |  February 11, 2010  1:01 PM
VB 6, VB 6.0, Visual Basic

Querying multiple member PF with SQL
I would need to SQL on a multiple member PF and I need to query the 2nd or nth member in the PF.  Is this possible just with an SQL query without using OVRDBF etc.?

Answer Question   |  February 15, 2010  8:17 AM
AS/400 SQL, DB2, Physical Files, SQL

Future of Silverlight
Silverlight is Built for Future or Not?i.e It Can Be Replaced By Another Technology?

Answer Question   |  February 11, 2010  6:14 AM
Silverlight

A field from one table update two different fields in other table.
TBL_Items (ItemsID, Item) and TBL_Order (OrderID, OrderItem, DeliveredItem). At TBL_Items it is possible to find an items that has equal funtion to other. (Item1=Item23) A customer asks for Item1 and with a ComboBox I select Item1 and fill OrderItem. At the moment to deliver there are not Item1 and we replace it for Item23, also [...]

Answer Question   |  February 13, 2010  2:14 AM
ComboBox, forms, sub-forms

Pivot Table Dimensions (Not all are showing in the drop down)
I have created a Pivot Table with 5 different columns in the Page area.  Not all of the values in the raw data are appearing in the dropdowns.  I need to see all of the dropdowns for each of the 5 different columns.  Why is this only showing a partial dataset?

Answer Question   |  February 10, 2010  7:11 PM
excel, Pivot tables, Runtime Errors

JDE Enterprise Unicode
We are upgrading from JDE A7.30 co-existance to Enterprise One. The database has been converted to Unicode. I have another application (Avantis) which integrates to DDM files on a second iSeries which does not use Unicode. How can I access/create these DDM files to appear non-unicode to the second iSeries?

Answer Question   |  March 18, 2011  4:17 PM
Avantis, iSeries, JDE, JDE E1 9.0, Unicode

Scaling Amazon Web Services against RDS
Any recommendations for scaling multiple application server instances in Amazon Web Services against Amazon’s Relational Database Service?   For example, if you had multiple tomcat instances running, should they each also have a slave that talks to the RDS master? Or let them all connect to RDS?

Answer Question   |  February 10, 2010  3:42 PM
Amazon AWS, Amazon RDS, Amazon Web services, Cloud Computing in 2010, Knowledge Point Challenge, Scaling Out, Virtualization