Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to get the current value from a transactional table
Message
From
24/09/2001 15:58:35
Sorin Varzaru
Nyl Benefit Services
Westwood, Massachusetts, United States
 
 
To
24/09/2001 15:34:26
Lee Hak Keun
Cyberguild
Pusan, Korea
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: How to get the current value from a transactional table
Miscellaneous
Thread ID:
00560054
Message ID:
00560181
Views:
20
Unfortunately this is illegal in SQL server and as
mentioned, unreliable. Thank you though.

>lcTarget=SYS(2015)
>select person,date,code,value ;
> from (lcTarget) ;
> group by person,code into (lcTarget) order by person,code
>
Previous
Reply
Map
View

Click here to load this message in the networking platform