grumbel, where is the wishlist if you need one: "How to get the current profile" | Uniface 9 | Forum

Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

—  Results per page  —








— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters
For a group of consecutive words like 'end of support' use Match phrase

sp_Feed Topic RSS sp_TopicIcon
grumbel, where is the wishlist if you need one: "How to get the current profile"
30 May 2018
2:23 pm
Avatar
istiller
Member
Forum Posts: 251
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Hi freaks

A simple task:
To get the current profile of an unfetch row in a generic way

Problem:
If one use a database field as a right-hand-side-expression, UnifAce tries to fetch the row.
If this happens outside a READ-trigger: No useable values (as the are already the fetched one ),  but no crash
If you want to do this in READ-trigger before the READ: Stack overflow->Crash

So how to implement – for debugging purpose – a simple output of the profile that a user typed in?
$ioprint will also give you some hints, but not end-user friendly and no chance for further processing

@UnifAce
  a) where is the promise whishlist?
  b) how to get the current profile?

Ingo

30 May 2018
5:03 pm
Avatar
Adrian Gosbell
Amsterdam, seat 77a of a Boeing 747
Admin
Forum Posts: 317
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

istiller said
@UnifAce
  a) where is the promise whishlist?

Work in progress, the replacement to ‘this version’ of Uniface.info is being finalised. It is not ‘far away’. 

30 May 2018
9:08 pm
Avatar
Knut
Member
Forum Posts: 211
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Ingo,

putlistitems/occ in a “retrieve” trigger?

Knut

01 Jun 2018
8:15 am
Avatar
istiller
Member
Forum Posts: 251
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Knut said
Ingo,

putlistitems/occ in a “retrieve” trigger?

Knut  

Hi Knut

That was my first choise to get the profile.
But unfortunately this will end in an endless loop -> crash
All fields in this statement are RHS (right-hand-side) expression, so UnifAce will/have to fetch them

Ingo

01 Jun 2018
2:51 pm
Avatar
Knut
Member
Forum Posts: 211
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Ingo,

Rather than trying to do it in the read trigger – I’d have a local proc doing the retrieve.
That way, you can have the outer/inner etc handled, and putlistitems/occ won’t crash
Uniface.

Knut

05 Jun 2018
10:58 am
Avatar
istiller
Member
Forum Posts: 251
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Knut said
Ingo,

Rather than trying to do it in the read trigger – I’d have a local proc doing the retrieve.
That way, you can have the outer/inner etc handled, and putlistitems/occ won’t crash
Uniface.

Knut  

Hi Knut

A possible solution, but … Wink
But you have to replace all RETRIEVEs by a GP_RETRIEVE.
Okay, maybe in future I/we will do so Laugh

BTW:
Next crash: $empty() does also try to retrieve on the fly

@UnifAce:
a) Please mark in docu all proc-statements, which are doing a retrieve on the fly if not done (i.e all RHS expressions regarding the hitlist)
b) Is it possible to check, weather a RETRIEVE allready done or not? Without an endlesse loop of courceConfused

Ingo

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 131

Currently Online:
18 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ulrich-merkel: 1782

Iain Sharp: 653

Theo Neeskens: 353

gianni: 301

rogerw: 260

istiller: 251

Knut: 211

lalitpct: 197

Arjen van Vliet: 175

sochaz: 173

Member Stats:

Guest Posters: 3

Members: 8718

Moderators: 0

Admins: 8

Forum Stats:

Groups: 1

Forums: 62

Topics: 2192

Posts: 9481

Newest Members:

VikaDit, Refomibon, NapsdqaLews, BssaeqiLews, vasin159, NYAlex, Demodom, DorrisSek, HousepfReviews2, gahaddence

Administrators: admin: 23, Adrian Gosbell: 317, diseli: 958, Bob Maier: 3, Nico Peereboom: 77, Michael Rabone: 4, richiet: 406, JanCees: 28