NetTalk Central

Author Topic: WebService example 77 GPF on Insert  (Read 5011 times)

Alberto

  • Hero Member
  • *****
  • Posts: 1873
    • MSN Messenger - alberto-michelis@hotmail.com
    • View Profile
    • ARMi software solutions
    • Email
WebService example 77 GPF on Insert
« on: July 02, 2019, 01:17:49 PM »
Just compile server and client and try to insert a record.
But only if you complete the "Notes" field
May be because its a memo field?
NT11.14
see pic

Im just testing to receive a blob... that said... how to send a blob in a soap request with NT/xFiles?
What type of field to use in a queue? or may be has to be made hand coded?

« Last Edit: July 02, 2019, 01:58:24 PM by michelis »
-----------
Regards
Alberto

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11251
    • View Profile
Re: WebService example 77 GPF on Insert
« Reply #1 on: July 02, 2019, 10:38:22 PM »

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11251
    • View Profile
Re: WebService example 77 GPF on Insert
« Reply #2 on: July 02, 2019, 11:08:06 PM »
Hi Alberto,

There were a couple small (mostly cosmetic) things I needed to do to update that app, but unfortunately I was not able to duplicate the GPF. Perhaps you changed the dict (from a memo to a blob?).

Blobs are a little complicated because they are not at all like Memos, and not at all like any other field type.
How you deal with them depends a little bit on the context of what you have in mind. Plus of course you have to deal with them on both the client side, and the server side.

I'll expand the example a bit to show the use of a blob field for the next build.

cheers
Bruce

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11251
    • View Profile
Re: WebService example 77 GPF on Insert
« Reply #3 on: July 03, 2019, 02:46:05 AM »
>> how to send a blob in a soap request with NT/xFiles?

do you mean a "blob in a table" - so you are constructing your xml from a Table or View?
Or do you mean as in "some binary data" - like an image file loaded from the disk?

And how married are you to SOAP and XML? This is a _lot_ easier to do in JSON (because jFiles already knows about StringTheory.)

cheers
Bruce

Alberto

  • Hero Member
  • *****
  • Posts: 1873
    • MSN Messenger - alberto-michelis@hotmail.com
    • View Profile
    • ARMi software solutions
    • Email
Re: WebService example 77 GPF on Insert
« Reply #4 on: July 03, 2019, 09:02:12 AM »
1-Regarding the example I only add a GUIDblob field, string(16) to the customer table and a File to store the blobs.
The error is because of the memo field, no doubt.
Attached goes the modified example.

2-Ive made an android app using Basic4Android, the app is now consuming a NT web service without problem using XML, no problem to use Json.
The app, when connected reads a database, for each record on this database the user has to take a picture, this may be done disconnected, Im using Sqlite for store the image as a blob.
Then when the app can be connected again the app needs to update the server database records with the taken pic.

Then I need a way to send the Sqlite blob to the NTwebservice and store it in the database.
-----------
Regards
Alberto