I have a sql db, where i register info connected to a user. In this table there is a field called 'user'. I can see information from all users in SGSV, but would like to only see the information on the user that is presentluy logged in.
I have tried different SQL sentences with WHERE in the SELECT statement, but cannot get 'hold' of the user presently logged in. Is it a db field or how do I get a filter that only show information about the logged in user ??

Mike

Thanks Paul

My questions most probably shows I am a 'novice' and hope it is not a bother to you

Mike

Hi Paul,

Thanks for a speedy answer. Below the full Sql sentence. As you see I have a db called carakostplan and a few calculations fields, and an inner join. In the carakostplan 'bruger' is a key field identifying the user and I only want the user to see his/her own info

SELECT
carakostplan.bruger,carakostplan.bruger,carakostplan.Dato, carakostplan.Vejning,carakostplan.Maaltid,carakostplan.Madvare,
caramadvare.kcal/100*Vejning AS Forbrugt,
caramadvare.fedtindhold/100*Vejning AS Fedt,
caramadvare.proteinindhold/100*Vejning AS Protein,
caramadvare.sukkerindhold/100*Vejning AS Kulhyrat

FROM (carakostplan INNER JOIN caramadvare ON carakostplan.madvare = caramadvare.Madvare)

WHERE carakostplan.bruger = [DNN:Username]

ORDER by carakostplan.Maaltid ;

Thanks

Mike

Hi again

Thanks Paul - simple and how obvious- once you see it

Mike