Zeoslib Portal

Maybe it helps when you convert the timestamp to a date using to_date, either in your query or, if you have to use a TZTable, by creating a view with the to_date conversion and using that view for the TZTable. As far as I remember the timestamp was only introduced in Oracle 10g. What Oracle client v...

Hi Chris,

Thanky you. What I did wrong was writing :MEMORY instead of :memory:. Who would expect that?
Now it is working fine :-)

Rüdiger

XE. That is what I meant. It is hard to say how that thingy is called. I looked it up in the documentation: it#s Net Service Name. Aha.

For Oracle it works that way:
Database: tnsnames.ora entry for the database
HostName: empty

Hi!

It should be possible to create a SQLite database in memory, on the fly, create and populate tables and do sql operations on them. Other components (DISqlite) can do that.
Any ideas how this could be done using Zeos?

Regards,
Rüdiger

What error message do you get?

Can you connect to other Oracle versions? As far as I know, connection methods didn't have changed.
I leave Hostname empty, and in Database there is the entry from my tnsnames.ora. That should also worj for Oracle 11g.

hth
Rüdiger

Conn.StartTransaction only works in AutoCommit mode. StartTransaction means then "I want to start a new transaction, even when it is not necessary, as I am in AutoCommit mode". Quite strange, but it is so. With most database engines you do not need to start a transaction manually. After a ...

Hi Maria, Do you have persistent fields for table resguardo? That means, have you doubleclicked the component and choosen "add all fields"? Then ZTable1FECHA_DOCUMENTO should be a TDateField. What happens when you are trying it without persistent fields (just deleting them in the field edi...

Hi Maria, Is this still with date/time variables? Inserting/updating or also selecting? Strange enough, the explanation of ORA-00932 sounds quite different: "An attempt was made to perform an operation on incompatible datatypes. For example, adding a character field to a date field (dates may o...

Hi María,

In the end you will have to reconstruct Lazarus to use Zeos with it, so it would be better to look for the compilation errors and what caused them. Did it work before you made these changes?
And Oracle 8.0.5 is really old.

Regards,
Rüdiger

Hi Olga, Now I tried it. It can't be done automatically, because the "MasterSource" property of a TZQuery only accepts one. But it is not so bad. In the "OnChange" method of both components where you display the Farms and Grains I did that: QQualityGrain.Close; QQualityGrain.Para...

Hi Olga, Why do you need the GrainInf_farm_idFarm in QualityGrain? GrainInf is already linked to Farm, so when QualityGrain is linked to GrainInf (by GrainInf_idGrainInf) it is automatically linked to Farm. It would be another thing if GrainInf would be "Farm-independent" (which in my opin...

When the query is too complex Zeos can not decide how to build e.g. the update statemant. In this case you have to use TZUpdateSQL and write your own udate, insert etc. code. Sometimes Zeos generates very complicated (WHERE ... AND ... AND ...) update statement. You can control that setting TZQuery'...

Using the "automatic" features (using the dataset's procedures and the master-detail arrangement) is certainly easier - as long as it works, but it should work in most cases. Performance should be the same, as in any case it is just SQL. If you are not content with the performance of autom...