Search found 65 matches

by klchin
14.10.2005, 03:55
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: resume broken connection
Replies: 9
Views: 2998

Hi,

Any general API for all kind of SQL server?

Regards,
KL Chin
by klchin
13.10.2005, 03:00
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: resume broken connection
Replies: 9
Views: 2998

Hi,

BTW, instead of using "Open" or "Exec"to find-out to find
out the connection was broken, any other method?

Regards
KL Chin
by klchin
10.10.2005, 08:03
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: resume broken connection
Replies: 9
Views: 2998

Hi, I having the similar problem, only it was under the internet enviroment. I would like to know under which event it will be trigger? Or which function to determine the connection was disconnect before starting query Open or Exec? I try to catch the exeception, and used back the connection from th...
by klchin
10.10.2005, 07:28
Forum: 6.1.5
Topic: HOw can I insert data
Replies: 1
Views: 955

Hi,

You can use TZquery with standard SQL statement.

i.e.
Insert into Address (name,address,id,telephone ) Values
( 'abc','No 19, West Road','123-abc','888-999-11111' );
by klchin
02.09.2005, 06:32
Forum: 6.1.5
Topic: Zeos(6.1.5) + MsSQL
Replies: 0
Views: 1145

Zeos(6.1.5) + MsSQL

Hi Alls, How to solve this option setting, when execute the SQL below Select * from subMsSQLsvr.DatabaseName.dbo.TableName. where I connected to the main MsSQL server and wanted access the sub-MsSQL server. Error: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for t...