Fórum Rest e Json #385077
29/08/2010
0
var
Sql: TStringBuilder;
Reader: TDBXReader;
Obj: TJSONObject;
I: Integer;
begin
Result := TJSONArray.Create;
Sql := TStringBuilder.Create;
Sql.Append('Select Cust_no, Customer, Address_Line1, ');
Sql.Append(' City, Country, Phone_no From Customer ');
if OrderBy <> EmptyStr then Sql.Append(' Order by '+OrderBy);
DataSet.Text := Sql.ToString;
Reader := DataSet.ExecuteQuery;
Obj := TJSONObject.Create;
for I := 0 to Reader.ColumnCount - 1 do
begin
Obj.AddPair(Reader.ValueType[I].Name,TJSONString.Create(Reader.ValueType[I].Name));
end;
Result.AddElement(Obj);
while Reader.Next do
begin
Obj := TJSONObject.Create;
Obj.AddPair('Codigo', TJSONNumber.Create(Reader.Value[0].GetInt32));
Obj.AddPair('Nome', TJSONString.Create(Reader.Value[1].GetAnsiString));
Obj.AddPair('Endereco', TJSONString.Create(Reader.Value[2].GetAnsiString));
Obj.AddPair('Cidade', TJSONString.Create(Reader.Value[3].GetAnsiString));
Obj.AddPair('Pais', TJSONString.Create(Reader.Value[4].GetAnsiString));
Obj.AddPair('Telefone', TJSONString.Create(Reader.Value[5].GetAnsiString));
Result.AddElement(Obj);
end;
end;
Como eu consigo inserir campos do tipo: -Double (exemplo salary do EMPLOYEE.FDB) -Data Obrigado:
Zilon Maciel
Curtir tópico
+ 0Posts
29/08/2010
Marco Salles
Gostei + 0
05/09/2010
Zilon Maciel
Gostei + 0
06/09/2010
Marco Salles
Gostei + 0
Clique aqui para fazer login e interagir na Comunidade :)