 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Thatchin
Guest
|
 Posted: Fri Jan 16, 2004 11:53 am Post subject: How to retrive the NO generated No into the TClientDataSet's |
 |
|
Hi All !
How to retrive the NO generated No into the TClientDataSet's field JNO.
Thanks in advance !
Thatchiin
|
|
| Back to top |
|
 |
Bill Todd (TeamB)
Guest
|
| Posted: Fri Jan 16, 2004 1:42 pm Post subject: Re: How to retrive the NO generated No into the TClientDataS |
|
|
On Fri, 16 Jan 2004 17:53:50 +0600, "Thatchin" <thatchiin (AT) hotmail (DOT) com>
wrote:
| Quote: | How to retrive the NO generated No into the TClientDataSet's field JNO.
|
Your question makes no sense. What database are you using and what,
exactly, are you trying to do?
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
|
Thatchin
Guest
|
| Posted: Mon Jan 19, 2004 10:04 am Post subject: Re: How to retrive the NO generated No into the TClientDataS |
|
|
Sorry Bill I agree with you. Im using Delphi 6 and Interbase.
The problem is I use GEN_ID to generate the InvoiceNo, and now I need that
particular generated no passed back to the client where the same has to be
used for printing purposes. thanks.
"Bill Todd (TeamB)" <no (AT) no (DOT) com> wrote
| Quote: | On Fri, 16 Jan 2004 17:53:50 +0600, "Thatchin"
wrote:
How to retrive the NO generated No into the TClientDataSet's field JNO.
Your question makes no sense. What database are you using and what,
exactly, are you trying to do?
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
|
| Back to top |
|
|
Bill Todd (TeamB)
Guest
|
| Posted: Mon Jan 19, 2004 1:31 pm Post subject: Re: How to retrive the NO generated No into the TClientDataS |
|
|
On Mon, 19 Jan 2004 16:04:59 +0600, "Thatchin" <thatchiin (AT) hotmail (DOT) com>
wrote:
| Quote: | The problem is I use GEN_ID to generate the InvoiceNo, and now I need that
particular generated no passed back to the client where the same has to be
used for printing purposes.
|
Write a stored procedure that calls GEN_ID and returns the number.
Call the stored proc in the OnNewRecord event handler and assign it to
the new invoice record.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
|
Thatchin
Guest
|
| Posted: Fri Jan 23, 2004 12:14 pm Post subject: Re: How to retrive the NO generated No into the TClientDataS |
|
|
Thanks Bill !
Also I tried with the folowing SQL Statement, this works fine too.
SELECT
GEN_ID(GENERATORNAME, 1)
FROM
RDB$DATABASE
"Bill Todd (TeamB)" <no (AT) no (DOT) com> wrote
| Quote: | On Mon, 19 Jan 2004 16:04:59 +0600, "Thatchin"
wrote:
The problem is I use GEN_ID to generate the InvoiceNo, and now I need
that
particular generated no passed back to the client where the same has to
be
used for printing purposes.
Write a stored procedure that calls GEN_ID and returns the number.
Call the stored proc in the OnNewRecord event handler and assign it to
the new invoice record.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
