# Thread: Email attachment in subdir

1. ## Email attachment in subdir

I want to send a table (car.dbf) as attachment. The table is in a subdirectory of the database (\to_send)
This means that the table I want to send (car.dbf) is
in folder "E:\Alpha5_appl\test\to_send" (a subfolder of the application)

Results:

1) with partial path:
table.send("\to_send\test2","","CDP",.f.,.t.,.t.) gives-"
(there is no trace of the subdirectory 'to_send' in the error printed by A5)

2) with full path:

table.send("E:\Alpha5_appl\test\to_send\test2","","CDP",.f.,.t.,.t.) gives -"
(Here also, there is no trace of the subdirectory 'to_send' in the error printed by A5)

In the Apha five xbasic manual I read: If the table specified by "tablename" is in the current database, it is not necessary to specify the full drive and path.
So I suppose if I specify the full path it should work... ;(

This happens in:

Alpha Five V5.0 build 1506, system Addins build 1058 and
Alpha Five V6.0 build 1532, system Addins build 2003 (not the latest one)

Is this a program error or am I missing something?

Tassos

2. ## RE: Email attachment in subdir

There was a mistake in my transcript in the following lines:
table.send("\to_send\test2","","CDP",.f.,.t.,.t.) gives-"

the "test2" should of course be "car" as follows:
table.send("\to_send\car","","CDP",.f.,.t.,.t.) gives-"

Thank you
Tassos

3. ## RE: Email attachment in subdir

Try this....
Code:
table.send("E:\Alpha5_appl\test\to_send\test2.dbf","","CDP",.f.,.t.,.t.)
There is no way that this would work, since you are telling A5 to look for a file called test2 in the ROOT of the current drive:
Code:
table.send("\test\to_send\test2","","CDP",.f.,.t.,.t.)

4. ## RE: Email attachment in subdir

Aaron,

I still can not figure out what I'm doing wrongly.
if the table is in the same dir as the application, it is Ok
but if I move the table in the subdir of the application then I get the error.
I'm attaching you some screenshots of the directories involved and also the test appl.
Of course I can always bypass this way and copy my file in the appl. dir, but I wonder what error I'm doing.

The program runs under window 2000 (server edition)

Thank you very much for your time.
Tassos

5. ## RE: Email attachment in subdir

How did you create the test table? I see you have

test2.dbf
test.ddd
test.ddm
test.ddx

Where are test.dbf and test2.ddd, test2.ddm, test2.ddx? It appears that you tried to rename just the .dbf file through windows explorer or something.

You cannot simply rename the dbf file by itself and expect everything to behave normally. To rename a table, right click on it in alpha five and choose 'rename.' Get rid of these garbage tables, create a new test table with alpha five and try again. If it still doesn't work, let me know.

6. ## RE: Email attachment in subdir

Thank you very much for your guidance.
I trace my error back to the following error:

I use the a_tbl.copy() in xbasic to create a new table
for selected records:

copy.set = ""
copy.db = weg+chr(92)+"to_office"+chr(92)+nom_file1
copy.dd = .F.
copy.delete_o_dd = .T.
copy.records = .T.
copy.fields = 138
copy.field1 = "Trip_Code"
copy.field2 = "Trip_Nr"
copy.field3 = "Leg_Nr"
...

copy.field138 = "L6"
a_tbl.copy()

Now, this creates the table correctly in the selected directory,
BUT of course this will not load (or import the table in the database)
(this means that it is not shown in the control panel under Tables/sets of this database)

Therefore I should not use the table.send() command, unless I first add this new table to the database.

Instead using the email_client() command will work.

Am I correct to state that:
An exported Table isn't anymore a table but just a file, as it doesn't belongs to the database anymore.

thanks,
Tassos

PS. As you probably know, I am living in Athens(Greece) from where I write you all these emails. So If you or any of your staff ever happens to pass, pls let me know.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•