After trigger select from other tables using joins
Is it possible to create a trigger on table A if there is an insert, update, or delete then fire the trigger but in addition to the changes in table A I want to capture values from table B,C,D,E…. even if those records had no action applied to them. I tried declaring variables from the [...]

Answer Question   |  July 30, 2009  3:48 PM
LEFT OUTER JOIN statement, Oracle, Oracle triggers, Triggers

Multiple DELETE From Statements in Query Manager
How do I enter more than one Delete from …… where .. Statement from within Query Manager?

Answer Question   |  August 25, 2009  3:41 PM
DELETE statement, IBM DB2 Query Management Facility, Query Manager

Image(Photo and Picturtes) in FoxPro 2.6
Sir, I am doin foxpro 2.6 application, I do not Know how to process the scanned photos to screen or print photo in screen. Please help me…YSR

Answer Question   |  April 6, 2012  12:18 PM
FoxPro, FoxPro 2.6, FoxPro 2.6 for DOS

Open Access 2007 files with Windows 2000 OS
Is there a reader that that will read .accdb files using a Windows 2000 operating system?

Answer Question   |  May 13, 2009  7:40 PM
Access 2007, Microsoft Access, Microsoft Windows 2000, Windows 2000 desktop

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

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

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 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

Active Directory restore problem
Dear All, I have a machine1 on which the Operating System is Microsoft Windows Server 2003 Enterprise Edition (Service Pack 2). This is the Domain Controller on which Microsoft Exchange 2003 is installed. I want to perform backup of this machine1 using VSS (application specific writers for AD and System State) and restore it on [...]

Answer Question   |  July 11, 2009  10:16 AM
Active Directory, Backup, Domain Controller, Exchange 2003, Volume Shadow Copy Service, VSS Backup, Windows Server 2003

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

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

Errors creating database with SQL Server 2008 I&M Training Manual
I’m going through the SQL Server 2008 I&M self-paced training manual, and when I do the exercise for creating a database, here’s what happens: CREATE DATABASE TK432 ON PRIMARY ( NAME = N’TK432_Data’, FILENAME = N’c:testTK432.mdf’, SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB ), FILEGROUP FG1 ( NAME = N’TK432_Data2′, FILENAME = N’c:testTK432.ndf’, [...]

Answer Question   |  February 6, 2011  4:11 PM
CREATE DATABASE statement, SQL Server 2008, SQL Server 2008 error messages, SQL Server 2008 training, SQL Server administration

Copy/paste a record with VBA in Microsoft Access
how can I copy number of records from a form and paste them in another form with VBA, not with the right click, in msaccess? Thanks

Answer Question   |  May 19, 2009  3:37 PM
Access VBA, Microsoft Access, VBA, Visual Basic for Applications

Execute command in SQL
can someone tell me the error in this statement declare @cmd nvarchar(4000) declare @PatNo bigint set @PatNo=123 set @cmd= N’insert into TmpDues ( PatNo, BillDate, ReceiptNo, PayMode Amt) select ReceiptTable.PatNo,ReceiptTable.BillDate,ReceiptTable.ReceiptNO,’+ ”’Cash”’+’ as PayMode,CashAmount From ‘ + @databasename + ‘.dbo.ReceiptTable where PAtNo=’ + cast(@PAtNo as nvarchar) exec @Cmd

Answer Question   |  May 16, 2009  6:26 AM
SQL, SQL error messages, SQL queries

Call SQR (Structured Query Reporter)
how to call sqr on aix and return spf to windows

Answer Question   |  May 11, 2009  12:54 AM
AIX, SQL, SQR, Structured Query Reporter

Clustered and Non clustered composite index
I have a database that has a clustered composite index and 2 non clustered indexes on each of the columns used in the composite index. Doesn’t it just need the clustered index?

Answer Question   |  May 11, 2009  8:22 PM
Clustered Index, Database, Non-Clustered Index

Update a flat file through CL
Hi, I have copied a message from MSGQ into a CL variable. Is it possible to write that message in a flat fiile through CL.

Answer Question   |  May 8, 2009  1:21 PM
CL, CL/400, Flat files

Label Traxxx Client – Anyone heard of this program?
Label Traxxx Client – Anyone heard of this program? We use this every day as one of our main databases. Does anyone know of a manual of shortcuts or how to understand this program?

Answer Question   |  May 11, 2009  12:19 PM
Database, Information needs analysis, Label Traxx