Hi All,
I have used the Alpha function and handled NULL but it yet does not work and gives warning
If Trim(Lnk_Read_ds.NAME_LINE)='' Or IsNull(Lnk_Read_ds.NAME_LINE) Then 0 Else If Alpha(Trim(Trim(Trim(Lnk_Read_ds.NAME_LINE),'-','A'),' ','A')[2,39]) Then 1 Else 0
Error is "Null String Argument"
Any help
Thanks
Job aborts - Alpha function
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 166
- Joined: Wed Mar 16, 2005 6:52 am
- Location: Mumbai, India
I think the problem is to do with:
Trim will not take kindly to a null value as input
try this:
Code: Select all
Trim(Lnk_Read_ds.NAME_LINE)=''
try this:
Code: Select all
If Trim(NullToEmpty(Lnk_Read_ds.NAME_LINE))='' Then 0 Else If Alpha(Trim(Trim(Trim(Lnk_Read_ds.NAME_LINE),'-','A'),' ','A')[2,39]) Then 1 Else 0
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>