How are people copying files (images or other files) from Appeon Mobile apps to their server?
I am trying trying to use UPDATEBLOB to store the image in the database but the below code is throwing the following error: "Error Code: 10999. Object refrence not set to an instance of an object" at the insert statement. This statement works from PB Desktop without issue.
String ls_filepath Integer li_return blob l_blob_file int l_file_handle eon_mobile_str_cameraoption lstr_option eon_mobile_cameraex ln_camera lstr_option.i_filetype = 1 // Photo lstr_option.b_allowedit = FALSE // The photo is not editable after picture-taking ln_camera = create eon_mobile_cameraex ln_camera.of_openalbums ( ls_filepath ) // i also tried ln_camera.of_openalbums ( ls_filepath, l_blob_file) MessageBox('',ls_filepath) l_file_handle = FileOpen(ls_filepath, StreamMode!) MessageBox('','Handle: ' + String(l_file_handle)) IF l_file_handle <> -1 THEN MessageBox('Info','Reading File') FileRead(l_file_handle, l_blob_file) MessageBox('Info','Closing File') FileClose(l_file_handle) MessageBox('Info','Inserting Blob to database') // this is where it is failing UPDATEBLOB storage_blobs SET FileBlob = :l_blob_file WHERE storage_blobs.ID = 2 USING SQLCA; MessageBox('Info','Inserting Blob to database done') Else MessageBox('Error','Cannot get handle on file') END IF IF SQLCA.SQLNRows > 0 THEN COMMIT USING SQLCA ; Else MessageBox('Error','Cannot insert blob to database') END IF p_1.picturename = ls_filepath // this works
I was hoping to avoid using the File Upload and Download feature due to how our client's internal servers are setup. Don't want to have to recopy the file from the Appeon Server machine to another machine etc. but if this is the only way it can be done... Ideally I'd love to be able to upload it to a SOAP Webservice using a byte array but I've had issues doing this too.
Is it possible to use UpdateBlob like above (connecting to a ms sql database) or can anyone spot why this is failing.