Databases with Turbo Delphi

[Typhoonbot]

Hello all

As my subject suggests, I am working with Turbo Delphi.

I have a database with a table called "tblWords" which has a field called "Words". I want to extract a record from the "Words" field, in a SPECIFIC POSITION (ie: the record from position 145). ( I actually want to extract a random record from the field, but just telling me how to get anyone will be fine ).

How can I do this with delphi ?

ps: I have linked the database etc.

 

[Typhoonbot]

Hi, dont worry, what I ended up doing was giving every record in this field a autonumber (with Index field). I then generated a random integer value between (0 and RecordCount). and simply used an SQL statement where I checked "WHERE Index LIKE <Random Generated Number>". It works very well

Regards