Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #744
| 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> |
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
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