Welcome, Guest
Username: Password: Remember me
Components and Libraries for Database Development, discussions, problems and suggestions
  • Page:
  • 1

TOPIC:

Database Table 10 years 7 months ago #4595

  • Lieven Vandaele
  • Lieven Vandaele's Avatar Topic Author
  • Offline
  • New Member
  • 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 10 years 7 months ago #4596

  • Lieven Vandaele
  • Lieven Vandaele's Avatar Topic Author
  • Offline
  • New Member
  • 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 10 years 7 months ago #4599

  • Adular
  • Adular's Avatar
  • Offline
  • New Member
  • 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 10 years 7 months ago #4600

  • Lieven Vandaele
  • Lieven Vandaele's Avatar Topic Author
  • Offline
  • New Member
  • 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.

  • Page:
  • 1