C#

VFPDAp.InsertCommand.CommandText = "insert into my_table1 (my_time,reminder) values(?, ?)";
VFPDAp.UpdateCommand.CommandText = "update my_table1 set my_time=?, reminder=? where reminder=? ";

SQL: Column 'Q0P2' is not found

Paramu1973 wrote:

"update my_table1 set my_time=?, reminder=? where reminder=? ";

Bastard Programmer from Hell
if you can't read my code, try converting it here[^]

copy /Y "$(TargetDir)$(ProjectName).dll" "$(SolutionDir)lib\$(ProjectName).dll"

copy /Y "$(ProjectDir)rdlcdir\*.rdlc" "$(SolutionDir)lib"

DaveyM69 wrote:

If you need the base class's method to be called as well, the inheriting class should call base.Function()

BaseLayer2 base2 = new Child1Layer2();

BaseLayer2 base2 = new Child2Layer2();

AmbiguousName wrote:

this works absolutely fine in C++.

using System;

public class BaseLayer1
{
  public virtual void Function()
  { Console.WriteLine("BL1"); }
}
 
public class ChildLayer1 : BaseLayer1
{
  
  BaseLayer2 base2 = new BaseLayer2();
 
  public override void Function()
  {
    Console.WriteLine("CL1"); 
    base2.Function(); // Reaches Here. should go to base class in layer2 as well.
  }
}

public class BaseLayer2
{
  public virtual void Function()
  {Console.WriteLine("BL2");}
}
 
public class Child1Layer2 : BaseLayer2		         // Child of BaseLayer2
{
  public override void Function()
  {Console.WriteLine("C1L2");}
}
 
public class Child2Layer2 : Child1Layer2		// Child of Child1Layer2
{
  public override void Function()
  {Console.WriteLine("C2L2");}
}

class Starter {
 public static void Main(){
  new ChildLayer1().Function();
 }
}

CL1
BL2

select  COUNT (Trans_id),ip.TNum, from dbo.Trans  t inner join  dbo.IWbook iw on t.IWork_ID = iw.IWork_ID inner  join dbo.IPack ip on ip.PID = iw.PID where ip.TNum = @parameter_value group by ip.TNum
 
The linq is the following:
 
var  varGoodTransCount = (from t in rData.Trans join iw in rData.Ibooks on t.Ibook_ID equals iw.Ibook_ID join ip in rData.IPacks on iw.PID equals ip.PID where ip.TNum == SPkgID group ip by ip.TNum into g select new { TNum = g.Key, Frequency = g.Count() }).FirstOrDefault();