Tips and Frequently Asked Questions

 How can I use a database component library for which no built-in interface component is provided in IntraWeb Query Builder?


You can use TatCustomDatabase component to manually retrieve tables and field names and pass the names to visual query component. Just drop a TatCustomDatabase component and set event handlers for all its events. The example below shows how to use TatCustomDatabase to support BDE components (although it is already supported by the specific TatBDEDatabase component). You must have a TDatabase component in the form named Database1 which points to the DBDEMOS database.
procedure TForm1.atCustomDatabase1ReadSqlPropertyEvent(ADataset: TDataSet;
  var ASQL: String);
begin
  if ADataset is TQuery then
    ASQL := TQuery(ADataset).SQL.Text;
end;

procedure TForm1.atCustomDatabase1RetrieveFieldNameListEvent(
  const ATableName: String; const AList: TStrings);
var
  table: TTable;
  c: integer;
begin
  table:=TTable.Create(nil);
  try
    table.DatabaseName := 'DBDEMOS';
    table.TableName := ATableName;
    table.FieldDefs.Update;
    for c := 0 to table.FieldDefs.Count-1 do
      AList.AddObject(
      table.FieldDefs[c].Name, // FieldName
      TObject(Ord(table.FieldDefs[c].DataType)) ); // DataType
  finally
    table.Free;
  end;
end;

procedure TForm1.atCustomDatabase1RetrieveTablenameListEvent(
  const AList: TStrings);
begin
  Database1.GetTableNames(AList);
end;

procedure TForm1.atCustomDatabase1OpenQueryEvent(ASql: String;
  var ADataset: TDataSet);
begin
  ADataset := TQuery.Create(Self);
  with TQuery(ADataset) do
  try
    DatabaseName := 'DBDEMOS';
    Sql.Text := ASql;
    Open;
  except
    ADataset.Free;
    ADataset := nil;
    raise;
  end;
end;

procedure TForm1.atCustomDatabase1WriteSqlPropertyEvent(ADataset: TDataSet;
  ASql: String);
begin
  if ADataset is TQuery then
    TQuery(ADataset).SQL.Text := ASQL;
end;


Pricing

Single Developer License Site License
 

TMS Query Studio


€ 105

35 yearly renewal
license for 1 developer


Includes
check  Full source code
check  Access to the TMS Support Center
check  Free updates and new releases
MOST POPULAR

TMS VCL Subscription


€ 895

450 for a 2 year renewal
license for 1 developer


Includes
check  Full source code
check  Access to the TMS Support Center
check  Free updates and new releases
check  TMS Query Studio
check  All TMS VCL products
more_horiz  Discover more
BEST VALUE

TMS ALL-ACCESS


€ 1,795

595 yearly renewal
license for 1 developer


Includes
check  Full source code
check  Access to the TMS Support Center
check  Free updates and new releases
check  TMS Query Studio
check  All TMS VCL products
check  All TMS products
more_horiz  Discover more
All prices excl. VAT. Renewal price is subject to change and only valid up to 30 days after license has expired. After renewal period a discount price is offered to renew the license.

TMS ALL-ACCESS

key
Your unlimited access to all TMS products
local_offer
One money and time saving bundle

Free Trial

Start a free TMS Query Studio evaluation today!
RAD Studio

What our customers say

We have been using TMS components in our software development for almost 30 years. Throughout this time, we have consistently experienced friendly and high-quality service. Problems are not simply dismissed with the words "no error found," but rather, solutions are actively sought in collaboration with the customer. The components are well-designed and highly configurable to meet individual needs. We have also found TMS to be a reliable partner in custom development projects.

- Holger Hanschmann

Excellent components, enhances and improves the end product. Support is excellent. Reply promptly and always have an answer or fix, something which is important when trying to develop software to a deadline. Would highly recommend the components and the company to any fellow Delphi developers.

- Trevor Bradley

I use TMS components since a couple of years and I'm really happy with the components but especially with the support the company does provide, too. I always (!) get fast and competent help. In my opinion they have a great package of software and service.

- Jimi Romano

As a developer for 30+ years, and a Delphi developer since 1996, I've a solid foundation on desktop development. But I was skeptical of indulging in web development. Though the market was demanding a switch, it seemed too difficult to make the transition. TMS Software was my "magic bullet" to get me started with zero intimidation. Love their Web Core and XData products. Now I can develop powerful web applications using Delphi. TMS Software has renewed my love for Delphi and won my heart for their innovators. Thanks to the team for great products and a large volume of demos and manuals. You ROCK!

- Larry

In the past I have purchased other components from other parties. I will say proudly that TMS is the best in support, price and style. Whenever I need a help your team is always there to help me. Keep up the good work

- Mohamed Thooloon

TMS WEB Core

language
Create modern web apps in Delphi & VSC
build_circle
Use Object Pascal code to build JavaScript apps