?
Solved

Using TTable's Lookup Method ?

Posted on 2003-02-25
3
Medium Priority
?
216 Views
Last Modified: 2010-04-04
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
Comment
Question by:shaneholmes
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
bogiboy earned 200 total points
ID: 8021863
Check the database to make sure that LastLogin is not null for the U and P that you are looking for.
0
 
LVL 11

Author Comment

by:shaneholmes
ID: 8022185
ah - if not (VarType(V) in [varNull]) then
0
 
LVL 11

Author Comment

by:shaneholmes
ID: 8022613
ah - if not (VarType(V) in [varNull]) then
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question