Dropdown should not hide when popup is opened
hi all…. In one of my page there are Dropdown’s and in the same page there are popups too, so when i open the popup the dropdowns in the main screen are hided, but i need them to be displayed even when popup ia opened… can any one sent me what to be done….thanking u. [...]

Answer Question   |  May 19, 2009  11:42 AM
DropDownList, Pop-ups, Web development

Error when using SQL*Plus @@ command in SQL Navigator
When I try to use the @@ SQL*Plus command in a script I get the message “ORA-00936: missing exppression!” when it reaches the line containing this command. I read the help and they say that the @@ command is admitted. I’ve tried the same script in Oracle Enterprise Manager Console->Tools->Database->Applications->SQL*Plus Worksheet and it worked.

Answer Question   |  May 12, 2009  10:22 AM
ORA-00936, Oracle Enterprise Manager, Oracle error messages, SQL, SQL Navigator, SQLPlus

ASP.NET connection from MochaSoft software to pub1.rzkh.de
Hi, If anybody has done asp.net to AS400 connection from mochasoft software pub1.rzkh.de. Please share how to do it, I want to show data in datagrid of asp.net and data is store in pf at pub1.rzkh.de server. Please help me. Thanks

Answer Question   |  May 12, 2009  8:18 AM
AS/400 connectivity, ASP.NET, DataGrid, MochaSoft, Web development

How to pass array in MySQL procedure parameter
how to pass array in mysql procedure parameter

Answer Question   |  September 21, 2011  7:13 AM
Database programming, MySQL, MySQL Stored Procedures, SQL

Access password protected URL and download the output
Hi, I want to access a url where we have to login and then open a link where it shows a list of data rows retrived from the d/b and store that data to a local file. Thanks in advance…

Answer Question   |  May 12, 2009  6:59 AM
Java, SOAP, Web development

Calculating prior Query fields
Inside my query, is four listed fields; date, printer, and a Start and End meter for daily meter readings to keep track of printer impressions. I’m trying to receive a return value by subtracting a meter reading from the START field in a current row and the END meter in the previous row depending on [...]

Answer Question   |  May 13, 2009  4:24 AM
DLookup, Query optimization, WHERE statement

Access 2007: VB code to make a button press link to a specific record in another form
The database is for a set of components. One of my forms shows details about each component on a separate record (the property “Default View” is Single Form). The other form is a list of all components by component number displayed all together (the property “Default View” is Continuous Forms). The list of components has [...]

Answer Question   |  November 25, 2011  9:59 PM
Access 2007 forms, Access VBA, Microsoft Access, Microsoft Access 2007, VBA, Visual Basic for Applications

VB6 kernal func GetFreeDiskSpace returns a Long (not long enough)
I have a VB6 kernal func which returns free space as a long, but the max val for a long is 2.1 meg and I have 140 gig free. Is there a func or sub that returns free space as currency? Current func follows: —————————————————————————————————— Private Declare Function GetDiskFreeSpaceEx Lib “kernel32″ Alias “GetDiskFreeSpaceExA” (ByVal lpRootPathName [...]

Answer Question   |  May 12, 2009  8:12 PM
VB6, Visual Basic

Connecting VB2008 to SQLServer2005
How to connect VB2008 with SQLServer2005 through coding.. Not through OleDBAdaptar.. Also Let me know the code for Add,Edit, Delete & Save in VB2008

Answer Question   |  September 2, 2011  6:02 PM
OLE, SQL Server 2005, VB 2008, Visual Basic

Raw Data not in Pivot
I have a large pivot table looking to a raw data worksheet. All the data in raw data is not showing in the pivot table.

Answer Question   |  May 18, 2009  5:51 PM
Microsoft Excel, Pivot tables

sql Help
I have a ten character field and need to exclude records if the first 2 character equal a specific pattern how do you do that?

Answer Question   |  May 11, 2009  5:21 PM
SQL, SQL Fields

Updating Combobox after new data added
Using access 2003, I have a form (frmJobSheet) which contains a combobox (cboContacts) containing all the contacts in a talbe (tblContacts). If a name is entered in cboContacts which doesn’t exist in tblContacts, I want to open another form (frmContacts) which the user would then enter the new contact details. When frmContacts is closed, I [...]

Answer Question   |  June 25, 2009  3:07 PM
Access 2003, Access 2003 forms, Access forms, ComboBox, Microsoft Access

Access: Form to input dates
Hi, I was wondering if some Access expert could help me with this short questions. I have an access database with one table, which has 4 columns: ID, Task, Date, Hours I would like to create a form in which a user sees the following headings Task : Mon : Tue : Wed : Thur [...]

Answer Question   |  May 12, 2009  1:42 PM
Access forms, Access Forms Database, Microsoft Access

How to Set UI AutomationProperty for a ListItem?
I have a test.xaml - <Grid> <ListBox Name=”ListBox1″/> </Grid> And in the test.xaml.cs file, I initiatilize the ListBox for (int i=1; i<=50; i++) { ListBox1.Items.Add(“Item” + i); } Now I want to set a HelpText AutomationProperty to each of the ListItems. How do I do it? I tried the following, but no success - <Grid> [...]

Answer Question   |  May 19, 2009  12:55 PM
ListItem, UI, UI Automation, WPF ListBox

How to use DateDiff to calculate costs?
Hi, In my Access bookings system you select a number of Units and a start and end booking time. I need to calculate the cost of each Unit for the booking as well as a total cost for all Units in the booking. The information is stored in two tables: a bookings table called tblHourPeriod [...]

Answer Question   |  May 13, 2009  10:16 AM
Database programming, DATEDIFF, Microsoft Access

Querying database tables with their descriptions
I want to query an SQL server database for specific tables and their descriptions. How do I do that? Is there a special tool needed to do this?

Answer Question   |  May 11, 2009  10:01 AM
SQL, SQL queries, SQL Server Query

How can I export data from mainframe to Excel in REXX
i want to export data in PS to excel through rexx code.As i am a beginner in REXX .can any one help me in this .

Answer Question   |  August 12, 2011  6:13 AM
Mainframe, Microsoft Excel, Microsoft Excel import/export, REXX, REXX Procedure, REXX procedure to export data to Excel

How to connect to an AS/400 database from a remote PHP script
Hello. I have a requirement to use a PHP script running under Windows to access a remote DB2/400 on an iSeries. Can anyone please assist in what PHP coding would be needed, thank you! Regards Paul

Answer Question   |  May 26, 2009  10:13 PM
AS/400 connectivity, AS/400 development, DB2/400, iSeries connectivity, iSeries development, PHP, Remote access

SQL Studio Express scheduled backup
I need a scheduled backup for a standalone SQL database on an XP Pro PC. I have Studio Express installed and this does not have a scheduling utility. Can anyone suggest a way of achieving this without the expense of an SQL Express license

Answer Question   |  May 16, 2009  9:01 PM
Backup Scheduler, SQL, SQL Backup, SQL job scheduler

Transform DB2 to XML from AS/400
I have been requested to create XML files from AS/400 DB2 files to be used to update data on a client’s web server. I have looked at IBM’s XML Toolkit for iSeries, but the examples are all about parsing XML input and nothing about creating XML from native AS/400 database files. Is there something in [...]

Answer Question   |  November 4, 2010  3:36 PM
AS/400 development, DB2, DB2/400, iSeries development, XML, XML Toolkit for iSeries