Tilted Forum Project Discussion Community - View Single Post

hrdwareguy · 12-21-2004, 10:32 AM

I have used SQL before in some very basic and limited fashion. I know how to write select and insert statements but that's about it.

We currently use flat .DBF file for our customer database at work. I am going to propose a solution that uses an SQL server but I have some questions for the SQL GURU's around here.

First off, can sql tables have associated indexes and if so, how do you access the information via the index? For example if I enter a phone number I want to be able to jump to that phone number if it exists. If it does not exist, I need to go to the closes match and be able to go to the previous and next records.

Next, I need to know how to set permissions on tables. I have one table that everyone needs read access to, but only 3 people need write access to. I will have both internal and external sources looking at some of these tables so will need to set the security appropriately.

I will be doing my developnet in Delphi, not that it should make a difference though.

Thanks for your advice, I will probably have more questions later.

Hrd

edited to add another point

12-21-2004, 10:32 AM	#1 (permalink)
hrdwareguy "Officer, I was in fear for my life" Location: Oklahoma City	SQL Help I have used SQL before in some very basic and limited fashion. I know how to write select and insert statements but that's about it. We currently use flat .DBF file for our customer database at work. I am going to propose a solution that uses an SQL server but I have some questions for the SQL GURU's around here. First off, can sql tables have associated indexes and if so, how do you access the information via the index? For example if I enter a phone number I want to be able to jump to that phone number if it exists. If it does not exist, I need to go to the closes match and be able to go to the previous and next records. Next, I need to know how to set permissions on tables. I have one table that everyone needs read access to, but only 3 people need write access to. I will have both internal and external sources looking at some of these tables so will need to set the security appropriately. I will be doing my developnet in Delphi, not that it should make a difference though. Thanks for your advice, I will probably have more questions later. Hrd edited to add another point __________________ Gun Control is hitting what you aim at Aim for the TFP, Donate Today Last edited by hrdwareguy; 12-21-2004 at 01:15 PM..