Triggers to Populate Geometry of a Feature
Hi, Has anyone created a trigger that populates a field with the geometry of that table, where the table contains spatial geometry? For example, I would like to create a trigger to automatically populate an area (AREA_SQM) or perimiter (PERIM_M) field of a building area feature (AREA_BUILDING) once the feature has been created. Thanks in [...]
Answer Question
| December 9, 2009 7:38 PM
Database, Oracle
Hi, Has anyone created a trigger that populates a field with the geometry of that table, where the table contains spatial geometry? For example, I would like to create a trigger to automatically populate an area (AREA_SQM) or perimiter (PERIM_M) field of a building area feature (AREA_BUILDING) once the feature has been created. Thanks in [...]
Answer Question
| December 9, 2009 7:38 PM
Database, Oracle
The most-watched IT questions this week: Dec. 8, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Pushan1234 asks about Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime. CarlosDL and MrDenny provide some pointers. 2. Bonbon78 runs into trouble Converting date values [...]
Answer Question
| December 9, 2009 8:07 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
Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Pushan1234 asks about Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime. CarlosDL and MrDenny provide some pointers. 2. Bonbon78 runs into trouble Converting date values [...]
Answer Question
| December 9, 2009 8:07 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
Want to be a Sun Solaris Administrator.
I am Varun Malhotra. I am going to join a course in Sun Solaris Administration. This year I completed my BCA degree and currently I am working in a call centre. What is the future scope of Solaris administrators? Is it a good area to work in? Will I be getting a good job after [...]
Answer Question
| May 12, 2010 8:18 PM
IT careers, Solaris certifications, Sun Solaris
I am Varun Malhotra. I am going to join a course in Sun Solaris Administration. This year I completed my BCA degree and currently I am working in a call centre. What is the future scope of Solaris administrators? Is it a good area to work in? Will I be getting a good job after [...]
Answer Question
| May 12, 2010 8:18 PM
IT careers, Solaris certifications, Sun Solaris
Edit .accdb from multiple workstations
How can I input data in to a database file using microsoft access 2007 from multiple computers at the same time. From my understanding I need to have SQL Server running in order for me to do this, correct ? Also if I do need Sql server can it be installed on a Windows Xp [...]
Answer Question
| December 12, 2009 3:14 AM
Access 2007, Access Database, Microsoft Access, Windows XP, Windows XP SP2
How can I input data in to a database file using microsoft access 2007 from multiple computers at the same time. From my understanding I need to have SQL Server running in order for me to do this, correct ? Also if I do need Sql server can it be installed on a Windows Xp [...]
Answer Question
| December 12, 2009 3:14 AM
Access 2007, Access Database, Microsoft Access, Windows XP, Windows XP SP2
export VB6 report in pdf format.
i am making a project in vb 6 using ms access as a database. i am making report in crystal report and want to export that repot in pdf format.
Answer Question
| January 21, 2010 4:47 AM
Access Database, Crystal Reports, Microsoft Access, VB6, Visual Basic
i am making a project in vb 6 using ms access as a database. i am making report in crystal report and want to export that repot in pdf format.
Answer Question
| January 21, 2010 4:47 AM
Access Database, Crystal Reports, Microsoft Access, VB6, Visual Basic
Reconnecting to databases in SharePoint after server wipe
My Windows Server 2003 box died which had WSS 3.0 on it. The server has been wiped and I still have the SQL Server intact. Everything is reinstalling now; can I just reinstall SharePoint and “reconnect” to the databases that already are there or do I need to start all over?
Answer Question
| December 4, 2009 7:33 PM
Database administration, Servers, SharePoint, Sharepoint installation, SQL Server, Windows Server 2003, WSS 3.0
My Windows Server 2003 box died which had WSS 3.0 on it. The server has been wiped and I still have the SQL Server intact. Everything is reinstalling now; can I just reinstall SharePoint and “reconnect” to the databases that already are there or do I need to start all over?
Answer Question
| December 4, 2009 7:33 PM
Database administration, Servers, SharePoint, Sharepoint installation, SQL Server, Windows Server 2003, WSS 3.0
SQL Query to return a single value for each record based on max FIELD, not max record
I have a table with 12 date columns per record (D1 thru D12) and I want to select from each record, the max date of those columns (not the max of the records). I know: select max(D1) from table1 will yield max of D1, but say I want D3 from record1, D1 from record2, etc [...]
Answer Question
| December 24, 2009 7:59 AM
Access 2007, Microsoft Access, SQL, SQL Query
I have a table with 12 date columns per record (D1 thru D12) and I want to select from each record, the max date of those columns (not the max of the records). I know: select max(D1) from table1 will yield max of D1, but say I want D3 from record1, D1 from record2, etc [...]
Answer Question
| December 24, 2009 7:59 AM
Access 2007, Microsoft Access, SQL, SQL Query
which is the best among DBA and CCNA for career in all aspects
Hi All, presently i’ve one year of exp. in network field. i want change my domain to DBA, now iam cofused whether to ontinue with CCNA or to change to DBA. please can anyone suggest me which will be the best for my career in all aspects. please help me out
Answer Question
| July 23, 2011 5:51 AM
Careers, CCNA, Certifications, DBA, IT careers
Hi All, presently i’ve one year of exp. in network field. i want change my domain to DBA, now iam cofused whether to ontinue with CCNA or to change to DBA. please can anyone suggest me which will be the best for my career in all aspects. please help me out
Answer Question
| July 23, 2011 5:51 AM
Careers, CCNA, Certifications, DBA, IT careers
VB6.0 Connectivity to Oracle
How to connect oracle 9i to vb6.0 using active X data objects? please mention the code.. Thnx … Saurabh
Answer Question
| May 20, 2011 5:18 AM
ActiveX, Activex connectivity, ODBC, Oracle 9i, VB6.0, Visual Basic
How to connect oracle 9i to vb6.0 using active X data objects? please mention the code.. Thnx … Saurabh
Answer Question
| May 20, 2011 5:18 AM
ActiveX, Activex connectivity, ODBC, Oracle 9i, VB6.0, Visual Basic
The most-watched IT questions this week: Dec. 1, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. CompEng asked about open-ended SQL statements, and Mrdenny and Meandyou delivered the goods. 2. Kalpana queried Networking certifications, and where the best place is to get certified. XENOPHON22, Schmidtw and KevinBeaver all chimed in [...]
Answer Question
| December 11, 2009 6:21 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
Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. CompEng asked about open-ended SQL statements, and Mrdenny and Meandyou delivered the goods. 2. Kalpana queried Networking certifications, and where the best place is to get certified. XENOPHON22, Schmidtw and KevinBeaver all chimed in [...]
Answer Question
| December 11, 2009 6:21 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
About MCSE
Is there any chance to get high profile job after completing the MCSE exam conducted by Microsoft ?
Answer Question
| December 4, 2009 8:26 AM
Careers, IT careers, MCSE
Is there any chance to get high profile job after completing the MCSE exam conducted by Microsoft ?
Answer Question
| December 4, 2009 8:26 AM
Careers, IT careers, MCSE
Building an xml in java
Please give me an example of building an xml with multiple child nodes, in java. I want something like : <Parent> <Child1>something</Child1> <Child2>something else</Child2> </Parent> Now, the values for Child1 and Child2 must be picked using SQL from AS400. Picking values is where i think i am failing. My program constructs something like : <Parent> [...]
Answer Question
| November 30, 2009 7:20 AM
AS/400, Java, JDBC, SQL Query, XML
Please give me an example of building an xml with multiple child nodes, in java. I want something like : <Parent> <Child1>something</Child1> <Child2>something else</Child2> </Parent> Now, the values for Child1 and Child2 must be picked using SQL from AS400. Picking values is where i think i am failing. My program constructs something like : <Parent> [...]
Answer Question
| November 30, 2009 7:20 AM
AS/400, Java, JDBC, SQL Query, XML
Microsoft Access Report
I am able to alter one of my access reports, but everytime i try to exit and save it the report will not close untill i say no to save changes has anyone got any ideas as it is driving me insane
Answer Question
| November 30, 2009 10:49 AM
Microsoft Access
I am able to alter one of my access reports, but everytime i try to exit and save it the report will not close untill i say no to save changes has anyone got any ideas as it is driving me insane
Answer Question
| November 30, 2009 10:49 AM
Microsoft Access
Best way to create a large access databases.
I am new to access databases, as I am sure everyone says there first time. One thing I do know is that the database I will create will be very large and I Would like to know is it better to break up the database in to several linked databases together or just have one and live [...]
Answer Question
| November 30, 2009 7:40 PM
Database, Microsoft Access
I am new to access databases, as I am sure everyone says there first time. One thing I do know is that the database I will create will be very large and I Would like to know is it better to break up the database in to several linked databases together or just have one and live [...]
Answer Question
| November 30, 2009 7:40 PM
Database, Microsoft Access
Data Dynamic Activ Report Version 2.0
I Have Data Dynamic Active Report Activex, When I load designed Report from vb6 I can show a evaluation message in yellow backgroun How to remove it and also when I give print 1 page printer will print 2 page (With blank page) How to solve this problem or how to hack this proble
Answer Question
| November 23, 2009 6:43 AM
Access 2003, ActiveX, data dynamic active report, VB 6.0, Visual Basic 6, Windows XP
I Have Data Dynamic Active Report Activex, When I load designed Report from vb6 I can show a evaluation message in yellow backgroun How to remove it and also when I give print 1 page printer will print 2 page (With blank page) How to solve this problem or how to hack this proble
Answer Question
| November 23, 2009 6:43 AM
Access 2003, ActiveX, data dynamic active report, VB 6.0, Visual Basic 6, Windows XP
S/W course
hello sir/madam recently i m studying B.E final year but anyone plz suggest me latest s/w course which will be helpful if done b4 placements…. thanx
Answer Question
| December 4, 2009 8:02 PM
Careers, Certifications, IT careers, s/w
hello sir/madam recently i m studying B.E final year but anyone plz suggest me latest s/w course which will be helpful if done b4 placements…. thanx
Answer Question
| December 4, 2009 8:02 PM
Careers, Certifications, IT careers, s/w
JDBC connection to DB2/400
Hi, We have application which runs on Java Server connects DB2/400 using JDBC connection. would like to know what is the maximumnumber of database connections supported on DB2/400 and how can I adjust this connection activity so that it is not impacting our application running on as/400 i.e. how to imrpove the performance of as/400 [...]
Answer Question
| June 30, 2010 11:32 AM
DB/400, DB2/400, JDBC
Hi, We have application which runs on Java Server connects DB2/400 using JDBC connection. would like to know what is the maximumnumber of database connections supported on DB2/400 and how can I adjust this connection activity so that it is not impacting our application running on as/400 i.e. how to imrpove the performance of as/400 [...]
Answer Question
| June 30, 2010 11:32 AM
DB/400, DB2/400, JDBC
start career
sir, I have completed my MCA in 2004,but not working after studies because I was in abroad with my family.Recently return back to chennai looking for good opportunity.I would like to start my career in ORACLE DBA.Which course in that will help me to start my career.Also can u suggest me any way to get [...]
Answer Question
| December 4, 2009 9:44 AM
Careers, Database administration, DBA, DBA training, IT careers
sir, I have completed my MCA in 2004,but not working after studies because I was in abroad with my family.Recently return back to chennai looking for good opportunity.I would like to start my career in ORACLE DBA.Which course in that will help me to start my career.Also can u suggest me any way to get [...]
Answer Question
| December 4, 2009 9:44 AM
Careers, Database administration, DBA, DBA training, IT careers
CONNECTION VB WITH ACCESS
how to connect visual basic 6 and msaccess 2003 by using connection string
Answer Question
| August 9, 2010 7:56 AM
Access 2003, VB 6.0, Visual Basic, Visual Studio 2005
how to connect visual basic 6 and msaccess 2003 by using connection string
Answer Question
| August 9, 2010 7:56 AM
Access 2003, VB 6.0, Visual Basic, Visual Studio 2005
Msg 102, level 15, State 1, Line 14
Hi, I’m ttrying to create my db tables in a stored procedure and I keep getting the error that the syntax is incorrect around the ‘ON’ on the line “SET ANSI_NULLS ON”. Could you please help me? I can’t see what’s wrong. Here’s my code: CREATE PROCEDURE InsertDBTables AS BEGIN SET NOCOUNT ON; SET ANSI_NULLS [...]
Answer Question
| November 19, 2009 6:54 PM
CREATE TABLE statement, SQL, Stored Procedures
Hi, I’m ttrying to create my db tables in a stored procedure and I keep getting the error that the syntax is incorrect around the ‘ON’ on the line “SET ANSI_NULLS ON”. Could you please help me? I can’t see what’s wrong. Here’s my code: CREATE PROCEDURE InsertDBTables AS BEGIN SET NOCOUNT ON; SET ANSI_NULLS [...]
Answer Question
| November 19, 2009 6:54 PM
CREATE TABLE statement, SQL, Stored Procedures
