Search found 3 matches

by maakk
26.10.2008, 13:36
Forum: 6.6 - stable
Topic: TZQuery is read-only when using stored procedure in SQL
Replies: 4
Views: 711

I see but what if I need more control over how my data get updated? I thought that TZUpdateSQL is there just to meet such requirement. I mean, I want to select the data one way, and then insert/update completely other way (namely: using a stored procedure, which e.g. returns the value of the primary...
by maakk
25.10.2008, 21:03
Forum: Firebird
Topic: Inserting records using custom stored procedure
Replies: 0
Views: 648

Inserting records using custom stored procedure

I'm new both to delphi & Zeoslib, so please forgive my stupid questions... I have a table in database: create generator gen_icd10_id; create table icd10 ( ident integer not null, code varchar(8) not null, name varchar(255) not null ); set term ^ ; alter table icd10 add constraint pk_icd10 primar...
by maakk
25.10.2008, 14:04
Forum: 6.6 - stable
Topic: TZQuery is read-only when using stored procedure in SQL
Replies: 4
Views: 711

TZQuery is read-only when using stored procedure in SQL

First, I'm new to Delphi and Zeoslib, so pardon me if this is a stupid question, but: - I have TZConnection, TZQuery and TZUpdateSQL - TZQuery is data source for standard Delphi data controls (TDBEdit, TDBGrid) through a TDataSource Now, when I set the SQL of TZQuery like this: 'SELECT * FROM PATIEN...