parameter query fakeout (Access 2000 SP2)

Topic

New Reply

I was able in the VB code, to get parameters to store from a form and so now I have a nice SQL statement that works in SQL query analyzer. I’d like to turn this into a view, so I can call it from a stored procedure, but I can’t figure out how to do it. Here’s my code:

Me.ServerFilter = “(BIGChecks.bg_CHK_NO)>='” & Me.chksdate & “‘ And (BIGChecks.bg_CHK_NO)=’00046780’ And (BIGChecks.bg_CHK_NO)<='00046782';

So is there a way to turn this strsql into a view?

Reply | Quote

Replies

Sorry about the lack of replies. Apparently not many Loungers are working with SQL Server.

Reply | Quote

Sorry about the lack of replies. Apparently not many Loungers are working with SQL Server.

Reply | Quote

Sorry Peggy – I missed you post. In order to do this sort of thing in an MDB file, your best choice is to use a pass through query that you build and save dynamically, so that isn’t really using a view. You can do this sort of thing in a stored procedure, but views can’t have parameters that are dynamic. But aren’t you using ADP files? If that’s the case you should be able to pass parameters to a stored procedure and have it return data. Am I missing something here?

Reply | Quote

Wendell and Hans,

After banging my head upon my desk a few times, I finally decided to review the data that’s being exported and found that I could simply things much better to set up a check table with an “X” field for exported, and then load the new day’s bigcheck data into this table. Then, by utilizing a DTS, I’m able to totally automate the process and have the users run the DTS, which gets the data, mooshes it around and exports it into a format that they can then send to the bank.

Oh, the learning curve I’m having here…

Reply | Quote

I understand that learning curve issue – I hadn’t done any significant SQL Server work for a few months, and now I’m back in it and having to be retrained!

Reply | Quote

I understand that learning curve issue – I hadn’t done any significant SQL Server work for a few months, and now I’m back in it and having to be retrained!

Reply | Quote

Wendell and Hans,

After banging my head upon my desk a few times, I finally decided to review the data that’s being exported and found that I could simply things much better to set up a check table with an “X” field for exported, and then load the new day’s bigcheck data into this table. Then, by utilizing a DTS, I’m able to totally automate the process and have the users run the DTS, which gets the data, mooshes it around and exports it into a format that they can then send to the bank.

Oh, the learning curve I’m having here…

Reply | Quote

Sorry Peggy – I missed you post. In order to do this sort of thing in an MDB file, your best choice is to use a pass through query that you build and save dynamically, so that isn’t really using a view. You can do this sort of thing in a stored procedure, but views can’t have parameters that are dynamic. But aren’t you using ADP files? If that’s the case you should be able to pass parameters to a stored procedure and have it return data. Am I missing something here?

Reply | Quote