The problem is the IS_NULL functions that I pointed you towards. I didn’t release the data types in the prior post. You can’t have a blank value in a field which is a numeric data type (of which the money data type is one). Try changing the IS_NULL functions to this. <pre>SELECT DISTINCT oas_balance.cmpcode, oas_balance.el1, [...]
View Answer | August 14, 2008 6:56 AM
Implicit Conversion Error, SQL
Yes, you can setup a linked server from the SQL Server to the Access database. However when doing this, do remember that it is an Access database and performance will not be very good. If you open books online and look under “linked servers [SQL Server], Access databases” you’ll see a page specifically talking about [...]
View Answer | August 13, 2008 1:22 AM
Access Database, Microsoft Access, SQL, SQL Server 2000
I’m seeing a couple of issues here. First, I don’t see you closing your case statements. <pre>SELECT DISTINCT … CASE WHEN balcode = ‘ACTUAL’ AND yr = 2008 AND period = 6 THEN full_value END AS Act_Amt, …</pre> Now if the full_value has a NULL value in it, it’s a little easier to work with. [...]
View Answer | August 13, 2008 1:18 AM
CASE statement, SQL, SQL Query
Use CPYTOIMPF and point the target to the windows server /QNTC/myserver/myshare/myfile.csv
View Answer | August 12, 2008 5:48 PM
AS/400 import/export, CL, CSV format
Make sure that the “Allow Additions” form property is not set to No for some reason.
View Answer | August 12, 2008 2:50 PM
Access forms, Database programming, Microsoft Access
That isn’t going to work as written. The output of a CASE statement has to be a single value, but for it to work for the IN, each letter has to be a seperate value. I’d recommend setting up a joining table between the e.emp_status and c.com_inactive_flag columns so that you can find the matches [...]
View Answer | August 11, 2008 8:52 PM
CASE statement, SQL
If several users are simply running <a href=”http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-the-select-statement/”>SELECT</a> statements against the same table and getting locked up then you may need to look at your indexes. They probably aren’t setup correctly. In addition you may want to change your SELECT statements to use the WITH (NOLOCK) hint. This will prevent the SELECT statements from taking [...]
View Answer | August 11, 2008 4:08 PM
Database performance and tuning, SQL Server 2000, SQL Server database, Windows Server 2003
Not a “Final Answer”, more of a places to check list: Here’s a few resources that should help with your problem. OpenOffice Basic Programming Guide Programming OpenOffice with Visual Basic If these do not seem to help, Open Office has it’s own version of basic as well.
View Answer | May 14, 2013 1:27 PM
Database connectivity, OpenOffice Base, Visual Basic
Hi, You could try using the DIGITS function to convert a character field to numeric. I’m not sure whether this would work with Query Management. Regards, Martin Gilbert.
View Answer | August 11, 2008 12:16 PM
Query Management Facility
View Answer | August 11, 2008 12:03 PM
Hi Rinsa, Pls go through this <a href=”http://www.microsoft.com/learning/mcp/mcse/windows2003/default.mspx”> MCSE on Windows Server 2003 Certification Requirements </a> from Microsoft. Which will guide u what exams u need to complete. Thanks & Regards, Vlvpk
View Answer | August 10, 2008 1:13 AM
Career development, CCNA, Certifications, Cisco certifications, IT careers, MCSE, Microsoft certifications, Networking certifications
I Think if you know the complete data structure write new utility to print the additional new reports.If you run separte compiler files(fxp) from menu select any one which is not used.Make same name program creating sub-menu for new reports. Like this you can add as many as you want. email@example.com There are two ways: [...]
View Answer | August 9, 2008 8:06 AM
Database, FoxDent, FoxPro, FoxPro 2.6, HIPAA, Printing
Not as far as I know of.
View Answer | August 8, 2008 9:43 PM
BLOB, CLOB, Data Transformation Services, DTS
The EASIEST is to simply build forms, reports, etc. with in the Access 2003 database and make it an MDE file so that users can’t modify the forms and reports. I would have the application mdb link to the data mdb. You could also build web forms in Access 2003 if you want.
View Answer | August 8, 2008 1:56 PM
Access 2003, Microsoft Access
If the items are stored as rows in a table with a date, you could do this in a query: Select Item, Sum(IIf(DateDiff(“d”,[ItemDate],Now()) Between 1 And 15,1,0)) AS 0to15, Sum(IIf(DateDiff(“d”,[ItemDate],Now()) Between 16 And 30,1,0)) AS 16to30…… From Table Group By Item.
View Answer | August 8, 2008 1:52 PM
Access 2000, Microsoft Access
I feel Switch will be more optimized rather than using nested If… Endif…
View Answer | August 8, 2008 6:01 AM
CASE statement, IF ELSE statement, VB.NET, Visual Basic 2005
Have you heard of <b>LinkedIn.com</b>. It is an international professional’s network site, so ideally you can post your detailed requirement there and most probably you should get response.
View Answer | August 8, 2008 5:57 AM
Career development, IT careers, IT jobs
Cursor expressions (sometimes known as cursor subqueries) are an element of the SQL language (earlier) and now of the PL/SQL too. A cursor expression can be used as an actual parameter to a PL/SQL procedure or function, which has great significance in connection with table. It can also be used functions in the SELECT statement [...]
View Answer | August 7, 2008 5:25 AM
Cursor Table, PL/SQL Table
As of now if we see in IT field, you are a raw or fresh hand with no practical knowledge. Yes, you can go for ABAP, as it has ample growth scope but it all depends on your taste, choice and calibre. First of all you have to locate an authorized centre where you can [...]
View Answer | August 7, 2008 5:09 AM
ABAP, IT careers
THIS IS NOT A BAD CHOICE ON THE CHEAP CP1-AM2-6400A MADE BY amd.Though depending on what the server is being used for.If you are working for or own the company.Depending on how much growth your company might predict in the future <a href=”http://www.intel.com/products/processor/xeon7000/index.htm?iid=technology_quadcore_index+body_xeon7000″>dual/quad xeon</a> (http://www.intel.com/products/processor/xeon7000/index.htm?iid=technology_quadcore_index+body_xeon7000)might be the best way to go.Dont let possible enviroment of [...]
View Answer | August 7, 2008 4:50 AM
Database design, SQL Server 2005, SQL Server performance