Re: TADODataset does not want to post records


hmmmm, the TADODataset was in ltBatchOptimistic and I did not update the batch...

"Johan" <johanvw@xxxxxxxxxxxxxx> wrote:

I'm having problems with a particular TADODataset which does not want to "Post" records to the database (SQL Server 2000).

It has a select statement which extract 21 fields from a table and from some parameters. There are onnew, beforeopen, beforepost and afterpost events. No fancy stuff. Integers, chars and money fields. In the beforepost event it does some calculations and set the fields.

The dataset extracts and display the data if I do a manual insert, but does not want to post it. I've tried all kinds of stuff to get this thing workin, but alas... here I am, begging for help.

P.S. I've inherited this program...

.

Relevant Pages

  • Re: Excel Calculation issues
    ... Hmmmm. ... VB Format() does the right thing with 40179.00440002. ... I suspect the latter because of the similarities that I see in examples that have different results. ... a number like 30000.098 will display ok. ...
    (microsoft.public.excel)
  • Re: Accessing A Large MS SQL Table Over ADO Components
    ... >An avarage table will be holding around 1000000 records in our application. ... >If we want to display the data on a readonly grid wich component is the best ... They essentially do the same thing but TadoDataset has properties that are a bit ... on your SQL server the severside cursors can perform better. ...
    (borland.public.delphi.database.ado)
  • TADODataset does not want to post records
    ... The dataset extracts and display the data if I do a manual insert, but does not want to post it. ... I've tried all kinds of stuff to get this thing workin, but alas... ... here I am, begging for help. ...
    (borland.public.delphi.database.ado)