topic Re: SQL Parameters in Collaboration with other software

SQL Parameters

Anonymous — Mon, 24 Jul 2017 09:46:02 GMT

Entering the "SELECT parameters FROM Objects" gives me all Parameters of every Object. they seem to be in one extra table in the column "Parameters". How can I Select Objects having one single Parameter (f.e. "testparameter001" in common.

Re: SQL Parameters

Akos Somorjai — Mon, 24 Jul 2017 11:55:05 GMT

kmcw_ wrote:
Entering the "SELECT parameters FROM Objects" gives me all Parameters of every Object. they seem to be in one extra table in the column "Parameters". How can I Select Objects having one single Parameter (f.e. "testparameter001" in common.

Hi,

The SQL queries are not supported any more officially (the last supported version was ARCHICAD 18 ), so don't rely on them. Someone else here may be able to answer you question.

Sorry, Akos

Re: SQL Parameters

Anonymous — Mon, 24 Jul 2017 12:43:59 GMT

But it still works 😉 (AC 20) I just can't find the right syntax For objects.parameters

Re: SQL Parameters

Ralph Wessel — Mon, 24 Jul 2017 15:27:17 GMT

kmcw_ wrote:
But it still works 😉 (AC 20) I just can't find the right syntax For objects.parameters

I'd strongly recommend not using unsupported technology – you're setting yourself up for a disaster. If GS hasn't updated it beyond 20, the fact that it appears to work is coincidental and almost certainly unstable.

Re: SQL Parameters

runxel — Tue, 25 Jul 2017 09:38:24 GMT

The command is already removed in 21. It's sad, but I guess there were just too few users who actually used it.

Re: SQL Parameters

Anonymous — Mon, 11 Sep 2017 14:00:32 GMT

Actually it works fine with:
SELECT LIBRARY_PART_NAME, XX.PARAMETERS.NAME, XX.PARAMETERS.VALUE
FROM FLAT( OBJECTS, PARAMETERS) AS XX

BUT ehen I whant to add

WHERE XX.PAREMETER.VALUE=1

I get an error that It cant transform datatype GDLVARIANT to typ 1. I tried to use
CAST (XX.PARAMETERS.VALUES AS *) * for "*" I tried: "CHAR", "VARCHAR" or "string"
But the error remains the same. Can somone tell me how to transvorm a "GDLVARIANT" into something I can use? THX

Re: SQL Parameters

Mihaly Palenik — Tue, 12 Sep 2017 10:39:43 GMT

Hello,

Try to use this query:

SELECT LIBRARY_PART_NAME, XX.PARAMETERS.NAME, XX.PARAMETERS.VALUE 
FROM FLAT(OBJECTS, PARAMETERS) AS XX 
WHERE CAST (XX.PARAMETERS.VALUE AS CHAR(50)) = '1'

It works in ArchiCAD 20.

Best,
Mihály