Something simple - I can do the equivalent of this this in a pgadmin window:
CREATE USER "FRED"' PASSWORD 'password' in ROLE whatever; and it keeps the caps of FRED I alwasy end up with lower case letters for the user name when I pass the query to postgres even if the logon_name here is "FRED" it > lower case and if I enclose in ' ' or $$ characters etc bombs sql = "CREATE USER " & staff!logon_name & " PASSWORD $$" & staff!password & "$$ IN ROLE " & role Any help appreciated. richard ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user