Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #744

Re: Problem with VO- duplicate registers in sql server

From E®!k \\/!$$E® <nospam@nospam.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Problem with VO- duplicate registers in sql server
Date 2011-04-07 21:27 +0200
Message-ID <906hghFpceU1@mid.individual.net> (permalink)
References <bdfa758b-f750-4484-b417-a7002c6a98c9@a26g2000vbo.googlegroups.com>

Show all headers | View raw


JoseMaria,

In addition of what Meinhard wrote:
The Vo2Ado RDD is not showing you the new added record after an append if 
you have a ClientSide cursor.
This can be solved with a serverside cursor, but that will slow down the 
whole thing dramaticly.
My suggestion will be not using the VO2ADO.RDD at all. You do not take full 
advantage of SqlServer if you use it like a DBF table.
You best use the AdoServer class for data attached to a form, or use your 
own scatter/gather.

I always use a AdoCommand with an Insert command to add records to a table 
and retrieve the PrimaryKey value of the new row with SELECT @@IDENTITY

hth

Erik


"JoseMaria"  wrote in message 
news:bdfa758b-f750-4484-b417-a7002c6a98c9@a26g2000vbo.googlegroups.com...

using VO 2.8 sp3 and RDD version of VO2ADO to access SQL server 2008
R2 express:

I have noticed that whenever there are in one table duplicate records
(2 or 3 records with exactly the same information) and I try to delete/
update/insert records to this table I have sometimes problems with
strange crashes in my application.

Is there any easy solution to this problem ?

Is it possible to add one column to each table with a numeric value
that is automatically informed with a different value each time I
insert a record ? I have tried adding column uniqueidentifier to a
table but it is populated with nulls, not values.

Thanks for your help. 

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Problem with VO- duplicate registers in sql server JoseMaria <jmespinosabaviera@yahoo.com> - 2011-04-07 02:48 -0700
  Re: Problem with VO- duplicate registers in sql server Meinhard Schnoor-Matriciani <msm@appfact.de> - 2011-04-07 13:46 +0200
  Re: Problem with VO- duplicate registers in sql server E®!k \\/!$$E® <nospam@nospam.com> - 2011-04-07 21:27 +0200
    Re: Problem with VO- duplicate registers in sql server JoseMaria <jmespinosabaviera@yahoo.com> - 2011-04-07 14:24 -0700
      Re: Problem with VO- duplicate registers in sql server Karl Faller <k.faller_withoutthat_@onlinehome.de> - 2011-04-07 23:45 +0200
        Re: Problem with VO- duplicate registers in sql server JoseMaria <jmespinosabaviera@yahoo.com> - 2011-04-07 14:54 -0700
          Re: Problem with VO- duplicate registers in sql server "Willie Moore" <williem@wmconsulting.com> - 2011-04-08 08:22 -0500
            Re: Problem with VO- duplicate registers in sql server JoseMaria <jmespinosabaviera@yahoo.com> - 2011-04-08 11:46 -0700
              Re: Problem with VO- duplicate registers in sql server "Willie Moore" <williem@wmconsulting.com> - 2011-04-08 14:46 -0500
      Re: Problem with VO- duplicate registers in sql server "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-04-07 22:25 +0000

csiph-web