Messages

1

Web Server - Ask For Help / Re: example 79 in 11.21

« on: June 12, 2020, 01:20:34 PM »

Android

2

Web Server - Ask For Help / Re: example 79 in 11.21

« on: June 12, 2020, 12:31:02 PM »

I even succeeded to read Code39 from my phone.
From notebook, only string field appeared . As I know, never said not to use camera.
I hope it helped  you in some way.

3

Web Server - Ask For Help / Disconnedted app, Browse

« on: May 20, 2020, 11:26:42 PM »

Hi,

1.  In disconnected app, there is a need to link two tables in browse. Dictionary link MANY:1 was set.  ,
There are three fields in browse ( ID , IDparent, IDparentDesc) . Column IDparent was filled with a false value.
IDparentDesc column is empty. Where can I put code to check values, or to manually put code for linking tables?
Any kind of example will be appreciated.
2. I'm browsing 1500 rows.  Very slow on mobile (file loaded) . The same browse on WebServer version with page load looks very nice.
Thanks to jking and his Coin  example I have a filter. Where to put a code for initial filter '1=2' , to display "nothing" on the mobile version?


Amer

4

Web Server - Ask For Help / Re: Phone app Server sync

« on: May 20, 2020, 10:57:49 PM »

Hi Bruce,

The problem was in me of course.  I use MS SQL server database. Point is that I didn't put the unique key in the table , as I mention that in Clarion dictionary. After trying to sync that data with IndexedDB, only one row was synced. What did I expect?

Thanks again for the reply.

Amer

5

Web Server - Ask For Help / Phone app Server sync

« on: May 14, 2020, 05:02:14 AM »

Hello,

I think that I followed steps for creating a phone app with sync to the server.
Created Admin app only
 Sync app
 Phone app
In Admin app I inserted 1500 rows for warehouse inventory, with server code.
Required columns are there GUID,sts,ts,dts.
sts=p_web.GetElapsedTimeUTC()
ts=sts

Problem is that when I start the phone app + sync , my 1499 rows didn’t synchronize on phone ,but just one row.
I really don’t know what is a condition for that “randomly” row.
Application is with initial settings, so as far as I know there are no sync filters .
Let me mention that when I insert a row on phone , it’s automatically synced with the server.
Point is that the phone needs to make updates on rows, which has to be sync to server.

Any help?

6

Web Server - Ask For Help / Re: Phone app, Javascript, Database functions

« on: May 04, 2020, 06:24:20 AM »

I agree with that. You have more experience on forum.

BTW, after some  time I got some "result" after Get, realized with idbGetBy (nt-idb.js) .

function Buttonclick(locean){
   idbOpen(database);
   let x=locean;    //"02400"
   database.xinvent.record.eankod =locean ;     //"02400";
   idbGetBy(database,database.xinvent,"eankod",x,   
      function(){ // got record         
         $("#locdescription").val(database.xinvent.record.description);

         $("#locdescription").change();
      }
   );
};
This is a first part. It works only  with fixed value (  "02400") , but not with locean . It has to be passed parameter , called with button OnClick as
'Buttonclick(locean)' . locean is a form string field.
In Chrome source I get:
x = input#locean.nt-entry.ui-corner-all {jQuery341069521962941633861: {…}, accept: "", alt: "", autocomplete: "off", defaultChecked: false, …}, locean = input#locean.nt-entry.ui-corner-all {jQuery341069521962941633861: {…}, accept: "", alt: "", autocomplete: "off", defaultChecked: false, …}

Also, I saw that idbGetBy is a special case of idbSelect, and their options: to, equal, limit ...
More about that.
With explaining of nt-idb.js, phone projects, will not more exist a a problem.


Amer

7

Web Server - Ask For Help / Phone app, Javascript, Database functions

« on: May 01, 2020, 08:21:33 AM »

I’m trying to create phone project.    
It should be looks like fixed assets inventory in few steps:
Fill denormalized table on server from original assets table
Sync on phone
On memory form,with barcode reader to find existing asset and display their description on another “description” field. If it exists to update “found ” column, if not to add another row in assets table.

Problem is of course with javascript . On Scanner tab I would like to call javascript function
‘clicked(locEAN)’.
Is there any javascript example with comments on implementing database commands
idbAdd, idbPut,idbGet , etc .
 Point is that locEAN is member of UniqueKey KlocEAN , not GUID column.
 In all definitions of database functions , only GUID column is mentioned.

I would like to have  Clarion “like” commands:
open, close, set, get, add, put,delete .

Any help?