Skip to Content
0
Former Member
Aug 04, 2005 at 10:02 AM

Improve multiple SELECT

15 Views

Hi all,

in a FORM i've a multiple sequential SELECT like this :

  • Case 1

SELECT * FROM myTABLE INTO myZone WHERE XX = 'X4'.

  • Case 2

SELECT * FROM myTABLE INTO myZone WHERE XX = 'X3'.

  • Case 3

SELECT * FROM myTABLE INTO myZone WHERE XX = 'X2'.

  • Case 4

SELECT * FROM myTABLE INTO myZone WHERE XX = 'X1'.

It's just an sample ๐Ÿ˜‰ So, how can i do to improve this code ; i must use internal table or ?

Thanks so much