SQL server issue
The SQL below runs in MS Access, but fails when run in the SQL query analyser. TRANSFORM First(qryWebCustomersAllParents.Parent) AS FirstOfParent SELECT tblCustomers.CustomerID, tblCustomers.CustNameAbbr AS Customer, tblLUBudgetLevels_1.BudgetLevel, qryWebCustomerListCCRMs.CCRMPost, qryWebCustomerListCCRMs.CCRMIncumbent, qryWebCustomerListCCRMs.PostEmailRLIAlias, qryWebCustomerListCCRMs.PostTelephoneVPN FROM qryWebCustomersAllParents RIGHT JOIN ((tblCustomers LEFT JOIN tblLUBudgetLevels AS tblLUBudgetLevels_1 ON tblCustomers.CustBudgetLevelID = tblLUBudgetLevels_1.BudgetLevelID) LEFT JOIN qryWebCustomerListCCRMs ON tblCustomers.CustomerID = qryWebCustomerListCCRMs.CustomerID) ON qryWebCustomersAllParents.CustHierCustomerID = tblCustomers.CustomerID [...]
Answer Question
| January 20, 2005 10:19 AM
SQL
The SQL below runs in MS Access, but fails when run in the SQL query analyser. TRANSFORM First(qryWebCustomersAllParents.Parent) AS FirstOfParent SELECT tblCustomers.CustomerID, tblCustomers.CustNameAbbr AS Customer, tblLUBudgetLevels_1.BudgetLevel, qryWebCustomerListCCRMs.CCRMPost, qryWebCustomerListCCRMs.CCRMIncumbent, qryWebCustomerListCCRMs.PostEmailRLIAlias, qryWebCustomerListCCRMs.PostTelephoneVPN FROM qryWebCustomersAllParents RIGHT JOIN ((tblCustomers LEFT JOIN tblLUBudgetLevels AS tblLUBudgetLevels_1 ON tblCustomers.CustBudgetLevelID = tblLUBudgetLevels_1.BudgetLevelID) LEFT JOIN qryWebCustomerListCCRMs ON tblCustomers.CustomerID = qryWebCustomerListCCRMs.CustomerID) ON qryWebCustomersAllParents.CustHierCustomerID = tblCustomers.CustomerID [...]
Answer Question
| January 20, 2005 10:19 AM
SQL
NULL Constraints Missing
I am working with Oracle 8i and created a simple table with three columns (two columns with NOT NULL constraints and the remaining column with a NULL constraint). I then did a select from user_constraints and only the NOT NULL constraints where returned. Any idea why the NULL constraint does not show up?
Answer Question
| January 19, 2005 7:00 PM
SQL
I am working with Oracle 8i and created a simple table with three columns (two columns with NOT NULL constraints and the remaining column with a NULL constraint). I then did a select from user_constraints and only the NOT NULL constraints where returned. Any idea why the NULL constraint does not show up?
Answer Question
| January 19, 2005 7:00 PM
SQL
determine time of day from elapsed time
does anyone know of a routine that would allow me to determine the time of day based on a beginning time and a elapsed time in hh:mm:ss?
Answer Question
| January 18, 2005 2:30 PM
Development
does anyone know of a routine that would allow me to determine the time of day based on a beginning time and a elapsed time in hh:mm:ss?
Answer Question
| January 18, 2005 2:30 PM
Development
VB.NET Syntax for data relations
I’m using the dataset helper class to join datatables. I need to join datatables with multiple primary/foreign keys, but I can’t find the syntax for Data.DataRelations.Relations.Add that allows joining more than one column. Is it possible to do this? Thanks.
Answer Question
| January 17, 2005 6:57 PM
Development, Software testing, Tech support
I’m using the dataset helper class to join datatables. I need to join datatables with multiple primary/foreign keys, but I can’t find the syntax for Data.DataRelations.Relations.Add that allows joining more than one column. Is it possible to do this? Thanks.
Answer Question
| January 17, 2005 6:57 PM
Development, Software testing, Tech support
Make records(values) as a column header
Hi, I have a table 1, table2. table 1 ======== id, — Primary Key fname, lname, birth_dt, status table2 ——- id, — FK reference to table 1 survey_id table3 ——- Qid, — PK survey_id, — FK reference to table 2 question — has values like q1, q2, q3, .. ans also I wants to store [...]
Answer Question
| January 16, 2005 3:36 PM
DataCenter, Lifecycle development
Hi, I have a table 1, table2. table 1 ======== id, — Primary Key fname, lname, birth_dt, status table2 ——- id, — FK reference to table 1 survey_id table3 ——- Qid, — PK survey_id, — FK reference to table 2 question — has values like q1, q2, q3, .. ans also I wants to store [...]
Answer Question
| January 16, 2005 3:36 PM
DataCenter, Lifecycle development
Operations Navigator – Management Central
I am unable to connect to Management Central system. We are on V5R1M0, the TCP/IP connectivity is fine, job log for “qypsjsvr” show – CPFB9A1 Management central connection failed. Please help
Answer Question
| January 19, 2005 2:10 AM
DataCenter, Development, Hardware, Networking, Security
I am unable to connect to Management Central system. We are on V5R1M0, the TCP/IP connectivity is fine, job log for “qypsjsvr” show – CPFB9A1 Management central connection failed. Please help
Answer Question
| January 19, 2005 2:10 AM
DataCenter, Development, Hardware, Networking, Security
Printing Dollar Symbol in Printer file.
How do we print Dollar symbol in Printer file? I tried giving dollar,but it defaults giving a asterisk with a dash over it. OS/400 version used V5R1.
Answer Question
| January 16, 2005 6:03 AM
Development
How do we print Dollar symbol in Printer file? I tried giving dollar,but it defaults giving a asterisk with a dash over it. OS/400 version used V5R1.
Answer Question
| January 16, 2005 6:03 AM
Development
Tracking emails sent from VB
Hi. Thanks for your time. We are expanding our in-house insurance policy program to send emails to our brokers. I currently create “form emails” asking for missing information, missing apps, etc.. Currently we drag the email from Outlook to the Desktop. Then drag the Msg file into our Documentmanagement software. So, my question is: How [...]
Answer Question
| January 14, 2005 7:07 PM
Visual Basic
Hi. Thanks for your time. We are expanding our in-house insurance policy program to send emails to our brokers. I currently create “form emails” asking for missing information, missing apps, etc.. Currently we drag the email from Outlook to the Desktop. Then drag the Msg file into our Documentmanagement software. So, my question is: How [...]
Answer Question
| January 14, 2005 7:07 PM
Visual Basic
CHGLIBL Question
We have a home-grown menu system that integrates CL commands into the menu calls. One command is CHGLIBL LIBLD(HUMSDTA) – used to (obviously) change a library list. Then the appropriate program is called and a RSTLIBL command is issued. Where can I find the description of HUMSDTA and how do I modify it? Any help [...]
Answer Question
| January 13, 2005 6:24 PM
Programming Languages
We have a home-grown menu system that integrates CL commands into the menu calls. One command is CHGLIBL LIBLD(HUMSDTA) – used to (obviously) change a library list. Then the appropriate program is called and a RSTLIBL command is issued. Where can I find the description of HUMSDTA and how do I modify it? Any help [...]
Answer Question
| January 13, 2005 6:24 PM
Programming Languages
Developing a Java application(a batch)that transfers data from SAP to Oracle DB and vise versa. HELP ME PLEASE!
Hello, I’m a student and a newbie. I wanna learn Java in relation to SAP-BAPIs. My Test db is Oralce and I wanna develope a small application(call it a batch) that stores SAP Jobs(e.g meta data) in to my test Oracle db. The application should also be able to do bidirectional transaction(from SAP to the [...]
Answer Question
| January 13, 2005 10:59 AM
Development, Lifecycle development, Oracle
Hello, I’m a student and a newbie. I wanna learn Java in relation to SAP-BAPIs. My Test db is Oralce and I wanna develope a small application(call it a batch) that stores SAP Jobs(e.g meta data) in to my test Oracle db. The application should also be able to do bidirectional transaction(from SAP to the [...]
Answer Question
| January 13, 2005 10:59 AM
Development, Lifecycle development, Oracle
Storing Outlook Customs Forms values in Database
Hi, I would like to know if there is any way to store the values entered in an Outlook custom form into an MS Access database or SQL database. And if one can’t store it in a database, is there anyway to build a repository of values of an outlook custom form. Best Regards, joey8580
Answer Question
| January 13, 2005 10:56 AM
Development, E-mail applications, Exchange, VBA, VBScript
Hi, I would like to know if there is any way to store the values entered in an Outlook custom form into an MS Access database or SQL database. And if one can’t store it in a database, is there anyway to build a repository of values of an outlook custom form. Best Regards, joey8580
Answer Question
| January 13, 2005 10:56 AM
Development, E-mail applications, Exchange, VBA, VBScript
COM ports
I am installing a brainmaster eeg device onto a compaq nx9030 laptop. the brainmaster unit uses a serial connector, and the laptop only has usb. i am using a cables unlimited adapter. The brainmaster device cannot recieve information from the laptop but it can connect to com port 3. the problem is none of the [...]
Answer Question
| January 16, 2005 10:19 AM
DataCenter, Development, Hardware, Networking
I am installing a brainmaster eeg device onto a compaq nx9030 laptop. the brainmaster unit uses a serial connector, and the laptop only has usb. i am using a cables unlimited adapter. The brainmaster device cannot recieve information from the laptop but it can connect to com port 3. the problem is none of the [...]
Answer Question
| January 16, 2005 10:19 AM
DataCenter, Development, Hardware, Networking
Is it possible to use Javascript to pull data from a cell within an Excel spreadsheet when the notes form is displayed via a browser ? IE 5.5 or above.
Is it possible to use Javascript to pull data from a cell within an Excel spreadsheet when the notes form is displayed via a browser ? IE 5.5 or above. For clarification, the term ?user? refers to the browser user. The term ?customer? refers to the notes designer’s customer who wants the button to do [...]
Answer Question
| January 13, 2005 9:28 AM
Development, Domino Designer
Is it possible to use Javascript to pull data from a cell within an Excel spreadsheet when the notes form is displayed via a browser ? IE 5.5 or above. For clarification, the term ?user? refers to the browser user. The term ?customer? refers to the notes designer’s customer who wants the button to do [...]
Answer Question
| January 13, 2005 9:28 AM
Development, Domino Designer
i cant send and receive my mails
i am unable to send or receive my mails through outlook for the past one week even though the internet is quite okay.i use ms outlook
Answer Question
| January 11, 2005 4:31 AM
Development, Exchange, Networking
i am unable to send or receive my mails through outlook for the past one week even though the internet is quite okay.i use ms outlook
Answer Question
| January 11, 2005 4:31 AM
Development, Exchange, Networking
Learning VB.net or ASP
Hi, I know VB and made some applications by it now I wana switch to vb.net or asp,is it any free training resource step by step about vb.net or asp for beginers? Thank you. —– Regards Mahnaz
Answer Question
| January 10, 2005 7:27 AM
ASP, VB.NET
Hi, I know VB and made some applications by it now I wana switch to vb.net or asp,is it any free training resource step by step about vb.net or asp for beginers? Thank you. —– Regards Mahnaz
Answer Question
| January 10, 2005 7:27 AM
ASP, VB.NET
Multi-DataTable Joins
I need to join two (or more) DataTables in a SQL statement and fill a third DataTable with the resulting records, while disconnected from the databases that filled the first two DataTables. I have researched a dozen books and the online help, but can’t find any mention of this. Can it be done? Thanks
Answer Question
| January 9, 2005 11:42 AM
Development
I need to join two (or more) DataTables in a SQL statement and fill a third DataTable with the resulting records, while disconnected from the databases that filled the first two DataTables. I have researched a dozen books and the online help, but can’t find any mention of this. Can it be done? Thanks
Answer Question
| January 9, 2005 11:42 AM
Development
How to monitor and manage lan gateway from a helius router?
Hi Everyone, I am trying to filter/manage a gateway through a helius router for directway. We are running windows 2000 server with all xp clients, around 50 of them. We have active directory running with the domain controller handing out dns and dhcp to clients. All clients are pointing to the helius router for their [...]
Answer Question
| January 10, 2005 3:32 AM
Application software, Auditing, DataCenter, Integration/Connectivity, Linux, Networking Products, Routers, Security, Security management, Servers, System monitoring, System utilities, Unix, Windows 2000 Server, Windows client administration and maintenance, Windows XP
Hi Everyone, I am trying to filter/manage a gateway through a helius router for directway. We are running windows 2000 server with all xp clients, around 50 of them. We have active directory running with the domain controller handing out dns and dhcp to clients. All clients are pointing to the helius router for their [...]
Answer Question
| January 10, 2005 3:32 AM
Application software, Auditing, DataCenter, Integration/Connectivity, Linux, Networking Products, Routers, Security, Security management, Servers, System monitoring, System utilities, Unix, Windows 2000 Server, Windows client administration and maintenance, Windows XP
bar code label / advanced form design / printing solutions
We are shopping for a bar code label printing and advanced form design / printing solution that runs on or plays nicely with the AS/400. Main initiatives that are driving this purchase are inventory product labeling and VICs Bill of Lading. Vendors / products that are currently on our radar; JBM Systems OctoTools, Quadrant Software [...]
Answer Question
| January 10, 2005 9:24 AM
Application software, CIO, Development, Vendor support, Vendors
We are shopping for a bar code label printing and advanced form design / printing solution that runs on or plays nicely with the AS/400. Main initiatives that are driving this purchase are inventory product labeling and VICs Bill of Lading. Vendors / products that are currently on our radar; JBM Systems OctoTools, Quadrant Software [...]
Answer Question
| January 10, 2005 9:24 AM
Application software, CIO, Development, Vendor support, Vendors
Database choice for web application
I am building web applications, using ASP.NET, each of which must store/retrieve data to/from a set of central databases. I basically have a choice between using MS Access or SQL Server and could use some advice about which to go for or what criteria to apply. Bear in mind that there will be several databases [...]
Answer Question
| January 24, 2005 4:28 AM
Database Management Systems, DataCenter, Development, SQL Server, Web development tools, Web services
I am building web applications, using ASP.NET, each of which must store/retrieve data to/from a set of central databases. I basically have a choice between using MS Access or SQL Server and could use some advice about which to go for or what criteria to apply. Bear in mind that there will be several databases [...]
Answer Question
| January 24, 2005 4:28 AM
Database Management Systems, DataCenter, Development, SQL Server, Web development tools, Web services
VS.NET SETUP project for .NET Framework 1.0
I am building an application with a setup project to be installed on a machine with .NET F/W 1.0. My build machine is running VS.NET 2003, which uses .NET F/W 1.1. I can build the application project (specifiying that target machine has 1.0 OR 1.1) and hand-install it onto my target (.NET F/W 1.0) machine, [...]
Answer Question
| January 11, 2005 4:20 AM
C, VB.NET, Visual Basic
I am building an application with a setup project to be installed on a machine with .NET F/W 1.0. My build machine is running VS.NET 2003, which uses .NET F/W 1.1. I can build the application project (specifiying that target machine has 1.0 OR 1.1) and hand-install it onto my target (.NET F/W 1.0) machine, [...]
Answer Question
| January 11, 2005 4:20 AM
C, VB.NET, Visual Basic
