TOPIC:

Database Table 11 years 1 month ago #4595

Lieven Vandaele Topic Author Offline New Member Posts: 6 Thank you received: 1	Hi, Wonder if somebody can help me. I have a database connecting with TODBCConnection, connected. I do have a TDatasource. Where is the TTable ? I would like to connect straight to the ODBC, this for network connections. Any suggestions welcomed.
	Please Log in or Create an account to join the conversation.

Database Table 11 years 1 month ago #4596

Lieven Vandaele Topic Author Offline New Member Posts: 6 Thank you received: 1	Sorry for this, am not looking for TTable(not BDE). Am looking for a table that can be used with the TODBCconnection component. Thanks
	Please Log in or Create an account to join the conversation.

Database Table 11 years 1 month ago #4599

Adular
Offline
New Member
Posts: 17
Thank you received: 2

TSqlQuery works for me
Example:
< .... >

 TForm1 = class(TForm)
    Button1: TButton;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    ODBCConnection1: TODBCConnection;
    SQLQuery1: TSQLQuery;
    SQLTransaction1: TSQLTransaction;
    procedure Button1Click(Sender: TObject);
  private
    { private declarations }
<....>

<....>
and as a test

procedure TForm1.test;
begin
  if SQLQuery1 is TDataset then with SQLQuery1 as TDataset do begin
     first;
     while not eof do next;
  end;
end;

The following user(s) said Thank You: Lieven Vandaele

Please Log in or Create an account to join the conversation.

Database Table 11 years 1 month ago #4600

Lieven Vandaele Topic Author Offline New Member Posts: 6 Thank you received: 1	Indeed this could be done, thanks. If one is used using a txxtable........., I can live with this.
	Please Log in or Create an account to join the conversation.

Forum

CodeTyphon Studio

CodeTyphon Studio Components and Libraries

Database Development

Database Table