Use of Object Store

rschnell · 09-12-2021 05:18 AM

I am trying to use an object store instead of the file system.

To test it I have adapted to DocUpload sample to use my object store. Of course with the normal Google store it works fine.

My SQL server object store has two columns, FileName nvarcharmax(255) and File varbinary(max)

I have set the object store to be called “blobs” and in the samples data for the app sample I have set the storage to “blobs”

saving an image causes NO records to be stored in “blobs”. (or anywhere else for that matter)

then I also read that only two fields/columns will be used in an object store. So even if I got it to work, how would I for example create a reference to the one stored blob so that it can be the child of something?

Finally should it work also for eg a PDF file in the same store?

rschnell

Sorry unfortunate wording … the sql is MSSQL not MySQL ! I routinely have used this kind of storage successfully in MSSQL.

Steve

rschnell

How does that help? What I am saying is it doesn’t work as stated … as tested with the sample app.

Steve

I have no experience with object stores, so the only thing I can offer is the available documentation. I don’t recall too much discussion of object stores here in the community, so I imagine you won’t find much searching here. I’m not aware of any prominent community members that use object stores, so I don’t know whether you’ll get much of a response. You may just want to contact Support (and mention that the docs are lacking).

https://www.appsheet.com/Support/Contact

rschnell

Thank you for that advice.

Tomorrow I will post a detailed description of the steps with some illustrations and see what happens. I can send that to support too.

rschnell

Here is the exact scenario.

The working example:

Data Structure in Appsheet

Default Store in Appsheet

Data in MSSQL - OK!!

Change the store to be “blobs” instead of “default”

Here is the MSSQL “Blobs” structure and has no data, nothing is stored there after running the app.

“FileImage” column matches the original appsheet image column

“ImageDescription” matches the Appsheet FileImage and ImageDescription columns.

rschnell

Aha! Of course In this expanded example I need to make sure the blob store has all the appsheet fields because I now see in the log:

“Errors”: "DiagnosticFrameworkWrapper.CustomerFacingException: One or more SQL Server errors has been encountered:\nA column in your AppSheet table does not exist in your SQL Server table. Please make sure that all columns in your AppSheet table (except virtual columns) exist in your SQL Server table.\r\n

Will try this.

Now the tables exactly match except the image and file columns are varbinary

And … I get the same error