How to select a record?
lazarus / 16-Databases

----------------------------------------------------------------------
Jvan · 2021-05-28 21:39

After executing my SQL query, how can I get the data row of a record?

Something like this:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
SQLQuery1.Records[15].Fields[3].AsString;

----------------------------------------------------------------------
lucamar · 2021-05-28 21:49

Read it from the query; TSQLQuery is a descendant of TDataset so you
can use its Fields and other properties (and methods) to access the
data; e.g.:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
SQLQuery1.RecNo := 15;SomeString :=
SQLQuery1.Fields.FieldByNumber(3).AsString;

----------------------------------------------------------------------
Jvan · 2021-05-28 21:55

Thanks.