Discussions tagged Syntax
Need some help with syntax
- Resolved
- How-to
- Last updated 2 months ago
- Arnd Schmidt replied 2 months ago
Hi!
Can anyone tell me what's wrong with this syntax?
IF ISNUMBER(as_tolerance) THEN
ls_compare = "NUMBER"
ldec_tolerance = dec(as_tolerance)
ELSEIF right(trim(as_tolerance),1) = "%" THEN
IF ISNUMBER( left(trim(as_tolerance),len(as_tolerance...
Syntax conversion will result in partial loss of columns alias
- Issue
- Last updated 5 months ago
- Chris Pollach @Appeon replied 5 months ago
Hello I am using Infomaker 2019 R3.When I click on Data, then Design Menu and Convert to GraphicsI get this alert, I am trying to add another table to link my data. IF I click yes, I can link my data but I believe I have lost other data in doing to...
Call webservice with XML in one parameter
- How-to
- Last updated 1 year ago
- Roland Smith replied 1 year ago
Hi there,
I need to call a webservice using HTTPclient.
The service have several parameters (strings) and one parameter should contain XML-query.
When post with XML-query 400/Bad request is returned. With empty parameter 200/Ok is returned.
Ho...
Most of my career I have had to maintain some other developer(s) code. With that in mind, I attempt to follow PowerBuilder's documented approaches for all the code I write. I have, however, seen code like what is shown below that works in a client/...
Modify Datawindow to use Stored procedure for update using code
- Resolved
- How-to
- Last updated 1 year ago
- Jim Nesbitt replied 1 year ago
Hi
I'm converting a Powerbuilder project to Powerserver. Some of the windows use SQLPreview to call stored procedures to update the database.
SQLPreview isn't supported by Powerserver, so I want to modify the datawindow dynamically to use the stor...
MSOLEDBSQL - SqlState 42000 OLE DB Driver for SQLServer Incorrect syntax near X
- Resolved
- Issue
- Last updated 3 years ago
- Kevin Geist replied 1 year ago
When I do CTRL L to verify my event code, I get errors that indicates MSOLEDBSQL throws a SqlState 42000 OLE DB Driver for SQLServer Incorrect syntax near 'xxx'
Yet, when I run this code connecting to this database, the code works, the imbedded sql...
I need help with Syntax Error
- Resolved
- Advice
- Last updated 3 years ago
- Miguel Leeuwe replied 1 year ago
Hi friends,
I created a user event in my dw, and wrote a routine. Today, I've been trying to add a conditional loop, but can't save the changes due to error C0031: Syntax Error. The offending lines are the first IF statement and associated END IF ...
Information Required [ Appeon PowerBuilder 2019 Datatype Blob ]
- How-to
- Last updated 4 years ago
- Michael Kramer replied 4 years ago
I am working on some of features available in Appeon (PowerBuilder 2019) for upgrading from the old version. I need some information/help for the following topics
Converting Blob into string
I am encrypting the plain text using “SymmetricEncryp...
- Page :
- 1