Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
1
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
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
2
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?
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?
3
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?
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?
Pages: [1]