Re: Setting control value based on a SQL Select statement

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You can use the output feature of parameters for a SP if you are using an
ADODB command object. Of course, you cannot do that if you are using a SP
bound to a form. For example of using a command object, see the previous
posts in this newsgroup.

A second way of returning more than a single parameter is simply to use a
recordset.

I don't understand what you mean by « So as an alternative I use a SQL
Select statement where GUID = linked server GUID in the hope I can return
these two values. ».

Don't be so complicated and make a SELECT statement at the end of your SP
and capture the result in a recordset.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Guy Kerr" <GuyKerr@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1367B1D4-9F4B-47FC-83F2-14DE3AF191CA@xxxxxxxxxxxxxxxx
Sorry I'm not too well versed in the terminology but I think I know what
you
mean. The form is bound to a SQL view and the control is bound to a field
from the view.

Here's some more detail that may help explain it better.

Each time you select a client from the client combo box a GUID is
generated
using VB code. The clientID (the bound column from the client combo box)
and
the GUID are passed as parameters to a stored procedure. The stored
procedure creates a new record in the ClientNumbers table on a linked
server.
The stored procedure also generates a "debtorid" and a "CRRNumber" which
are
essentially the last generated number + 1 for each of those fields. What
I
was trying to accomplish is to return those two values (debtorID and
CRRNumber) generated by the stored procedure since they are stored in the
ClientNumbers table on the linked server.

I'd posted a prior question on how to return values from the stored
procedure but was told I can't do this using the OUTPUT feature of SQL
stored
procedures. So as an alternative I use a SQL Select statement where GUID
=
linked server GUID in the hope I can return these two values.

I hope this makes sense.



"Sylvain Lafontaine" wrote:

What do you mean exactly by setting the value of a control? Are you
talking
about a bound or an unbound control and a bound or an unbound form?

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Guy Kerr" <GuyKerr@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:49665F9E-A4D5-4277-92A1-8BBAA6157FDB@xxxxxxxxxxxxxxxx
This may sound like a stupid question but for the life of me I can't
figure
this out. I found a pseudo-workaround by setting my control to a
ListBox
and
then using .RowSourceType and .RowSource= SQLStmt to set the value of
the
control but it's not what I'd call a good solution. Am I missing
something
here or is there a way to use a SQL Select statement to set the value
of a
control (other than combobox or listbox)?






.

Relevant Pages

  • SQL statement in form text control
    ... The SQL is sent to the rowsource property of a combo box. ... The combination of name and DOB provides 1 unique client. ... of changing it to a text control and aiming the SQL at it, ... I want the query to then fire and the report to display. ...
    (microsoft.public.access.formscoding)
  • Re: Setting control value based on a SQL Select statement
    ... Sylvain can you give me an example of what you mean by "Don't be so ... Select statement where GUID = linked server GUID in the hope I can return ... The form is bound to a SQL view and the control is bound to a field ... Each time you select a client from the client combo box a GUID is ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL statement in form text control
    ... one of the reports is all incidents involving a ... The SQL is sent to the rowsource property of a combo box. ... The combination of name and DOB provides 1 unique client. ... of changing it to a text control and aiming the SQL at it, ...
    (microsoft.public.access.formscoding)
  • openssh 3.5p1: PATCH
    ... - sftp transaction logging ... control over whether the client can execute chmod, ...
    (comp.security.ssh)
  • Asp.net Important Topics.
    ... ASP.NET server controls contained within the page. ... A custom server control is ... can also perform validation using client script. ... Where does the Web page belong in the .NET Framework class hierarchy? ...
    (microsoft.public.dotnet.framework.aspnet)