|
| Iniciado por guest, 27,sep. 2015 14:29 - 9 respuestas |
| |
| | | |
|
| |
| Publicado el 27,septiembre 2015 - 14:29 |
Hi all,
I need a help...I have several excel files and PDF files..
First I need to save them in the databse, so i created db item with type as "sound,image,binary " ..but i am unable to store those files just like images...Need a solution
Then I need to retrieve those files from DB and want to display as excel worksheet or pdf file.How is it possible?? Plz suggest a solution.. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 28,septiembre 2015 - 10:34 |
| did you try with HLinkMemo / HExtractMemo fuctions? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 28,septiembre 2015 - 12:02 |
Hello Amal,
I am currently putting some finishing touches to the WXEDM open source project that does just that. The project will be available on my web site sometime in the current week.
So if you can wait a few days....
Till then, you can read the articles I already published about it (on my web site too)
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 28,septiembre 2015 - 22:33 |
Hi Amal,
You are right about the db format: sound image binary.
Look at my post on the shell execute. for getting the stuff out of the db.
To Put it in the db you can use this :
IF HLinkMemo(Verzonden_Email_bijlagen,Bijlage,TABLE_bijlagen.COL_Bijlage,hAcceptOpenedFile,"bestands omschrijving") = False THEN
Error("kan niets toevoegen", HErrorInfo())
RETURN
END
HAdd(Verzonden_Email_bijlagen)
http://doc.windev.com/…<=en-US&productversion=xxA180063c |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,septiembre 2015 - 10:08 |
Thank U Mr. Paulo,Harari and Allard..
I tried using HlinkMemo and HextractMemo...Both works fine..
Thanks & regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,septiembre 2015 - 13:55 |
| I have one more problem....I need to remove some unwanted files saved as memo in db..so how is it possible?how can I delete them?? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 29,septiembre 2015 - 16:43 |
| check the remarks section on the help of the hlinkmemo function |
| |
| |
| | | |
|
| | |
| |
| Publicado el 30,septiembre 2015 - 00:02 |
Hi
Just delete the record?
IF Hreadseekfirst( file, recordid, recordnumerto find) THEN
hdelete(file)
END
Should do the job
Regards
Allard |
| |
| |
| | | |
|
| | |
| |
| Publicado el 30,septiembre 2015 - 07:39 |
Hi
Allard..i just want to delete the memo only..to free up the memo and store a new file overthere....other contents of the entire row should b there...only that filememo link need to get deleted for storing a new file..
Paulo : I checked the remark section..but didnt work well as i expect |
| |
| |
| | | |
|
| | |
| |
| Publicado el 30,septiembre 2015 - 09:13 |
Amal,
according to the help use
HLinkMemo(db_table,db_item, filename)
to store a file in the database and
HLinkMemo(db_table,db_item, "")
to clear it |
| |
| |
| | | |
|
| | | | |
| | |
|