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


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

Re: VO2ADO - MSSQL 2008 - SELECT/UPDATE/... spooky

From Malcolm G <malcolm-news2012delete@delete.jobstream.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: VO2ADO - MSSQL 2008 - SELECT/UPDATE/... spooky
References <e08bf7ae-8fa1-44d3-b7de-04b64dff7b36@googlegroups.com>
Message-ID <UmMnt.48257$LC7.45593@fx06.am4> (permalink)
Organization virginmedia.com
Date 2013-05-24 17:15 +0100

Show all headers | View raw


> My User test function. This function gives always a 0 (zero) for RecordCount. Even for SELECT * FROM SYS_Users, but not when I do a SELECT * FROM SYS__Versie.

interesting (I would expect you to get -1 some of the time
but zero is a surprise)

http://msdn.microsoft.com/en-us/library/windows/desktop/ms676701%28v=vs.85%29.aspx

The cursor type of the Recordset object affects whether the number of
records can be determined. The RecordCount property will return -1 for a
forward-only cursor; the actual count for a static or keyset cursor; and
either -1 or the actual count for a dynamic cursor, depending on the
data source.

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


Thread

VO2ADO - MSSQL 2008 - SELECT/UPDATE/... spooky Frans Wauters <info@wautersit.com> - 2013-05-24 07:28 -0700
  Re: VO2ADO - MSSQL 2008 - SELECT/UPDATE/... spooky "andrej Terkaj" <aterkaj@task.si> - 2013-05-24 16:53 +0200
  Re: VO2ADO - MSSQL 2008 - SELECT/UPDATE/... spooky Malcolm G <malcolm-news2012delete@delete.jobstream.com> - 2013-05-24 17:15 +0100
    Re: VO2ADO - MSSQL 2008 - SELECT/UPDATE/... spooky Frans Wauters <info@wautersit.com> - 2013-05-24 09:27 -0700
  Re: VO2ADO - MSSQL 2008 - SELECT/UPDATE/... spooky Frans Wauters <info@wautersit.com> - 2013-05-24 09:17 -0700

csiph-web