CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.

YesSoftware Forums -> CodeCharge Studio -> ASP

 Dlookup problem

Print topic Send  topic

Author Message

Posts: 225
Posted: 10/02/2009, 10:19 AM


I am having trouble with constructing this through the "add action".
SoortGroep.sgp_MedewerkerLCGewijzigd.Value = CCDLookUp("med_LC","Medewerker","med_ID=" & DBKBSSTCONN.ToSQL(CCGetUserID(),ccsInteger), DBKBSSTCONN)

In the "events tab" of my record form
using "server > before insert > add action > DLookup"
What do I need to type in there to get the above statement?
Convert result to
Type of target

Tried a lot of differend things but I never succeed...

Thanks for helping,

View profile  Send private message

Posts: 942
Posted: 10/03/2009, 3:35 PM


Expression = DataField Name
Domain = Your database table
Criteria = the selection or WHERE statement for selecting your records
Connection = The name of the DB Connection to Use. (this is a dropdown selection)
Convert result to = Your choice text, int, float.. etc (also a drop down)
Type of target = Type of varaiable you want the result to appear in, Variable, Cookie, Session, Page Component. (also a drop Down)
Target = Name of the target variable, control, etc.

John Real - More CodeCharge Studio Support at -
View profile  Send private message

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Web Database

Join thousands of Web developers who build Web applications with minimal coding.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.