Return general SQL Query results
Hi, I am trying to create a few methods handling my DB connection. What I need is a simple: SELECT * FROM TABLE result. The only help I could find is some CreateADOquery method, which seems to be ver...
Forum Discussion
you should be able to use fieldcount and field[] array
example in delphi but you can see the point here.
function GetQuery(s:string):string;
var
i;
q;
begin
q := CreateAndOpenQuery(s); // my own routine just to create and open adoquery
result := '';
while not q.eof do
begin
for i := 0 to q.fieldcount-1 do
result := result + q.field[i].asstring+#9;
result := result +#13;
q.next;
end;
end;
Thanks, I'm going to try that and we'll see.
