• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

Using TTable's Lookup Method ?

Can anyone tell me what I am doing wrong here?
I c
keep getting the same answer either way

Note: LastLogIn is a DateTime Stamp

var
 V: Variant;

V:= tblAccounts.Lookup('UserName; Password', VarArrayOf([U,P]),'LastLogIn');
if not (VarType(V) in [varNull]) then
    ShowMessage('Account exist!')
   else
    ShowMessage('Account does not exist');
0
shaneholmes
Asked:
shaneholmes
  • 2
1 Solution
 
bogiboyCommented:
Check the database to make sure that LastLogin is not null for the U and P that you are looking for.
0
 
shaneholmesAuthor Commented:
ah - if not (VarType(V) in [varNull]) then
0
 
shaneholmesAuthor Commented:
ah - if not (VarType(V) in [varNull]) then
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.

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