Inserting a row above the current row

See also questions close to this topic

• Insert problem in a Filemaker datetime field

  I need to enter a value in a Filemaker table, in a field that should be DATETIME or TIMESTAMP.I do not know Filemaker at all, but I do this simple query

  INSERT INTO RadioGestInterface (Data_Ora_Prestazione) VALUES ('2019-02-14 11:13:11')
  

  But I always get this error: ERROR [HY000] [FileMaker][FileMaker] FQL0013/(1:62): Incompatible types in assignment. Where am I wrong?
• Postgres UPSERT Modify Conflict then Insert Record

  I'm struggling with building an UPSERT script that on conflict (1) modifies the existing record to avoid a conflict and then (2) inserts the new record. I am trying to build a table that maintains point in time fidelity while conserving space. The theory being that it is more efficient to properly capture the change in data as opposed to capturing duplicate slices of data that doesn't change.

  I have built an example to help point out what I am trying to do. There are three race car drivers that are at a certain track for a certain period of time. One of the drivers decides to change tracks while the other two decide to stay where they are. At some later point in time, a fourth driver enters the picture.

  I would like to be able to query the table and say "who was at what track on this day?"

  Hopefully this makes sense.

  Thanks in advance.

  ----------------------Set up an example table
  create table drivers(
  firstName varchar(30)
  ,lastName varchar(30)
  ,raceTrack varchar(30)
  ,effectiveDate date 
  ,expirationDate date
  );
  
  insert into drivers
  select 'ricky', 'bobby', 'talladega', cast('2019-01-01' as date), cast('9999-12-31' as date)
  union
  select 'cal', 'naughton', 'martinsville', cast('2019-01-01' as date), cast('9999-12-31' as date)
  union
  select 'jean', 'girard', 'daytona', cast('2019-01-01' as date), cast('9999-12-31' as date);
  
  ----------------------Expire the daytona record for Jean
  ----This is the UPDATE portion of the UPSERT and triggers a conflict with the UPSERT since firstname and lastname match. 
  update drivers set expirationdate = cast('2019-02-10' as date)
  where firstname = 'jean' and lastname = 'girard';
  
  ----------------------Insert new circuit de monaco record for Jean
  ----This is the INSERT portion of the UPSERT
  insert into drivers
  select 'jean', 'girard', 'circuit de monaco', cast('2019-02-11' as date), cast('9999-12-31' as date);
  
  ----------------------A new driver comes into the data
  ----This is an example of the expected behavior without a conflict
  insert into drivers
  select 'reese', 'bobby', 'greenville pickens', cast('2019-02-12' as date), cast('9999-12-31' as date);
  
  ----------------------Query all of the driver and track records for some day in January 2019
  
  select * 
  from drivers
  where cast('2019-01-11' as date) between effectivedate and expirationdate;
  
  ----------------------Query all of the driver and track records for some day in February 2019
  
  select * 
  from drivers
  where cast('2019-02-11' as date) between effectivedate and expirationdate;
  
  select * 
  from drivers
  where cast('2019-02-12' as date) between effectivedate and expirationdate;
  
• How to automatically insert a copied row after a specific value in a cell with VBA

  I have a table that contains a set of bundles that have to be broken down into their components. For this I'm looking for VBA instructions that will copy any row that contains the tag "-edubnd" at the end of the 'sku' cell (please see table bellow for example) twice underneath itself.

  It might be easier to ignore the tag component and use a specific set of values that the code looks for, that's also possible as the values marked as bundles are always the same in the column. What I mean is, instead of looking for the -edubnd tag, the code just looks for a specific value in that column,

  I have created a sample table below that is similar-enough to my table in excel that it should serve to illustrate the question.

  I'm currently filtering out the dataset, copying it into a different excel document, then running this:

  Sub insertrows()
      Dim I As Long
      Dim xCount As Integer
  
  LableNumber:
      xCount = 2
      For I = Range("A" & Rows.CountLarge).End(xlUp).Row To 1 Step -1
          Rows(I).Copy
          Rows(I).Resize(xCount).Insert
      Next
      Application.CutCopyMode = False
  End Sub
  

  Current table:

  column1   |    column2    |  column3 |  column3
  ----------------------------------------------
    A       |      pear     |  blue    |  10
    A       |      apple    |  orange  |  50
    A       |      orange   |  yellow  |  30
    A       |      kiwi     |  yellow  |  20
    A       | orange-edubnd |  blue    |  100
    A       |      apple    |  green   |  10
    A       |  pear-edubnd  |  green   |  50
    A       |      mango    |  pink    |  60
  

  Desired table

  Note: the copied row after each distinct column2 with the -edubnd tag

   column1   |    column2    |  column3 |  column3
  ----------------------------------------------
    A       |      pear     |  blue    |  10
    A       |      apple    |  orange  |  50
    A       |      orange   |  yellow  |  30
    A       |      kiwi     |  yellow  |  20
    A       | orange-edubnd |  blue    |  100
    A       | orange-edubnd |  blue    |  100
    A       | orange-edubnd |  blue    |  100
    A       |      apple    |  green   |  10
    A       |  pear-edubnd  |  green   |  50
    A       |  pear-edubnd  |  green   |  50
    A       |  pear-edubnd  |  green   |  50
    A       |      mango    |  pink    |  60