Search found 6 matches

by angerp67
05.11.2011, 16:46
Forum: ZeosLib 7.0 Beta Forum
Topic: delphi xe zeos 7 sql server 2007
Replies: 4
Views: 788

i attach src demo for delphi ze and sql for create table

link to download
http:\\assistenza.gestionaleopen.it\download\paolo\src_demo_xe.zip
by angerp67
05.11.2011, 16:24
Forum: ZeosLib 7.0 Beta Forum
Topic: delphi xe zeos 7 sql server 2007
Replies: 4
Views: 788

I'm using tzquery but i tried with tztable
and ib both cases dataset is readonly

paolo
by angerp67
05.11.2011, 06:43
Forum: ZeosLib 7.0 Beta Forum
Topic: delphi xe zeos 7 sql server 2007
Replies: 4
Views: 788

delphi xe zeos 7 sql server 2007

I connect to database sql server 2008 , i see record of table but if i want to edit data, dataset is like readonly but property of query readonly is false. if i use ado connection and tado query i can modify data there is some property to set in connection object or query object to ability data modi...
by angerp67
21.12.2010, 16:42
Forum: MySQL
Topic: setting CLIENT_MULTI_RESULTS
Replies: 1
Views: 1304

setting CLIENT_MULTI_RESULTS

HI, I created a stored procedure but when I execute query for run the program mysql raise an error sql error p_program can't return a result set in the given context. reading mysql documentation there is a connection parameter CLIENT_MULTI_STATEMENTS to set. How can i set this parameter in the conne...
by angerp67
18.12.2007, 17:55
Forum: PostgreSQL
Topic: create database for postgressql 8.2
Replies: 2
Views: 1341

It work fine

thank you
paolo
by angerp67
15.12.2007, 16:30
Forum: PostgreSQL
Topic: create database for postgressql 8.2
Replies: 2
Views: 1341

create database for postgressql 8.2

I Tried to create database at run-time with postgressql 8.2 and zeos 6.6.2 arc_fir.connected := false; arc_fir.database := 'postgres'; arc_fir.connected := true; ZSQLProcessor.Script.Text := 'CREATE DATABASE dbname WITH TEMPLATE = template0 ENCODING = ''UTF8'';'; ZSQLProcessor.Execute; when i ran sq...