Search found 3 matches
- 26.10.2008, 13:36
- Forum: 6.6 - stable
- Topic: TZQuery is read-only when using stored procedure in SQL
- Replies: 4
- Views: 727
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...
- 25.10.2008, 21:03
- Forum: Firebird
- Topic: Inserting records using custom stored procedure
- Replies: 0
- Views: 659
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...
- 25.10.2008, 14:04
- Forum: 6.6 - stable
- Topic: TZQuery is read-only when using stored procedure in SQL
- Replies: 4
- Views: 727
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...