multy commands in sqlite operated by SQLite Administrator

Forum related to SQLite

Moderators: gto, cipto_kh, EgonHugeist

Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 22.12.2010, 11:49

multy commands in sqlite operated by SQLite Administrator

Postby Meteor » 22.12.2010, 12:03

The SQLite Administrator can operate only the first command in SQL file like update or select but if you need update and then select it operate only the first comand.
In another SQlite administarator like SQLite Expert it works with more then one comand in SQL file.

How it can be solved?


Eilon Peleg


update all_banks set CUS = 'Ormat';
update all_banks set LEN = length(CUS);

SELECT [All_Banks].[Customer], [All_Banks].[Bank], [All_Banks].[Branch],
[All_Banks].[Account], [All_Banks].[Date], [All_Banks].[User1],
[All_Banks].[Pass1], [All_Banks].[Remarks], [All_Banks].[CUS]
FROM [All_Banks]
WHERE [All_Banks].[CUS] =
[substr]([All_Banks].[Customer], 1, [All_Banks].[LEN])
ORDER BY [All_Banks].[Bank];

User avatar
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium

Postby mdaems » 25.12.2010, 08:46

The administrator is not maintained anymore by the original writer. So don't expect big results on this questing.

When writing programs yourself, execution of scripts is done by the TZSQLProcessor component.


Return to “SQLite”

Who is online

Users browsing this forum: No registered users and 1 guest