[dba-SQLServer]Re: Linking to Local Table

Robert L. Stewart rl_stewart at highstream.net
Wed Oct 29 16:10:35 CST 2003


David,

Populate the form with a stored procedure
that uses the values stored in the local XML
file as parameters.

Robert

At 03:53 PM 10/29/2003 -0600, you wrote:
>Date: Thu, 30 Oct 2003 10:53:27 +1300
>From: David Emerson <davide at dalyn.co.nz>
>Subject: Re: [dba-SQLServer]Re: Linking to Local Table
>To: dba-sqlserver at databaseadvisors.com
>Message-ID: <5.2.0.9.0.20031030104458.00b6e5a0 at mail.dalyn.co.nz>
>Content-Type: text/plain; format=flowed; charset=us-ascii
>
>Thanks everyone for the feedback so far.  The storing of the data in a
>temporary file is not the problem - the problem is how I can use that data
>with the SQL BE and not have two people logged in as the same user
>overwriting each others table of data (remember 'Users' have been set up
>more as job functions so that individuals don't have their own log on -
>they log in as manager, or operations, or marketing.  This means that we
>are not constantly setting up and deleting individual log ons as people
>come and go).
>
>I may just sit on this one and see if any bright ideas hit me over the next
>week.
>
>David
>
>
>At 29/10/2003, you wrote:
> >David,
> >
> >You would write a local file with something like
> >
> ><TableName>Customer</TableName>
> ><LastRecord>12345</LastRecord>
> >
> >Your customer form would need to look at this file
> >and get the place to go to from it.
> >
> >It is like the days when we used the ini file
> >to do similar things.
> >
> >Robert




More information about the dba-SQLServer mailing list