Zeoslib Portal

Why don't you use FormatDateTime('yyyy-MM-dd', datetimepicker1.date)? Then you can convert the date to any format you want.

Regards,
Rüdiger

Claro que funciona. Faço sempre assim...

Hi,

How did you export the data? The date format looks quite weird. And 12/30/1899 looks quite like zero.

Regards,
Rüdiger

Hi Marco,

Multiple connection components should do it. There is no more transaction component, since Zeos 6.

Regards,
Rüdiger

Hi Frank,

Ah, you didn't mention that you had installed Delphi 2006, you wrote it was a fresh install. And no way to have different search paths for the two versions?

Rüdiger

OK Ben that is true. But there have been many people who where confused with open/close and execute. So as a rule of thumb I say: when the query retorns rows: open/close, when not: execute.

Rüdiger

What is not easy here?
But what is qRwGeneral? Shouldn#t it be ZREadOnlyQuery1?
And with queries returning rows it is better to use Query.Close and Query.Open.

Hi John,

But they should at least appear in the Components... window in the Components/Install Packages menu (sorry, didn't see ZeosTrouble.jpg before). What about unchecking Zeos, closing Delphi and installing again? I know, an old trick...

Regards,
Rüdiger

Hm, that's strange. In Delphi, when you go to Components > Install Packages, is Zeos Database Components checked? And when you highlight Zeos and click Components..., are they appearing? And path settings: normally there has nothing to be done. By default, ${Delphi}\Projects\bpl is already there. Yo...

Hi,

This issue has been mentioned here before. If I remember well it had something to do with older versions being in the path. Is this a fresh install?
Maybe you can do a search here in the forum.

hth
Rüdiger

Hi!

As far as I can see, in the second case you tried to assign a datasource before you put it on the form - of course nothing to choose. After you deleted the ZQuery and put it on again - then the datasource was already there...

Regards,
Rüdiger

But does it really make sense to fetch all records of such a big table? Why don't you narrow down the result set to the records you really need? Just a question...

It seems so. I use 'oracle' for 10g, no problems. What happens when you use 'oracle-9i'? Or does it not yet exist in 6.1.5? Maybe you should try to a newer version. I use 6.5.1 as of 13/10/2005. If not, there seems to be no other way tan to dive into the code and look for the real origin of the erro...

There must be a "not found" message in the Filemon log when the "driver not found" message appears. Have you applied a filter to Filemon? Otherwise it is hard to find the right lines, as there appears so much. I have used Zeos 6.15 wit Oracle 8.1.7 and 10.2, am now using 6.5.1 an...

Hi, Normally, when you install the Oracle client, the installer creates a path entry %ORACLE_HOME%\bin, for example c:\oracle\bin, as the first element in the Path variable. So this should not be the problem. You could use Sysinternal's Filemon to find out what your program is looking for. Regards, ...