Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

VB6+Data Environment+SQL+ADO

GuestID is the PK of GUEST table and FK in BOOKING table (BookingID is PK of Booking table). On the Booking Form I want to display the Lname's in a Datalist of all those Guests who have made a Booking. How can I do this? The query is simply "select Lname from GUEST where GuestID = THISID (that is BOOKING.GuestID). I have made the sql command in the Data Env. How can I run this sql command and supply the parameter? What event do I put this code in - is it in Form_Load?

I'm really stuck..any help is much appreciated.

Comments

  • gigsvoogigsvoo Member Posts: 328
    If you are using DataEnvironment, drap the command object u created into the page.

    Neo Gigs
    http://communities.msn.com.my/VisualBasicwithNeo

  • Chris BrownChris Brown USAMember Posts: 4,496 ✭✭

    // http://forcoder.org // free video tutorials and ebooks about || C, Objective-C, Visual Basic, Swift, Visual Basic .NET, Java, PHP, Delphi, PL/SQL, Go, JavaScript, R, Ruby, Assembly, Perl, MATLAB, Python, C#, Scratch, C++ Logo, Hack, Bash, F#, ABAP, ML, Transact-SQL, Julia, Crystal, Clojure, D, Prolog, LabVIEW, Alice, COBOL, Awk, Lua, Ada, SAS, Apex, Lisp, Scheme, VBScript, Kotlin, Scala, Fortran, Erlang, Rust, FoxPro, Dart || ____

Sign In or Register to comment.