from:"frank

Re: [pgadmin-hackers] pgAdmin2 support multi language (extract string

2003-09-29 Thread frank_lupo

Hi Hiroshi Saito,
Thanks for your patch, you can send the Japanese.lng file?
Thanks

 Hi Frank.
 
 It is Great.!
 
 I tried it.
 There are two problems.
 
 1) Font selection is Japanese problem. Or Multi-Byte font.
 It seems that this can be avoided with this patch.
 
 2) The input of the Japanese.lng file causes an error.
 Some of the characters of Multi-byte cause a problem.
 It is troublesome though this is the problem of VisualBasic.
 
 However, See below.
 http://cre-ent.skcapi.co.jp/~saito/pgadmin2/pgAdmin2_MultiLanguage.jpg
 This is not the edition translated specially.!!
 It can be expressed perfectly in Japanese.
 
 Regards,
 Hiroshi Saito


Bye !!
Frank Lupo (Wolf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo


Email.it, the professional e-mail, gratis per te: clicca qui 

Sponsor:
Da Peraga un giro del mondo gastronomico tra un acquisto  l'altro... fai un salto al Ristoro Sunflower. 
Clicca qui

Re: [pgadmin-hackers] pgadmin2_Operator_patch

2003-09-13 Thread frank_lupo

 MessageHi frank.

 - Original Message - 
 From: Dave Page 

  From: frank_lupo [mailto:[EMAIL PROTECTED] 

   I add a support to operator class in pgschema and pgadmin2.
   I fix frmVisualQueryBuilder.frx binary file.
 (snip)

  Hi Frank,

  That is excellent work - pgAdmin II has life yet!! :-)

  Mark  I were particularly impressed with the Query Builder - it looks really good!

 I think so, too.
 But, a transplant isn't finished in Japanese.
 I must supply this immediately.
 Because,
 There is popularity of pgAdmin2 in Japan.:-)

 Regards,
 Hiroshi Saito

Hi All,
thanks.
I would want translate pgadmin2 in other languages.

Bye !!
Frank Lupo (Wolf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo

Email.it, the professional e-mail, gratis per te: clicca qui 

Sponsor:
Eccezionale!!! Questo  quello che aspettavi per liberarti dalle zanzare, clicca qui
Clicca qui

Re: [pgadmin-hackers] pgadmin2_Operator_patch

2003-09-12 Thread frank_lupo

 Thanks Hiroshi, patch applied.
 
 Frank; I like the new query builder :-) One minor problem -
 frmVisualQueryBuilder.frx has been added as an ASCII file. Can you
 remove it and re-add it as a binary file please?
 
 Regards, Dave.

Hi Dave, Hiroshi,

I add a support to operator class in pgschema and pgadmin2.
I fix frmVisualQueryBuilder.frx binary file.
My new idea on pgadmin2 are:
- add parm on visual query builder
-generation documentation 

-editor for trigger ,function and rule-relationship diagramming 
- traslation lang
- 

Thanks


Bye !!
Frank Lupo (Wolf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo


Email.it, the professional e-mail, gratis per te: clicca qui 

Sponsor:
Una sorpresa estiva Tele2: Estate con noi e con i vostri amici. 300 minuti telefono gratis
Clicca qui

[pgadmin-hackers]

2003-09-04 Thread frank_lupo

Hi Jean-Michel Pouré,
this is a traslation of pgadmin3 in italian.

Bye



--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Un regalo unico e speciale, REGALA UNA STELLA, avrai il certificato di
proprietà e la mappa per localizzarla nella galassia. La trovi su www.regali.it
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1497d=4-9

pgadmin3.zip
Description: Zip compressed data

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

   http://www.postgresql.org/docs/faqs/FAQ.html

[pgadmin-hackers]

2003-09-04 Thread frank_lupo

Hi Jean-Michel Pouré,this is a traslation of pgadmin3 in italian.
Bye !!
Frank Lupo (Wolf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt
WebSite: http://users.jc-hosting.co.uk/frank_lupo


Email.it, the professional e-mail, gratis per te: clicca qui 

Sponsor:
Iscriviti Gratis al primo corso on-line di Web Marketing in Italia!  Collegati subito a: http://www.internet-marketing.it/?EMAILk0403a
Clicca qui 

pgadmin3.zip
Description: Zip compressed data

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [pgadmin-hackers] Re: pgAdmin II Release

2003-07-17 Thread frank_lupo

  Hi Frank,
  
  Are there any last bug fixes to get into pgAdmin II before release?
  
  If not, I want to get it released this week so you can start adding
  features again.
  
  Regards, Dave.
  
  
 Hi Dave,
 I fix drop object.
  

Sorry, add file

Bye !!
Frank Lupo (Wolf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo


--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
StepStone le migliori soluzioni per le tue ricerche di personale!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1712d=17-7

pgadmin.zip
Description: Zip compressed data

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [pgadmin-hackers] pga2: fix and add

2003-06-23 Thread frank_lupo


Hi Dave,
 Can I have the fixes only please - we're in beta so no new code rightnow.
Ok, but I have new code to add. 

 I was also going to email you to suggest a Beta 2 release. 
Yes, good idea.

 I also want to avoid pga2  pga3 releasing together. Any objections?
No .
I must suspend the development the pgadmin2?


Bye !!
Frank Lupo (Wolf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo


Email.it, the professional e-mail, gratis per te: clicca qui 

Sponsor:
Non hai ancora aperto Conto Arancio? Allora clicca qui.
Clicca qui

[pgadmin-hackers] pga2: fix and add

2003-06-20 Thread frank_lupo

Hi Dave,

I have fix and add new functionality.

frmmain
- fix drop 
- fix properties

frmSQLOutput
- add f5 refresh
- add canc delete record
- add f2 edit rcord
- add ins add record
- add esc close edit/add record
- add f4 save record

frmoptions
- add Show Users For Privileges
- fix form Privileges
- add Ask Delete Object Database

frmconnect
- add description connection


Bye !!
Frank Lupo (Wolf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo


--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
L'interpretazione dei doni di orti, frutteti, prati e giardini nel nostro Ristoro 
Sunflower.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1478d=20-6

pgadmin.zip
Description: Zip compressed data

---(end of broadcast)---
TIP 8: explain analyze is your friend

RE: [pgadmin-hackers] Error Emails

2003-06-09 Thread frank_lupo

 
 
  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 08 June 2003 20:13
  To: Dave Page
  Cc: franklupo; pgadmin-hackers
  Subject: RE: [pgadmin-hackers] Error Emails
  
  
  
  Hi Dave, 
  
  remove clspgApp.cls and vbs. to create class.
 
 Hi Frank,
 
 I removed clspgapp.cls and it gets regenerated incorrectly again:
 
 Public Sub LogError(lError As Long, szError As String, szRoutine As
 String, Optional bSendMail As Boolean = True)
 Call basMisc.LogError(lError,szError,szRoutine,bSendMail,=,True)
 End Sub
 
 Regards, Dave.
 


Hi Dave,
I have fix problem in vbs script.


Index: crtPgAppClass.vbs
===3
 D==
3
D=
RCS file: /disk1/cvsroot/pgadmin2/crtPgAppClass.vbs,v
retrieving revision 1.2
diff -r1.2 crtPgAppClass.vbs
226c226
   for ii=0 to ubound(vData)
---
 for ii=0 to ubound(vData)
229a230,231
   elseif vData(ii)== then
   ii=ii+1




Bye !!
Frank Lupo (Wolf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo



--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Erbe e tisane di primissima qualità.
Inoltre 1800 articoli erboristici. Tutti a portata di un click !

Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1309d=9-6

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

[pgadmin-hackers] pga2: fix select when schena is not selected

2003-06-09 Thread frank_lupo

I fix a sqloutput when the schema is not selected.


Bye !!
Frank Lupo (Wolf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo


--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Conto Arancio: facile aprirlo, difficile rinunciarci.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=663d=9-6

pga2fix.zip
Description: Zip compressed data

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

http://www.postgresql.org/docs/faqs/FAQ.html

Re: [pgadmin-hackers] Error Emails

2003-06-06 Thread frank_lupo

 Hi Frank,
 
 I'm a little concerned about all the error reports we get via email
 these day from the new error dialogue. Many of them are issues that
 don't require our help.
 
 Perhaps we should remove the email button, or at least make it require a
 little more input from the user?
 
 Regards, Dave.
 
Hi Dave,

I fix error on form type tabs show in porpety 1 tabs,
I add optional parm to LogError bSendMail for enable or disable send mail (default 
enable).
   - in frmConnect button cmdConnect is disable
   - in cmdExecute button is disable

Do you think?







Bye !!
Frank Lupo (Wolf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo


--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Ricordatelo: gli altri vogliono truffarti sul web, dai dialer ai programmi
spia. Manuali.net ti consegna le armi per difenderti con oltre 700 trucchi:
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1187d=6-6

pga2fix.zip
Description: Zip compressed data

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[pgadmin-hackers] RE: pga2: problem schema

2003-06-06 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 06 June 2003 07:44
  To: Dave Page
  Cc: pgadmin-hackers
  Subject: RE: pga2: problem schema

  the selection in psql is:

  --
  SELECT n.nspname as Schema,
  pg_catalog.format_type(t.oid, NULL) AS Name,
  pg_catalog.obj_description(t.oid, 'pg_type') as 
  Description FROM pg_catalog.pg_type t
  LEFT JOIN pg_catalog.pg_namespace n ON n.oid = 
  t.typnamespace WHERE (t.typrelid = 0 OR (SELECT c.relkind = 
  'c' FROM pg_catalog.pg_class c WHERE c.oid = t.typrelid)) AND 
  t.typname !~ '^_'
  AND pg_catalog.pg_type_is_visible(t.oid)
  ORDER BY 1, 2;
  --

 Hmm, what about:

 SELECT oid, *, pg_get_userbyid(typowner) as typeowner FROM pg_type WHERE
 typtype != 'd' AND (typtype != 'c' OR (typtype = 'c' AND typrelid = 0))

 That includes typtype = 'c', but only if typrelid = 0 which I think
 should solve Marc's problem.

 Regards, Dave.

Ok, it's a good solution.

Please chage you in cvs.

Question mail list
I resubscribe to pgadmin haker and pgadmin support, using [EMAIL PROTECTED], [EMAIL 
PROTECTED],
but I send mail to mail list , not recive mail in my addres.

Why?

Thanks

Bye !!
Frank Lupo (Wolf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo

--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Digitalpix stampa le tue migliori foto digitali 
su vera carta fotografica professionale.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1532d=6-6

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

[pgadmin-hackers] RE: pga2: problem schema

2003-06-06 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 05 June 2003 11:08
  To: Dave Page
  Subject: pga2: problem schema

  I have a problem in pgschema.
  The selection type result 0.
  The problem is SQL_GET_TYPES7_3. 
  This is changed by Marc Persuy. 
  This selectin is in error.
  Please replace previous version of SQL_GET_TYPES7_3

 Hmm, the old version was wrong as well as it hid custom types. See below
 from Marc Persuy (which I modified slightly to exclude toast table
 types. Any idea what it should really be?

 Regards, Dave.

 --

 Hello,

 Your product is my everyday's tool, and superb.

 Even with the latest version of pgAdmin, I can't see the types I defined
 on postgres 7.3.

=0
 A 
=0

A

 So I tried a small change in pg Schema\basGlobal.bas, namely :

 Replace this sql constant :

 'Public Const SQL_GET_TYPES7_3 = SELECT oid, *,
 pg_get_userbyid(typowner) as typeowner FROM pg_type WHERE typtype != 'd'
 AND typtype != 'c'

 by this one :

 Public Const SQL_GET_TYPES7_3 = SELECT pg_type.oid, *,
 pg_get_userbyid(typowner) as typeowner FROM pg_type, pg_class WHERE
 pg_type.typrelid = pg_class.oid AND pg_class.relkind in ('c','s','t')

 I tested and it works to get the list of defined types, but I can't see
 no function like pg_get_viewdef(viewOID) which could be applied to a
 type, so displayed screen is not very explicit..

 Have You got an idea to get the work fully done ?

 Sincerely

 Marc Persuy

Hi Da
 ve,
=0

A
the selection in psql is:

--
SELECT n.nspname as Schema,
  pg_catalog.format_type(t.oid, NULL) AS Name,
  pg_catalog.obj_description(t.oid, 'pg_type') as Description
FROM pg_catalog.pg_type t
 LEFT JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace
WHERE (t.typrelid = 0 OR (SELECT c.relkind = 'c' FROM pg_catalog.pg_class c WHERE 
c.oid = t.typrelid)) AND t.typname !~ '^_'
  AND pg_catalog.pg_type_is_visible(t.oid)
ORDER BY 1, 2;
--

Do you think?

Bye !!
Frank Lupo (Wolf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo

--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Scopri la nuovissima stampante HP. Design elegante, stampa veloce e di qualità! 
Scoprila qui!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=764d=6-6

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

Re: [pgadmin-hackers] pga2: reserved keywords

2003-05-31 Thread frank_lupo

 
  In the DEFAULT_AUTOHIGHLIGHT on pgadmin2 any reserved 
  keywords are not present. I have extracted on documentation 
  the reserved keywords. 
  Can You add a color on keywords in attachment file ?
  I'll add these keywords in pgadmin2.
 
 I can, but I honestly don't know when. I've got a bunch of stuff going
 on right now - if you can do it soon that may be quicker. Let me know
 either way please.
 

Hi Dave,

Excuse, I do not understand.


Bye !!
Frank Lupo (Wolf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo



--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Manuali.net ti insegna a creare il tuo primo sito web con effetti speciali
grazie a Macromedia FlashMX. 30 Lezioni ed assistenza tramite forum:
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1186d=30-5

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

http://archives.postgresql.org

RE: [pgadmin-hackers] pga2: reserved keywords

2003-05-31 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 30 May 2003 14:15
  To: Dave Page
  Cc: pgadmin-hackers
  Subject: Re: [pgadmin-hackers] pga2: reserved keywords

  Excuse, I do not understand.

 Don't worry, I found some time.

 New keywords are attached - I removed the ones that aren't relevant to
 PostgreSQL as there were a lot of them, and they may have a large impact
 on performance of the HighlightBox.

 The codes seem vaguely sensible, but feel free to change them.

 Regards, Dave

Hi Dave,
thanks  good work.
I have a problem, the DEFAULT_AUTOHIGHLIGHT is a const, is not possible to add many 
lines.
I have idea, on load pgadmin2 read a txt file and load keyword in 
DEFAULT_AUTOHIGHLIGHT variable no const.
Do you think ?

Bye !!
Fran
 k Lupo (

W
olf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo

--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Pacchetto SuperClassic: 50 libri a soli 16,01 Euro!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=815d=30-5

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[pgadmin-hackers] pga2: reserved keywords

2003-05-29 Thread frank_lupo

Hi Dave,

I have change the pgschema and pgadmin to fix problem on reserved keywords .
The reserved keywords in pgschema are added by the pgadmin2 using ctx.AUTOHIGHLIGHT.

In the DEFAULT_AUTOHIGHLIGHT  on pgadmin2 any reserved keywords are not present.
I have extracted on documentation the reserved keywords. 
Can You add a color on keywords in attachment file ?
I'll add these keywords in pgadmin2.

Bye !!
Frank Lupo (Wolf) !!

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

-- 
GPG Key: http://users.jc-hosting.co.uk/frank_lupo/files/publickey.txt

WebSite: http://users.jc-hosting.co.uk/frank_lupo


--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Enciclopedia tascabile: 50 libri di cultura generale a 16,01 Euro!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=818d=29-5

keyword.prc
Description: Binary data

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

RE: [pgadmin-hackers] pgadmin2 conversion patch

2003-04-03 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 03 April 2003 13:25
  To: pgadmin-hackers
  Subject: [pgadmin-hackers] pgadmin2 conversion patch

  add :

 conversion to clone object

 image to clone form

 image to find form

 Hi Frank,

 Patch applied very easily, thanks.

 For other reasons, that I can't figure out, the build process is now
 creating clspgapp.cls incorrectly (see attached). Note the 

 Option Explicit

 Private ObjDbClone

 On line 76 that the compiler is complaining about. Any ideas?

 Regards, Dave

I not have this problem. I send my clsPgApp.cls

Bye !!
Frank Lupo (Wolf) !!

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

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

Sponsor:
Con Email.it partecipa al grande sondaggio Novatris sul mondo Internet ! Puoi vincere 
1500 euro! Prova subito
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1329d=3-4

clsPgApp.cls
Description: Binary data

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

http://archives.postgresql.org

RE: [pgadmin-hackers] Question send modification

2003-04-03 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 03 April 2003 10:44
  To: Dave Page
  Cc: pgadmin-hackers
  Subject: RE: [pgadmin-hackers] Question send modification

  In the current version of pgadmin2 are present the errore in 
  form file. 
  Is not add the icon of conversion e.g frmfind.

 Did you update from CVS first? All the files are comitted.

 Regards, Dave.

Perhaps I am using badly cvs. 
I have download files using wincvs.  
I have executed of the modifications between which added of icon in the listimage. 
Hour I would have to pass the modifications to you of the files.
The diff it generates the difference of the files ascii.
It does not come generated the diff for the files frx.  
How I make to pass these to you?

Bye !!
Fran
 k Lupo (

W
olf) !!

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

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

Sponsor:
Vestiti da campione! Abbigliamento tecnico e Accessori giusti per lo Sport del cuore
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1079d=3-4

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

RE: [pgadmin-hackers] Question send modification

2003-04-03 Thread frank_lupo

Hi Dave,

Excuse, but I want to understand like function the mechanism of the cvs.
1) I have download pgadmin2 using wincvs
2) I have executed of the modifications 
3) I have sent to you the diff file

How I make to update regarding the repository?  
I have executed update but I do not see applied the modifications.  
I have tried to download of pgadmin2 and the modifications not are.  
They are I that I am working badly?  
If you have time you can explain to me as it must be worked with cvs (wincvs).

Thanks

Bye !!
Frank Lupo (Wolf) !!

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





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

Sponsor:
Partecipa al grande sondaggio Novatris sul mondo Internet! Puoi vincere 1500 euro 
clicca qui
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1327d=4-4


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

http://www.postgresql.org/docs/faqs/FAQ.html

[pgadmin-hackers] Qeustion pgadmin2 develop

2003-04-02 Thread frank_lupo

Hi Dave

There are many new functionalities for pgadmin2 that I would want to develop.
I wonder if it has sense to make them or of it it is worth the pain.
How much time will want that the pgadmin3 before to us usable?  
I see that the development and much assets.
What I must make?



Bye !!
Frank Lupo (Wolf) !!

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





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

Sponsor:
Hai bisogno di un nuovo decoder per guardare le partite della tua squadra del cuore? 
Trovalo qui!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=765d=2-4


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

http://www.postgresql.org/docs/faqs/FAQ.html

RE: [pgadmin-hackers] problem compilation pgadmin2

2003-04-02 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 03 April 2003 08:04
  To: pgadmin-hackers
  Subject: [pgadmin-hackers] problem compilation pgadmin2

  Hi Dave

  Ok finally they are successful to use cvs.

  I have download the pgadmin2, pgschema and activex.  

  When I execute the compilation using BuildAll.bat, proposals 
  of the errors come me.

  Impossible to set up the compatible component with the 
  version:  c:\pgadmin2\binaries\pgschema.dll.

  This error is present in all the programs.

  The compilation does not come executed.  

  How I can make in order to resolve the problem?

 Hi Frank,

 Copy an old version of pgschema.dll to
 c:\pgadm
 in2\bina

r
ies\pgschema.dll. It's just the compiler complaining
 that it can't find the version with the existing class ids etc.

 Regards, Dave.

Hi Dave 

Ok, the compilation is ok. 
The file that I have download with cvs I have them in single reading.  
It is right that they are therefore?

Bye !!
Frank Lupo (Wolf) !!

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

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

Sponsor:
Moda sport ai tuoi piedi! La scarpa di tendenza del momento la trovi da Oliviero.it
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1077d=3-4

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[pgadmin-hackers] question abort query

2003-03-28 Thread frank_lupo

Dave is possible to abort query in Visual Basic using ADO?



Bye !!
Frank Lupo (Wolf) !!

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





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

Sponsor:
Clicca su QxService! Trova il tuo artigiano e vinci un Nec e606 UMTS e ricariche 
telefoniche! Che aspetti? Clicca qui!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1417d=28-3


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [pgadmin-hackers] todo question?

2003-03-27 Thread frank_lupo

  -Original Message-
  From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] 
  Sent: 27 March 2003 09:08
  To: pgadmin-hackers
  Subject: Re: [pgadmin-hackers] todo question?

  Le Mercredi 26 Mars 2003 23:12, Dave Page a écrit :
   I think the idea here was to create something similar to Oracle 
   packages(?).  Jean-Michel, do you remember the details - I 
  think that 
   was you one wasn't it?

  This was before schema was introduced. The idea was to be 
  able to group 
  objects and export them to SQL. 

The concept is obsolete. Now the schema exist.  
It is not more from making?

Bye !!
Frank Lupo (Wolf) !!

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

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

Sponsor:
Tutti i nuovi modelli di telefonia su Ebest
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=550d=27-3

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

RE: [pgadmin-hackers] Clone object database

2003-03-25 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 24 March 2003 16:21
  To: Dave Page
  Cc: pgadmin-hackers
  Subject: RE: [pgadmin-hackers] Clone object database

  6) The patch doesn't include updates to frmMain and clsContext to 
  handle the menus.
  Ok, execute refresh 

 Hi Frank,

 I still don't see the updates for frmMain and clsContext. We need to add
 Copy/Paste to the popup menu, and add the relevant subroutines, as well
 as add code to clsContext to enable/disable the options.

 Regards, Dave.

These modifications could make you them?

Bye !!
Frank Lupo (Wolf) !!

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

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

Sponsor:
Il nostro catalogo completo a casa tua, gratis! Vieni da Peraga, tanti prodotti 
introvabili per te.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=450d=25-3

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

http://www.postgresql.org/docs/faqs/FAQ.html

Re: [pgadmin-hackers] add scroll frmtable

2003-03-24 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 19 March 2003 17:18
  To: Dave Page
  Cc: pgadmin-hackers
  Subject: RE: [pgadmin-hackers] add scroll frmtable

  Hi dave

  change the top position 
  from :
 ...
  OK for Column,ForeignKey,Rule,Trigger,Index
 ...
  Now Verify 
 ...

 Hi Frank,

 That looks excellent, it works really well in the IDE.

 The only problem is that is doesn't compile :-(. Because VB runs the
 usercontrol when it builds it, it fails to access the ctx object from
 the Initialize subroutine. Any ideas?

 Regards, Dave.

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

The problem is when compile VB, Initialize usercontrol which is present in frmdummy. 
When Initialize form the frmmain.svr object is not Initialize.

Private Sub UserControl_Initialize()
If inIDE Then: On Error GoTo 0: Else: On Error GoTo Err_Handler
If Not frmMain.svr Is Nothing Then
  frmMain.svr.LogEvent Entering   App.Title  
:ScrollObjDb.UserControl_Initialize(), etFullDebug
End If

  szDatabase = ctx.CurrentDB
  szNamespace = ctx.CurrentNS

  If Len(Trim(szDatabase)) = 0 Then Exit Sub

  'save table name if object depend of table
  Select Case ctx.CurrentObject.ObjectType
Case Column, ForeignKey, Rule, Trigger, Index
  szTable = ctx.CurrentObject.Table
  End Select

  Exit Sub
Err_Handler: If Err.Number  0 Then LogError Err.Number, Err.Description, App.Title  
:ScrollObjDb.UserControl_Initialize
End Sub

Bye !!
Frank Lupo (Wolf) !!

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

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

Sponsor:
Fatti del male. Lascia perdere www.gratis.it.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=725d=24-3

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

http://archives.postgresql.org

RE: [pgadmin-hackers] add scroll frmtable

2003-03-19 Thread frank_lupo

Hi dave

 1) Control positioning (see attachment). Could this be because I have XP's fancy 
 graphics turned on?

change the top position 
from :
'.Top = objForm.Height - .Height * 2 - 25
to
.Top = objForm!cmdOK.Top

 2) It doesn't work for all objects (is this just because they were missed?) e.g. 
 columns, rules (there may be more).

OK for Column,ForeignKey,Rule,Trigger,Index

 
 3) It scrolls all objects. Need to check whether the user is viewing
 system objects or not.

Now Verify 

 4) When I scroll to another table, the properties window closes! Most
 other object types seem OK.

Correct error

Bye !!
Frank Lupo (Wolf) !!

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


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

Sponsor:
Conto Arancio. Zero rischi, zero spese, tanti interessi.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=658d=19-3

patch.zip
Description: Zip compressed data

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

RE: [pgadmin-hackers] add scroll frmtable

2003-03-18 Thread frank_lupo

 Hi Frank,
 
 I just tried this patch and some of it seems to be missing. When I try
 to select the next or previous object, it stops on a call to the
 function LoadObjDb which doesn't exist. The Up/Down control is also
 positioned so the it is partly off the edge of the dialogue.
 
 Regards, Dave.
 
  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 17 March 2003 16:57
  To: Dave Page
  Cc: pgadmin-hackers
  Subject: RE: [pgadmin-hackers] add scroll frmtable
  
  
   
   
-Original Message-
From: frank_lupo [mailto:[EMAIL PROTECTED] 
Sent: 14 March 2003 20:21
To: Dave Page
Cc: pgadmin-hackers
Subject: RE: [pgadmin-hackers] add scroll frmtable

  
  I have added the scroll to the form frmtable like example.
  
  What of tasks?
  
  it would be from extending on all the form.
 
 Hi Frank,
 
 This needs to warn the user is changes to the object 
  have been made 
 and not saved before scrolling. Can you add that 
  functionality, and 
 patch all appropriate forms please?
 
 Thanks, Dave.
 

My idea is create a patch form to add control dinamic.
   
   OK, I'll look forward to seeing it.
   
   Regards, Dave.
   
  Create:
  - control scroll object database
  - patch
  !
  
  - frmD
  
  u
  mmy 
  
  I create a patch to add a control for scroll object database.
  
  Bye !!
  Frank Lupo (Wolf) !!
  
  /\_ _/\
  \ o o /
  --ooo-ooo---
  
  
  --
  Prendi GRATIS l'email universale che... risparmia: 
 http://www.email.it/f
 
 Sponsor:
 Moda sport ai tuoi piedi! La scarpa di tendenza del momento la trovi da
 Oliviero.it
 Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1077d=17-3
 

Sorry the routine LoadObjDb not exists, is a my error.

Bye !!
Frank Lupo (Wolf) !!

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





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

Sponsor:
Speciale voli a soli 80 Euro...affrettatevi, cliccate e partite per la Scandinavia
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1228d=19-3

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

http://archives.postgresql.org

[pgadmin-hackers] clone object database

2003-03-17 Thread frank_lupo

There are problems for the clone object database?

Bye !!
Frank Lupo (Wolf) !!

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



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

Sponsor:
Professionisti per le emergenze quotidiane della casa e della famiglia?
su QXservice trovi idraulici, imbianchini, baby sitter e tanti altri.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=535d=17-3

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

[pgadmin-hackers] Clone object database

2003-03-13 Thread frank_lupo

This program clone a object database:

Domain
clone defination
Table 
clone Column,Check,ForeignKey,Rule,Trigger,Index,Acl
View
clone defination,Acl
User
clone defination,group where is present
Group
clone defination,user present in group

Using:

Insert into Sub main then call to InitClone
For copy using CopyObjDb 
For paste using PasteObjDb

I create a module, is possible to create a class or plug-in

Bye !!
Frank Lupo (Wolf) !!

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


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

Sponsor:
Viaggiare in aereo spendendo poco non è un sogno perchè Sterling fa dei tuoi sogni 
realtà, clicca subito
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1227d=13-3

cloneobjdb.zip
Description: Zip compressed data

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[pgadmin-hackers] fix error Statistics in index,table,column,sequence

2003-03-11 Thread frank_lupo

fix error to select from Statistics add filter schemaname=ctx.currentNS.

Bye !!
Frank Lupo (Wolf) !!

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


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

Sponsor:
DVD, libri, cibi e bevande, cosmesi, prodotti erboristici, articoli per lo sport, 
cellulari e PC...tutto a prezzi scontatissimi,
Clicca qui
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=838d=11-3*** old_frmmain.frm Fri Mar 07 17:21:18 2003
--- frmmain.frm Tue Mar 11 15:28:40 2003
***
*** 1,13 
  VERSION 5.00
! Object = {831FDD16-0C5C-11D2-A9FC-F8754DA1}#2.0#0; mscomctl.ocx
! Object = {BDC217C8-ED16-11CD-956C-C04E4C0A}#1.1#0; tabctl32.ocx
! Object = {F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0; comdlg32.ocx
  Object = {44F33AC4-8757-4330-B063-18608617F23E}#12.4#0; HighlightBox.ocx
  Begin VB.Form frmMain 
 Caption =   pgAdmin II
 ClientHeight=   6675
 ClientLeft  =   165
!ClientTop   =   855
 ClientWidth =   9675
 Icon=   frmMain.frx:
 LinkTopic   =   Form1
--- 1,13 
  VERSION 5.00
! Object = {831FDD16-0C5C-11D2-A9FC-F8754DA1}#2.0#0; MSCOMCTL.OCX
! Object = {BDC217C8-ED16-11CD-956C-C04E4C0A}#1.1#0; TABCTL32.OCX
! Object = {F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0; COMDLG32.OCX
  Object = {44F33AC4-8757-4330-B063-18608617F23E}#12.4#0; HighlightBox.ocx
  Begin VB.Form frmMain 
 Caption =   pgAdmin II
 ClientHeight=   6675
 ClientLeft  =   165
!ClientTop   =   1425
 ClientWidth =   9675
 Icon=   frmMain.frx:
 LinkTopic   =   Form1
***
*** 339,345 
   NumPanels   =   5
   BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
  AutoSize=   1
! Object.Width   =   5611
  MinWidth=   2
  Text=   Ready
  TextSave=   Ready
--- 339,345 
   NumPanels   =   5
   BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
  AutoSize=   1
! Object.Width   =   5638
  MinWidth=   2
  Text=   Ready
  TextSave=   Ready
***
*** 3252,3273 
  
  Dim lvItem As ListItem
  Dim rsStat As New Recordset
  
' Statistics.
' These don't come from pgSchema because they aren't really schema related.
If ctx.dbVer = 7.2 Then
! Set rsStat = svr.Databases(ctx.CurrentDB).Execute(SELECT relname, blks_read, 
blks_hit FROM pg_statio_all_sequences ORDER BY relname)
  sv.ColumnHeaders.Add , , Sequence, 2000
  sv.ColumnHeaders.Add , , Blocks Read, 2000
  sv.ColumnHeaders.Add , , Blocks Hit, 2000

  While Not rsStat.EOF
!   If 
svr.Databases(ctx.CurrentDB).Namespaces(ctx.CurrentNS).Sequences.Exists(rsStat!relname)
 Then
! If Not 
(svr.Databases(ctx.CurrentDB).Namespaces(ctx.CurrentNS).Sequences(rsStat!relname).SystemObject
 And Not ctx.IncludeSys) Then
!   Set lvItem = sv.ListItems.Add(, STA+  GetID, rsStat!relname  , 
statistics, statistics)
!   lvItem.SubItems(1) = rsStat!blks_read  
!   lvItem.SubItems(2) = rsStat!blks_hit  
! End If
End If
rsStat.MoveNext
  Wend
--- 3252,3277 
  
  Dim lvItem As ListItem
  Dim rsStat As New Recordset
+ Dim szSql As String
  
' Statistics.
' These don't come from pgSchema because they aren't really schema related.
If ctx.dbVer = 7.2 Then
! If ctx.dbVer = 7.3 Then
!   szSql = SELECT relname, blks_read, blks_hit FROM pg_statio_all_sequences 
where schemaname='  ctx.CurrentNS  ' ORDER BY relname
! Else
!   szSql = SELECT relname, blks_read, blks_hit FROM pg_statio_all_sequences 
ORDER BY relname
! End If
! Set rsStat = svr.Databases(ctx.CurrentDB).Execute(szSql)
  sv.ColumnHeaders.Add , , Sequence, 2000
  sv.ColumnHeaders.Add , , Blocks Read, 2000
  sv.ColumnHeaders.Add , , Blocks Hit, 2000

  While Not rsStat.EOF
!   If Not 
(svr.Databases(ctx.CurrentDB).Namespaces(ctx.CurrentNS).Sequences(rsStat!relname).SystemObject
 And Not ctx.IncludeSys) Then
! Set lvItem = sv.ListItems.Add(, STA+  GetID, rsStat!relname  , 
statistics, statistics)
! lvItem.SubItems(1) = rsStat!blks_read  
! lvItem.SubItems(2) = rsStat!blks_hit  
End If
rsStat.MoveNext
  Wend
***
*** 3404,3427 
  
  Dim lvItem As ListItem
  Dim rsStat As New Recordset
  
' Statistics.
' These don't come from pgSchema because they aren't really schema related.
If ctx.dbVer = 7.2 Then
! Set rsStat = svr.Databases(ctx.CurrentDB).Execute(SELECT relname, n_tup_ins, 
n_tup_upd, n_tup_del FROM pg_stat_all_tables ORDER BY relname)
  sv.ColumnHeaders.Add , , Table, 2000
  sv.ColumnHeaders.Add , , Tuples Inserted, 2000

Re: [pgadmin-hackers] reindex action

2003-03-06 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 05 March 2003 21:13
  To: pgadmin-hackers
  Subject: [pgadmin-hackers] reindex action

  I developed a reindex command (table,index no database).

 Sorry Frank - this breaks the OO design of pgSchema. Unless there are
 exceptional circumstances, anything that occurs to an object should be
 implemented as a method of that object, so I would expect to see methods
 like:

 pgIndex.ReIndex()
 pgDatabase.ReIndex()
 pgTable.ReIndex()

 Can you recode it in that fashion please?

 Thanks, Dave.

Excuse, I have corrected the schema. 
How we make to call these actions?  

Bye !!
Frank Lupo (Wolf) !!

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

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

Sponsor:
Stai cercando una casella di posta professionale senza pubblicità e senza scadenza? 
Quello che fa per te è Email.it Pro15 o Pro50, ordinala subito, è proprio forte!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1045d=6-3

pgDatabase.cls
Description: Binary data

pgIndex.cls
Description: Binary data

pgTable.cls
Description: Binary data

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[pgadmin-hackers] idea error Handler

2003-03-04 Thread frank_lupo

Current error Handler in first line of routine is :
On Error GoTo Err_Handler

In ide this method is not good because is not possible to debug routine when 
when it comes generated an error.

Change all routine using
If InIDE Then:  On Error GoTo 0: Else: On Error GoTo Err_Handler:

The InIDE is the global variable which indicate if program running in VB Design 
Environment (ide).

This is a method to retrive if execution is in ide.

--
'''module global
Global InIDE As Boolean

'''module api
Public Declare Function GetModuleFileName Lib kernel32 Alias GetModuleFileNameA 
(ByVal hModule As Long, ByVal lpFileName As String, ByVal nSize As Long) As Long

'''module misc

sub main

  InIDE = InVBDesignEnvironment

end sub


'verify if execution of pgAdin2 is in ide
Public Function InVBDesignEnvironment() As Boolean
Dim szFileName As String
Dim lCount As Long

  szFileName = String(255, 0)
  lCount = GetModuleFileName(App.hInstance, szFileName, 255)
  szFileName = Left(szFileName, lCount)

  InVBDesignEnvironment = False
  If UCase(Right(szFileName, 7)) = VB6.EXE Then InVBDesignEnvironment = True
End Function



Bye !!
Frank Lupo (Wolf) !!

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



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

Sponsor:
Speciale voli a soli 80 Euro...affrettatevi, cliccate e partite per la Scandinavia
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1228d=4-3

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[pgadmin-hackers] Add story sql command in frmSQLInput

2003-03-03 Thread frank_lupo

Add story sql command. For store query I'm using the registry :

HKEY_CURRENT_USER, Software\  App.Title  \Command Sql, CmdSql

Bye !!
Frank Lupo (Wolf) !!

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


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

Sponsor:
Baffati, sbiaditi, stracciati e i lavaggi più strani per un capo Ever-Green : il jeans.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1078d=3-3

_frmSQLInput.zip
Description: Zip compressed data

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [pgadmin-hackers] problem to developing the lock

2003-02-28 Thread frank_lupo

 It's rumoured that frank_lupo once said:
 
  I set autocommit =off.
  When drop view and i do not send commit or rollback,is not possible to
  select from other user on pg_view. The Pgadmin2 when read schema is
  locked,and is not possible to make whichever other operation.  This is
  my problem.
  It is not possible to use pgadmin2 if the view are
  locked.
 
 Oh, I see. How about wrapping everything in a transaction in
 pgDatabase.Execute in pgSchema? We should probably then provide a
 secondary connection for use with SQL queries in pgAdmin. Probably not a
 bad idea anyway.
 What do you think?
 
 Regards, Dave.
 

The problem is the function pg_get_viewdef. If the view is drop and transiction is 
safe (no commit/rollback) the function lock query.
Is possible not use this function?
Is possible that the other functions that returns the definition
  of obje

c
t have the same limit?

Bye !!
Frank Lupo (Wolf) !!

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



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

Sponsor:
I gioielli più nuovi, le collezioni più trendy, le trovi solo su Gioie.it!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=768d=28-2

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[pgadmin-hackers] create class application to add in schema

2003-02-28 Thread frank_lupo

Insert script file in the directory project pgadmin2
---
PGSCHEMA
Add in pgServer.cls
'pgAdminII application
Public pgApp As Object
This is a object to recive application class.
---
PGADMIN2
For create a class to istance a pgServer.pgApp execute a script crtpgAppclass.bat. 
This script call script crtpgAppclass.vbs, that reading the files of the project 
pgAdmin2 
it creates the class clspgApp.cls.  This class goes inserted in the pgAdmin2 project.

add in basMisc.bas
Sub Main.

  'Create the Server Object
  Set frmMain.svr = New pgServer
  Set frmMain.svr.pgApp = New clspgApp
.

Add in BuildAll.bat the execution of crtpgAppClass.bat

Bye !!
Frank Lupo (Wolf) !!

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


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

Sponsor:
Lascia che gli altri muoiano d'invidia: ricopriti di Gioie preziose.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=769d=28-2

crtpgAppClass.zip
Description: Zip compressed data

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[pgadmin-hackers] development language

2003-02-26 Thread frank_lupo

I was thinking with which language, and which ambient it is the best one for the 
future developments.
I have inasmuch as to the begun one to develop with wxWindows, this is an optimal 
choice, but if you allow must be made of the sagacities for several the systems 
operates to you.  
You have never taken in consideration java?  
I do not know it well, but I did not know well not even visual basic.  Optimal and a 
free ide of development is NetBeans (http://www.netbeans.org/). 
Thinks that this road could be held in consideration, inasmuch as the not left 
development of the pgadmin3 completely.  
If we want we can make all.
You drink over and know to say what to us of tasks.


Bye !!
Frank Lupo (Wolf) !!

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



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

Sponsor:
Consigli su piante, fiori e bonsai? Affidati a Mr. Green, clicca qui!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=749d=26-2

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

http://archives.postgresql.org

RE: [pgadmin-hackers] development language

2003-02-26 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 26 February 2003 17:19
  To: pgadmin-hackers
  Subject: [pgadmin-hackers] development language

  I was thinking with which language, and which ambient it is 
  the best one for the future developments.

  I have inasmuch as to the begun one to develop with 
  wxWindows, this is an optimal choice, but if you allow must 
  be made of the sagacities for several the systems operates to you. 

  You have never taken in consideration java? 

  I do not know it well, but I did not know well not even 
  visual basic. Optimal and a free ide of development is 
  NetBeans (http://www.netbeans.org/). 

  Thinks that this road could be held in consideration, 
  inasmuch as the not left development of the pgadmin3 completely. 

 Hi Frank,

 I'm afraid I don't fully understand what you are saying, but yes, we
 have looked at Java, and a number of other technologies for pgAdmin III
 including QT, Python, TCL/Tk, C# and probably a few more I've forgotten.
 We decided up C++ and wxWindows, and have even got some way into the
 project, though both Mark  I have not touched it in a while due to
 commitments at work. The code to date can be found at
 http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/pgadmin3/. It compiles on
 Windows, Linux and FreeBSD at the moment. Please feel free to take a
 look and have a go at some coding if you like.

 Regards, Dave.

excuse for my English, I only say that it would be useful not to compile for several 
the systems operated to you, is true that java it is slow but our problem is not this. 
 The jdbc exists for postgres.  Perhaps we will have of the advantages.  Perhaps...

Bye !!
Frank Lupo (Wolf) !!

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

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

Sponsor:
Un regalo, mille possibilità di scelta, una più preziosa dell'altra.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=613d=26-2

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

RE: [pgadmin-hackers] development language

2003-02-26 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 26 February 2003 17:19
  To: pgadmin-hackers
  Subject: [pgadmin-hackers] development language

  I was thinking with which language, and which ambient it is 
  the best one for the future developments.

  I have inasmuch as to the begun one to develop with 
  wxWindows, this is an optimal choice, but if you allow must 
  be made of the sagacities for several the systems operates to you. 

  You have never taken in consideration java? 

  I do not know it well, but I did not know well not even 
  visual basic. Optimal and a free ide of development is 
  NetBeans (http://www.netbeans.org/). 

  Thinks that this road could be held in consideration, 
  inasmuch as the not left development of the pgadmin3 completely. 

 Hi Frank,

 I'm afraid I don't fully understand what you are saying, but yes, we
 have looked at Java, and a number of other technologies for pgAdmin III
 including QT, Python, TCL/Tk, C# and probably a few more I've forgotten.
 We decided up C++ and wxWindows, and have even got some way into the
 project, though both Mark  I have not touched it in a while due to
 commitments at work. The code to date can be found at
 http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/pgadmin3/. It compiles on
 Windows, Linux and FreeBSD at the moment. Please feel free to take a
 look and have a go at some coding if you like.

 Regards, Dave.

excuse for my English, I only say that it would be useful not to compile for several 
the systems operated to you, is true that java it is slow but our problem is not this. 
 The jdbc exists for postgres.  Perhaps we will have of the advantages.  Perhaps...

Bye !!
Frank Lupo (Wolf) !!

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

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

Sponsor:
Professionisti per le emergenze quotidiane della casa e della famiglia?
su QXservice trovi idraulici, imbianchini, baby sitter e tanti altri.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=535d=26-2

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

RE: [pgadmin-hackers] development language

2003-02-26 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 26 February 2003 17:19
  To: pgadmin-hackers
  Subject: [pgadmin-hackers] development language

  I was thinking with which language, and which ambient it is 
  the best one for the future developments.

  I have inasmuch as to the begun one to develop with 
  wxWindows, this is an optimal choice, but if you allow must 
  be made of the sagacities for several the systems operates to you. 

  You have never taken in consideration java? 

  I do not know it well, but I did not know well not even 
  visual basic. Optimal and a free ide of development is 
  NetBeans (http://www.netbeans.org/). 

  Thinks that this road could be held in consideration, 
  inasmuch as the not left development of the pgadmin3 completely. 

 Hi Frank,

 I'm afraid I don't fully understand what you are saying, but yes, we
 have looked at Java, and a number of other technologies for pgAdmin III
 including QT, Python, TCL/Tk, C# and probably a few more I've forgotten.
 We decided up C++ and wxWindows, and have even got some way into the
 project, though both Mark  I have not touched it in a while due to
 commitments at work. The code to date can be found at
 http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/pgadmin3/. It compiles on
 Windows, Linux and FreeBSD at the moment. Please feel free to take a
 look and have a go at some coding if you like.

 Regards, Dave.

excuse for my English, I only say that it would be useful not to compile for several 
the systems operated to you, is true that java it is slow but our problem is not this. 
 The jdbc exists for postgres.  Perhaps we will have of the advantages.  Perhaps...

Bye !!
Frank Lupo (Wolf) !!

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

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

Sponsor:
Comunica con il mondo in sicurezza e rapidità ordina subito la tua casella da 15 MB o 
50 MB di spazio
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1044d=26-2

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

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

RE: [pgadmin-hackers] development language

2003-02-26 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED] 
  Sent: 26 February 2003 21:00
  To: Dave Page
  Cc: pgadmin-hackers
  Subject: RE: [pgadmin-hackers] development language

  excuse for my English,

 :-) Your English is *far* better than my Italian!!

  I only say that it would be useful not 
  to compile for several the systems operated to you, is true 
  that java it is slow but our problem is not this.  The jdbc 
  exists for postgres.  Perhaps we will have of the advantages. 
   Perhaps...

 I've had nothing but bad experiences with Java and despite giving it as
 unbiased consideration as I could, I decided upon C++/wxWindows in
 preference. Having just finished 8 solid weeks of C++ training just
 before Christmas in preference to Java I'm even more reluctant to
 change.
=0
 A 
=0
A
 So it's C++/wxWindows for pgAdmin3 :-)

 Regards, Dave.

therefore it is C++/wxWindows for pgAdmin3:  -)

Bye !!
Frank Lupo (Wolf) !!

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

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

Sponsor:
 nuovissimo Sony Ericsson T68i  marchiato TIM
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=552d=26-2

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

[pgadmin-hackers] Add a definable row limit to 'View Data'

2003-02-24 Thread frank_lupo

The sub is in frmmain.


Private Sub mnuPopupViewData_Click()
On Error GoTo Err_Handler
svr.LogEvent Entering   App.Title  :frmMain.mnuPopupViewData_Click(), etFullDebug
  
Dim objOutputForm As New frmSQLOutput
Dim rsQuery As New Recordset
Dim szTemp As String
Dim lLimit As Long
Dim lNumRow As Long
Const ROW_LIMIT_QUESTION As Long = 5000

  'count row
  lNumRow = 0
  StartMsg Counting Records...
  Set rsQuery = frmMain.svr.Databases(ctx.CurrentDB).Execute(SELECT count(*) AS count 
FROM   ctx.CurrentObject.FormattedID)
  If Not rsQuery.EOF Then lNumRow = rsQuery!Count
  EndMsg

  'Add a definable row limit to 'View Data'
  szTemp = InputBox(Insert row limit  vbCrLf  Table contain   lNumRow   
rows, Row limit, lNumRow)
  If Len(szTemp) = 0 Then Exit Sub
  lLimit = 0
  If IsNumeric(szTemp) Then lLimit = szTemp
  szTemp = LIMIT   lLimit
  
  If lLimit  ROW_LIMIT_QUESTION And lNumRow  0 Then
If MsgBox(The row limit is   lLimit  . The records which may take some time 
to load.  vbCrLf  Do you wish to continue?, vbQuestion + vbYesNo, Continue?) = 
vbNo Then Exit Sub
  End If
  
  StartMsg Executing SQL Query...
  Set rsQuery = frmMain.svr.Databases(ctx.CurrentDB).Execute(SELECT * FROM   
ctx.CurrentObject.FormattedID  szTemp)
  Load objOutputForm
  objOutputForm.Display rsQuery, ctx.CurrentDB, (  ctx.CurrentObject.ObjectType  
:   ctx.CurrentObject.FormattedID  )
  objOutputForm.Show
  EndMsg
  
  Exit Sub
  
Err_Handler:
  EndMsg
  If Err.Number  0 Then LogError Err.Number, Err.Description, App.Title  
:frmMain.mnuPopupViewData_Click
End Sub



Bye !!
Frank Lupo (Wolf) !!

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



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

Sponsor:
Il lavandino che gocciola ti fa innervosire? L'idraulico che ti serve
lo trovi su QxService! Clicca qui ed il tuo problema sarà risolto!!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=840d=24-2

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [pgadmin-hackers] problem to developing the lock

2003-02-22 Thread frank_lupo

 It's rumoured that frank_lupo once said:
  I am developing the lock but I find problems why the pgadmin2 it
  remains blocked.  How can be resolved the problem?
 
  Read mail:
  drop view not possible to select from pg_view
  http://archives.postgresql.org/pgsql-general/2003-01/msg01031.php
 
 Sorry Frank, I don't understand what you mean :-(
 
 Regards, Dave.
 
 
 

I set autocommit =off. 
When drop view and i do not send commit or rollback,is not possible to select from 
other user on pg_view. The Pgadmin2 when read schema is locked,and is not possible to 
make whichever other operation.  This is my problem.
It is not possible to use pgadmin2 if the view are locked.


Bye !!
Frank Lupo (Wolf) !!

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



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

Sponsor:
Un giorno a settimana gusta la Mozzarella di Bufala Campana e la Treccia di Agerola.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=982d=22-2

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[pgadmin-hackers] fixx bug find object

2003-02-21 Thread frank_lupo

fix bug for version precedent 7.3
In version  7.3 is not present cast,domain

This is the correct way to generate the differences between the files?

Bye !!
Frank Lupo (Wolf) !!

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


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

Sponsor:
Nessun'idea per un regalo? Da noi troverai novità preziose ogni giorno.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=773d=21-2
*** frmFind.frm Thu Feb 20 19:29:24 2003
--- old_frmFind.frm Fri Feb 21 13:53:07 2003
***
*** 506,515 
'load object type
lvObjType.ListItems.Clear
lvObjType.ListItems.Add , AGG, Aggregate, aggregate, aggregate
!   If ctx.dbVer = 7.3 Then
! lvObjType.ListItems.Add , CST, Cast, cast, cast
! lvObjType.ListItems.Add , DOM, Domain, domain, domain
!   End If
lvObjType.ListItems.Add , FNC, Function, function, function
lvObjType.ListItems.Add , LNG, Language, language, language
lvObjType.ListItems.Add , OPR, Operator, operator, operator
--- 506,513 
'load object type
lvObjType.ListItems.Clear
lvObjType.ListItems.Add , AGG, Aggregate, aggregate, aggregate
!   lvObjType.ListItems.Add , CST, Cast, cast, cast
!   lvObjType.ListItems.Add , DOM, Domain, domain, domain
lvObjType.ListItems.Add , FNC, Function, function, function
lvObjType.ListItems.Add , LNG, Language, language, language
lvObjType.ListItems.Add , OPR, Operator, operator, operator
***
*** 639,648 
szNamespace = lvItem.Text
If chkAdvOpt.Value = 1 Then
  If lvObjType.ListItems(AGG).Checked Then colObj.Add 
objDatabase.Namespaces(szNamespace).Aggregates
! If ctx.dbVer = 7.3 Then
!   If lvObjType.ListItems(CST).Checked Then colObj.Add objDatabase.Casts
!   If lvObjType.ListItems(DOM).Checked Then colObj.Add 
objDatabase.Namespaces(szNamespace).Domains
! End If
  If lvObjType.ListItems(FNC).Checked Then colObj.Add 
objDatabase.Namespaces(szNamespace).Functions
  If lvObjType.ListItems(LNG).Checked Then colObj.Add objDatabase.Languages
  If lvObjType.ListItems(OPR).Checked Then colObj.Add 
objDatabase.Namespaces(szNamespace).Operators
--- 637,644 
szNamespace = lvItem.Text
If chkAdvOpt.Value = 1 Then
  If lvObjType.ListItems(AGG).Checked Then colObj.Add 
objDatabase.Namespaces(szNamespace).Aggregates
! If lvObjType.ListItems(CST).Checked Then colObj.Add objDatabase.Casts
! If lvObjType.ListItems(DOM).Checked Then colObj.Add 
objDatabase.Namespaces(szNamespace).Domains
  If lvObjType.ListItems(FNC).Checked Then colObj.Add 
objDatabase.Namespaces(szNamespace).Functions
  If lvObjType.ListItems(LNG).Checked Then colObj.Add objDatabase.Languages
  If lvObjType.ListItems(OPR).Checked Then colObj.Add 
objDatabase.Namespaces(szNamespace).Operators
***
*** 652,661 
  If lvObjType.ListItems(VIE).Checked Then colObj.Add 
objDatabase.Namespaces(szNamespace).Views
Else
  colObj.Add objDatabase.Namespaces(szNamespace).Aggregates
! If ctx.dbVer = 7.3 Then
!   colObj.Add objDatabase.Casts
!   colObj.Add objDatabase.Namespaces(szNamespace).Domains
! End If
  colObj.Add objDatabase.Namespaces(szNamespace).Functions
  colObj.Add objDatabase.Languages
  colObj.Add objDatabase.Namespaces(szNamespace).Operators
--- 648,655 
  If lvObjType.ListItems(VIE).Checked Then colObj.Add 
objDatabase.Namespaces(szNamespace).Views
Else
  colObj.Add objDatabase.Namespaces(szNamespace).Aggregates
! colObj.Add objDatabase.Casts
! colObj.Add objDatabase.Namespaces(szNamespace).Domains
  colObj.Add objDatabase.Namespaces(szNamespace).Functions
  colObj.Add objDatabase.Languages
  colObj.Add objDatabase.Namespaces(szNamespace).Operators


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

[pgadmin-hackers] reset statistic

2003-02-21 Thread frank_lupo

add reset statistic similar to mnuPopupVacuum

Private Sub mnuPopupResetStat_Click()
On Error GoTo Err_Handler
svr.LogEvent Entering   App.Title  :frmMain.mnuPopupResetStat_Click(), 
etFullDebug

  'reset statistic
  If MsgBox(Confirm reset statistic?, vbApplicationModal + vbYesNo) = vbYes Then
svr.Databases(ctx.CurrentDB).Execute select pg_stat_reset()
  End If
  
  Exit Sub
Err_Handler: If Err.Number  0 Then LogError Err.Number, Err.Description, App.Title  
:frmMain.mnuPopupResetStat_Click
End Sub


Bye !!
Frank Lupo (Wolf) !!

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



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

Sponsor:
Un regalo, mille possibilità di scelta, una più preziosa dell'altra.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=613d=21-2

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [pgadmin-hackers] Pg_hba.conf Editor

2003-02-20 Thread frank_lupo

 Hi all,
 
 I've just committed a new pg_hba.conf editor plugin for pgAdmin II as
 originally submitted by Frank Lupo and subsequently enhanced and
 converted to a plugin by Mark Yeatman.
 
 This will be particularly useful for Cygwin PostgreSQL and the upcoming
 Win32 native port.
 
 Snapshot binaries are in the binaries folder at http://cvs.pgadmin.org
 for those interested in trying it out. Installation instructions are in
 the readme.
 
 Regards, Dave.
 
 ---(end of broadcast)---
 TIP 2: you can get off all lists at once with the unregister command
 (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
 

improvements:

- add AutoSizeColumnLv when load,add,update,remove line
- when select option from file database/user show filelistbox with selection 
multiple.
- add p
 ossibili
t
y to create the new files (database/user)
- combination files and databases/users, it does not exclude the other (my error)
  read documentation
 e.g 
# TYPE  DATABASEUSERIP-ADDRESSIP-MASK   METHOD
local   db1,db2,@demodbs  all   md5
local   all @admins,+supportmd5
I do not comprise the manual insertion of the values, if these come read from schema

Bye !!
Frank Lupo (Wolf) !!

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



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

Sponsor:
Un collegamento internet veloce e ancora più conveniente: 702 28528 01
Provalo subito clicca qui
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=440d=20-2

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

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

RE: [pgadmin-hackers] new functionality variable database

2003-02-20 Thread frank_lupo

-OriginalMessage-
From:frank_lupo[mailto:[EMAIL PROTECTED]
Sent:18February200310:51
To:pgadmin-hackers
Subject:[pgadmin-hackers]newfunctionalityvariabledatabase

Addcomboforselectvalueofvaiable(user/database).

Addcomboforcreatedatabasefromtemplate

HiFrank,

Igetanerrorwh
 enever
b
sp;Iviewthepropertiesofauserordatabasewith
thisupdate.It'sasubscriptoutofrangeerrorinbasVarDb.GetVarDb
andIthinkit'shappeningbecausemyusersanddatabasesdon'thaveany
variablessetforthem.Ispendalittletimetryingtofigureitout,
butI'mreallybusyrightnow-canyoutakealookplease?

Thanks,Dave

Sorry call in Main sub the InitVarDb() sub.
This sub create a collection variable.

Bye !!
F
 rank Lup
o
 (Wolf) !!

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

Prendi GRATIS l'email universale che... risparmia: clicca qui 

Sponsor:
Prova la convenienza di eBay: migliaia di articoli a prezzi senza confronto.
Clicca qui

Re: [pgadmin-hackers] new export access

2003-02-17 Thread frank_lupo

 
 
  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED]] 
  Sent: 14 February 2003 13:56
  To: Dave Page
  Cc: pgadmin-hackers
  Subject: Re: [pgadmin-hackers] new export access
  
  
  correct a bug :
  - select value not specify name (return ?column?)
  e.g select 1 
  - column name escape using [] 
  e.g select 1 as pippo peppo
  - escape value chr(34) your case
 
 Hi Frank, 
 
 I just tested this again and there are still some issues I'm afraid:
 
 - It won't use pre-existing .mdb files.
Of default I delete the file mdb and I recreate it. Is wanted to be maintained and to 
be created new table in this?

 - it appeared to hang whilst copying my data.
What wants to say this?

Bye !!
Frank Lupo (Wolf) !!

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



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

Sponsor:
Il lavandino che gocciola ti fa innervosire? L'idraulico che ti serve
lo trovi su QxService! Clicca qui ed il tuo problema sarà risolto!!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=840d=17-2

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [pgadmin-hackers] new export access

2003-02-17 Thread frank_lupo

 
 
  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED]] 
  Sent: 17 February 2003 14:40
  To: Dave Page
  Cc: pgadmin-hackers
  Subject: Re: [pgadmin-hackers] new export access
  
  
   
   
-Original Message-
From: frank_lupo [mailto:[EMAIL PROTECTED]]
Sent: 14 February 2003 13:56
To: Dave Page
Cc: pgadmin-hackers
Subject: Re: [pgadmin-hackers] new export access


correct a bug :
- select value not specify name (return ?column?)
e.g select 1
- column name escape using [] 
e.g select 1 as pippo peppo
- escape value chr(34) your case
   
   Hi Frank,
   
   I just tested this again and there are still some issues I'm afraid:
   
   - It
 won't us
e
 pre-existing .mdb files.
  Of default I delete the file mdb and I recreate it. Is wanted 
  to be maintained and to be created new table in this?
 
 For this exporter I think yes. 
 
   - it appeared to hang whilst copying my data.
  What wants to say this?
 
 Mouse cursor display busy? Perhaps display a count of rows on an small
 form?
 
 I think something is certainly needed otherwise for a few thousand+ row
 it looks like it has hung.
 
 Regards, Dave.
 
 ---(end of broadcast)---
 TIP 5: Have you checked our extensive FAQ?
 
 http://www.postgresql.org/users-lounge/docs/faq.html
 

New Functionality:
- if file exists don't delete 
- Add form status (progressbar and record count)
- Add combo for select type operation if table destination exists




Bye !!
 
Frank

Lupo (Wolf) !!

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




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

Sponsor:
Il modo più semplice e conveniente per mandare bouquet e composizioni floreali in 
tutta Italia.
Rapporto personalizzato con il Tuo fiorista, ad i prezzi più bassi del Web.
La qualità è garantita!

Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=367d=17-2


access.zip
Description: Zip compressed data

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[pgadmin-hackers] new export access

2003-02-14 Thread frank_lupo

I create a new export to access. I don't know all column in access. 
For this reason is presente a message and the raise error.

Bye !!
Frank Lupo (Wolf) !!

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


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

Sponsor:
Viaggiare è il tuo sogno? Prepara la valigia al resto ci pensa Cofidis...scopri come
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1247d=14-2


access.zip
Description: Zip compressed data

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Re: [pgadmin-hackers] new export access

2003-02-14 Thread frank_lupo

correct a bug :
- select value not specify name (return ?column?)
  e.g select 1  
- column name escape using [] 
  e.g select 1 as pippo peppo
- escape value chr(34) your case

Bye !!
Frank Lupo (Wolf) !!

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


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

Sponsor:
Quando hai bisogno di liquidità non devi spiegare per cosa. Conto Privilegiato è 
discreto.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1240d=14-2


access.zip
Description: Zip compressed data

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

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

[pgadmin-hackers] documentation from pgAdmin2

2003-02-13 Thread frank_lupo

This is a primordial docuemntation of database from pgAdmin2.
I create a chm or html file.
Send me your opinions.



Bye !!
Frank Lupo (Wolf) !!

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




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

Sponsor:
Destinazione Scandinavia a soli 80 Euro...clicca e scopri la convenienza
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1226d=13-2


cast.chm
Description: Binary data


pg_class.chm
Description: Binary data

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

http://archives.postgresql.org

RE: [pgadmin-hackers] documentation from pgAdmin2

2003-02-13 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED]] 
  Sent: 13 February 2003 15:01
  To: pgadmin-hackers
  Subject: [pgadmin-hackers] documentation from pgAdmin2

  This is a primordial docuemntation of database from pgAdmin2.

  I create a chm or html file.

 Hi Frank,

 Looks excellent. How easy is it to generate?

 My only (minor) comments: Could probably do with   in empty cells,
 and I think there are some line spacing issues in the SQL cell for
 pg_class.

 Regards, Dave.

The idea is read a frmmain form and silumate the click on the form.
I developed the primordial programm, is required the HTML_Help_Workshop exe to 
generate chm file. It easy to generate.

Bye !!
Frank Lupo (Wolf) !!

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

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

Sponsor:
Caldo, sole e belle giornate. Giochiamo in giardino con i giochi Little
Tikes, li trovi in esclusiva nel MammaShop.it. Senza spese di spedizione!!!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=624d=13-2

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[pgadmin-hackers] find object idea

2003-02-05 Thread frank_lupo

In frmfind don use Name but Identifier  (objTmp.Identifier).
e.g if find a function 
by name int4
by Identifier int4(text) 

Bye !!
Frank Lupo (Wolf) !!

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



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

Sponsor:
Ti serve un idraulico? Un elettricista o un imbianchino?
Vai su QxService e troverai chi ti serve!!
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=845d=5-2

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [pgadmin-hackers] find object database form

2003-02-03 Thread frank_lupo

  -Original Message-
  From: frank_lupo [mailto:[EMAIL PROTECTED]] 
  Sent: 31 January 2003 11:13
  To: pgadmin-hackers
  Subject: [pgadmin-hackers] find object database form

  I developed a find object database

 Hi Frank,

 This is a nice addition to pgAdmin, thanks. There are a couple of
 changes that would make it better before I add it however:

 - It is not clear that the comment and sql boxes filter the pre-existing
 results. It would make more sense for empty fields to be ignored, so you
 could search just on comment for example.

 - An option to search for objects with a given OID would be very useful.

 This would probably work well as a plugin, rather than built into
 pgAdmin. I might do that myself if you have no objections?

 Thanks again, Dave.

 ---

-
---(end of broadcast)---
 TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

The option find are in AND (name and comment and sql). 
If precedente filter is clear the filter is not active.
It is not possible to create plugin, because it does not come passed to plugin the 
reference of all the PgAdmin application, this serves in order to visualize the detail 
of the object in the listview (event doubleclick).

Bye !!
Frank Lupo (Wolf) !!

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

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

Sponsor:
Cerchi l'Eldorado? Entra nella miniera d'oro più ricca del web!!!
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=611d=3-2

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[pgadmin-hackers] problem to connect 7.3

2003-01-22 Thread frank_lupo

Good year,
I have a problem to connect a postgresql 7.3 using last version of PgAdmin2. When connect to database error message is 'blank'.
I resoved problem changing the attribute connection KSQO to 0 from 1.
Is it avalid solution ?


Bye !!
Frank Lupo (Wolf) !!

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




Prendi GRATIS l'email universale che... risparmia: clicca qui 

Sponsor:
Ti piace la musica Jazz? Ti offriamo 5 CD a 25,01 Euro!
Clicca qui

Re: [pgadmin-hackers] problem to connect 7.3

2003-01-22 Thread frank_lupo

 

 
-Original Message-From: frank_lupo [mailto:[EMAIL PROTECTED]] Sent: 22 January 2003 10:04To: pgadmin-hackersSubject: [pgadmin-hackers] problem to connect 7.3
Good year,
I have a problem to connect a postgresql 7.3 using last version of PgAdmin2. When connect to database error message is 'blank'.
I resoved problem changing the attribute connection KSQO to 0 from 1.
 Is it avalid solution ?
 
Doesn't sound like it. what version of the ODBC driver do you have?

Regards, Dave.

The version on odbc 7.02.00.01

Bye !!
Frank Lupo (Wolf) !!

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




Prendi GRATIS l'email universale che... risparmia: clicca qui 

Sponsor:
Il tuo regalo di Natale super scontato? Dell Dimension o Inspiron, -120 euro!
Clicca qui

RE: [pgadmin-hackers] idea for reading encodign format

2002-09-11 Thread frank_lupo


Is possible that the problem the vesrione of the compiler? 
My version 7.2iscompiledbyGCC2.95.3-5
Your version 7.2iscompiledbyGCCegcs-2.91.66

Is a problem ?


OK, anyideasontheproblemImentioned?
-OriginalMessage-From:frank_lupo [mailto:[EMAIL PROTECTED]]Sent:10September&
 nbsp;200
2
 16:34To:DavePageCc:pgadmin-hackersSubject: Re:[pgadmin-hackers]ideaforreadingencodignformat

IusingPostgreSQL7.2
template1=#select version(); versionPostgreSQL 7.2oni686-pc-cygwin,compiledbyGCC2.95.3-5(1row)
 
Itriedon2
 ;systems
:


template1=#select versin(); version---!-- -PostgreSQL 7.3b1oni686-pc-cygwin,compiledbyGCC2.95.3-5(1row)

template1=#select &
 nbsp;
s
p;pg_encoding_to_char(0)template1-#unionselect pg_encoding_to_char(1)template1-#unionselect pg_encoding_to_char(2)template1-#unionselect pg_encoding_to_char(3)template1-#unionselect pg_encoding_to_char(4)template1-#unionselect pg_encoding_to_char(5)template1-#unionselect pg_encoding_to_char(6)template1-#unionselect pg_encoding_to_char(7)template1-#unionselect pg_encoding_to_char(8)template1-#unionselect pg_encoding_to_char(9)template1-#unionselect pg_enc
 oding_t!
&
nbsp;o_char(10)template1-#unionselect pg_encoding_to_char(11)template1-#unionselect pg_encoding_to_char(12)template1-#unionselect pg_encoding_to_char(13)template1-#unionselect pg_encoding_to_char(14)template1-#unionselect pg_encoding_to_char(15)template1-#unionselect pg_encoding_to_char(16)template1-#unionselect pg_encoding_to_char(17)template1-#unionselect pg_encoding_to_char(18)template1-#unionselect pg_encoding_to_char(19)template1-#unionselect pg_enc
 oding_to
_
char(20)template1-#unionselect pg_encoding_to_char(21);pg_encoding_to_char-EUC_CNEUC_JPEUC_KREUC_TWJOHABKOI8LATIN1LATIN10LATIN2LATIN3LATIN4LA! TIN5n bsp;LATIN6LATIN7LATIN8LATIN9MULE_INTERNALSQL_ASCIITCVNUNICODEWIN1256WIN874(22 rows)

and

template1=select version(); version---PostgreSQL 7.2oni686-pc-linux-gnu,compiledbyGCCegcs-2.91.66(1! row)

template1= selectpg_encoding_to_char(0)template1
 -
s
p;unionselect pg_encoding_to_char(1)template1-unionselect pg_encoding_to_char(2)template1-unionselect pg_encoding_to_char(3)template1-unionselect pg_encoding_to_char(4)template1-unionselect pg_encoding_to_char(5)template1-unionselect pg_encoding_to_char(6)template1-unionselect pg_encoding_to_char(7)template1-unionselect pg_encoding_to_char(8)template1-unionselect pg_encoding_to_char(9)template1-unionselect pg_encoding_to_char(10)templat
 e1-&
n
bsp;unionselect pg_encoding_to_char(11)template1-unionselectnb!sp; pg_encoding_to_char(12)template1-unionselect pg_encoding_to_char(13)template1-unionselect pg_encoding_to_char(14)template1-unionselect pg_encoding_to_char(15)template1-unionselect pg_encoding_to_char(16)template1-unionselect pg_encoding_to_char(17)template1-unionselect pg_encoding_to_char(18)template1-unionselect pg_encoding_to_char(19)template1-unionselect 
 pg_encod
i
ng_to_char(20)template1-unionselect pg_encoding_to_char(21);pg_encoding_to_char-SQL_ASCII(1 row)

The7.2systemwas!;compiled withoutmultibytesupport.In7.3,multibyteisalwayson.Iguess itprobablydoesn'tmattermuchasit'sobviouslygivingonlyusefulencodings, theproblemisthis(onthe7.2
 bsp;syst
e
m):

template1=select pg_encoding_to_char(45);pg_encoding_to_char-SQL_ASCII(1 row)

template1=select pg_encoding_to_char(450);pg_encoding_to_char-SQL_ASCII(1 row)0D 

Howwouldtheloop knowwhentogiveupandexit?

Regards, Dave. 
 -OriginalMessage-From:frank_lupo [mailto:[EMAIL PROTECTED]]Sent:10September2002 14:45To:DavePage!Cc: pgadmin-hackersSubject: RE:[pgadmin-hackers]ideaforreadingencodignformat
 
 
Ireplacethiscodeinfrmdatabasepgadmin2.Idon'thavethisproblem.  
 p;
0D
Whatisyourresultifyouexecutethisselection? 
selectpg_encoding_to_char(0) 
unionselectpg_encoding_to_char(1) 
unionselectpg_encoding_to_char(2) 
unionselectnbsp;pg_encoding_to_char(3) 
union
 selectpg_encoding_to_char(4) 
unionselectpg_encoding_to_char(5) 
unionselectpg_encoding_to_char(6) 
unionselectpg_encoding_to_char(7) 
unionselectpg_encoding_to_char(8) 
union
b
sp;selectpg_encoding_to_char(9) 
unionselectpg_encoding_to_char(10) 
unionselectpg_encoding_to_char(11) 
unionselectpg_encoding_to_char(12) 
unionselectpg_encoding_to_char(13) 
 p;

<
P>unionselectpg_encoding_to_char(14) 
unionselectpg_encoding_to_char(15) 
unionselect pg_encod!ing_to_char(16) 
unionselectpg_encoding_to_char(17) 
unionselectpg_encoding
 _to_char
(
18) 
unionselectpg_encoding_to_char(19) 
unionselectpg_encoding_to_char(20) 
unionselectpg_encoding_to_char(21) 
Myresultis: 
pg_encoding_to_char-ALTEUC_CNEUC_JPEUC_KREUC_TWISO_8859_5ISO_8859_6KOI8LATIN1
L
ATIN10LATIN2n!

RE: [pgadmin-hackers] idea for reading encodign format

2002-09-10 Thread frank_lupo


I replace this code in frmdatabase pgadmin2. I don't have this problem. 
What is your result if you execute this selection ?
select pg_encoding_to_char(0) 
union select pg_encoding_to_char(1)
union select pg_encoding_to_char(2)
union select pg_encoding_to_char(3)
union select pg_encoding_to_char(4)
union select pg_encoding_to_char(5)
union select pg_encoding_to_char(6)
union select pg_encoding_to_char(7)
union select pg_encoding_to_char(8)
union select pg_encoding_to_char(9)
union select pg_encoding_to_char(10)
union select pg_encoding_to_char(11)
union select pg_encoding_to_char(12)
union select pg_encoding_to_char(13)
union select pg_encoding_to_char(14)
union select pg_encoding_to_char(15)
union select pg_encodi
 ng_to_ch
a
r(16)
union select pg_encoding_to_char(17)
union select pg_encoding_to_char(18)
union select pg_encoding_to_char(19)
union select pg_encoding_to_char(20)
union select pg_encoding_to_char(21)
My result is :
pg_encoding_to_char-ALTEUC_CNEUC_JPEUC_KREUC_TWISO_8859_5ISO_8859_6KOI8LATIN1LATIN10LATIN2LATIN3LATIN4LATIN5LATIN6LATIN7LATIN8LATIN9MULE_INTERNAL
 bsp;SQL_
A
SCIIUNICODEWIN(22 rows)
The order is not by number encoding.


Hi Frank,

Hmm,thatdoesn'tseemtoworkhere.ForanyrandomintegervalueofX thatItryinselectpg_encoding_to_char(X),IgetSQL_ASCIIasthe result.

This isaproblemIwouldliketofix,thoughIdon'thavetimemyselfrightnow :-(

Regards,Dave.
-OriginalMessage-From:frank_lupo [mailto:[EMAIL PROTECTED]]Sent:09September2002 16:46To:pgadmin-hackersSubject:[pgadmin-hackers]idea
  &
n
bsp;forreadingencodignformat

forreadingencodignformatcurrent versionis:
'Loadthe EncodingSchemescboProperties(0).Text= "SQL_ASCII"SetobjItem= cboProperties(0).ComboItems.Add(,,"SQL_ASCII","encoding", "encoding")objItem.Selected=True cboProperties(0).ComboItems.Add,,"EUC_JP", "encoding","encoding"cboProperties(0).ComboItems.Add, ,"EUC_CN","en
 coding",
&
nbsp;"encoding" cboProperties(0).ComboItems.Add,,"EUC_KR","encoding", "encoding"cboProperties(0).ComboItems.Add,,"EUC_TW", "encoding","encoding"cboProperties(0).ComboItems.Add, ,"UNICODE","encoding","encoding" cboProperties(0).ComboItems.Add,,"MULE_INTERNAL","encoding", "encoding"BR;cboProperties(0).ComboItems.Add,, "LATIN1","encoding","encoding" cboProperties(0).ComboItems.Add,,"LATIN2","encoding", "encoding"cboProperties(0).ComboItems.Add,,"LATIN3", 
 p;
"
encoding","encoding"cboProperties(0).ComboItems.Add, ,"LATIN4","encoding","encoding" cboProperties(0).ComboItems.Add,,"LATIN5","encoding", "encoding"cboProperties(0).ComboItems.Add,,"KOI8", "encoding","encoding"cboProperties(0).ComboItems.Add, ,"WIN","encoding","encoding" cboProperties(0).ComboItems.Add,,"ALT","encoding","encoding"
thisversionisaproblemtocustom encodignintoprogram.Fornewencodignmodifyprogramtoaddnew 
 sp;encod
i
gn
Forreadingautomatlyencodign usignthiscode:/P 
DimrsSQLAsNewRecordsetDim bIsValidAsBoolean
'Loadthe EncodingSchemesbIsValid=TrueX =0While bIsValidSetrsSQL= frmMain.svr.Databases("template1").Execute("selectpg_encoding_to_char(" X")")If 
 sp;rsSQL
.
Fields(0).Value=""ThenbIsValid= FalseIfbIsValid ThenIf X=0 Then cboProperties(0).Text= rsSQL.Fields(0).Value SetobjItem=cboProperties(0).ComboItems.Add(,,rsSQL.Fields(0).Value, "encoding", "encoding") objItem.Selected= True
 ;&
n
bsp; Else cboProperties(0).ComboItems.Add,,rsSQL.Fields(0).Value,"encoding", "encoding" EndIfEnd IfX=X+ 1Wend

bye!!

FrankLupo
Bye!!FrankLupo
 sp;(Wolf
)
!! 
PrendiGRATISl'email universaleche...risparmia:cliccaqui Sponsor:Tuffatiinunmondodioccasionid'oro...Cliccaqui








Bye !!
Frank Lupo (Wolf) !!


Prendi GRATIS l'email universale che... risparmia: clicca qui 

Sponsor:
Sei un webmaster, vuoi guadagnare? Affiliati ad Artefiori. Clicca qui!
Clicca qui

Re: [pgadmin-hackers] idea for reading encodign format

2002-09-10 Thread frank_lupo

I usingPostgreSQL 7.2
template1=# select version(); versionPostgreSQL 7.2 on i686-pc-cygwin, compiled by GCC 2.95.3-5(1 row)


Itriedon2 systems:

template1=#select versin(); version
 
-
-PostgreSQL 7.3b1oni686-pc-cygwin,compiledbyGCC2.95.3-5(1row)

template1=#select pg_encoding_to_char(0)template1-#unionselect pg_encoding_to_char(1)template1-#unionselect pg_encoding_to_char(2)template1-#unionselect pg_encoding_to_char(3)template1-#unionselect pg_encoding_to_char(4)template1-#unionselect pg_encoding_to_char(5)template1-#unionselect pg_encoding_to_char(6)template1-#unionselect pg_encoding_to_char(7)template1-#unionselect pg_encoding_to_char(8)template1-#unionselect pg_encoding_to_char(9)template1-#unionselect pg_encoding_to
 _char(10
)
template1-#unionselect pg_encoding_to_char(11)template1-#unionselect pg_encoding_to_char(12)template1-#unionselect pg_encoding_to_char(13)template1-#unionselect pg_encoding_to_char(14)template1-#unionselect pg_encoding_to_char(15)template1-#unionselect pg_encoding_to_char(16)template1-#unionselect pg_encoding_to_char(17)template1-#unionselect pg_encoding_to_char(18)template1-#unionselect pg_encoding_to_char(19)template1-#unionselect pg_encoding_to_char(20)template1-#unionselect pg_encoding_to_char(21);pg_encoding_to_char-EUC_CNEUC_JPEUC_KREUC_TWJOHABKOI8LATIN1LATIN10LATIN2LATIN3LATIN4LAT
 IN5&
n
bsp;LATIN6LATIN7LATIN8LATIN9MULE_INTERNALSQL_ASCIITCVNUNICODEWIN1256WIN874(22 rows)

and

template1= select version(); version---PostgreSQL 7.2oni686-pc-linux-gnu,compiledbyGCCegcs-2.91.66(1&
 nbsp; ro
w
)

template1= selectpg_encoding_to_char(0)template1-unionselect pg_encoding_to_char(1)template1-unionselect pg_encoding_to_char(2)template1-unionselect pg_encoding_to_char(3)template1-unionselect pg_encoding_to_char(4)template1-unionselect pg_encoding_to_char(5)template1-unionselect pg_encoding_to_char(6)template1-unionselect pg_encoding_to_char(7)template1-unionselect pg_encoding_to_char(8)template1-unionselect pg_encoding_to_char(9)template1-unionselect pg_encoding_to_char(10)template1-unionselect pg_encoding_to_char(11)template1-unionselect
 p; pg_en
c
oding_to_char(12)template1-unionselect pg_encoding_to_char(13)template1-unionselect pg_encoding_to_char(14)template1-unionselect pg_encoding_to_char(15)template1-unionselect pg_encoding_to_char(16)template1-unionselect pg_encoding_to_char(17)template1-unionselect pg_encoding_to_char(18)template1-unionselect pg_encoding_to_char(19)template1-unionselect pg_encoding_to_char(20)template1-unionselect pg_encoding_to_char(21);pg_encoding_to_char-SQL_ASCII(1 row)

The7.2systemwas
  compile
d
withoutmultibytesupport.In7.3,multibyteisalwayson.Iguess itprobablydoesn'tmattermuchasit'sobviouslygivingonlyusefulencodings, theproblemisthis(onthe7.2system):

template1= select pg_encoding_to_char(45);pg_encoding_to_char-SQL_ASCII(1 row)

template1= select pg_encoding_to_char(450);pg_encoding_to_char-SQL_ASCII(1 row)0
D

Howwouldtheloop knowwhentogiveupandexit?

Regards, Dave.
-OriginalMessage-From:frank_lupo [mailto:[EMAIL PROTECTED]]Sent:10September2002 14:45To:DavePage<
 B>Cc:
pgadmin-hackersSubject: RE:[pgadmin-hackers]ideaforreadingencodignformat


Ireplacethiscodeinfrmdatabasepgadmin2.Idon'thavethisproblem. 
Whatisyourresultifyouexecutethisselection?
selectpg_encoding_to_char(0)
unionselectpg_encoding_to_char(1)
unionselect pg_encoding_to_char(2)
unionselect
&
nbsp; pg_encoding_to_char(3)
unionselect pg_encoding_to_char(4)
unionselect pg_encoding_to_char(5)
unionselect pg_encoding_to_char(6)
unionselect pg_encoding_to_char(7)
unionselect pg_encoding_to_char(8)
unionselect pg_encoding_to_char(9)
unionselect pg_encoding_to_char(10)
unionselect pg_encoding_to_char(11)
unionselect pg_encoding_to_char(12)
unionselect pg_encoding_to_char(13)
unionselect pg_encoding_to_char(14)
unionselect pg_encoding_to_char(15)
unionselect pg_encod!ing_to_char(16)
unionselect pg_encoding_to_char(17)
unionselect pg_encoding_to_char(18)
unionselect pg_encoding_to_char(19)
unionselect pg_encoding_to_char(20)
unionselectpg_encoding_to_char(21)
Myresultis:
pg_encoding_to_char-ALTEUC_CNEUC_JPEUC_KREUC_TWISO_8859_5ISO_8859_6KOI8LATIN1LATIN10LATIN2
 sp;LATIN
3
LATIN4LATIN5LATIN6LATIN7LATIN8LATIN9MULE_INTERNAL! nbsp;SQL_ASCIIUNICODEWIN(22rows)
Theorderisnotbynumberencoding.
 
HiFrank,

Hmm,thatdoesn'tseemtoworkhere.ForanyrandomintegervalueofX 
 p;
&
nbsp;thatItryinselectpg_encoding_to_char(X),IgetSQL_ASCIIasthe result.

This isaproblemIwouldliketofix,thoughIdon'thavetimemyselfrightnow :-(

Regards,Dave.
 <
/
DIV> 
 -OriginalMessage-From:frank_lupo [mailto:[EMAIL PROTECTED]]Sent:09September2002

[pgadmin-hackers] idea for reading encodign format

2002-09-09 Thread frank_lupo

for reading encodign format current version is:
 'Load the Encoding Schemes cboProperties(0).Text = "SQL_ASCII" Set objItem = cboProperties(0).ComboItems.Add(, , "SQL_ASCII", "encoding", "encoding") objItem.Selected = True  cboProperties(0).ComboItems.Add , , "EUC_JP", "encoding", "encoding" cboProperties(0).ComboItems.Add , , "EUC_CN", "encoding", "encoding" cboProperties(0).ComboItems.Add , , "EUC_KR", "encoding", "encoding" cboProperties(0).ComboItems.Add , , "EUC_TW", "encoding", "encoding" cboProperties(0).ComboItems.Add , , "UNICODE", "encoding", "encoding" cboProperties(0).ComboItems.Add , , "MULE_INTERNAL", "encoding", "encoding"<
 BR>
;
 cboProperties(0).ComboItems.Add , , "LATIN1", "encoding", "encoding" cboProperties(0).ComboItems.Add , , "LATIN2", "encoding", "encoding" cboProperties(0).ComboItems.Add , , "LATIN3", "encoding", "encoding" cboProperties(0).ComboItems.Add , , "LATIN4", "encoding", "encoding" cboProperties(0).ComboItems.Add , , "LATIN5", "encoding", "encoding" cboProperties(0).ComboItems.Add , , "KOI8", "encoding", "encoding" cboProperties(0).ComboItems.Add , , "WIN", "encoding", "encoding" cboProperties(0).ComboItems.Add , , "ALT", "encoding", "encoding"
this version is a problem to custom encodign into program. For new encodign modify program to add new encodign
For reading automatly encodign usign this code
 :
<
/P>
Dim rsSQL As New RecordsetDim bIsValid As Boolean
 'Load the Encoding Schemes bIsValid = True X = 0 While bIsValid Set rsSQL = frmMain.svr.Databases("template1").Execute("select pg_encoding_to_char("  X  ")") If rsSQL.Fields(0).Value = "" Then bIsValid = False If bIsValid Then If X = 0 Then cboProperties(0).Text = rsSQL.Fields(0).Value Set objItem = cboProperties
 (0).Comb
o
Items.Add(, , rsSQL.Fields(0).Value, "encoding", "encoding") objItem.Selected = True Else cboProperties(0).ComboItems.Add , , rsSQL.Fields(0).Value, "encoding", "encoding" End If End If X = X + 1 Wend

bye !!

Frank Lupo


Bye !!
Frank Lupo (Wolf) !!


Prendi GRATIS l'email universale che... risparmia: clicca qui 

Sponsor:
Tuffati in un mondo di occasioni d'oro...
Clicca qui

[pgadmin-hackers] problem save db schema

2002-09-05 Thread frank_lupo

When save a db schema the schema containa TEMPORARY object of database.
E.g Table,sequence


Bye !!
Frank Lupo (Wolf) !!


Prendi GRATIS l'email universale che... risparmia: clicca qui 

Sponsor:
Conto Arancio, il migliore amico dei tuoi risparmi.
Clicca qui

[pgadmin-hackers] depending idea

2002-06-05 Thread frank_lupo


if possible add new folder similar statics for denending object?
e.s
in table view a domain
in view view a table
in function view a table or view
ecc...

the modality is two
Show Dependent Object
Show Depended On Object


Bye !!
Frank Lupo (Wolf) !!



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

Sponsor:
Sai cosa è una lampada di sale? scoprilo qui:
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=373d=5-6

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

Documentations method and member pgadmin vb

2002-03-11 Thread Frank_Lupo Frank_Lupo


For documentations the public methods and memebers for class
use the vbdox.
This programs read the tags of source and generate the html documentation. Is very 
good.


http://sourceforge.net/projects/vbdox/

Bye
--
Frank Lupo (Wolf) !!

Questo messaggio e' stato inviato con Telemail http://www.telemail.it , 
La freemail per la comunicazione unificata gratuita

63 matches

Mail list logo