This tip on SearchExchange about Outlook meeting requests might have the answer you are looking for.

I guess you could see the columns being monitored by looking at the trigger code.

You can use the sp_helptext procedure to see the code.

CharlieBrown, the second-level text for CPF2972 is ‘See the messages previously listed. Correct the error, and then try the request again.’

Joking aside, CharlieBrown is right – check the joblog. It will provide you with the reason the CPYFRMQRYF is failing.

If your search pattern is ‘ite’ – a subset of ‘item’ – it will return a valid result, wanted or no. If you follow BigKat’s suggestion and prepend and append a blank to the search pattern – giving you ‘ ite ‘ – a valid result will occur only if that pattern is found.

but it given same result like i search ‘ITE’ and it given ITEM also…..

We have our custom menus set up as actual *menu objects.
Our software provider has their menus all coded in CLLE.
The main reason for them being a program is for security and menu option access.

My suggestion is to start with the *menu objects like suggested.
If a menu does not show up on your list that you expect then look for it with type *all.

WRKOBJ OBJ(*ALL/MYMENU) OBJTYPE(*ALL)

Here is another scheen shot. You can see the green screen menu here. And the word Clienti, where t should be the t with , which is in romanian. Instead, it is displayed with something like p.

Fixed, thank you all for your valuable suggestions.
YuVa

scan for ‘ 321 ‘ instead of ’321′

Can some one guide me …how to find a exact word or string using “Scan” not a part of some other string.

say if i need 321 it should not give me 3210 nor 1321 it should only give me line containing string 321

hi i am using scan function like that:
if %scan(%trim(#strng):istrng)<>0 where #strng=ite
now scan function scan in istring if istrng has “item” then result came
like item no exist
but i want it search only “ite“.

Tom, thank you for the suggestion, but how could I do that?

I Came to Know,even though i enabled SSL FTP,it is not required for others to follow the same.
But,at this time i’m getting Cryptographic Errors while Creating CA..I found some PTF are lagging..I’m going to apply them and see..what happens next while creating:)

Hi Tom,
I am working on win xp, SQL server 2k8, it’s our project database.
We have 10 database which contains table which have insert,update and delete trigger. i sucessfully identified the table which have these three trigers. now i want to identify the columns within that database table(which hve 3 above mentioned triggers) which will be editable/ or user can update. as per table trigger.

0124.00 D toaddrs s 3106a

Okay, so toaddrs is neither a DS nor an array. Since it’s not a DS, it can’t be qualified and it won’t have any subfields. It’s just a long character field.

Consider changing this to a DS with likeds(emailaddrs) dim(20).

Tom

THANQ guys

What database is it? What platform? (And perhaps what OS release?)

Tom

Thank you Tom the explanation.
First of all this program is a monster and I shouldn’t write it in that way.

Everything is declared in the D spec as global variables.

0122.00 D subject         s             80a
0123.00 D htmlmsg         s           5000a
0124.00 D toaddrs         s           3106a
0125.00 d srnumcs         s              8a
0126.00 D fromaddr        s            100a
0127.00 D fromname        s            100a

The tool recommended by Jerry123 did a good job in my case.

I’m not aware of anything for a QM form similar to the ‘cover page’ for a Query/400 query. But a QM form might be used with any number of different QM queries, unlike Query/400 where the query and the form are always bound together. For QM, a ‘cover page’ would need to more sophisticated to handle all the possible combinations.

Can you describe the actual need? Maybe some variation is possible or someone else knows a trick with QM.

Tom