B4J Question JRDC2: Parameterized placeholders are only for values ?

le_toubib · Sep 19, 2016

hi all
i m trying to implement a similar query in JRDC2 :

SELECT * FROM patients WHERE ? = ?

i.e : dynamic field names since i have too many fields in this table 40+

in php it was possible to directly post the field name , and then parametrize the value , but here in JRDC2 is there a way to do it ?

Erel · Sep 20, 2016

Column names cannot be parameterized. You can probably use a stored procedure for that, or a simpler solution is to create a command for each of the fields.

B4X:

sql.select_field1 = SELECT * FROM patients WHERE field1 = ?
sql.select_field2 = SELECT * FROM patients WHERE field2 = ?
sql.select_field3 = SELECT * FROM patients WHERE field3 = ?
sql.select_field4 = SELECT * FROM patients WHERE field4 = ?

The command name can be built dynamically in the clients.

B4J Question JRDC2: Parameterized placeholders are only for values ?

le_toubib

Active Member

Erel

B4X founder

Similar Threads

B4J Question JRDC2: Parameterized placeholders are only for values ?

le_toubib

Active Member

Erel

B4X founder

Similar Threads

Privacy & Transparency

Privacy & Transparency