Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 357
  • Last Modified:

For Gafoor78 PB Expert.

http://www.experts-exchange.com/Programming/Programming_Languages/PowerBuilder/Q_21221722.html

Thanks Gafoor for your detailed code.

Please give any comments to be accepted immediately.

0
Mateen
Asked:
Mateen
  • 3
  • 3
1 Solution
 
gafoor78Commented:
Hi mateen

thank u and enjoy powerbuilder

rgrds
gafoor
0
 
MateenAuthor Commented:
Hi gafoor78

For the search object, I sent an email to gafoor78@yahoo.com, but it seems that
the mail has not been received by u.

I shall be happy, if you could please send me your search object at this address.

mateensdmlstpl@yahoo.com.

Thanks.

0
 
gafoor78Commented:
hi

u can just copy the code i posted  as it is ( bcoz it is the exported systax) and paste in a notepad after that save it as any name with extention 'sru'. then import it in ur PBL...

any way i will send it in ur mail id also...check ur inbox..

cheers
gafoor
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
MateenAuthor Commented:
Hi gafoor

I tried to paste your user object. There is an error.

Only non visual user objects can be placed in the non visual user objects.

Is this sle_uo_fast_find use 'PFC' aslo. If so , I have not yet used PFC.

Please help
0
 
gafoor78Commented:
hi mateen

it is checking 4 PFC datawindow also...but it will not make you problm....try to regenerate the object then try by putting the uo in ur window..if u still gets the error, then let me know the error message as it is

rgrds
gafooor
0
 
MateenAuthor Commented:
gagoor78:

best regards

Sir, I don't have words to thank u 4 your very smart search object.
U must be pleased to know that I am using it dynamically

dw_1.dataobject = szDatawindowObject
dw_1.SetTransObject(SQLCA)
sle_1.of_SetDW(dw_1)
sle_1.of_SetRowSelect(true)
string ls_coltype, ls_colname
long IJK
for ijk = 1 to Long(dw_1.Describe('datawindow.column.count'))
       ls_colname = dw_1.Describe('#'+string(ijk)+'.Name')
    ls_coltype = Lower(Left(dw_1.Describe(ls_colname + ".ColType"),4))
    //if pos('chardatenumblongintdecireal',ls_coltype) < 0 then return
    sle_1.of_RegisterCol(ls_colname,'ANY')  
next

This single coding works for all the reports (more than thousand).

Owing to u

Mateen
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now