delphi xe zeos 7 sql server 2007

angerp67 · Post by **angerp67** » 05.11.2011, 06:43

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 modification ??

Best regards
Paolo Angeretti

papelhigienico · Post by **papelhigienico** » 05.11.2011, 12:02

Are you using TZQuery or a TZTable ?

angerp67 · Post by **angerp67** » 05.11.2011, 16:24

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

paolo

angerp67 · Post by **angerp67** » 05.11.2011, 16:46

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

Post by **EgonHugeist** » 03.03.2012, 18:10

i'm starting to to workout the missig MSSQL-supports for D12_UP next time. Maybe you can help me here?