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


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

Re: Problem with VO- duplicate registers in sql server

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>

Show all headers | View raw


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


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