Programming Forums > Application Development > Delphi

gj15987 · Jul 18th, 2005, 8:25 AM

Hey all,

I have created a log in box for a form. When the user correctly enters a username and password the desired form will open. However, I only want the form to display certain records in a database...I assume this is a query...how is this done in delphi?! I am using paradox tables.

Thanks!
Grant.

Ooble · Jul 18th, 2005, 9:05 AM

You just run an SQL query through it. I've never used Paradox, but SQL generally works in the same way - execute something like this:

(Toggle Plain Text)

SELECT column1, column2 FROM table WHERE column1 < 100 AND column3 = 'Moo.';

Jul 18th, 2005, 8:25 AM	#1
gj15987 Programmer Join Date: Feb 2005 Posts: 45 Rep Power: 0	Queries in delphi Hey all, I have created a log in box for a form. When the user correctly enters a username and password the desired form will open. However, I only want the form to display certain records in a database...I assume this is a query...how is this done in delphi?! I am using paradox tables. Thanks! Grant.

Jul 18th, 2005, 9:05 AM	#2
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	You just run an SQL query through it. I've never used Paradox, but SQL generally works in the same way - execute something like this: (Toggle Plain Text) SELECT column1, column2 FROM table WHERE column1 < 100 AND column3 = 'Moo.'; SELECT column1, column2 FROM table WHERE column1 < 100 AND column3 = 'Moo.'; __________________ Me :: You :: Them

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Application Development > Delphi

Queries in delphi