Topic Options
#24685 - 10/02/09 11:01 AM Select table mdb script
gbelmm Offline
Junior Member

Registered: 08/26/09
Posts: 12
Loc: chile
FileOpen Test.psm5

FilePrint

DatabaseOpen Test1.mdb

FilePrintTo

You can select a specific table with this

Top
#24686 - 10/02/09 11:30 AM Re: Select table mdb script
Anonymous
Unregistered


gblemm,

No you cannot. PrintShop Mail only supports a single table inside the MDB. When you use Automation to select an MDB database (or SQL or Excel for that matter), PrintShop mail will select the same table as what you previously selected when opening that database in PrintShop Mail.

For example, if you have "test.mdb" with two tables: "table1" and "table2", when you open this database in PrintShop Mail it will ask you which table to select. When you start automation, that's the table it will use.

I'm not sure what happens if you use a database that's never been opened through PrintShopMail, I'm assuming it will try to look for the table name it knows and if it doesn't find it, either take the first table in the database or simply fail to initiate the job.

However, the point is that the best practice when using PrintShop Mail is to only have one table in your database; this is how it was programmed and that is how it is meant to be used.

Hope this helps,
Eric.

Top
#24687 - 10/02/09 02:54 PM Re: Select table mdb script
gbelmm Offline
Junior Member

Registered: 08/26/09
Posts: 12
Loc: chile
ok


thank

Top
#24688 - 10/05/09 03:14 AM Re: Select table mdb script
Sander vd Berg Offline
OL Expert

Registered: 06/10/08
Posts: 197
Loc: Objectif Lune NL
DatabaseOpen will always select the first table.

I realize this doesn't help right now, but just so you know, the next release of PSM will allow you to select different tables in an automated process. It offers a new script command DatabaseSelectTable which you can call after calling DatabaseOpen.

Top
#24689 - 10/05/09 11:41 AM Re: Select table mdb script
gbelmm Offline
Junior Member

Registered: 08/26/09
Posts: 12
Loc: chile
thanks

wait the next release

Top