Re: [fpc-pascal] Trying to compile ZeosDBO cli program

2018-02-15 Thread leledumbo via fpc-pascal
> Never mind I have it figured out.  You have to add the path to 
> the /etc/fpc.cfg file, such as: 

You can do it from command line, too. In fact, if you already have it
working from Lazarus, simply open Project Options->Show Options->Command
Line Parameters tab, copy the content for your fpc options, done.



--
Sent from: http://free-pascal-general.1045716.n5.nabble.com/
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] Trying to compile ZeosDBO cli program

2018-02-13 Thread Terry A. Haimann
Never mind I have it figured out.  You have to add the path to
the /etc/fpc.cfg file, such as:

-Fu/home/user/ZeosDBO/packages/lazarus/lib/x86_64-linux

I remembered we do something like this years ago with an older mysql
library.

Terry H.



I tried adding the following to my path:

/home/terry/ZeosDBO/src/plain
/home/terry/ZeosDBO/src/
/home/terry/ZeosDBO/src/component
/home/terry/ZeosDBO/src/core
/home/terry/ZeosDBO/src/dbc
/home/terry/ZeosDBO/src/parsesql

And when I try to coompile, it is still saying:
Can't find Unit Zconnection 

I only added the paths in temporarily.


On 13/02/2018 15:48 μμ, Terry A. Haimann wrote:
> I really do not understand your response.  If you are talking about
> Lazarus, I already have it working there.
OK

> I am wanting to get it to
> work from a command line batch program using fpc.  Using fpc I do not
> know how to set required packages and from fpc I do not know where a
> Project Inspector would be.

Oh! I assumed that the cli application was edited from lazarus in that 
case add the folder where the code is to your path not the compiled 
binaries. I Assume something along the lines of
/home/terry/ZeosDBO/src/plain
/home/terry/ZeosDBO/src/
/home/terry/ZeosDBO/src/component
/home/terry/ZeosDBO/src/core
/home/terry/ZeosDBO/src/dbc
/home/terry/ZeosDBO/src/parsesql


___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] Trying to compile ZeosDBO cli program

2018-02-13 Thread Terry A. Haimann
I tried adding the following to my path:

/home/terry/ZeosDBO/src/plain
/home/terry/ZeosDBO/src/
/home/terry/ZeosDBO/src/component
/home/terry/ZeosDBO/src/core
/home/terry/ZeosDBO/src/dbc
/home/terry/ZeosDBO/src/parsesql

And when I try to coompile, it is still saying:
Can't find Unit Zconnection 

I only added the paths in temporarily.


On 13/02/2018 15:48 μμ, Terry A. Haimann wrote:
> I really do not understand your response.  If you are talking about
> Lazarus, I already have it working there.
OK

> I am wanting to get it to
> work from a command line batch program using fpc.  Using fpc I do not
> know how to set required packages and from fpc I do not know where a
> Project Inspector would be.

Oh! I assumed that the cli application was edited from lazarus in that 
case add the folder where the code is to your path not the compiled 
binaries. I Assume something along the lines of
/home/terry/ZeosDBO/src/plain
/home/terry/ZeosDBO/src/
/home/terry/ZeosDBO/src/component
/home/terry/ZeosDBO/src/core
/home/terry/ZeosDBO/src/dbc
/home/terry/ZeosDBO/src/parsesql


___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] Trying to compile ZeosDBO cli program

2018-02-13 Thread stdreamer

On 13/02/2018 15:48 μμ, Terry A. Haimann wrote:

I really do not understand your response.  If you are talking about
Lazarus, I already have it working there.

OK


I am wanting to get it to
work from a command line batch program using fpc.  Using fpc I do not
know how to set required packages and from fpc I do not know where a
Project Inspector would be.


Oh! I assumed that the cli application was edited from lazarus in that 
case add the folder where the code is to your path not the compiled 
binaries. I Assume something along the lines of

/home/terry/ZeosDBO/src/plain
/home/terry/ZeosDBO/src/
/home/terry/ZeosDBO/src/component
/home/terry/ZeosDBO/src/core
/home/terry/ZeosDBO/src/dbc
/home/terry/ZeosDBO/src/parsesql

___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] Trying to compile ZeosDBO cli program

2018-02-13 Thread Terry A. Haimann
I really do not understand your response.  If you are talking about
Lazarus, I already have it working there.  I am wanting to get it to
work from a command line batch program using fpc.  Using fpc I do not
know how to set required packages and from fpc I do not know where a
Project Inspector would be.

Mostly, at this point,I want to compare ZeosDBO's performance against
SqlDB.  I know how to do this with SqlDB, but think it's performance is
lackluster. 

Terry H


On 13/02/2018 04:50 πμ, Terry A. Haimann wrote:
> First of all, thank you for looking at this, Terry H.
>
> To compile a cli FreePascal program to use ZeosDBO library, I assume
all
> I have to do is include the path to those files.
>
> On my laptop, the files appear to be in:
>
> /home/terry/ZeosDBO/packages/lazarus/lib/x86_64-linux
>
> Well after adding that to the path and put ZConnection in the uses
> clause, it comes up with a "Can't find unit ZConnection"
>
you do not add the path (remove it) you add the ZeosDBO package to your 
required packages. Open the project inspector and select add new 
requirement. that will sort the file not found out for you.


___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] Trying to compile ZeosDBO cli program

2018-02-13 Thread stdreamer

On 13/02/2018 04:50 πμ, Terry A. Haimann wrote:

First of all, thank you for looking at this, Terry H.

To compile a cli FreePascal program to use ZeosDBO library, I assume all
I have to do is include the path to those files.

On my laptop, the files appear to be in:

/home/terry/ZeosDBO/packages/lazarus/lib/x86_64-linux

Well after adding that to the path and put ZConnection in the uses
clause, it comes up with a "Can't find unit ZConnection"

you do not add the path (remove it) you add the ZeosDBO package to your 
required packages. Open the project inspector and select add new 
requirement. that will sort the file not found out for you.

___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

[fpc-pascal] Trying to compile ZeosDBO cli program

2018-02-12 Thread Terry A. Haimann
First of all, thank you for looking at this, Terry H.

To compile a cli FreePascal program to use ZeosDBO library, I assume all
I have to do is include the path to those files.

On my laptop, the files appear to be in:

/home/terry/ZeosDBO/packages/lazarus/lib/x86_64-linux

Well after adding that to the path and put ZConnection in the uses
clause, it comes up with a "Can't find unit ZConnection"

At least a directory of that gives me these files:

ZAbstractConnection.oZDbcASA.o
ZDbcInterbase6ResultSet.ppu  ZDbcPooled.o ZEncoding.ppu
ZMatchPattern.ppu ZPlainLoader.o
ZSqlMetadata.o
ZAbstractConnection.ppu  ZDbcASA.ppu
ZDbcInterbase6Statement.oZDbcPooled.ppu   ZExpression.o
ZMessages.o   ZPlainLoader.ppu
ZSqlMetadata.ppu
ZAbstractDataset.o   ZDbcASAResultSet.o
ZDbcInterbase6Statement.ppu  ZDbcPostgreSqlMetadata.o
ZExpression.ppu  ZMessages.ppu
ZPlainMySqlConstants.o  ZSqlMonitor.o
ZAbstractDataset.ppu ZDbcASAResultSet.ppu
ZDbcInterbase6Utils.oZDbcPostgreSqlMetadata.ppu   ZExprParser.o
ZMessages.rsj ZPlainMySqlConstants.ppu
ZSqlMonitor.ppu
ZAbstractRODataset.o ZDbcASAStatement.o
ZDbcInterbase6Utils.ppu  ZDbcPostgreSql.o
ZExprParser.ppu  ZMySqlAnalyser.o
ZPlainMySqlDriver.o ZSqlProcessor.o
ZAbstractRODataset.ppu   ZDbcASAStatement.ppuZDbcIntfs.o
ZDbcPostgreSql.ppu   ZExprToken.o ZMySqlAnalyser.ppu
ZPlainMySqlDriver.ppu   ZSqlProcessor.ppu
ZAbstractTable.o ZDbcASAUtils.o  ZDbcIntfs.ppu
ZDbcPostgreSqlResultSet.oZExprToken.ppu   ZMySqlToken.o
zplain.oZSqlStrings.o
ZAbstractTable.ppu   ZDbcASAUtils.ppuZDbcLogging.o
ZDbcPostgreSqlResultSet.ppu  ZFunctionsConvert.o  ZMySqlToken.ppu
ZPlainOracleConstants.o ZSqlStrings.ppu
ZClasses.o   ZDbcCachedResultSet.o   ZDbcLogging.ppu
ZDbcPostgreSqlStatement.oZFunctionsConvert.ppuZOracleAnalyser.o
ZPlainOracleConstants.ppu   ZSqlUpdate.o
ZClasses.ppu ZDbcCachedResultSet.ppu ZDbcMetadata.o
ZDbcPostgreSqlStatement.ppu  ZFunctionsDateTime.o
ZOracleAnalyser.ppu   ZPlainOracleDriver.o
ZSqlUpdate.ppu
ZCollections.o   ZDbcCache.o ZDbcMetadata.ppu
ZDbcPostgreSqlUtils.oZFunctionsDateTime.ppu   ZOracleToken.o
ZPlainOracleDriver.ppu  ZStoredProcedure.o
ZCollections.ppu ZDbcCache.ppu   ZDbcMySqlMetadata.o
ZDbcPostgreSqlUtils.ppu  ZFunctionsMath.o ZOracleToken.ppu
ZPlainPostgreSqlDriver.oZStoredProcedure.ppu
ZCompatibility.o zdbc.compiled
ZDbcMySqlMetadata.ppuzdbc.ppu
ZFunctionsMath.ppu   zparsesql.compiled
ZPlainPostgreSqlDriver.ppu  ZStreamBlob.o
ZCompatibility.ppu   ZDbcConnection.oZDbcMySql.o
ZDbcResultSetMetadata.o  ZFunctions.o zparsesql.o
zplain.ppu  ZStreamBlob.ppu
zcomponent.compiled  ZDbcConnection.ppu  ZDbcMySql.ppu
ZDbcResultSetMetadata.ppuZFunctionsOther.ozparsesql.ppu
ZPlainSqLiteDriver.oZSybaseAnalyser.o
zcomponent.o ZDbcDbLibMetadata.o
ZDbcMySqlResultSet.o ZDbcResultSet.o
ZFunctionsOther.ppu  ZPgEventAlerter.o
ZPlainSqLiteDriver.ppu  ZSybaseAnalyser.ppu
zcomponent.ppu   ZDbcDbLibMetadata.ppu
ZDbcMySqlResultSet.ppu   ZDbcResultSet.ppuZFunctions.ppu
ZPgEventAlerter.ppu   ZPostgreSqlAnalyser.o
ZSybaseToken.o
ZComponentReg.o  ZDbcDbLib.o
ZDbcMySqlStatement.o ZDbcSqLiteMetadata.o
ZFunctionsStrings.o  ZPlainASAConstants.o
ZPostgreSqlAnalyser.ppu ZSybaseToken.ppu
ZComponentReg.ppuZDbcDbLib.ppu
ZDbcMySqlStatement.ppu   ZDbcSqLiteMetadata.ppu
ZFunctionsStrings.ppuZPlainASAConstants.ppu
ZPostgreSqlToken.o  ZSysUtils.o
ZConnectionGroup.o   ZDbcDbLibResultSet.oZDbcMySqlUtils.o
ZDbcSqLite.o ZGenericSqlAnalyser.oZPlainASADriver.o
ZPostgreSqlToken.ppuZSysUtils.ppu
ZConnectionGroup.ppu ZDbcDbLibResultSet.ppu  ZDbcMySqlUtils.ppu
ZDbcSqLite.ppu   ZGenericSqlAnalyser.ppu
ZPlainASADriver.ppu   ZPropertyEditor.o
ZTokenizer.o
ZConnection.oZDbcDbLibStatement.ozdbc.o
ZDbcSqLiteResultSet.oZGenericSqlToken.o   zplain.compiled
ZPropertyEditor.ppu ZTokenizer.ppu
ZConnection.ppu  ZDbcDbLibStatement.ppu
ZDbcOracleMetadata.o ZDbcSqLiteResultSet.ppu
ZGenericSqlToken.ppu ZPlainDbLibConstants.o
ZScriptParser.o ZUpdateSqlEditor.o
zcore.compiled   ZDbcDbLibUtils.o
ZDbcOracleMetadata.ppu   ZDbcSqLiteStatement.o
ZGroupedConnection.o ZPlainDbLibConstants.ppu
ZScriptParser.ppu   ZUpdateSqlEditor.ppu
zcore.o  ZDbcDbLibUtils.ppu  ZDbcOracle.o
ZDbcSqLiteStatement.ppu  ZGroupedConnection.ppu
ZPlainDbLibDriver.o