Hello

I want to browse between cached records to avoids doubles values.
How can I do it?
I remember an article about working with CachedUpdates but I can't find it

Thanks Sorin

Hershcu,

<< I want to browse between cached records to avoids doubles values.  How can I do it? I remember an article about working with CachedUpdates but I can't find it >>

Could you give me a little more information on exactly what you're trying to do ?  I'm not entirely sure what you mean by "avoids double values".

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

Thanks

When I add records to a table that is in BeginCached mode
I want to check that I didn't add a value that exists already

Thanks Sorin

Hershcu,

<< When I add records to a table that is in BeginCached mode I want to check that I didn't add a value that exists already >>

A primary key is required for cached update usage (it uses the replication functionality internally), and that will also ensure that you cannot create two rows with the same primary key.

Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim

<<A primary key is required for cached update usage (it uses the replication functionality internally), and that will also ensure that you cannot create two rows with the same primary key.>>

I have a primary key but maybe I'll clarify my question with a simple scenario.
I have m/d data. I want to add a new record to the master table and some records to the detail table.
Since I want to save, commit all the new records on one instance I set the detail table on BeginCachedUpdates.
Now I want to check after every new record inserted on the detail table if the value exists on an other record between the cached records and show a error message.

I hope I clarify my problem
Thanks Sorin

Hershcu,

<< I have a primary key but maybe I'll clarify my question with a simple scenario. I have m/d data. I want to add a new record to the master table and some records to the detail table. Since I want to save, commit all the new records on one instance I set the detail table on BeginCachedUpdates. Now I want to check after every new record inserted on the detail table if the value exists on an other record between the cached records and show a error message. >>

I'm still not sure I understand.

Do you want to check for duplicate rows with only the cached rows, or with both the cached rows and any rows in the underlying table ?

Also, again, you cannot insert multiple rows with the same primary key in the cached detail table, so there isn't really any need to check anything.  You'll get a primary key exception if you try to insert a new row that has the same primary key, which (I think) is what you want.

Tim Young
Elevate Software
www.elevatesoft.com

Thanks

I want to check for duplicate rows only on the cached rows.
and I want to show a message error before the user try to save the row

Sorin

<< I have a primary key but maybe I'll clarify my question with a simple scenario. I have m/d data. I want to add a new record to the master table and some records to the detail table. Since I want to save, commit all the new records on one instance I set the detail table on BeginCachedUpdates. Now I want to check after every new record inserted on the detail table if the value exists on an other record between the cached records and show a error message. >>

I'm still not sure I understand.

Do you want to check for duplicate rows with only the cached rows, or with both the cached rows and any rows in the underlying table ?

Also, again, you cannot insert multiple rows with the same primary key in the cached detail table, so there isn't really any need to check anything.  You'll get a primary key exception if you try to insert a new row that has the same primary key, which (I think) is what you want.

Tim Young
Elevate Software
www.elevatesoft.com

Sorin,

I think I know what you mean... you want the ability to query the cached rows, as if it was a temporary table.
As far as I know there is no way to do that.
I do it myself in my applications using a temporary table for the detail rows, instead of cached updates, this way:

- On Edit -> Load all the detail rows to a temporary table
- On Cancel -> the temporary table is discarded
- On Post -> Previous detail rows in the database are replaced by those in the temporary table under a transaction

--
Fernando Dias
[Team Elevate]

<< I want to check for duplicate rows only on the cached rows. and I want to show a message error before the user try to save the row >>

Okay, but what constitutes a "duplicate row" ?  Is the primary key not sufficient for determining this ?

Tim Young
Elevate Software
www.elevatesoft.com

<<Okay, but what constitutes a "duplicate row" ?  Is the primary key not sufficient for determining this ?>>

On my case the column that link to the master table and an other column from the detail table are the primary key.
When I post a cached table with a duplicate primary key values it's raise an error.
And I want to raise an error before the user try to commit the cached data.

Is Fernando suggestion the only option?

Thanks Sorin