Code: Select all
SELECT * FROM "MediaInfo" WHERE "aid" = :P1
Thanks
Code: Select all
SELECT * FROM "MediaInfo" WHERE "aid" = :P1
Code: Select all
SELECT * FROM "MediaInfo" WHERE "aid" = :P1 * 1
Code: Select all
SELECT * FROM "MediaInfo" WHERE "aid" IN ( :P1 )
While this seems to be an issue with BOTH OpenOffice and LibreOffice Parser ( the module that CHANGES the SQL Query ) . . . for example, to substitute the Parameter to a value, or, an INPUT date from local format to SQL format ( YYYY-MM-DD ) . . . I would encourage you file a BUG report.cwdavi1 wrote::P1*1 works, too lazy to try the IN just to see if it works, I'm sure you did. Thank you for the info and thanks to all the knowledgeable people who provide support on this forum. I could have searched for years and never found this. As an aside, is this something I could fix for the project? I had 27 years experience as a software engineer developing applications and systems before I retired in 2007.