auto replace issue

[stef]

I didn't read all of the AutoReplace issues, but this is one of my points.

I also have to use AutoReplace after softText stopped working by release 7.1

One problem I have with AutoReplace.
If I make a shortcut for often used Tables e.g.
Delivery short cut will be
del = select * from delivery
Thats work fine but when may query is much longer I use this shortcut also for the table
eg
select * from delivery del
When you now use this in the where clause it will always write the complete shortcut. That's not what i want.

Result
select * from delivery where select * from delivery where delivery = '' ;.

Same problem by using the "enter"!!

thx

that's it!

 

[Stew Stryker]

That's why I usually use the Templates plug-in instead of AutoReplace, because I have to explicitly press Ctrl-J to get the replacement.

 

[mike]

Here's another option. I place and asterisk after my table aliases to prevent this. I did that when I used the shortcuts plug-in also.

For example:

s* = SELECT * FROM
s = SELECT
f = FROM
w = WHERE
del* = delivery del
,del* = ,delivery del
emp* = employees emp
,emp* = ,employees emp

In comments "It's" is replaced with "ItSELECT" so I need to think about that part a bit more.

Mike

 

[stef]

@Stew,

I don't get it. Maybee i'm blond.
What do you mean by template-plug-in??

@Mike,

Thanks this is also a possibility.

thx
Stef

 

[Qkxy]

BAR Solutions Plug-Ins:
http://www.bar-solutions.com/software/download/mytools/template.zip

 

[stef]

thanks that's work for me!

 

[Stew Stryker]

Yeah, it's worked nicely for me for a couple years stef! (Us blonds have to stick together!)

Frankly, I haven't found many uses for AutoReplace yet, because any short string I might use for AutoReplace I could also see using for a table alias. But maybe that just confirms that I have a limited imagination???