Zeoslib Portal

Sound like this would be database specific. What database are you using?

Regards,

Ben

ZStoredProc doesn't currently support PosgreSQL's functions. Use ZQuery instead.

Regards,

Ben

try ZQuery1.ParamByName('UserNameTxt').AsString := UserNameTxt.Text; ZQuery1.ParamByName('PasswordTxt').AsString := PasswordTxt.Text; instead of UserNameTxt.Text := ZQuery1.ParamByName('UserNameTxt').AsString; PasswordTxt.Text:= ZQuery1.ParamByName('PasswordTxt').AsString; Regards, Ben

I agree that it can't get much easier but if you are doing this often, you could create a function to do it. Also have you looked at the TZSequence component? It could be useful for this but I'm not sure what databases it supports. BTW Query.Open is completely equivalent to Query.Active := True; Ben

@Ben : I think the OP wanted to catch the errors raised on the server. Maybe, but RAISE NOTICE is different to LISTEN / NOTIFY which is what was supported by previous versions of ZeosLib, that's all I was saying. On PostgreSQL's command line: postgres=# listen some_message; LISTEN postgres=# notify...

I think the OP was talking about something other than LISTEN / NOTIFY. ( http://www.postgresql.org/docs/8.2/interactive/sql-notify.html ) RAISE NOTICE is similar to RAISE EXCEPTION and used in PL/pgSQL functions to return messages within the function call without aborting the transaction. See here: ...

The above messages are all expected when you install ZeosLib. The .res files do need to be recreated and only the ZComponentDesign100.bpl file should be installed. The others should just be compiled.

Regards,

Ben

Try the TZQuery.CanModify property.

Regards,

Ben

Thanks Edwin!!

I came across this same problem about a year ago and spent ~2 days trying to work out how to fix it.

Sometimes you can't see the wood for the trees.

Regards,

Ben

BTW you could just use PostgreSQL-7 protocol and the libpq73.dll. I don't think ZeosLib uses much, if any of the new features available in the new dlls.

Regards,

Ben

You'll also need to put the following files in the system32 folder (or your programs folder):

comerr32.dll
iconv.dll
krb5_32.dll
libeay32.dll
libiconv-2.dll
libintl-2.dll
ssleay32.dll

which you can find in the bin folder of a windows version of a PostgreSQL install.

Regards,

Ben

Try setting Not tested but should work.

Regards,

Ben

What you need is an 'Interval' data type. I'm not sure MySQL supports it (BTW PostgreSQL does). If MySQL doesn't have such a thing you might be better off just using a large floating point data type. I think that is what TDateTime is anyway so it might be a good fit.

Regards,

Ben

I've learned from bitter experience that you need varchar(254) instead of text for most string fields. In Delphi anything bigger is a problem as it's always treated as a Memo field. It also helps when using MS Access to connect to PostgreSQL. BTW if you just want to view your Memo fields in a dbgrid...

I think he means it's an interface and will release itself if you set it to nil.

Regards,

Ben