[fpc-pascal] Connecting to a database from a commandline pascal program

[DaWorm]

Wouldn't this...

MyConnection.Create(Nil);
// MyQuery.Create(Nil);

... be more like...

MyConnection := TZConnection.Create();
MyQuery := TQuery.Create();

Then at the end you'd need...

MyQuery.Free();
MyConnection.Free();

Jeff


On Fri, Feb 16, 2018 at 10:25 AM, Terry A. Haimann <terry at haimann.us> wrote:

> Hello,
>
> I am trying to write a command Line Pascal program to connect to a MySQL
> database using the ZeosDBO Library. I am sure I have done something
> stupid.
>
> I have it now so that it will compile, but it crashes as soon as I try
> to modify my TZConnection variable.
>
>
> I have it defined as:
>
>         MyConnection:           TZconnection;
>
> And code is defined as:
>
>         WriteLn('2');
>         MyConnection.Create(Nil);
>         // MyQuery.Create(Nil);
>         WriteLn('2.0);
>         MyConnection := '127.0.0.1';
>         WriteLn('2.1');
>         MyConnection.Protocol   := 'mysql';
>         WriteLn('2.2');
>         MyConnection.Database   := 'MyDatabase';
>         WriteLn('2.3');
>         MyConnection.User       := 'MyUser';
>         WriteLn('2.4');
>         MyConnection.Password   := 'MyPass';
>         WriteLn('2.5');
>         MyConnection.Connected := True;
>         WriteLn('2.6');
>
> It never hits 2.0, so I believe it is dying on the create. Am I doing
> the create wrong?  I can't find any examples as too doing this, I have
> tried googling it.  Most of the examples I see are doing this from
> Lazarus.  Not from a command line Free Pascal program.
>
> Thanks in advance,      Terry H.
>
> _______________________________________________
> fpc-pascal maillist  -  fpc-pascal at lists.freepascal.org
> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-pascal/attachments/20180216/bcc941ad/attachment.html>