Database Splitting
What other alternative do I have to split a lotus note database beside writing a code to copy  document to newly created database?

Answer Question   |  November 9, 2009  4:58 PM
Access Database, Database optimization, Lotus Domino

How to combine 2 linked Excel tables in access 2003 with same field names, using query?
I have 3 employees working who have no access on their PC. they are performing their data entry in excel and I ahve linked all three tables to one access file as I have Access on my PC. I need to combine all 3 tables using query or some other method in access to create [...]

Answer Question   |  June 22, 2012  6:37 PM
Access 2003, Data management, Microsoft Access query

The IT Blog Top 10: Nov. 5, 2009
10. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover has put together a useful tutorial for Sun’s xVM VirtualBox. 9. How to reset the Cisco Catalyst Switch to Factory Defaults Yasir Irfan offers some advice for those needing a fresh late on Catalyst switches. 8. Independent clauses and semicolons Margaret Rouse offers up [...]

Answer Question   |  November 5, 2009  4:01 PM
Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

lamp or sap
HI all , i ve complted my engneering in electronics and Commnctn; Now i have two options to take up as my career, sap or lamp; which has more opening and scope ; what are the categories in sap/

Answer Question   |  November 26, 2009  1:01 PM
Careers, Certifications, IT careers, LAMP, SAP, SAP careers

RPGLE Flat File
how can i keyed a flat file in RPGLE

Answer Question   |  November 28, 2009  10:58 AM
Flat files, RPGLE

Mysql syntax
Hi Have a table: budget When I try this: MySql: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a courseno from table course 2 also represents: a courseno from table course It doesnt work … Any suggestions…. ?

Answer Question   |  November 4, 2009  9:59 PM
Data Tables, MySQL, tables

Constraints (MySql,tables,null,PK,FK etc)
Hi all(waves) noob here ( ) ( yes you might look down upon me) ( ) never the less….:)  Quick question: Tables made so far: department values (depno,dname) course values values (courseno) How would I create a table eg “Table budgets”…with values of two budgets (£100 and £200) for courses. 1.Courses are managed by departments. [...]

Answer Question   |  January 23, 2010  7:52 PM
constraints, foreign key, MySQL, NOT NULL, NULL, primary key, tables

The most-watched IT questions this week: Nov. 3, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and answered by Jerry [...]

Answer Question   |  November 4, 2009  2:33 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

PHP Datagrid
Hi! I m new to php and MySQL database. I want to know how whether php provides any class for datagrid

Answer Question   |  February 14, 2011  4:57 PM
DataGrid, MySQL Database, PHP/MySQL

Migration from Paradox to MS Access or VB.Net/MS SQL
We have a department that has several applications running on Paradox 11.  They need assistance migrating their tables and application UI/code to another platform.  Any feedback or guidance would be appreciated.

Answer Question   |  January 23, 2010  9:11 PM
Access 2003, Microsoft Access, Paradox 11, SQL, VB.NET, VB.NET 2008, Windows Server 2007, Windows XP

How to convert LONG to CLOB or to VARCHAR type in select statement
Hi, I need to convert LONG to CLOB or to VARCHAR type, to be able to apply either dbms_lob.substr() or just SUBSTR() function to this conversion result. Unfortunately Oracle function to_lob() converts LONG value in the column long_column to LOB values in the select list of a subquery in an INSERT or UPDATE statement O_N_L_Y. [...]

Answer Question   |  April 19, 2011  8:00 PM
CLOB, Conversion, DataType, Long, Oracle, PL/SQL, SQL

How to prepare for IT interview?
How to prepare for IT interview?

Answer Question   |  October 30, 2009  7:05 AM
Careers, Interviews, IT careers

The IT Blog Top 10: Oct. 29, 2009
10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view VirtualBox virtual machines remotely Rick [...]

Answer Question   |  November 28, 2009  7:08 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, IT Blogs, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

COMBO BOX (IN VB) HOW BEHAVE LIKE MS ACCESS
HI VB EXPERTS, PLEASE SOLVE HOW CAN BEHAVE THE VB COMBO JUST LIKE MS ACCESS COMBO (OFFICE 2003/2007) EG. IN MS ACCESS COMBO :- A) WHEN START TYPING THEN NEAREST MATCHED SELECTED/DISPLAYED B) ON GOT FOCUS COMBO DROPDOWN ABOVE FACILITIES I WISH TO AVAIL IN VB COMBO BOX PLEASE PLEASE PLEASE SOLVE IT NB : THIS [...]

Answer Question   |  January 23, 2010  7:24 AM
Microsoft Access, VB, Visual Basic

IT infrastruture
Dear Sir, I Gaurav Nijhawan 21years old working in a mnc company in gurgaon(India). I have two years of experience in IT for supporting a site. I did MCP( Microsoft Certified Professional). earlier i was working as a desktop support engineer and completely work on Desktop and Outlook troubleshotting. I had a little bit of knowledge of [...]

Answer Question   |  November 5, 2009  5:05 AM
Careers, CCNA, Certifications, IT careers, IT infrastruture

UDS and DS
I know well Data Strucutre (DS) and its usage, how an UDS (Data Area Data Structure) is different from and ordinary DS, I just find to know by myself but I was unable to find it. Can any one help me in expalainigt this?

Answer Question   |  October 27, 2009  2:23 PM
AS/400, AS/400 database, Data structures

What are the points to be taken care of when designing a database on Linux?
What are the points to be taken care of when designing a database on Linux? What are the different replication methods available?

Answer Question   |  October 27, 2009  2:39 PM
Database design, Database replication, Linux databases

SQL query help
Below is a list of the query that I am working on. There are part numbers that may be match to more than one module number. What I need is to show only the part numbers for the list. These part numbers I need a list of only one part number for each group. PartNo—— [...]

Answer Question   |  October 30, 2009  1:24 PM
SQL, SQL queries, SQL Query

MySQL database size
Is there a limit on database size for MySQL? my database is getting on the large zise will this effect proformance?

Answer Question   |  October 26, 2009  5:45 PM
MySQL, PHP, PHP Coding, SQL, SQL Database

New To the Industry
Hello, my name is Kristine and I am a first year student in IT field. My major is Networking communications and Information systems w/ a concentration in MS operating systems. I wanted to know if anyone had any websites i can go to or magazines I can subscribe to get learn about my new career.

Answer Question   |  October 30, 2009  6:02 AM
Careers, IT careers, Networking careers, Networking certifications