janiali
Posts: 44
|
| Posted: 12/10/2007, 8:57 AM |
|
Quote Oper:
ok sorry the code shoudl be like thsi to be safe:
i read your PM
if ccgetgroupID() = 4 then
tblpip.datasource.where = " (UserID > 0) "
else
tblpip.datasource.where = " UserID = " & ccgetuserid()
End If
1 line coudl be commented but let keepit that way
just dont use the: userid = ccgetuserid() (expresion)
we are going dinamic for your others stuff
hi oper I m bothring you too much now again there isone error as below
Form: Grid tblPIP
Error: Ambiguous column name 'UserID'. (Microsoft OLE DB Provider for SQL Server)
I removed the userid=ccgetuserid from datsource .
pls have a look live
thanks
jani
_________________
Jani Ali |
 |
 |
Oper
Posts: 1195
|
| Posted: 12/10/2007, 9:21 AM |
|
dont worry bothering i'm just playing right now with the CCS4 on the other computer.
that casue you are using some builder/table where there are 2 userid field
just sustitud for this:
if ccgetgroupID() = 4 then
tblpip.datasource.where = " (tblpip.UserID > 0) "
else
tblpip.datasource.where = " tblpip.UserID = " & ccgetuserid()
End If
let me know please.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
janiali
Posts: 44
|
| Posted: 12/10/2007, 9:33 AM |
|
Quote Oper:
ok sorry the code shoudl be like thsi to be safe:
i read your PM
if ccgetgroupID() = 4 then
tblpip.datasource.where = " (UserID > 0) "
else
tblpip.datasource.where = " UserID = " & ccgetuserid()
End If
1 line coudl be commented but let keepit that way
just dont use the: userid = ccgetuserid() (expresion)
we are going dinamic for your others stuff
Hi Oper
its still not working giving the error below
Form: Grid tblPIP
Error: Ambiguous column name 'UserID'. (Microsoft OLE DB Provider for SQL Server)
you can check live as well .
I have removed not using ccgetuserID now .
thanks
Jani
_________________
Jani Ali |
|
|
|
Oper
Posts: 1195
|
| Posted: 12/10/2007, 9:45 AM |
|
if ccgetgroupID() = 4 then
tblpip.datasource.where = " (tblpip.UserID > 0) "
else
tblpip.datasource.where = " tblpip.UserID = " & ccgetuserid()
End If
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
janiali
Posts: 44
|
| Posted: 12/10/2007, 9:59 AM |
|
Quote Oper:
if ccgetgroupID() = 4 then
tblpip.datasource.where = " (tblpip.UserID > 0) "
else
tblpip.datasource.where = " tblpip.UserID = " & ccgetuserid()
End If
Great Oper you Are Great you have done it
Thanks a lot I am really great full to you
just little small question which I asked you before as well that I don't want goupID 1 to see his data even.
how to solve this is this possible
Please help
thanks
can you also tell me if I need further you help in this forum how I can get that as I have posted two more topics but no body answerd that . as one is related to the same page you have seen that page
please let me know if you can help the post id is as below
http://forums.codecharge.com/posts.php?post_id=92437
thanks
Jani
_________________
Jani Ali |
|
|
|
Oper
Posts: 1195
|
| Posted: 12/10/2007, 10:03 AM |
|
do you mean groupID 1 shoudlnt view the grid on the button?
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
janiali
Posts: 44
|
| Posted: 12/10/2007, 10:07 AM |
|
Quote Oper:
do you mean groupID 1 shoudlnt view the grid on the button?
yes you are Right
or may be they can see there own data but not update .
please tell me both option so what ever will be suiteable I will use that
Thanks for quick response
Jani
_________________
Jani Ali |
|
|
|
Oper
Posts: 1195
|
| Posted: 12/10/2007, 10:08 AM |
|
select case ccgetgroupID()
case 1
tblpip.datasource.where = " (tblpip.UserID < 0) "
case 4
tblpip.datasource.where = " (tblpip.UserID > 0) "
case else
tblpip.datasource.where = " tblpip.UserID = " & ccgetuserid()
End Select
Simple solution here, of course you could totaly disapear the Grid if needit.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
janiali
Posts: 44
|
| Posted: 12/10/2007, 10:23 AM |
|
Quote Oper:
select case ccgetgroupID()
case 1
tblpip.datasource.where = " (tblpip.UserID < 0) "
case 4
tblpip.datasource.where = " (tblpip.UserID > 0) "
case else
tblpip.datasource.where = " tblpip.UserID = " & ccgetuserid()
End Select
Simple solution here, of course you could totaly disapear the Grid if needit.
Great Oper its working fine
thanks a lot you are really great where do you lear CCS thsi much how I can learn 5 or 10 % of that  thanks a lot once again
can you please Please check this post for another problem on the same page
Please
http://forums.yessoftware.com/posts.php?post_id=92437
thanks
Jani
_________________
Jani Ali |
|
|
|
Oper
Posts: 1195
|
| Posted: 12/10/2007, 10:41 AM |
|
first advice try to practice and learn SQL, then how the evnt work in CCS
and Play a lot.
i have been using CCS since a litle back 2002~ with the CC version
i still have around the
CCStudio1.0 version 2002-08-21
and the CodeCharge2.0 Small version 2002 ( i think Codecharge Small died on 2.0) then
CCStudio 1.0 started.
i really trust in CCS we even have recomended CCS for few goverment Company here at R.D. they just got there first license and more to come next year i'm sure.
i said one time CCS is great the problem is the leaning curve without help is a pain in the A$$
we have been teaching those company with the version that expired. and the elarning curve is really fast whne someone teach you then you start seeing the product in other way. as soon they know the power of CCS they Buy without a doubt.
But manual,help and forum you wont get much if you dont have patience.
(i will check your other psot still have 1 more hour free today)
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
janiali
Posts: 44
|
| Posted: 12/11/2007, 3:08 AM |
|
thanks a Lot Oper for Great FeebBack and Guide Line . I will try to learn SQL and CCS events
can you just guide me little more that how and where I can get some training ? online ? or some other way ?
thanks
Jani
_________________
Jani Ali |
|
|
|
