GeekHipster
asked on
Is there a Pervasive 9.6 equivalent of the %ROWTYPE in Oracle?
I can find very little on working with cursors in Pervasive. It seems as though if I want to read a record into a variable, it has to be 1 variable for every field. Is there some way of reading an entire row?
Also any small code snippits of working cursors in Pervasive would be muchly appreciated. The help file is very limited in this area.
Also any small code snippits of working cursors in Pervasive would be muchly appreciated. The help file is very limited in this area.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Don't ask me what kind of table has hundreds of columns. Wasn't my idea! :)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I just have to update rows in table B, with information from table A. I could do this in the application layer easily enough I know. I'd just like to reference an entire row somehow instead of having to store every field individually. I don't think I'm going to find what I'm looking for. Thanks for the help, it works like this in any case.
ASKER
Thanks.
Open in new window