Zeoslib Portal

LISTEN and NOTIFY are slightly different. I think the OP is talking about RAISE NOTICE and RAISE EXCEPTION which can be used in stored procedures to display messages. See here http://www.postgresql.org/docs/8.3/interactive/plpgsql-errors-and-messages.html I thought there was a patch in the testing v...

BTW if you want to use ':' in your query which also has parameters then double your ':'s.

Regards,

Ben

All, I'm pretty sure there is no such thing as ADO on Linux so we can't expect much from the Lazarus team regarding that. The only way I can find to access MS SQL server fron *nix is via http://www.freetds.org/. This includes a standard library and an ODBC driver so it's a start. As I understand it,...

You could try using a TZSequence component. It's used for situations like this.

Ben

You need to use multiple TZConnections for concurrent queries. I've done it in a similar application to the one you describe and it works very well.

Ben

You could use a trigger as follows: CREATE TRIGGER APP_MODULES_DEFAULT FOR APP_MODULES ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF ((NEW.LASTUPDATE IS NULL) OR (NEW.LASTUPDATE = 0)) THEN BEGIN NEW.LASTUPDATED = "Now"; END END to replace your DEFAULT clause. I've had to do this when using o...

It looks like it's libpq.dll working as designed. See here: http://www.postgresql.org/docs/8.3/static/libpq-notice-processing.html . Note where is says "The default notice handling function prints the message on stderr, ...." It also looks like the only way to stop this is to set the PQnot...

See the ZSequence component. It's made specifically for this.

Regards,

Ben

I'm not sure how SQLite Administrator manages it but see http://www.sqlite.org/lang_vacuum.html for the standard SQLite command.

Regards,

Ben

Try using the TZSQLMonitor to see what queries are being sent to the server.

Ben

If I had to guess I'd say your table doesn't have a primary key. Try adding one to see if that fixes this.

Ben

Jona, It looks like Delphi's TTimeField is being used to represent your result. TTimeFields are limited to the range 00:00:00 .. 23:59:59.999.... and it looks like when Zeos is passed a value outside this range it returns 00:00:00 (See AnsiSQLDateToDateTime in the ZSysUtils unit). You could try usin...

Which DB are you using?

I don't expect you will be able to do this whatever database you are using. Try using a view instead.

In delphi you would do this using a calculated field and doing the calculation in the OnCalcFields event handler.

Regards,

Ben

With a quick web search I've found the original code by Kevin Boylan which Sergey Seroukhov used as the base for the ZMatchPattern Unit. See attached file.

I've used this to replace the code in ZMatchPattern and the filtering seems to work correctly.

Anyone have any comments?

Ben

After some investigation it looks like this is a problem in the ZMatchPattern.pas unit. See function MatchAfterStar(Pattern, Text: string): Integer; var P, T, PLen, TLen: Integer; begin Result := 0; P := 1; T := 1; PLen := Length(Pattern); TLen := Length(Text); if TLen = 1 then begin Result := MATCH...