Reading Ftp filepath from database Table

Former Member — Fri, 19 Jul 2013 13:45:14 GMT

Hello Experts,

today i come up with one interesting Question ..lolz

i want to read file-path from database table.

i just do that using the code below

data: filepath3 type string,
         filepath2 type ZFILEPATH.
 select single * from zfilepath into filepath2 . 
    filepath3 = filepath2-filepath.

i.e. the file path is /sapmnt/EQS/photos/ (case sensitive).

but when i put this path in my database table field it automatically changes to capital letter. so how can i solve this or is there any other solution to read ftp file path from database table?

this is the whole ftp path

ftp://svhqeqs01/sapmnt/EQS/photos/
with credentials 
username: test123
pass: test123

appreciate your fast response!!

best regards,

Re: Reading Ftp filepath from database Table

venkateswaran_k — Fri, 19 Jul 2013 17:39:36 GMT

Please check the domain charactertics of your type ZFILEPATH.

Probbably you might have specified as ALL CAPS.

Use the Normal Char variable instead of type ZFILEPATH.

I think you might have copied the standard table FILEPATH to ZFILEPATH.

Try not to use that domain PATHINTERN. Instead use normal char/string data element.

In the standard PATHINTERN domain, the check box lowercase is not checked. so it always convert to Upper Case.

So you need to copy the PATHINTERN to ZPATHINTERN and use that domain in your ztable

Regards,

Venkat

topic Reading Ftp filepath from database Table in Application Development and Automation Discussions

Reading Ftp filepath from database Table

Re: Reading Ftp filepath from database Table