基于Environment访问存储过程参数的表单+值 [英] Access Form + values for stored procedure parameter based on Environment

问题描述

我为带有参数的sql server存储过程创建了一个PassThrough查询，并在Form按钮单击事件中调用它。存储过程的参数应该按照环境（开发，测试和生产）。当此访问权限（accdb extention）移动到其他环境时，我应该在哪里设置
。

I created a PassThrough query for sql server stored procedure with parameters and calling this in Form button click event.The parameters for stored procedure should be changed as per environment (development, test and production). Where should I set them when this access (accdb extention) is moved to other environment.

参数：

日期：所有环境应该设置为今天的日期

Date: all environments should be set to today's date

指示符：'D'代表dev，'T'代表测试，'P'代表Prod

Indictor: 'D' for dev, 'T' for test and 'P' for Prod

路径：DevServerName \ dev\folder1（适用于开发）

Path: DevServerName\dev\folder1 (for dev)

         TestServerName \ test\folder1（供测试）

         TestServerName\test\folder1 (for test)

         ProdServerName \Prod\folder1（用于产品）

         ProdServerName\Prod\folder1 (for prod)

它们不是用户输入字段，可在运行时动态更改。它们仅在部署到不同环境时才会更改。如何在Access中设置它们以及在何处可以设置它们。

They are not user input fields to change dynamically when it runs. They change only upon deployment to different environments. How can I set them in Access and where can I set them when pushed.

谢谢

推荐答案

虽然我不确定我是否理解这个问题，但我会尝试尝试。无论何时值都需要持续存在以供以后使用或比较，最好放在表中。因此，例如，当您将数据库部署到测试环境中时，
您需要有一个表来存储指示当前环境的值。然后，当您将其部署到生产环境中时，您只需要更新表以反映新环境。

I'll try to take a stab at it although I am not sure I understand the question. Anytime a value needs to persists for later usage or comparisons, the best place to put it is in a table. So, for example, when you deploy the database into a test environment, you'll need to have a table to store a value indicating the current environment. Then, when you deploy it into production, you just need to update the table to reflect the new environment.

希望它有所帮助......

Hope it helps...

这篇关于基于Environment访问存储过程参数的表单+值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！