General information
Category:
Coding, syntax & commands
Title:
Using strings for alias
The code that I have inherited is full of things like
USE myTable ALIAS myAlias
and then code such as
SELECT 'myAlias' ---- rather than SELECT myAlias
REPLACE myField WITH myValue IN 'myAlias'
etc.
This doesn't seem to cause any problems, but I did find a problem with a similar construct
SET PROCEDURE TO 'procdir\proc1','procdir\proc2'
When the project builder came across this line it only pulled proc1 into the project while
SET PROCEDURE TO 'procdir\proc1'
SET PROCEDURE TO 'procdir\proc2' ADDITIVE
and
SET PROCEDURE TO procdir\proc1,procdir\proc2
got both of them
Are there any reasons to use strings (maybe it made it more clear to him) and does anybody know of any other gotchas from using them?
Thanks......Rich
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only