ADOQuery\BatchUpdate

From: Jeff (jbarr62307_at_worldnet.att.net)
Date: 10/31/03

  • Next message: Vincent Choy: "who connect to Access" 
    Date: Thu, 30 Oct 2003 17:40:07 -0600

    I am using Delphi 7 and SQL Server 2000. I have an ADOQuery that has 2
    dummy fields created with the SQL for the query(select *, InvNo as Qty,
    Name as RecordStatus). We use these fields to store temporary
    information for background processing. When the records get posted to
    the table as a batch, I get an error that the InvNo field name is in the
    list twice. Is there a way to add dummy fields at runtime and remove
    them before updating the table?

    TIA

  • Next message: Vincent Choy: "who connect to Access"