Hi all,
This is a slightly strange one so I didn't know where to put it.
I'm currently running some reports through a Progress Open Edge Driver in Access, and I've generally worked out how to set up some Pass Through Queries using the correct Progress syntax.
I've come across a field where I need to use a TRIM function though, and I'm not sure of the correct syntax to use. This is the standard Access Query SQL before I've converted it to a Pass Through Query (which then requires Progress syntax):
My question is does anyone know how to use the TRIM function or equivalent in the Progress syntax?
These are the changes I make as far as I know to convert it to Progress syntax:
But I'm getting a Syntax error. It's probably very simple but I am a very inexperienced SQL user.
Regards,
Nick
This is a slightly strange one so I didn't know where to put it.
I'm currently running some reports through a Progress Open Edge Driver in Access, and I've generally worked out how to set up some Pass Through Queries using the correct Progress syntax.
I've come across a field where I need to use a TRIM function though, and I'm not sure of the correct syntax to use. This is the standard Access Query SQL before I've converted it to a Pass Through Query (which then requires Progress syntax):
Code:
SELECT Trim([PUB_stock]![scode]) AS scode
FROM PUB_stock;
My question is does anyone know how to use the TRIM function or equivalent in the Progress syntax?
These are the changes I make as far as I know to convert it to Progress syntax:
Code:
SELECT Trim(PUB.stock.scode) AS 'scode'
FROM PUB.stock
But I'm getting a Syntax error. It's probably very simple but I am a very inexperienced SQL user.
Regards,
Nick