Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sunnydreams

    VB 6 code for pulling records .

    Thx for the update, My first database(Table1) is in the QA server and the Second one (Table2)in the Development Server.I want to pull teh records from QA to development so that we can rerun that once ina month. Can u Pls explain abt the DTS package u have mentioned..Will that solve this prob? I...
  2. sunnydreams

    VB 6 code for pulling records .

    I have the records in a database( Table 1) .Now I want to write code, to pull those data from Table1 to different database(Table 2) which is on a different Server and should run that (Table2) code every month.ie.it has to be rerun. Can anyone of u Pls help me with this code. I use Microsoft Sql...
  3. sunnydreams

    error msg '80040e14' ----Urgent help!!

    Hi all--- We are working with Microsoft SQL Server and when we try to insert a record into a table called 'employee salary', we get the following errormessage: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY...
  4. sunnydreams

    VB 6 - If Condition Statement not working as desired

    Software Used: VB 6 Database: SQL Server PROBLEM DESC: I have the following code as an example: (This code needs to work in a generic scenario also, I have just taken some example here like "Employeeid =123", but in general any Employeeid should work and cannot be hard coded) If szSenderID =...
  5. sunnydreams

    Table with If Condition

    VB 6 Code: If szSenderID = "sss" And dict_L11.Item("employeeIdQualifier") = "zz" And IsNumeric(Left(dict_L11.Item("employeeId"), 1)) = True Then dict_L11.Item("employeeId") = "AB" & dict_L11.Item("employeeId") The result for this Code is IF Employeeid= 123 it gives result as "AB123" if...

Part and Inventory Search

Back
Top