Search found 19 matches

by Darkbow
17.04.2011, 18:07
Forum: 6.6 - stable
Topic: Firebird : Stored proc on insert/update
Replies: 0
Views: 596

Firebird : Stored proc on insert/update

Hi, using scenario Lazarus 0.9.31-29128 + FPC-2.4.2-20110120 + Firebird Embedded 2.1 in a Win32 environment I have following scenario: TZQuery which retrieves a select that is a join of three tables. I have an editable DBGrid tied to this TZQuery through a TDataSource. Whenever the user inserts or u...
by Darkbow
13.02.2011, 12:59
Forum: 6.6 - stable
Topic: Lazarus + Zeos 6.6.6-stable
Replies: 5
Views: 1284

Forgot to post the solution of my problem, just in case anybody else runs into it. It seems it was a problem on the Lazarus side. I put the Zeos folder in the Components subfolder of the Lazarus installation and recompiled Lazarus. All went fine and I could create a project, drop some Zeos component...
by Darkbow
19.12.2010, 11:49
Forum: 6.6 - stable
Topic: Lazarus + Zeos 6.6.6-stable
Replies: 5
Views: 1284

mdaems wrote:Darkbow,

Lazarus version is 0.9.28.2 since a year, when I look at the sourceforge download pages. So 0.9.23 is quite old now (medio 2007, I think)

Mark
sorry, that was a typo. I meant 0.9.28.3
by Darkbow
17.12.2010, 19:55
Forum: 6.6 - stable
Topic: Lazarus + Zeos 6.6.6-stable
Replies: 5
Views: 1284

Hi Darkbow, Hi, and thx for your answer. :) First of all, why not the latest lazarus version? Because FPC 2.4.2 is the stable version of Free Pascal, as far as I know. I need to use a stable combination of FPC + Lazarus so I downloaded the Lazarus build that uses that FPC version. As I have no expe...
by Darkbow
16.12.2010, 19:46
Forum: 6.6 - stable
Topic: Lazarus + Zeos 6.6.6-stable
Replies: 5
Views: 1284

Lazarus + Zeos 6.6.6-stable

Ok, this is making me crazy... I need to install Lazarus 0.9.23-FPC.2.4.2 in the hope it will help me to sort out some serious bugs regarding TImage and loading JPEGs. I also need to use Zeos components with it, but I am not able to install neither 6.6.5 nor 6.6.6 versions in it. First one won't eve...
by Darkbow
13.12.2010, 18:35
Forum: Firebird
Topic: Firebird Embedded + Zeos on Ubuntu
Replies: 5
Views: 1283

Hmmm, I could swear I had done that step. Can not test it since my Ubuntu machine collapsed (HD failure) and I have not installed it again. As soon as I do I'll post the results here.
by Darkbow
17.11.2010, 17:24
Forum: Firebird
Topic: Firebird Embedded + Zeos on Ubuntu
Replies: 5
Views: 1283

Hi,

I am sorry but I do not understand what you mean...

How can I tell my application in Ubuntu where to look for the libraries? Or how do I configure Zeos to do so?

Thanks and best regards
by Darkbow
09.11.2010, 14:43
Forum: Firebird
Topic: Filtering Timestamp with zeos and fb URGENT
Replies: 10
Views: 1344

Are you sure the date format is correct? On the other hand, I am unsure whether if the selected database affects the filter in Zeos somehow, but you could try to use: filter := ' (movdate>='+QuotedStr('01-01-2010')+' AS TIMESTAMP)and(movdate<='+QuotedStr('31-01-2010')+' AS TIMESTAMP) '; HTH
by Darkbow
06.11.2010, 09:45
Forum: Firebird
Topic: Filtering Timestamp with zeos and fb URGENT
Replies: 10
Views: 1344

That sounds as a date cast problem. Supposing you are using Dialect 3 try this code instead: (movdate>=CAST('01-01-2010' AS TIMESTAMP)) and (movdate<=CAST('31-01-2010' AS TIMESTAMP)) If that does not work try replacing the comparison with: movdate<=(SELECT CAST('31-01-2010' AS TIMESTAMP)) FROM RDB$D...
by Darkbow
02.11.2010, 22:15
Forum: Firebird
Topic: Firebird Embedded + Zeos on Ubuntu
Replies: 5
Views: 1283

Firebird Embedded + Zeos on Ubuntu

Hi all, first of all sorry to ask this question. I know it has been answered several times but I checked all the posts related to my problem and I still can not solve it. I have programmed an app using Zeos 6.6.5 stable + Firebird Embedded 2.0 on Windows and it works just fine. Now I try to port it ...
by Darkbow
22.10.2009, 10:08
Forum: 6.6 - stable
Topic: TZQuery and TZUpdateSQL.
Replies: 2
Views: 739

I have not used TZUpdateSQL but my guess would be you have to fill the DeleteSQL, InsertSQL and ModifySQL properties of your TZUpdateSQL, and then TZQuery will use whatever SQL fits to the operation it must do.
by Darkbow
08.10.2009, 12:15
Forum: MySQL
Topic: Intercept OnReconcileError
Replies: 1
Views: 373

Could you please ellaborate a bit on your architecture? I am not sure I understood it. Do all threads access the same TClientDataset? If yes, is it protected somehow? If not, the problem could lay in the fact that TClientDatasets are not thread-safe. Regarding dbExpress, as far as I know some of its...
by Darkbow
01.10.2009, 13:40
Forum: 6.6 - stable
Topic: BDS2006 installation for Delphi and C++
Replies: 6
Views: 1056

The one you told me, KB->Compilers.

The error message was something like "You are not allowed to post here".
by Darkbow
29.09.2009, 16:15
Forum: 6.6 - stable
Topic: BDS2006 installation for Delphi and C++
Replies: 6
Views: 1056

Darkbow wrote: At least I'll put the steps in the Knowledge base. :)
Scratch that, forum does not allow me to submit articles... :?:
by Darkbow
29.09.2009, 16:03
Forum: 6.6 - stable
Topic: BDS2006 installation for Delphi and C++
Replies: 6
Views: 1056

To be honest I am no expert in the BDS IDEs. I have created, installed and deinstalled components before, but not much more. As I see it there are mainly 3 problems: 1- Not all .DCUs are created when building with "Generate all C++ Builder files", thus making steps 3,4 and 5 necessary. I h...