Search found 8 matches
- 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.
- 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
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
- 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...
- 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...
- 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
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
- 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
Thank you everybody, for package update !
regards
- 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...
- 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
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