NetTalk Central

Author Topic: How to deal wih a "blob" field on a browse and form  (Read 2434 times)

danz26

  • Newbie
  • *
  • Posts: 1
    • View Profile
    • Email
How to deal wih a "blob" field on a browse and form
« on: October 07, 2013, 09:35:35 AM »
Below is the structure of the physical file.  In my clarion handcoded project, I set up a local variable on the form to hold value ("memotext"), then I would assign pgapprm:memos_desc{PROP:Size} = clip(len(memotext));pg_apprentice_memos{PROP:value,-1} = clip(memotext).  Right now the form is trying to use pgapprm:memos_desc and compiler gives a variable expected error.
       
pg_apprentice_memos FILE,DRIVER('ODBC','/AUTOINC=SELECT CURRVAL(''"pg_apprentice_memos_id_seq"''::regclass) /PREAUTOINC=TRUE /EMULATEAUTONUMKEY = TRUE'),OWNER(ownerstring),NAME('public."pg_apprentice_memos"'),PRE(pgapprm),BINDABLE,THREAD
pg_apprentice_memos_id_key      KEY(pgapprm:id),PRIMARY
pg_apprentice_memos_key KEY(pgapprm:pg_apprentice_id,pgapprm:memo_date,pgapprm:memo_name)
apprentice_memos_pg_apprentice_fkey     KEY(pgapprm:pg_apprentice_id),DUP
memos_desc              BLOB,NAME('"memos_desc"')
Record                  RECORD,PRE()
id                          ULONG,name('"id"')
pg_apprentice_id            ULONG,NAME('"pg_apprentice_id"')
memo_name                   STRING(20),NAME('"memo_name"')
memo_date                   DATE,NAME('"memo_date"')
attach                      STRING(255),NAME('"attach"')
updated_at                  STRING(8),NAME('"updated_at"')
updated_at_GROUP            GROUP,OVER(updated_at)
updated_at_DATE                 DATE
updated_at_TIME                 TIME
                            END
updated_by                  STRING(20),NAME('"updated_by"')
                        END
                    END                       


[attachment deleted by admin]

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: How to deal wih a "blob" field on a browse and form
« Reply #1 on: October 07, 2013, 09:55:41 PM »
at the moment there's not a lot of support for Blobs in the generated code.
You could do the same approach as your windows app (ie copy into  a local variable) in the short term, but it's something I'll take a look at as well.

cheers
Bruce