RE: switching to a different database from a DSN

2001-07-11 Thread Gregory_Griffiths
Some databases allow you to share tables form others, so you could try that, I think that it is called a Database Link. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 11 July 2001 14:18 To: [EMAIL PROTECTED] Subject: switching to a different database

RE: Array problem

2001-07-06 Thread Gregory_Griffiths
If this is going to be included in a Dropdown then you'll need to do something like : print option$cc[2]/option -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 06 July 2001 16:15 To: Griffiths, Gregory D. /here Subject: RE: Array problem At the

RE: Slow execution

2001-06-12 Thread Gregory_Griffiths
How often is the data changed ? Is it required to be 'real time' ? If not, then perhaps you could use a snapshot rather than a big query ? have you tried using indexes as well ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 12 June 2001 14:29 To:

RE: MS Access

2001-06-01 Thread Gregory_Griffiths
Try using DBI::Proxy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 11:20 To: [EMAIL PROTECTED] Subject: MS Access Dear Friends, I would like to access Microsoft Access database file ie .mdb, through perl under Unix/ Linux

RE: Quick Question

2001-05-29 Thread Gregory_Griffiths
Just try the DBD::ODBC drivers or the Win32::ODBC drivers (the latter are part of the current ActiveState distribution I think). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 29 May 2001 13:17 To: [EMAIL PROTECTED] Subject: Quick Question I have

RE: Fetching Column Names

2001-05-08 Thread Gregory_Griffiths
You can do a DESC command in SQL, although most interfaces also provide a specific way of doing this. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 08 May 2001 10:45 To: [EMAIL PROTECTED] Subject: Fetching Column Names Is it possible to fetch the

RE: unable to find cl.exe

2001-04-26 Thread Gregory_Griffiths
with the ActiveState bundle is a tool called PPM - Perl Package Manager - I suggest that you use that to get and install the DBI, it worked for me. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 26 April 2001 15:08 To: [EMAIL PROTECTED]; [EMAIL

FW: How to add records to Access

2001-04-23 Thread Gregory_Griffiths
just do a DO command with an INSERT query. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 23 April 2001 13:58 To: [EMAIL PROTECTED] Subject: How to add records to Access Can anyone tell me how to add records to an MS ACCESS database? I