• Runtime Error 3001 – Arguments are of the wrong type or out of acceptable range or are in conflict with one another

    Dear Sir, Thanks for your answer for my earlier questing. It solved my problem I am using VB6 as front end and Access as back end. I'm editing my table for particular field. I am editing rate of one item in RMmaster file. It's doing it, but I want to edit rate of same field which is in another...

    RajeshP20 pointsBadges:
  • Install SQL server client tools

    With client utilities like query browser, or query analyzer...how do I install on client workstations? I am not interested in installing a SQL server. I should just be able to query a SQL server and display some results from my laptop. Can anybody guide me? Well, if we have to buy any licenses we...

    Krblr200720 pointsBadges:
  • Can a Pivot table be created in Oracle 10g?

    I am running a stored procedure on ORACLE 10g that truncates and repopulates a table (tbl_A) that contains 2 columns; a list of unique codes and monetary amounts. The number of codes may vary weekly. I would like to create a second table(tbl_B) that contains a column for each of the names being...

    CAJ5 pointsBadges:
  • I want to select months from Jan to Dec using SQL query

    I want to select months from January to December using SQL query. I will use this for list item note:- without using PL/SQL and less union.

    44063860 pointsBadges:
  • Advantages of database system over file systems

    What are the advantages of database system over file systems?

    Michael Tidmarsh30,585 pointsBadges:
  • Using SUBSTR with interactive SQL

    I am trying to change part of a field using the substring command in interactive SQL. To do this I entered the following: UPDATE LIBRARY/FILE_NAME SET SUBSTR(FIELD_NAME1,194,4) = 'XXXXX' WHERE FIELD_NAME2 = 99999 I get the error token ( was not valid. Valid tokens: = .' Obviously there is a syntax...

    GHENDER190 pointsBadges:
  • DB2 Date function to convert number to Date

    In Cognos-Framework Manager there is a calculation in the DB2 section called "Date". Supposedly this field will change a numeric date "01012005" to an actual date "01/01/2005". But, we tried it and it does not work. Can you see if you can find anything that will allow us to create a calculated...

    Meenac0 pointsBadges:
  • ORA-06502: Character string buffer too small

    Hi guys, Here's my script I have created aggregate string function 'Tab_To_String' using this below script CREATE OR REPLACE TYPE t_varchar2_tab AS TABLE OF VARCHAR2(4000); CREATE OR REPLACE FUNCTION Tab_To_String (p_varchar2_tab IN t_varchar2_tab, p_delimiter IN VARCHAR2 DEFAULT ',') RETURN...

    Kruti123456789shah15 pointsBadges:
  • Capture a photo through webcam with Visual Basic 6

    I want to capture a photo by clicking a button in VB 6.0 through webcam and store it to a desired location. How can I do it?

    Hanny5 pointsBadges:
  • How to create a CSV file in PHP code?

    I need to create a physical CSV file from PHP code. I have many solutions to get the results to print to a screen, but I need a file... any ideas?

    Texmansru4725 pointsBadges:
  • Rollback command in SQL

    Suppose user x insert values into table t1,and then update the table t1. After then he wants to increase the size of column c1. Then he wants to rollback to update values. He can do this or not? If yes then what is the right procedure?

    10111986105 pointsBadges:
  • Passing parameters to report viewer

    Hi Kindly excuse me if I appear a bit ignorant on this subject as I am relatively new to SSRS. I have managed to create a report that has 3 parameters (ie. Start Date,End Date,Drop down list) which I have successfully deployed to Report Server. The report basically uses a stored procedure which has...

    Shaygen5 pointsBadges:
  • Mac address to IP address resolution

    How can we resolve IP address from Mac address and can we do this from Cisco switch 3750? We are able to track port no and associated Mac address from Cisco switch by using the command #sh mac-address-table dyanamic>, but we also want to track the associated IP address with port no. Please...

    Ruchitgarhwal0 pointsBadges:
  • Concentrate more than two fields together into one field in SQL

    Say I have 3 columns: 1st name, middle name and last name. How do I merge the 3 columns into one column yet separate the content with commas?

    Sammy545 pointsBadges:
  • USB External Hard drive and Windows XP

    I have two issues which are basically the same. I have an external USB hard drive that I connect to a computer running Windows XP. Windows USB driver recognizes the hard drive and shows the drive in Device Manager but Windows does not show the drive in Windows Explorer. A customer has a USB FLASH...

    Cestanley0 pointsBadges:
  • How to create our own set up file in VB 6.0

    Dear friends, I want to know how to create setup file of our project in VB 6.0. Wait...I know how to create setup file using package and deployment tool but I want to know how can I create a file in which we can include images, pictures, some animations. I mean setup file with our own ideas and...

    Rajevinayak0 pointsBadges:
  • SQL query – Unique item with latest date of entry

    Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number). There are multiples which show multiple entries for single itemN, for example. item 1 has three...

    SmurkyIS15 pointsBadges:
  • Difference between Web services and WCF

    What is the difference between WCF and Web Services in .NET? Why are we using WCF in place of WebServices?

    Dsschauhan5 pointsBadges:
  • Running a VBScript from a batch file

    Hi, I have a VB script that I want ran from a batch file. How do I go about this? See the VBscript below:Dim oFS : Set oFS = CreateObject( "Scripting.FileSystemObject" ) Dim sSrcDir : sSrcDir = "//serverNameFBSurvey" ' Source directory (remote server) Dim sDstDir : sDstDir = "c:SampleDir" & ""...

    Waizkode5 pointsBadges:
  • Oracle SQL and compare date

    Hello! I need help. I want to compare two dates and count how many days its between them. Example: 2006-09-22 and 2006-10-06 results: 14 days Hope for help. Thanks!

    MissNew0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following