I have an application where a start form, launches a second one and then according to text input/selection more form open (as a 3rd level form). I want all the answers to be recorded in one table as a singe record, but instead I get 3 different records, with responses from each form. What do…

I created 80+ reports for the company intranet and they worked great. At the time the ODBC’s were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet but it still doesn’t…

Hello there fellow users, I have been entrusted with the task of designing and implementing a financial system for a charity foundation where I live. The charity foundation requires its work (addition and retrieval of records, for example) to be done online, using a web app. The app connects to a database server for storage…

I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6…

I have xmlfile stored in table in CLOB column.It contains some null rows with some spaces. While parsing that column, am using xmltype function on that column, then it is giving error :LPX-00229 input source is empty, beacuse of null clob columns. I have to craete an function index also using xmltype and some aother…

I have a database that resides on a server. Many users have access to this database to add and edit documents. When this database is replicated to a local machine not all documents will replicate. Can someone tell me what I need to do to correct this problem? Thanks,

I need to rename a field within a data structure? what code format do i use.

I got the “Could Not find installable ISAM error” while uploading an Excel file in my application.This seems to be happening at the “connection.Open()” code line. — Web Application — .Net 2.0 — Testing using IIS 7.0 on Vista Ultimate — Office 2007 Enterprise Installed on machine. Code works successfully when used in a Windows…

Crystal reports are not getting generated with odbc error. After the upgradation of rational tools from SQL to DB2 version, refreshing crystal reports template is not fetching data and end with ODBC Error. What could be the reason for this? Is any settings needed for this upgradation?

Why does the name of the database and the associated toolbar not show up when I look at the list of tables IN that data base. It does for most of my databases but not for one of them. How do I fis this?

I need to make a connection from BI Publisher to an MS Access database. Anyone can help me with the connect string and database driver class details for setting up a JDBC?

I have a server 2003 two node cluster with SQL 2005 installed. The orginal instance is working fine and there is no connection problem. I have created a second instance and can connect with the SQL Management Studio. When i try to create a ODBC connection from my client os both XP and VISTA both…

please provide me with all information on how to export my data to an excel sheet and how to filter the data using a dropdownlist (asp.net)

Hi All we are getting issue in as400 cpu utilisation. qzdasoinit jobs is getting killed after closing connection but after when we initiate a fresh connection it utlises cpu from where previous connection was closed. Suppose if previous connection was closed at cpu usage 10%, job would disappear from wrkactjob but when fresh connection is…

I am using SQLRPGLE program,need to handle record lock in sql statement ..plz suggest?

Can someone please help me in migrating my tables form Access to MYSQL Server Enterprise Manager

I have a customer Master with Code & Name Fields. While entering data through Input screen I will type customer name and the program will go on filtering the name of the customer from the Master Data File and when I press Enter Key it will select the exact record from the master with Code.…

I am attempting to run a calculation based on the numerical values entered into the form. The end result would be to include the numerical value entered into the form as an item in a query equation calculation. Any help you can provide is greatly appreciated.

hi, i have a wrok experience in automobile industry as customer relation and BPO experience in again cs for over 9 years , i have done MBA in marketing, wanted to pursue my career in SAP . please suggest which sap course i should do and from which institute ? thanx

How to print a PDF image stored in BLOB from SQLRPGLE?