Devart Forums

ViktorV

Please send a complete sample to alexp*devart*com to demonstrate the issue, including a script to create and fill a table.

ViktorV

You can retrieve the information about the Primary Key fields using the TUniMetaData component as shown below:

Code: Select all

  UniMetaData.MetaDataKind := 'IndexColumns';
  UniMetaData.Restrictions.Values['Table_Name'] := TableName;
  UniMetaData.Filter := 'INDEX_NAME = "PRIMARY"';
  UniMetaData.Filtered := True;
  UniMetaData.Open;
  while not UniMetaData.Eof do begin
    Format('Column name: %s', [UniMetaData.FieldByName('COLUMN_NAME').AsString]);
    UniMetaData.Next;
  end;

ViktorV

There are several variants of decision:

You can retrieve the information about table fields using the TUniTable component as shown below:

Code: Select all

  UniTable.TableName := TableName;
  UniTable.FieldDefs.Update;
  for i := 0 to UniTable.FieldDefs.Count - 1 do
  ...

You can also retrieve the information about the fields using the TUniMetaData component as shown below:

Code: Select all

  UniMetaData.MetaDataKind := 'Columns';
  UniMetaData.Restrictions.Values['Table_Name'] := TableName;
  UniMetaData.Open;
  while not UniMetaData.Eof do begin
    Format('Table name: %s | FieldName: %s | Fied Type: %s' | Fied Length: %s',     [UniMetaData.FieldByName('TABLE_NAME').AsString, UniMetaData.FieldByName('COLUMN_NAME').AsString, UniMetaData.FieldByName('DATA_TYPE').AsString, UniMetaData.FieldByName('DATA_LENGTH').AsString]);
    UniMetaData.Next;
  end;

ViktorV

The OnAsynReceiveEvent event is raised only when TScSSHShell.NonBlocking is True.

ViktorV

To solve the problem try to increase the TScSSHClient.Timeout and TScSSHShell.Timeout properties, e.g. to 120 second.

ViktorV

I can't reproduce the problem. Please try to compose a small sample to demonstrate the problem and send it to viktorv*devart*com.

ViktorV

If you use the Locate method on Col_2, MySQL cannot use the index. If a table has a multiple-column index, any leftmost prefix of the index can be used by the optimizer to find rows. MySQL cannot use the index to perform lookups, because Col_2 do not form a leftmost prefix of the index.
More details about how MySQL uses indexes can be found at http://dev.mysql.com/doc/refman/5.0/en/ ... dexes.html

ViktorV

To get the horizontal scrollbar displayed, you can change the Resize method in the CRGrid source code.
Add the following line:
ShowScrollBar(Handle, SB_HORZ, true);

I can not reproduce the problem with column width. If the dgeStretch option is not set in the TCRGrid.OptionsEx property, I can change column width without restrictions. Try to compose a small sample to demonstrate the problem and send it to viktorv*devart*com.

ViktorV

Yes, the use of TUniLoader give good result.

ViktorV

To avoid this issue, you should be corrected connection settings in the TSQLConnection component.

Connection Parameters:
DriverName=DevartPostgreSQL
DataBase=intelitime
HostName=186.202.166.79
User_Name=intelitime
Password=XXXXXX
FetchAll=True
EnableBCD=True
UseUnicode=False

ViktorV

We support source code only for Delphi.
Therefore, to recompile SecureBridge, you need Delphi.

ViktorV

Thank you for your advice.
Currently, TScSSHClient doesn't provide such functionality, but we will support it in the next SecureBridge build.

Devart Forums

Search found 3342 matches

Re: Post then Refresh different under 5.3.10

Re: Universal Field Types

Re: Universal Field Types

Re: Possible to have 8 thousand SSHShell connection at the same time?

Re: Possible to have 8 thousand SSHShell connection at the same time?

Re: Post then Refresh different under 5.3.10

Re: MySQL Index Selection

Re: CRDBGrid - Column Width & Horiz. Scroll

Re: How to achieve efficient data exchange？

Re: Could not parse the GetTables metadata command

Re: Need to recompile 6.3 sources under C++ Builder 2007

Re: Exceptions thrown on TScSSHClient::Connect