How create file from lcflfieldlist with binary field

HCL Domino Domino Forum
1

I have obtained a blob field from Oracle in a LCFieldList. I need create a file in a path (for example "c:") with the contents of the binary field in the lcfieldlist.I have attempted this:

Dim trg As New LCConnection(“file”)

trg.Database = sUnidad

trg.Metadata=sRuta

trg.binary=True

trg.Connect

Set flFiles = New LCFieldlist

'I obtain the blob in the flDest variable (type lcffieldlist)

Call flFiles.MapName(flDest,“CampoEnriquecido”,“Contents”)

Call trg.Insert(flFiles)

But an error occurs.

Any idea?

Thanks in advanced

2

Subject: How create file from lcflfieldlist with binary field

It’s hard to help you when you don’t say what error you are getting or on what line of code.

I suggest you use the DebugStr function to test what data are in your fieldlists.

The file connector is also discussed in the LEI Redbook.

It looks like maybe your fieldlist flfiles only contains a Contents column. You also need a filename to do an Insert.

3

Subject: RE: How create file from lcflfieldlist with binary field

Messages is not reported. Only de Lotus Notes Client is closed or the domino server is blocked if is executed from server agent.I have tried with FileName and TimeStamp too but the result is the same.

I will try use de debugstr but I think that the contents field is good because this content was inserted to the blob field from notes.

Thanks you.