AndreSch
Posts: 27
|
| Posted: 06/21/2008, 7:35 AM |
|
I am using a list of projects. When clicking on the project name I redirect that to the project detail screen. This means, I have set the name to be a link field. In the parameters of the link definition,I do pass the project_id.
Now on the project detail screen, I get a blank screen where the content needs to be dispalyed, and also no buttons except cancel.
The detail screen settings to Allow Update is Yes. Insert is No.
Any idea how to solve this?
|
 |
 |
Gena
Posts: 591
|
| Posted: 06/21/2008, 7:57 AM |
|
Have you set in your detail page WHERE statement in VQB like
your_project_id = project_id (URL)
?
_________________
Gena |
|
|
|
AndreSch
Posts: 27
|
| Posted: 06/21/2008, 8:17 AM |
|
thanks It was there,I deleted it and recreated it - now it works
|
|
|
|
AndreSch
Posts: 27
|
| Posted: 06/21/2008, 8:59 AM |
|
Hi a related question:
Once a user logs in, I have a screen where I display his detail and allow him to edit it. This screen is opened from the menu. How do I get the employee_id. In VQB is set a WHERE clause:
WHERE
user_id = {CCGetUserLogin()}
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 06/22/2008, 3:40 AM |
|
In VQB, select WHERE
if the user_id condition is already there, double click it,
if not, click the + sign
parameter settings:
user_id (=) equals UserID, type Session.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
AndreSch
Posts: 27
|
| Posted: 06/22/2008, 8:04 AM |
|
Well, I have done this but the screen is still blank!
What I have done, in the header bar of the form, I am displaying UserID, and it shows the correct UserID, but the content fie;ds such as first name, Last name are all bank
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 06/22/2008, 4:22 PM |
|
Post your SQL here.
In VQB press the SQL icon and copy paste the result here.
If you type the url followed by ?user_id=1 (use an existing value) does that work?
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
AndreSch
Posts: 27
|
| Posted: 06/22/2008, 10:13 PM |
|
SELECT *
FROM employee
WHERE user_id = {UserID}
|
|
|
|
|
