I've decied to migrate to zeoslib-6.5.1 for mysql5.0 support...
1. I'have downloaded:
ZEOSLIB - 20061003 Testing branch(rev 102) (zip 12.8MB)
2. I've extracted all files to:
C:\Programmi\Borland\Delphi7\Lib\Zeoslib-6.5.1-beta\
3. I've added to Delphi 7 libray path:
C:\Programmi\Borland\Delphi7\Lib\Zeoslib-6.5.1-beta\packages\delphi7\build
and
C:\Programmi\Borland\Delphi7\Lib\Zeoslib-6.5.1-beta\build
4. From Project Menu i've choosen "Compile all projects"
but I receive this error from the compiler:
[Error] ZPropertyEditor.pas(434): Undeclared identifier: 'GetSequences'
[Error] ZPropertyEditor.pas(447): Undeclared identifier: 'GetSequences'
[Fatal Error] ZComponentDesign.dpk(35): Could not compile used unit '..\..\src\component\ZPropertyEditor.pas'
Any suggest or ideas?
Code: Select all
{**
Gets a selected string value.
@return a selected string value.
}
procedure TZSequenceNamePropertyEditor.GetValueList(List: TStrings);
var
Connection: TZConnection;
Metadata: IZDatabaseMetadata;
ResultSet: IZResultSet;
{$IFDEF USE_METADATA}
Catalog, Schema: string;
{$ENDIF}
begin
Connection := GetObjectProp(GetComponent(0), 'Connection') as TZConnection;
if Assigned(Connection) and Connection.Connected then
begin
{$IFDEF USE_METADATA}
if GetComponent(0) is TZSqlMetadata then
begin
Catalog := GetStrProp(GetComponent(0), 'Catalog');
Schema := GetStrProp(GetComponent(0), 'Schema');
{$IFDEF SHOW_WARNING}
if not (IsEmpty(Catalog) and IsEmpty(Schema)) or
(MessageDlg(SPropertyQuery + CRLF + SPropertySequences + CRLF +
SPropertyExecute, mtWarning, [mbYes,mbNo], 0) = mrYes) then
{$ENDIF}
try
Metadata := Connection.DbcConnection.GetMetadata;
// Look for the Procedures of the defined Catalog and Schema
ResultSet := Metadata.GetSequences(Catalog, Schema, '');
[error]+>>---------- Here >^^^^^^
while ResultSet.Next do
List.Add(ResultSet.GetStringByName('SEQUENCE_NAME'));
finally
ResultSet.Close;
end;
end
else
{$ENDIF}
begin
try
Metadata := Connection.DbcConnection.GetMetadata;
// Look for the Procedures
ResultSet := Metadata.GetSequences(Connection.Catalog, '', '');
[error]+>>----- And Here >^^^^^^
while ResultSet.Next do
List.Add(ResultSet.GetStringByName('SEQUENCE_NAME'));
finally
ResultSet.Close;
end;
end;
end;
end;
Andrea.