How to get current value in SQL SELECT from buffered table? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to get current value in SQL SELECT from buffered table?

Message

From

26/04/2000 02:45:24

Borislav Borissov
Microcomplex
Sofia, Bulgaria

To

All

General information

Forum:

Visual FoxPro

Category:

Coding, syntax & commands

Title:

How to get current value in SQL SELECT from buffered table?

Miscellaneous

Thread ID:

00363464

Message ID:

00363464

Views:

44

I have Buffered table and want to create SQL cursor with current value from it. But when I try:

SELECT CURVAL("MyField","MyBuffTable") FROM MyBuffTable INTO CURSOR MyCursor

but I receive a cursor with number of records as MyBuffTable but with the same value in every record.

TIA

Boris

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

Click here to load this message in the networking platform