# You can download better example on our site:
# http://www.lksoft.narod.ru/
# There you can find nearly all functions call!

require "LKBinDB.pl";
require "LKSQL.pl";

$DB = new New LKDatabase('DB name');

$NewTable = $DB->Query(q!SELECT * FROM Table1 WHERE F1 like '%data%' ORDER BY f1,f2 DESC LIMIT 10,20!);
$NewTable->First;

do {
	$NewTable->{FieldByName}->{f1} = 'data';
	
	... # Access fields by $NewTable->{FieldByName}->{FIELD_NAME}
	
} while $NewTable->Next;

$NewTable->Close;	# TABLE Are Blocked until it closed

# ----------------------------------------------------------------

# $NewTable->Append;
# $NewTable->Post;
# $NewTable->Edit;
# $NewTable->Delete;
# $NewTable->Query(...);
# $NewTable->FindKey(...);
# $NewTable->FindKeyEx(...);

# ... also supported.
# It's like Borland CppBuilder/Delphi Table component.

1;