Messages

1

Web Server - Ask For Help / 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(,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]