>> How do I obtain the value bra:brandnamesysid that has has just been created by the PostGreSQL sequence.
This is a PostGres question, not a NetTalk Question. ie you do it the same way you would for a normal clarion / Postgres program.
>> How do I obtain the username from a normal login form?
In the login form you write the username into a session value, which you can then retrieve later on. ie just save the value, in the form, into a session value of your own name. (don't use a File-field name.)
cheers
Bruce