Re: XP SP2 problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Jure" <kupus2_at_hi_tocka_htnet_tocka_hr@xxxxxxxxxxxx> wrote in
news:e5qara$8u3$1@xxxxxxxxxxxxxx:

"David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote in message
news:Xns97D68BB102B28f99a49ed1d0c49c5bbb2@xxxxxxxxxxxx
"Jure" <kupus2_at_hi_tocka_htnet_tocka_hr@xxxxxxxxxxxx> wrote in
news:e5ppb0$66$1@xxxxxxxxxxxxxx:

"David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote in
message news:Xns97D5AA71C8DD2f99a49ed1d0c49c5bbb2@xxxxxxxxxxxx
"Jure" <kupus2_at_hi_tocka_htnet_tocka_hr@xxxxxxxxxxxx> wrote
in news:e5n30v$ski$1@xxxxxxxxxxxxxx:

Rows addes on XP SP2 machine wont replicate to other
databases, they have nulls in s_Generation column.
Is there a cure for this?

Newly added rows should be generation 0.

Are you saying that when you manually add a record to a table
in datasheet view, the s_Generation column remains Null?

Sounds like a major corruption of some sort.

I solved the problem. I use ADO and server side cursor to write
changes in database and during this process I initialize
s_Generation column to null because this is a generic procedure
that copies values from my data storage to recordset. On
windows other than XP SP2 it works just fine but on XP SP2 null
value is actually written in database. I can only say to good
people in Microsoft: don't fix it if it's not broken :))))

I didn't know you could edit data in the s_Generation field. It's
a Jet replication field, and I thought was completely unavailable
for any manipulation at all.

No, I didn't edit it, I created a new row, passed null through ADO
as initial value (before calling Update method) and database
accepted it instead of putting zero. I did the same for other
replication fields (s_GUID and others) but they are initialized
correctly.

Why in the world would you do that?

I would surmise that they are just like Autonumber fields, but if
you want the values in them to be correct, why would you pass a Null
as the value? The fields will initialize themselves correctly if you
don't pass any value to be appended into that field, so why would
you be mucking around with inserting values that are of no concern
to you?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: XP SP2 problem
    ... other than XP SP2 it works just fine but on XP SP2 null value is ... actually written in database. ... I didn't know you could edit data in the s_Generation field. ... Jet replication field, and I thought was completely unavailable for ...
    (microsoft.public.access.replication)
  • Re: chances of getting error no 87, hr = 2147221000 (CO_E_DLLNOTFOUND on SQL CE 2.0)
    ... your database instead of CoCreating every 2 minutes. ... Open method for opening the connection to the database. ... This is the static routine to initialize the connection. ... | of such a static routine provides the alternate means to do the same. ...
    (microsoft.public.sqlserver.ce)
  • Re: abstract sub programs overriding
    ... persistent data type, where the necessary data is read from a database, ... then the parent initialize can be called last. ... propagate the exception outward). ... the compiler can determine at ...
    (comp.lang.ada)
  • Re: XP SP2 problem
    ... that copies values from my data storage to recordset. ... value is actually written in database. ... The fields will initialize themselves correctly if you ... AddNew and pass array with names of all the columns and array with all the ...
    (microsoft.public.access.replication)
  • Re: IAS Service doest start
    ... There seems to be something wrong with your database, ... > I sent a post in Feb 17, and was asked to send a trace. ... > retrieve the Service SDO for service: IAS... ... > GetServiceSDO- Could not initialize the SDO schema... ...
    (microsoft.public.internet.radius)