SELECTSTRUCT

jsingh

Member
I am hoping that someone would be able to tell me how to fill in the select structure. I have figured out what the structure is made up of and what enum values are valid, but besides that I do not have any documentation as to how to make use of it and how to set it up.

I want to get results from F5612071 table. The select is
select deaa05, demcu, deev01
from F5612071
where demcu = 'value' and
deev01 = 'value'

This will return couple of rows which I want to itereate through.

Thanks in Advance

Jay
 

Lightning_McQueen

Active Member
Hi Jay,

This is how you do your select:

F5612071.select
CostCenter = value
EverestPoint01 = value
//
F5612071.FetchNext
aa05 -> Variable1
//
While SV File IO Status is equal to CO SUCCESS
//
//Do whatever you need to do with the record
//
F5612071.FetchNext
aa05 -> Variable1
//
End While

Hope this helps. Good luck.

---------------------
Nick Brodeur
Network Administrator
Stelfast Inc.
Atlanta, GA
 

Zoltan_Gyimesi

Legendary Poster
Hi Jay,

It isn't clear what is your problem really (at least for me). Could you de[censored] it a bit more detailed.

On the other hand, it seems so that your F5612071 table is a custom one of yours which does not known for us on the List/Forum. Further what do you mean "enum values".

Please, help us to help you.

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

jsingh

Member
I meant by declaring a SELECTSTRUCT variable when used within a business function.

I did go through couple of other business functions, and found how one could set up a where clause but there was one thing that I noticed and that was the DBREF item2 was not populated and the values were set to " ".

Is item2 for some future use or something else ???


Thanks

Jay Singh
 
Top