Hi

I can't find an example of setting attributes with SQL.

I want to do this:-

CREATE USER "Fred Bloggs"

plus I want to set the Attributes to a multiline value

e.g.

Email=Fred@bloggs.com
DayTimePhone=+6491234567
MobilePhone=+642741234567

Hope someone can help me with the syntax

Cheers

Jeff

Jeff Cook wrote:

<I can't find an example of setting attributes with SQL.

As usual the solution came to me as soon as I posted.  All I had to do was change the attributes using EDBMgr and look at the SQL!

Thus:-

CREATE USER "Fred Bloggs"
PASSWORD '<Password>'
ATTRIBUTES 'Email=Fred@bloggs.com
DayTimePhone=+6491234567
MobilePhone=+642741234567'

i.e just stick the lines in quotes!

Cheers

Jeff