Joined: 20 Jun 2011
Location: United Kingdom
Online Status: Offline
Posts: 5
Topic: Create Parameter to write back to SQL Posted: 15 Sep 2013 at 9:46pm
Hi
We currently have a process that we use to print cheques for a client.
I have been asked if I can find a way that the printing team can enter the 1st cheque number of the batch prior to printing and this then populates the relevant table in SQL - as well as printing this number on the cheque itself (for some reason having just the pre-printed number at the foot of the cheque isnt good enough for the banks..)
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 16 Sep 2013 at 6:27am
using a stored procedure, you could set a parameter for the first number to be printed. The store proc could do all the updating of tables and just return a recordset of checks to be printed.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
