ⓘ This article is 1233 days old and may be out of date.
May 12, 2021
ⓘ This article is 1233 days old and may be out of date.
Still can't find correct way to concatenate columns in PARADOX queries ? I will show how this short post
Still struggling to concatenate columns in PARADOX queries? This short post will show you how.
When we are querying old databases, we need to follow some rules to avoid problems. After being stuck for half a day trying to concatenate two columns, one DateTime
+ TimeSpan
(yes, the legacy database stored date separated from time) with ODBC for a C# application, I found a solution.
Simply use an AND
operator...
//... something before "select *"...
MyDatabase.MyDate1 AS DateCol,
MyDatabase.MyTime2 AS TimeCol
MyDatabase.MyDate1 & ' ' & MyDatabase.MyTime2 AS DateWithTime
//... something after ..."where ("
Now your query has a column with concatenated columns. In my case, the query above resulted in something like 12/12/2020 22:40:06.
I hope this helps you.