BorlandTalk.com

Sonnich · Guest

I have problems packing dbase table, I get an error:
[Microsoft][ODBC dBase Driver] Invalid SQL statement; expected
'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'

I have been looking into it, and did not find much. Does anyone know
about this?
The error occures on the execute statement.
I found a number pages describing this, but none explaining the
situation I have.

Code:
CoInitialize(nil);
connection := CreateOleObject('ADODB.Connection') as _Connection;
connection.Open('Data Source='+sDatabaseName, sUsername, sPassword, 0);

The solution one....
connection.Execute('Set Exclusive On', Ai, adCmdText);

Solution two:
cmd1 := CreateOleObject('ADODB.Command') as _Command;
cmd1.CommandType := adCmdText;
cmd1.Set_ActiveConnection(connection);
cmd1.CommandText := 'Set Exclusive On';
cmd1.Execute(Ai, Ai2, adCmdText);

{ rest... for both }
cmd1.CommandText := 'Pack Test.dbf';

PS: is there are a way to operate paradox tables? I seem to have
problems inserting/editing data once there is more than one row in a
table :-)

pr · Guest

"Sonnich" <sonnich.jensen (AT) elektrobit (DOT) com> wrote