Home > Archive > Clarion > July 2004 > How do I copy a BLOB to another TPS file?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How do I copy a BLOB to another TPS file?
|
|
| Arnett, James 2004-07-09, 8:55 am |
| I have two identical TPS files (USA.tps & Canada.tps) where I copy the
corresponding fields as:
USA:Location = CAN:Location ! string fields
USA:Date = CAN:Date ! date fields
USA:Blob = CAN:Blob ! BLOB binary checked fields
ADD(Canada)
All of the fields copy properly but the line with the Blob fields
generate an error, saying, "Variable expected."
Does anyone know if there's any extra stuff I need to do to get the
Blob field to copy to a corresponding Blob field in another file?
What's the trick?
Thanks!
James
| |
| Jason Berkan 2004-07-09, 3:55 pm |
| On 9 Jul 2004 01:23:31 -0700, james@jamesarnett.com (Arnett, James)
wrote:
>I have two identical TPS files (USA.tps & Canada.tps) where I copy the
>corresponding fields as:
>
>USA:Location = CAN:Location ! string fields
>USA:Date = CAN:Date ! date fields
>USA:Blob = CAN:Blob ! BLOB binary checked fields
>ADD(Canada)
I imagine this is just a data entry mistake, but you are assigning the
USA fields and then adding a record to the Canada file...
>All of the fields copy properly but the line with the Blob fields
>generate an error, saying, "Variable expected."
You cannot directly access BLOBs. From the online help on BLOB:
USA:Blob{PROP:Handle} = CAN:Blob{PROP:Handle}
Jason
| |
| Arnett, James 2004-07-09, 8:55 pm |
| Thanks Jason, that did the trick!
Jason Berkan <jason_berkan@canada.com> wrote in message
>
> You cannot directly access BLOBs. From the online help on BLOB:
>
> USA:Blob{PROP:Handle} = CAN:Blob{PROP:Handle}
>
> Jason
|
|
|
|
|