Search found 193 matches

Go to advanced search

by btrewern
12.04.2006, 11:29
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Problems connecting with Postgres 8.1.3
Replies: 3
Views: 974

Try using the 7.4 dll. Been working here for some time.

Regards,

Ben
by btrewern
12.04.2006, 11:26
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Set the DataSize of a field
Replies: 4
Views: 952

I think Delphi/BCB has a limit of 255 for String type fields. For anything more than that you have to use Memo fields. I'm not sure of the mapping between strings in MSSql and Delphi field types.

Ben
by btrewern
11.04.2006, 09:52
Forum: PostgreSQL
Topic: Runtime database create
Replies: 3
Views: 2121

I'd use a TZQuery and just ExecSQL the query. I doubt you can use parameters to create this type of query so just create the above string and use that.

Ben.
by btrewern
10.04.2006, 14:30
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Script without end delimiter
Replies: 4
Views: 1017

I'm not sure if it should execute or raise an error. Either way it shouldn't just ignore. I'll vote for Execute :-)

Ben
by btrewern
10.04.2006, 10:15
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Script without end delimiter
Replies: 4
Views: 1017

In the example did you mean to leave out the ; ? Otherwise I don't understand the question.

Ben
by btrewern
08.04.2006, 00:42
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Error in EscapeQuotes function
Replies: 1
Views: 401

Error in EscapeQuotes function

Does anybody else think this function looks wrong function EscapeQuotes(const Value: string): string; var I: Integer; PrevChar, PrevPrevChar: string; begin Result := ''; PrevChar := ' '; PrevPrevChar := ' '; for I := 1 to Length(Value) do begin Result := Result + Value[I]; if (Value[I] = '''') and (...
by btrewern
07.04.2006, 22:22
Forum: MySQL
Topic: Post Method
Replies: 3
Views: 1350

Post, Edit and Append work fine here!

RequestLive has changed to ReadOnly in 6.5.1 alpha.

What are you trying to do? Could you post some code.

Ben
by btrewern
06.04.2006, 16:15
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Invalid UTF-8 byte sequence detected
Replies: 7
Views: 1322

Check to make sure that the

Code: Select all

SET client_encoding = 'LATIN9'
is working.
try

Code: Select all

SELECT current_setting('client_encoding');
against the same connection to see if the parameter worked.

Regards,

Ben
by btrewern
04.04.2006, 12:12
Forum: ZDBC (ZEOS Database Connectivity)
Topic: Using SSL security to protect MySQ server
Replies: 3
Views: 3844

You could tunnel via ssh. I've tried it with VNC and got it working. See here : http://cyberknights.com.au/doc/PuTTY-tu ... HOWTO.html.

Regards,

Ben
by btrewern
30.03.2006, 15:25
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Access to DB2 with Zeos
Replies: 2
Views: 759

I don't think it's been written yet.

Regards,

Ben
by btrewern
28.03.2006, 20:13
Forum: 6.1.5
Topic: Issue with updating blob field
Replies: 1
Views: 1565

I've had to use temporary files to get this to work.

Regards,

Ben
by btrewern
25.03.2006, 22:45
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: ZConnection still connected after MySQL server stopped
Replies: 8
Views: 1431

Is that true? If you pull the plug on a MySQL server, your data is not saved and your tables get corrupted? If that is true then I'm glad I use PostgreSQL.

Ben
by btrewern
25.03.2006, 22:36
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Check the existance of a TABLENAME
Replies: 10
Views: 4657

I'm not sure if it is SQL spec complient but I shouldn't rely on it as I don't think it works on PostgreSQL, MS SQL Server, DB2 or Oracle.

Ben
by btrewern
23.03.2006, 18:22
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: time out and connection resume
Replies: 5
Views: 1071

There is a statement_timeout variable but I don't think there is a connection timeout setting for PostgreSQL These type of problems always seem to be related to router / network problems and the SELECT 1; type of work around is often used.

Regards,

Ben
by btrewern
21.03.2006, 15:44
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: SQL Monitor Logging
Replies: 12
Views: 5330

See the Sourceforge site: http://sourceforge.net/projects/zeoslib there is a link there to report bugs.

Ben

Go to advanced search