User bio
404 bio not found
Member since Apr 14, 2022
Posts:
Replies:
LPAD is a SQL function, not an ObjectScript function, which is why it didn't work for you if you replaced the single quotes with double quotes.
USER>write ">"_LPAD(1,10,"0")_"<" >< USER>write ">"_$$lpad^%qarfunc(1,10,"0")_"<" >0000000001<
There are two ways to solve the problem: using embedded SQL or an analog of LPAD for ObjectScript, for example:
CREATE TABLE example_table (
id VARCHAR(10) PRIMARY KEY,
normalized_id VARCHAR(10) COMPUTECODE {
&sql(select LPAD(:{id}, 10, '0') into :{*})
}
COMPUTEONCHANGE(id))
See Signing XML Documents (and especially pay attention to section "Requirements of the XML-Enabled Class")
Certifications & Credly badges:
Vitaliy has no Certifications & Credly badges yet.
Global Masters badges:
Vitaliy has no Global Masters badges yet.
Followers:
Following:
Vitaliy has not followed anybody yet.
This is a good question that I would also like to get an answer to.