Search found 8 matches

by mtournay
07.02.2021, 11:06
Forum: MS SQL Server
Topic: Execute stored proc with table parameter
Replies: 4
Views: 537

Re: Execute stored proc with table parameter

Hi aehimself https://ci.appveyor.com/project/FreeTDS/freetds Choose the flavor (x86, x64, VS dependency version), click on "Artifacts" and download. Took me a while to figure it out. I found this later that day, after cliking on all buttons and link in appveyor pages :) Thanx ! Best regards.
by mtournay
04.02.2021, 15:46
Forum: MS SQL Server
Topic: Execute stored proc with table parameter
Replies: 4
Views: 537

Re: Execute stored proc with table parameter

Hello

I finaly found zprocessor !

I have errors, but not sure from where it comes. The code above executes well in MSSM, but not from my pascal code ...
Can't share code of the proc, so i'm on my own

Bye
by mtournay
03.02.2021, 17:39
Forum: MS SQL Server
Topic: Execute stored proc with table parameter
Replies: 4
Views: 537

Execute stored proc with table parameter

Hi everybody I have to execute this through lazarus DECLARE @result int; DECLARE @liste AS MMEA_tableauProduits; insert into @liste (CodeCIP, quantite) VALUES ('3400935955838', 1),('4052199014111', 1); exec [dbo].[MMEA_ajouteDocVente] @IDF_CIP = '1234567', @DO_Ref = 'test', @Do_Type = 1, @listeProdu...
by mtournay
20.08.2018, 14:00
Forum: ZeosLib 7.1 stable Forum
Topic: ZUpdateObject example
Replies: 4
Views: 4220

Re: ZUpdateObject example

Hi Sorry to bother you, but it's still not working. I forget to mention that in the list query, there is a join SELECT T0.id, T0.article_id, T0.CodeCIP, T0.Libelle, T0.DateCreation, T0.BLM_ID, T0.DateRappel, T0.Commentaire, BLM.BLM_NOM FROM retraits AS T0 LEFT JOIN BLOCAGE_LOT_MOTIF BLM ON BLM.BLM_I...
by mtournay
20.08.2018, 13:18
Forum: ZeosLib 7.1 stable Forum
Topic: ZUpdateObject example
Replies: 4
Views: 4220

Re: ZUpdateObject example

Hi Jan

Do I have to understand that parameters in update/insert have to be present in original select ?

I will update to 7.2.4 via OPM and make some test....

regards
by mtournay
20.08.2018, 13:12
Forum: ZeosLib 7.2 Forum
Topic: Lazarus - online package manager
Replies: 7
Views: 2612

Re: Lazarus - online package manager

Hi

Thank you everybody, for package update !

regards
by mtournay
02.08.2018, 15:54
Forum: ZeosLib 7.1 stable Forum
Topic: ZUpdateObject example
Replies: 4
Views: 4220

ZUpdateObject example

Hi I try to use TZQuery and TZUpdateSQL with lazarus and it gives me headache. the situation is : a datamodule with TZquery and TZUpdateSQL TZQuery.UpdateObject is set to TZUpdateSQL component TZQuery have a select query SELECT libelle, CodeCIP FROM t0 TZUpdateSQL have an insert query INSERT INTO t0...
by mtournay
02.08.2018, 15:31
Forum: ZeosLib 7.2 Forum
Topic: Lazarus - online package manager
Replies: 7
Views: 2612

Lazarus - online package manager

Hi there

Lazarus 1.8 have an online package manager. ZeosLib is still in v7.1. Do you know how to change that ?

I also post a new thread in lazarus forum.

regards