SQL Parameters

[Anonymous]

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.

[Akos Somorjai]

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

[Anonymous]

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

[Ralph Wessel]

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.

[runxel]

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

[Anonymous]

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

[Mihaly Palenik]

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