I am trying to insert a record into an Ultralite table, and am using
parameters. Can I use a SQL Parameter within a function? Is there some other
way to do this?

INSERT INTO tblServiceRequests (IDNumber, AreaID)
VALUES (?, NullIf(?, 0))

I get a syntax error on this parameter:
INSERT INTO tblServiceRequests (IDNumber, AreaID)
VALUES (?, NullIf([ERROR->]?, 0))

Please show version, build of your ASA and type of UL API.
Is it prepared sql-statement or something else?

--
Sincerely yours,
Alex Usmanov
(ASA 9.0.2.3131, MW CW 9.2)
"Dave Was" <rental (AT) wasden (DOT) com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:45d567c9$1 (AT) forums-1-dub (DOT) ..

Oh, thanks Usmanov. The API type is C++. The version is 9.0.2.3249. It is a
prepared sql-statement.

"Usmanov A." <alex_u (AT) pochtamt (DOT) ru> wrote

UL-generator get hint for this error - you must define type of second
parameter by using CAST function (at least, it helps in my case). For
example:
INSERT INTO tblServiceRequests (IDNumber, AreaID) VALUES (?, NullIf(CAST(?
AS INTEGER), 0)).




--
Sincerely yours,
Alex Usmanov
(ASA 9.0.2.3131, MW CW 9.2)
"Dave Was" <rental (AT) wasden (DOT) com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:45d57905$1 (AT) forums-1-dub (DOT) ..

Thank you Usmanov. That is what I was missing.

"Usmanov A." <alex_u (AT) pochtamt (DOT) ru> wrote