Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread OT: Pascal Scripts and DBISAM
Fri, Apr 7 2006 3:53 PMPermanent Link

"Jose Eduardo Helminsky"
Hi everyone

I am building a special web server to handle dbisam tables without use of
cgi programs.

My intention is make use of Pascal Scripts to act like an ASP page into a
lightweight web server.
My doubt, someone have already used access dbisam tables inside scripts ?
All the other things is
already working but I have to acces dbisam tables inside functions like:

dbopen(1,'table1');
output('<html>');
if dbfindkey(1,[]) then begin
  output('<b>Found</b>');
end else begin
  output('<b>Not found<b>');
end;
output('<html>');
dbclose(1);

and I would like to use TDBISamTable assigned to a variable like:

var T: TDBISamTable;
T := TDBISamTable.Create(nil);
try
  T.TableName := 'X';
  ...
  T.Close;
finally
  T.Free;
end;

Eduardo

Fri, Apr 7 2006 4:19 PMPermanent Link

Michael Baytalsky
Hi Jose,

Do you have a specific scripting engine in mind or do you
ask for an advise on which scripting to use?
I can of course recommend our Context Scripting, which
is close to Pascal, only it doesn't have strong typing. I.e.
your code would look like:
var T; // no type here
begin
  T := TDBISAMTable.Create;
  try
    T.FindKey ....
  finally
    T.Free;
  end;
end;

You can look at it here:
http://www.contextsoft.com/products/ctxscript

There's no dbisam demo, but there's a demo on how to publish
classes and global scope procedures. TDataSet methods are already
published, so you will only need to publish a few methods, like
TDBISAMTable.Create and TDBSIAMQuery.Create.
Also, note, that you will have to create a separate instance of
scripting for each server thread (i.e. it's not thread-safe).

I was actually planning to write a small http server as a demo
for scripting myself, but as often happens, got too busy with more
important things Wink Instead, there's a demo/components for a simple
(but quite powerful) html/text reporting, which can be used to generate
html pages. That one includes some database access functions via BDE.


Regards,
Michael

Jose Eduardo Helminsky wrote:
> Hi everyone
>
> I am building a special web server to handle dbisam tables without use of
> cgi programs.
>
> My intention is make use of Pascal Scripts to act like an ASP page into a
> lightweight web server.
> My doubt, someone have already used access dbisam tables inside scripts ?
> All the other things is
> already working but I have to acces dbisam tables inside functions like:
>
> dbopen(1,'table1');
> output('<html>');
> if dbfindkey(1,[]) then begin
>    output('<b>Found</b>');
> end else begin
>    output('<b>Not found<b>');
> end;
> output('<html>');
> dbclose(1);
>
> and I would like to use TDBISamTable assigned to a variable like:
>
> var T: TDBISamTable;
> T := TDBISamTable.Create(nil);
> try
>    T.TableName := 'X';
>    ...
>    T.Close;
> finally
>    T.Free;
> end;
>
> Eduardo
>
>
Fri, Apr 7 2006 4:57 PMPermanent Link

"Jose Eduardo Helminsky"
Michael

Thanks for the info.
I will take a look, I think it is what I need.

Eduardo

Image