Re: [pgadmin-hackers] new export access

2003-02-17 Thread Dave Page


> -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.

- No status is displayed - it appeared to hang whilst copying my data.

Do you have time to fix these please?

Thanks, Dave.

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



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=840&d=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 Dave Page


> -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 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?

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



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=367&d=17-2


access.zip
Description: Zip compressed data

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