Changing Strings to Char in a DataBase
Posted on 2000-04-24
I'm new to Delphi so any input will be a help. The problem is that I have to access some Fields from an Access Database, then I need to put the fields into a ListBox. The fields I'm interested in are Servers and Drives. I can put all the fields in the Listbox but I only want the Fields that have a drive letter in the " drives " field. The data base is rather large so changing it is not an option.
What I want is something to look like this
Any servers without Drive letters I want to skip.
Here is some of the code.
procedure TForm1.ServersClick(Sender: TObject);
S : string;
D : string;
L : string;
While not Table1.Eof do begin
S := Table1.FieldByName ('ServerName').AsString + ', ';
D := Table1.FieldByName ('drives').AsString;
L := S + D;