HAL questions
 
Views
Replies
Last reply
rest api v2 - cannot get APVc register
is there anything special about APVc (Accounts payable) register? I get an error: not authorized to read this resource. Even though I can access all registers. Has it something to do with payments reg...
Created byAldevinas Katkus13:03 9 May 2019
96
7
09:01 5 Feb 2020
Elvis Kvalbergs
Halcust requirements for Version 8.4
Hi, Can someone please send me the requirements for modifying exiting Hal code so that it conforms with the requirements for auto-updating versions? We want to move all our customers to V8.4, but ne...
Created byUNILYNX10:52 13 July 2018
100
5
01:27 28 Dec 2019
David Delač
StringFromSet Function
Hi, I´m trying to use StringFromSet function in a WebPublic function and I doesn´t work with customized Set Ids. It is a SERP 8.4 in cloudnode, but If I start a server manually it Works perfectly al...
Created byGastón Salomone02:42 4 Dec 2018
52
3
22:39 27 Dec 2019
Omar Dottin
outer keyword in level0
I have seen in a few places the following. e.g., DoInvFormTool.hal: external outer procedure DoInvFormRowCustomizedFields(record IVVc,row IVVc,record DocVc,record SysFormatBlock,record RoundBlock,reco...
Created byAldevinas Katkus13:26 29 Oct 2018
58
4
21:12 27 Dec 2019
Swati D.
NewPeriodicTask2
I have been using NewPeriodicTask2 to import xml files for a number of different customers without any issues. I have a customer who uses the background task feature to import tab delimited order fi...
Created byLee D Papworth11:46 10 Mar 2019
86
9
20:35 24 Dec 2019
Lee D Papworth
qupdating function results in "server busy"
version 8.4 2018-07-26 (build 84192014), Windows server and Windows clients. I have a maintenance which generates PDF files from Invoices on the server. The number of PDF files generated is over 3000...
Created byAldevinas Katkus15:40 14 Jan 2019
72
3
20:15 24 Dec 2019
Swati D.
JSONGetChildNAME primitive function
Hi, I am working with json files with HAL, I have seen some primitives for JSON use, I need to know how to use this primitive JSONGetChildNAME Best regards JL Panama...
Created byicodelab05:21 9 Feb 2019
67
4
16:54 19 Dec 2019
David Delač
Sendwebrequest on export import
Hi, are there any special procedures which we could use to avoid hal crashing when trying to do an export-import of the database? HAL is crashing due to using the sendwebrequest, the customer has Real...
Created byjanis@burti.lv17:09 3 Dec 2019
60
4
09:14 19 Dec 2019
David Delač
import procedure executes in internal loop
I have a problem with 8.5 2019-09-15 (build 85321027). In 8.4 this import used to crash when I execute it second or third time in a row without restarting the SERP executable. I was advised to remove ...
Created byAldevinas Katkus08:48 9 Oct 2019
40
4
08:51 19 Dec 2019
Aldevinas Katkus
FileExists and FileSize
I have an interesting HAL problem. I have written an export, which uses CreateFile, WriteAreaToFile, and CloseFile. I am then using FileExists and FileSize to check that the file exists and is not emp...
Created byPaul Timms18:30 3 Oct 2019
55
3
09:11 5 Dec 2019
David Delač
Is there a way to programatically set what user a function runs as
When calling a webshop hal function. Is there a way to programatically set which user this function runs as ? (without the user doing a login action)...
Created byHåvar Falck-Andersen10:16 21 Oct 2019
71
4
04:02 3 Dec 2019
Swati D.
importing NotepadVc imports into wrong company
We're moving some companies from one DB to another. There is a attachments problem with customer's DB, but we have no problems with test DB. In customer's DB: Company number 107 is on row no. 91 in t...
Created byAldevinas Katkus20:49 31 Oct 2019
57
5
19:25 6 Nov 2019
Omar Dottin
Listing of fields and datatypes
Is there any routine that can be called that can give access to the list of all registers, their fields, and datatypes? The data from export/import report is exactly what I need but would like to acc...
Created byNeil00:24 11 Oct 2019
44
1
11:33 11 Oct 2019
Paul Timms
crash on updating record
My code crashes on updating customer's record. Why it happens. When I remove the pricelist from the customer in Standard ERP manually (not in HAL) it does not crash. Any ideas why it crashes? ... 2019...
Created byAldevinas Katkus15:37 19 July 2019
74
8
13:23 22 Aug 2019
Aldevinas Katkus
automatic check for referential integrity and "not null"
New ideas have just come to my mind (maybe it should be in the Other Ideas): When we define a field in a datadef.hal, we can point the table that this field refers to (kind of referential integrity): ...
Created byAldevinas Katkus08:28 14 Aug 2019
27
3
14:43 21 Aug 2019
Martin A.
"basketno" value in Webshop
I can see that basketno value is used in many places like case "addtobasket": ShopAddToBasket(GetShopProductArg,WebGetArg("qty"),WebGetArg("config"),WebGetArg("basketno")); but I cannot find...
Created byAldevinas Katkus14:53 11 Jun 2019
56
6
14:32 20 Aug 2019
Martin A.
How to upgrade registers when tag has changed
I recently upgraded a customer's system from 8.1 to 8.5. In 8.1, they have additional fields in Order Classes and Delivery Modes, added using RecordAddBegin. When these registers imported into 8.5, t...
Created byPaul Timms12:14 23 July 2019
44
2
17:49 23 July 2019
Paul Timms
Rest API - problem accessing custom register on Linux
Hi I have a strange problem with a customer's installation. I can not access custom registers through Rest API. I can access standard registers, so I know everything is set up correctly. I can acces...
Created byDavid Smerdel18:02 7 May 2019
112
13
15:40 16 July 2019
Martin A.
missing semicolon - no errors?
I have just noticed that in the file AccrualNewRn.hal there is a missing semicolon: OutString(1,0,USetStr(13562),true); EndFormat //missing semicolon here ProcessVI(RepSpec,VIr,totfwdbal,pertotde...
Created byAldevinas Katkus09:06 28 Jun 2019
17
1
11:25 1 July 2019
Martin A.
OAuth Rest API v2 - getting data from the DB
How do I get a data from the DB when I have already authenticated via OAuth2 and got an access token? I am getting an error "the resource is not allowed" when I am authorized and "not authorized to r...
Created byAldevinas Katkus10:52 4 Apr 2018
133
7
11:36 9 Apr 2019
Aldevinas Katkus
REST API Write functionality
Hello, From the REST API documentation, we are not sure if the most recent release has the functionality to allow REST API to write to the database. If yes, then is there any more documentation to sh...
Created by10:56 5 Mar 2019
131
13
08:33 3 Apr 2019
rest api v1 - fetch single record
Is it possible to fetch a single record using rest api version 1? with version 2 it is possible, I have already checked. I am fetching items register and there is a connection error on the external ap...
Created byAldevinas Katkus09:19 29 Mar 2019
33
3
16:38 1 Apr 2019
Giuseppe L.
VSVc register
What is this register used for? We have a situation where a supplier was registered in CUVc. After the record was saved a new purchase invoice was registered. Then the invoice was removed, but the su...
Created byChristoffer Riska10:23 14 Mar 2019
33
1
10:52 15 Mar 2019
Paul Timms
TLS 1.2
We have written a web based stock control system that uses a secure connection to StandardERP Our customer uses an app on their iPhones called Scan to Web. It is essentially a bar coding application ...
Created byLee D Papworth17:08 12 Mar 2019
52
3
15:09 14 Mar 2019
Lee D Papworth
Dynamically Adjusting form element before printing
Is there any way to adjust the positioning of form elements based on register data before printing? For example I have a width and height field on an item and would like to set the xpos and ypos of ...
Created byNeil19:28 26 Feb 2019
52
3
11:25 5 Mar 2019
David Delač
Latest Posts
Re: Folder
Piotr Wycichowski
Is it something when a user tried to use any of AI commands in SERP? /Piotr W....
10:07 8 Nov 2024
Re: Reconnecting issues: version 8.5 2022-02-02 (build 85420830)
Brittany McGrath
Thank you for your post Lilian. I see this post has been submitted twice and the second post is being addressed so I will close this duplicate. Thank you. ...
09:41 5 Nov 2024