Re: [pgadmin-hackers] new modifications

2003-01-27 Thread Dave Page
Title: Message



Hi 
Frank,
 
Thanks 
for the patch. I have added the changes to frmDatabase and frmUser to 
CVS.
 
I have 
*not* added the changes to frmGroup as they didn't work on my system. 
Unfortunately I don't have time to figure out why right now, but I did think it 
would be better not to add group members at all when the checkbox is checked, 
rather than add and them remove them again.
 
Thanks 
again,
 
Regards, Dave.

  
  -Original Message-From: frank_lupo 
  [mailto:[EMAIL PROTECTED]] Sent: 25 January 2003 
  14:38To: pgadmin-hackersSubject: [pgadmin-hackers] new 
  modifications
  i modify the program add:
   
  frmgroup: (show only user not in groups) Add sub 
  Exists  Add check chkProperties   change 
  Initialisefrmuser: (present in groups, the name of setting are in combo 
  selected from pg_settings) change Initialise Add 
  lvProperties(1) Add tabProperties(2) drop 
  txtvarname add cbovarnamefrmdatabase: (the name of setting are in 
  combo selected from pg_settings, add button show current setting) Add 
  CmdCurrVal change Initialise drop txtvarname add 
  cbovarname
   
   
  byeBye !! Frank Lupo (Wolf) !! /\_ _/\ \ o o / --ooo-ooo--- 
  Prendi GRATIS l'email 
  universale che... risparmia: clicca qui 
  Sponsor:A Natale regalati un computer e risparmia: 120 euro di 
  sconto su DELL Dimension e Inspiron!Clicca qui 


Re: [pgadmin-hackers] Data migration plugin and mssql6

2003-01-27 Thread Brage Førland
On Fri, Jan 24, 2003 at 11:52:43AM -, Dave Page wrote:

> > BTW, you might want to add a note to the CVS web interface 
> > that the tarball is not directy usable by Visal Studio, 
> > because it chokes on the unix text format in the checked out files.
> 
> Hmm, odd - it works fine here with a fresh tarball opened by VB6, SP5...

> How did you unpack it?

Winrar or unix rar. For each file Visual studio (6.0 SP5, running on NT4)
tries to open it gives an error message and makes a log file like this:

'0' could not be loaded
Line 0: The file \\DIONYSOS\brage\pgadmin2\frmIndex.frm could not be loaded.

I have to convert the files to dos format (LF -> CRLF) before they can be
opened.


-Brage

 

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



Re: [pgadmin-hackers] Data migration plugin and mssql6

2003-01-27 Thread Dave Page


> -Original Message-
> From: Brage Førland [mailto:[EMAIL PROTECTED]] 
> Sent: 27 January 2003 11:53
> To: Dave Page
> Cc: Brage Førland; [EMAIL PROTECTED]
> Subject: Re: [pgadmin-hackers] Data migration plugin and mssql6
> 
> 
> On Fri, Jan 24, 2003 at 11:52:43AM -, Dave Page wrote:
> 
> > > BTW, you might want to add a note to the CVS web interface
> > > that the tarball is not directy usable by Visal Studio, 
> > > because it chokes on the unix text format in the checked 
> out files.
> > 
> > Hmm, odd - it works fine here with a fresh tarball opened by VB6, 
> > SP5...
> 
> > How did you unpack it?
> 
> Winrar or unix rar. For each file Visual studio (6.0 SP5, 
> running on NT4) tries to open it gives an error message and 
> makes a log file like this:
> 
> '0' could not be loaded
> Line 0: The file \\DIONYSOS\brage\pgadmin2\frmIndex.frm could 
> not be loaded.
> 
> I have to convert the files to dos format (LF -> CRLF) before 
> they can be opened.

Try using Winzip, it works fine for me then.

Regards, Dave.

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html



[pgadmin-hackers] error in schema alter database --- SET

2003-01-27 Thread frank_lupo
In schema is present error when setting var to database or user.
The name of variable is quoted but the value no.

E.g 
pippo=# ALTER DATABASE gedis30 SET "TRANSACTION ISOLATION LEVEL" = read commi
tted\g
ERROR:  parser: parse error at or near "committed" at character 65
pippo=# ALTER DATABASE gedis30 SET "TRANSACTION ISOLATION LEVEL" = "read comm
itted"\g
ALTER DATABASE

Error in sub AddOrUpdate class UserVars, DatabaseVars

  szSQL = "ALTER DATABASE " & fmtID(Database) & " SET " & fmtID(Name) & " = " & 
dbSZ(Value)  ERROR

  szSQL = "ALTER USER " & fmtID(szUser) & " SET " & fmtID(Name) & " = " & dbSZ(Value) 
 ERROR



Bye !!
Frank Lupo (Wolf) !!

/\_ _/\
\ o o /
--ooo-ooo---



--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Il vero Pomodoro San Marzano D.O.P. dell' Agro-Sarnese-Nocerino.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=981&d=27-1

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster