Re: Newbie: MS Word + MyODBC + MySQL

2002-01-29 Thread Felix Schepmann

Hello Mr.Venu,

yes, of course, I took a look at it and I checked this out. It was quite
useable for mass-mailings, but not for single letters.
e.g. My database contains a lot of adresses. I created a dialogbox, where I
enter a name and now the corresponding adress will be looked up in th DB.
now if mysql returned only one row, a *.DOT document is loaded and I cut and
past each part of the adress from my hidden SQL result into the letterhead.
Problem is, that I have to use a second document for keeping the SQL-Result
and - which is a larger Problem - I cannot update any DB records.

regards,

Felix



- Original Message -
From: Venu [EMAIL PROTECTED]
To: Felix Schepmann [EMAIL PROTECTED]
Sent: Saturday, January 26, 2002 8:10 PM
Subject: RE: Newbie: MS Word + MyODBC + MySQL


 Hi,

  -Original Message-
  From: Felix Schepmann [mailto:[EMAIL PROTECTED]]
  Sent: Saturday, January 26, 2002 12:21 AM
  To: [EMAIL PROTECTED]
  Subject: Newbie: MS Word + MyODBC + MySQL
 
 
  Hi There !
 
  I am quite new to this MyODBC topic, though I am used to create Perl
  programs connecting to MySQL DBs. Currently I am able to fetch rows from
the
  DB via MyODBC and show them in a blank document as a table.
 
  Usually this is how I add data into my documents (like invoices, etc.):
 
  I open a new document, get the data into a blank table, get the contents
of
  the table and then copy and paste the data into my document.
 
  Is there a better way, to get the data from the DB, e.g. using the DB
  directly as a datasource?
  Is there a way how I can update the DB with new data, e.g. write some
kind
  of front-end within Word's VB ?
 
  IS there a FAQ for all my Word-questions?
 

 Did u had a time to look into the following section of the manual
 under 'WORD'.

 http://www.mysql.com/doc/M/y/MyODBC_clients.html

 Regards, Venu
 --
 For technical support contracts, go to https://order.mysql.com
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /   Mr. Venu [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
 /_/  /_/\_, /___/\___\_\___/  California, USA
___/  www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Newbie: MS Word + MyODBC + MySQL

2002-01-26 Thread Felix Schepmann

Hi There !

I am quite new to this MyODBC topic, though I am used to create Perl
programs connecting to MySQL DBs. Currently I am able to fetch rows from the
DB via MyODBC and show them in a blank document as a table.

Usually this is how I add data into my documents (like invoices, etc.):

I open a new document, get the data into a blank table, get the contents of
the table and then copy and paste the data into my document.

Is there a better way, to get the data from the DB, e.g. using the DB
directly as a datasource?
Is there a way how I can update the DB with new data, e.g. write some kind
of front-end within Word's VB ?

IS there a FAQ for all my Word-questions?

regards, Felix.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php