User Profile

Collapse

Profile Sidebar

Collapse
suexicano
suexicano
Last Activity: Nov 10 '11, 05:50 PM
Joined: Nov 10 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • suexicano
    started a topic Data type mismatch for Insert Query
    in C Sharp

    Data type mismatch for Insert Query

    Hi -

    Getting the famous Data type mismatch error with the following code. The CallComments is a Memo Data type ins Access 2007, and that is the data element causing the error.

    Code:
    this.Cursor = Cursors.WaitCursor;

OleDbCommand objCmd = new OleDbCommand("", conn);
objCmd.CommandText = "INSERT INTO LogTb (CallDate, PtLastName, PtFirstName, PtDOB, PtUniqueNo, PtPrimary, PtSecondary,
    ...
    See more | Go to post
    • suexicano
      replied to How to pull the most recent transaction based on entry date?
      in SQL Server
      Thank you for your response, but I forgot to mention that I wanted to pull the EntryDate, InvoiceNo, AND TransactionCode . I have tried the code below, but it pulls each record.

      Code:
      SELECT InvoiceNo, MAX(EntryDOS), TransactionCode
FROM DbTable
GROUP BY InvoiceNo, TransactionCode
      See more | Go to post

        Leave a comment:

      • suexicano
        started a topic How to pull the most recent transaction based on entry date?
        in SQL Server

        How to pull the most recent transaction based on entry date?

        Hi -

        Thanks for your help with this one.

        I have a table that records transactions for individual invoices, and I want to pull the most recent transaction based on the entry date. Using the example below, I want to write a SQL statement that would only pull records that have ID 3,4, and 9 (as those records have the most recent EntryDate for each individual Invoice). Here is an example of the transaction table:
        ...
        See more | Go to post
        • suexicano
          replied to Adding Item in listbox on parent form
          in C Sharp
          Thank you for the advice. I am a beginner and tips like that are valued from those who know better programming practises. I will have to figure out how to evoke the method in fchild orm once I close the child form
          See more | Go to post

            Leave a comment:

          • suexicano
            replied to Adding Item in listbox on parent form
            in C Sharp
            Thanks Ian for responding....

            Here is the condensed code within the child form....
            public partial class RaspadoForm : Form
            {
            Form1 m_parent = new Form1();

            private void EnterButton_Cli ck(object sender, EventArgs e)
            {
            conn.Open();
            SqlCommand InsertOrderDeta il = new SqlCommand("INS ERT INTO
            OrderDetailsTb (OrderID,...
            See more | Go to post

              Leave a comment:

            • suexicano
              started a topic Adding Item in listbox on parent form
              in C Sharp

              Adding Item in listbox on parent form

              Hi -

              I call a method (method is within the parent form) in the child form right before I close the child form. looks something like this:

              m_parent.GetOrd erDetailsFunc() ;
              this.Close();


              The method should add an items to a listbox located on the parent form, but it does not add the items. I had strategically placed a message box to make sure that the code...
              See more | Go to post
              No activity results to display
              Show More
              Working...