Search Result

Collapse
10 results in 0.0040 seconds.
Keywords
Members
Tags
insert into
  •  
  • isaace
    started a topic Sql - insert into
    in Access

    Sql - insert into

    I have an sql statement which I was hoping someone may be able to help me with. I'm getting the following errors:
    1 - runtime error 3346 (Number of query values and destination values are not the same
    2 - Runtime Error 3075 syntax

    Code:
    strSql = "INSERT INTO tblConversation ( " & _
                "RecordID, LeadID, Conversation, Subject, DateEntered, ContactDate, ContactTime, FollowUpDate
    ...
    See more | Go to post
    • moonlighting
      started a topic Help with runtime error due to incorrect VBA SQL statement syntax
      in Access

      Help with runtime error due to incorrect VBA SQL statement syntax

      Hoping an expert can help me fix an error that I'm getting while trying to execute an SQL statement in Access Visual Basic.

      Please note I have limited programming knowledge.

      Here's the background of my problem:

      I'm trying to create a list of the last ten records visited by the database user. As a record is visited, I want to capture in another table its [Docket_ID], a field that is located on a subform...
      See more | Go to post
      • Elite Hunter
        started a topic INSERT INTO EXCEPT doesn´t work
        in SQL Server

        INSERT INTO EXCEPT doesn´t work

        I have this statement:

        Code:
        INSERT INTO LlamadasRecompra (CodigoCompra, ClaveVive, Paciente, Status, Tel1, Tel2,
 Cel, Presentacion, Dosis, Compras, Medico,
 FechaUC, FechaCargaReceta, Receta)
(SELECT COD_COMPRA AS CodigoCompra, CLAVE_V AS ClaveVive, PACIENTE AS Paciente, STATUS AS Status, TEL1 AS Tel1, TEL2 AS Tel2,
 CEL AS Cel, PRESENTACION_UC AS Presentacion, DOSIS_DIARIA_VIVE AS Dosis, COMPRAS AS
        ...
        See more | Go to post
        • Joshua Grow
          started a topic SQL to Access insert into statement
          in .NET

          SQL to Access insert into statement

          Ok, so I am getting the following error when I run the code at the bottom of this page. I am using Visual Studio 2010 Professional, Access 2000 .mdb database. Any suggestions on why this doesn't work would be great!

          Error:

          System.Data.Ole Db.OleDbExcepti on (0x80040E14): Syntax error in INSERT INTO statement.
          at System.Data.Ole Db.OleDbCommand .ExecuteCommand TextErrorHandli ng(OleDbHResult hr)
          at System.Data.Ole Db.OleDbCommand .ExecuteCommand TextForSingleRe sult(tagDBPARAM S...
          See more | Go to post
          • Alex Dransfield
            started a topic How do I INSERT the values of variables into an Access table using SQL?
            in Access

            How do I INSERT the values of variables into an Access table using SQL?

            I am trying to record certain incidents in my C# program, such as a user logging in or accessing the database.

            I am attempting to use something like

            Code:
            OleDbCommand writeLogs = new OleDbCommand("INSERT INTO [LOG] (username, firstName, lastName, logDetails) VALUES (user, fName, lName, details);", connection);
            but I get the error that "No value was given for one or more required parameters"....
            See more | Go to post
            • luke noob
              started a topic How can i make this code 100% sql injection prove?
              in PHP

              How can i make this code 100% sql injection prove?

              [code=php]
              require 'database.php';
              require 'functions.php' ;


              if(isset($_POST['submit'])) {

              $firstname = addslashes(ucwo rds(strtolower( $_POST['firstname'])));
              $lastname = addslashes(ucwo rds(strtolower( $_POST['lastname'])));
              $emailaddress = addslashes($_PO ST['emailaddress']);
              $sex = addslashes($_PO ST['sex']);
              $dateofbirth = addslashes($_PO ST['dateofbirth']);...
              See more | Go to post
              • matt753
                started a topic Problem with SQL statement using CurrentDb.Execute
                in Access

                Problem with SQL statement using CurrentDb.Execute

                Can anyone tell me whats wrong with this SQL statement?

                Code:
                CurrentDb.Execute("INSERT INTO Joblist2Data (ID, DayUsed, Employee, Priority, Item, Task, Comments, Complete) VALUES (" & Null & ", #" & 5 / 27 / 10 & "#, " & cmbTechnician.Value & ", " & Null & ", " & Null & ", " & txtOrderID.Value & ", " & comments &
                ...
                See more | Go to post
                • embza
                  started a topic Inserting binary data types
                  in Oracle

                  Inserting binary data types

                  currently i have developed a C# application that makes ready structured variables holding binary values to be written into oracle database. The values to be inserted are different. some of them are as small as 1bit, 2bits, 3bit ....8bit, 2bytes,
                  and the others are as large as 8,000 bytes and some may be 4Gigs larger.
                  what data types should I use to store these values in my oracle10g database tables. Considering all the values are to...
                  See more | Go to post
                  Last edited by debasisdas; Dec 2 '09, 04:56 AM. Reason: snipped mail id.
                  • AlRojo
                    started a topic Why does my INSERT INTO code not work?
                    in Access

                    Why does my INSERT INTO code not work?

                    First, apologies for all the code; I'm not sure what is most relevant to my problem.

                    I am trying to use the code below to select Records from an Access table called [Client_Details] and insert them into another table (in the same database) called [ClientMailMerge Selection]. Once there I will then run a mail merge operation.

                    The problem is, no Records are being inserted and no error message is ever displayed.
                    ...
                    See more | Go to post
                    • questionit
                      started a topic insert into - add multiple values in a column
                      in SQL Server

                      insert into - add multiple values in a column

                      Hi

                      How do i write multiple values in a single column, using INSERT INTO

                      I have a listbox and i want all the selected values from that listbox inserted into a table column

                      INSERT INTO Orders(OrderID, Items) VALUES ____?????______ __

                      Do i need to run the above statement in a loop?

                      Thanks
                      qi
                      See more | Go to post
                      Previous template Next
                      Working...