Trailing spaces in strings – Clarion vs SQL
Posted on Thursday, February 19th, 2009
This topic came up at work a while ago when trying to perform database operations on strings containing a trailing space.
The Problem: One of our stored procedures was using CHARINDEX to search for strings within [...]
Temp Tables, Scope and Clarion
Posted on Tuesday, March 11th, 2008
I was discussing this with a colleague yesterday and thought everyone might be interested in the outcome.
Problem:
I was getting an error “There is already an object named ‘PK_SUPPLIERPRODUCTID’ in the database.” when trying to [...]