Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #767
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Problem with VO- duplicate registers in sql server |
| Date | 2011-04-08 08:22 -0500 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <inn25l$ui4$1@speranza.aioe.org> (permalink) |
| References | <bdfa758b-f750-4484-b417-a7002c6a98c9@a26g2000vbo.googlegroups.com> <906hghFpceU1@mid.individual.net> <f3515e10-f5b1-421f-bc5e-d3e3bc73507c@p3g2000vbv.googlegroups.com> <9qbsp6tfvefmn08rjfeu9ijbb89tv9kek0@4ax.com> <623f0ac9-ab83-480d-85d5-8f83b8822f94@p3g2000vbv.googlegroups.com> |
Jose, While this is not a free solution, the quickest way to get a DBF application up and running in SQL is to buy Geoff's SQL classes. They do a really good job of shielding you from SQL but do not limit you to just DBF style coding. As you get more comfortable with SQL, you can start using proper selects which will speed up your program. I have used Geoff's classes and they work. Regards, Willie "JoseMaria" wrote in message news:623f0ac9-ab83-480d-85d5-8f83b8822f94@p3g2000vbv.googlegroups.com... Karl, And when do I issue a "select" ? I don't issue selects as I use the rdd version, I use dbseek( cKey ) to search for records and after that a "while .not. eof() + dbskip" loop. You mean every time I do a dbseek I refresh the information and can see all new data added ? Thanks Jose Maria On Apr 7, 11:45 pm, Karl Faller <k.faller_withoutth...@onlinehome.de> wrote: > JoseMaria>Does it mean that if one user appends a record to a table, the > other > >users in the network are not going to see that record until they close > >the database and use it again ? > > No - AFAIK the others will, as fast as your append/insert is written > through. But with a clientside cursor YOU are looking at a "snapshot" > of the db, taken at the moment you issued your select. So, this cursor > will not reflect any operations you perform later on that table - to > see them, you'll have to repeat the select statement. > > Beware, that others might correct me, as my knowlegde of these things > is rather limited ;-) > > Karl
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