On Fri, 16 Dec 2022, Ondrej Pokorny via fpc-pascal wrote:
Hello,
I've got a similar problem about 2 days ago. I have a stored MSSQL procedure
that changes a table. When it is run in SQL Managements Studio, the data get
changed.
When I run it with FPC, it runs fine but nothing changes. I
On Fri, 16 Dec 2022, Andi Friess via fpc-pascal wrote:
Am 16.12.2022 um 08:50 schrieb Michael Van Canneyt via fpc-pascal:
ApplyUpdates as you use it, is not the correct solution.
Once more: ApplyUpdates ONLY makes sense after changing data and doing a
Post. Any other use does not make any sen
Hello,
I've got a similar problem about 2 days ago. I have a stored MSSQL
procedure that changes a table. When it is run in SQL Managements
Studio, the data get changed.
When I run it with FPC, it runs fine but nothing changes. I do commit
the transaction explicitly but the data isn't change
Am 16.12.2022 um 08:50 schrieb Michael Van Canneyt via fpc-pascal:
ApplyUpdates as you use it, is not the correct solution.
Once more: ApplyUpdates ONLY makes sense after changing data and doing a
Post. Any other use does not make any sense.
Data is changed by the SP. But this is done in a simp
On Fri, 16 Dec 2022, Andi Friess via fpc-pascal wrote:
Am 15.12.2022 um 14:59 schrieb Michael Van Canneyt via fpc-pascal:
On Thu, 15 Dec 2022, Andreas Frieß via fpc-pascal wrote:
Post operation.
No, if you use a stored procedure on the MSSQL Server there can be
changes on tables. Withou
Am 15.12.2022 um 14:59 schrieb Michael Van Canneyt via fpc-pascal:
On Thu, 15 Dec 2022, Andreas Frieß via fpc-pascal wrote:
Post operation.
No, if you use a stored procedure on the MSSQL Server there can be
changes on tables. Without the ApplyUpdates these changes are not
persitent. If you
On Thu, 15 Dec 2022, Andreas Frieß via fpc-pascal wrote:
Post operation.
No, if you use a stored procedure on the MSSQL Server there can be
changes on tables. Without the ApplyUpdates these changes are not
persitent. If you close and reopen the connection ALL is lost. With
ApplyUpdates it wo
Am 15.12.2022 um 11:15 schrieb Michael Van Canneyt via fpc-pascal:
On Thu, 15 Dec 2022, Andreas Frieß via fpc-pascal wrote:
On MSSQL i use a stroed procedure to count a value in a table and use
the following statement in Lazarus
1.
procedureTForm1.BuExecuteClick(Sender:TObject);
2.
On Thu, 15 Dec 2022, Andreas Frieß via fpc-pascal wrote:
On MSSQL i use a stroed procedure to count a value in a table and use
the following statement in Lazarus
1.
procedureTForm1.BuExecuteClick(Sender:TObject);
2.
var
3.
SQL:string;
4.
begin
5.
Memo1.Clear;
6.
On MSSQL i use a stroed procedure to count a value in a table and use
the following statement in Lazarus
1.
procedureTForm1.BuExecuteClick(Sender:TObject);
2.
var
3.
SQL:string;
4.
begin
5.
Memo1.Clear;
6.
SQL:='';
7.
SQL:='EXECUTE [dbo].[GetNextZaehler] :TagN
10 matches
Mail list logo
