Hi Tim & Team,

I've got a number of screen all maintaining TABLES using DataSource /
Tables, nothing out of the ordinary.
All of the screens have an ADD and EDIT button and allow the user to
edit or ADD a new record. All very straight forward really.

Now one screen when I use the ADD button calls a simple line of code for
example:

CompanyTable->Insert();

But for some reason a new record is NOT inserted and infact it doesn't
even go into an insert mode it just stays on the last record selected in
the datagrid. All very strange, so I went through and compared the code
with many other screens and it's identical besides the table name. No
errors are shown it just doesn't insert.

Have you seen anything like this before? I've also upgraded to the
latest version and made no difference.

Cheers,

Phil.

"Phil Read" <phil@vizualweb.com> wrote in message
news:B50AA486-9517-490E-9FDB-4D6170DACE0B@news.elevatesoft.com...
> Hi Tim & Team,
>
> I've got a number of screen all maintaining TABLES using DataSource /
> Tables, nothing out of the ordinary.
> All of the screens have an ADD and EDIT button and allow the user to edit
> or ADD a new record. All very straight forward really.
>
> Now one screen when I use the ADD button calls a simple line of code for
> example:
>
> CompanyTable->Insert();
>
> But for some reason a new record is NOT inserted and infact it doesn't
> even go into an insert mode it just stays on the last record selected in
> the datagrid. All very strange, so I went through and compared the code
> with many other screens and it's identical besides the table name. No
> errors are shown it just doesn't insert.
>

Maybe it does. Is the grid / datasource pointing to this same table
component?

Robert

Phil,

<< But for some reason a new record is NOT inserted and infact it doesn't
even go into an insert mode it just stays on the last record selected in the
datagrid. All very strange, so I went through and compared the code with
many other screens and it's identical besides the table name. No errors are
shown it just doesn't insert. >>

Check your event handlers for that table and make sure that you aren't
causing a re-positioning or refresh for the same table.  Doing so will cause
the table to leave the dsInsert state and go back to the same record.

--
Tim Young
Elevate Software
www.elevatesoft.com

On 19/02/2010 3:57 AM, Tim Young [Elevate Software] wrote:
> Phil,
>
> <<  But for some reason a new record is NOT inserted and infact it doesn't
> even go into an insert mode it just stays on the last record selected in the
> datagrid. All very strange, so I went through and compared the code with
> many other screens and it's identical besides the table name. No errors are
> shown it just doesn't insert.>>
>
> Check your event handlers for that table and make sure that you aren't
> causing a re-positioning or refresh for the same table.  Doing so will cause
> the table to leave the dsInsert state and go back to the same record.
>

Hi, Just checked, there's no Events on either table or source and the
dbgrid and dbedits are all using the same datasource, the code to EDIT
works but code to INSERT just doesn't do anything.

I had more code under the Onclick of the ADD button, but removed it all
and just had:

CompanyTable->Insert();

But same thing happens. Really weird, even tried repairing the table.

Thanks,

Phil.

Phil,

<< Hi, Just checked, there's no Events on either table or source and the
dbgrid and dbedits are all using the same datasource, the code to EDIT works
but code to INSERT just doesn't do anything.

I had more code under the Onclick of the ADD button, but removed it all and
just had:

CompanyTable->Insert();

But same thing happens. Really weird, even tried repairing the table. >>

Did you try creating a sample project that reproduces this ?  That usually
helps point to the issue.  Also, if you want to send me the code that you're
using, I can take a look at it and tell you where the problem is.

--
Tim Young
Elevate Software
www.elevatesoft.com