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


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

Re: About vo sqlserver

From Franz Rachbauer <office@rachbauer.org>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: About vo sqlserver
Date 2016-03-08 15:20 +0100
Organization Aioe.org NNTP Server
Message-ID <nbmn3s$ngg$1@gioia.aioe.org> (permalink)
References <2add1070-2947-4af4-ba3d-a7675c63597f@googlegroups.com>

Show all headers | View raw


Found these solutions in web (untested):
SELECT ID AS LastID FROM Persons WHERE ID = @@Identity;
or
SELECT MAX(ID) AS LastID FROM Persons
or
SELECT IDENT_CURRENT(‘MyTable’)

Please try which one meets your need.
Regards, Franz

Am 08.03.2016 um 14:50 schrieb jorgeaccinelli@dextrasistemas.com.ar:
> Hello everyone
>
> A specific issue on vo28 - vo2ado SQL Server .... A procedure performs a series of steps and one of them is to get the last ID of a table ... ...
>
>  From my vo app
> ( Program that invoked the sp )
>   i woluld like to get this last ID ...
>
> But how ?
> Some ilustrative fragment ?
>
> Thanks
> Jorge Accinelli
> Buenos Aires
>

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


Thread

About vo sqlserver jorgeaccinelli@dextrasistemas.com.ar - 2016-03-08 05:50 -0800
  Re: About vo sqlserver Franz Rachbauer <office@rachbauer.org> - 2016-03-08 15:20 +0100
  Re: About vo sqlserver jorgeaccinelli@dextrasistemas.com.ar - 2016-03-08 06:53 -0800
    Re: About vo sqlserver kormondi@kotech.hu - 2016-03-08 11:00 -0800
  Re: About vo sqlserver ingenierialym@gmail.com - 2016-03-08 13:16 -0800
  Re: About vo sqlserver jorgeaccinelli@dextrasistemas.com.ar - 2016-03-09 04:19 -0800

csiph-web