Recent content by JeffCarlin

Inside a bas module, which runs the routine.

Thanks Joe. It's a little more complicated than your example, unfortunately. We won't be working off a form or data input of any kind; we'll be reading values from an ini file and calling various functions based on the value's, uh, value. So, I tried the CallByName function, using "Me" as param...

Is there a way to reference a function by use of a variable. For example, function name is "MyFunction" and it takes parameter "A". If I set a variable (type variant??) named "myVar" to equal "MyFunction", will this work? x = myVar("A") I know it won't work the way I've shown it, but is there...

Thanks.

Quick question for you gurus out there: We have Ver 7 Pro and want to upgrade to Vers 10 Developer. a: Can we buy the upgrade package or do we have to buy the full monty? Thanks.

We have a VB app that is deployed to about 10 sites, with about 60 users, all connected via T1. Now, a new site is coming online and they will not be connected on the T1. The only way I will be able to reach them is via TCP/IP. Does anyone have any experience with this? Thanks.

It's the creation that fails. If I were to manually create the SP, it works fine. The error message is a syntax error. I'm pretty sure it has to do with the "plus" characters or the quotes. I've played around a lot, but can't seem to find the answer. The code shown above is the actual...

We use a "update" app to update the db in a VB app. The update app applies db patches as needed, such as ALTER TABLE, CREATE TABLE, etc. We also use it to CREATE PROCEDURE. This all works well until our new procedure contains quotes to handle varying params, such as: CREATE PROCEDURE...

Works like a charm. Many thanks Mukund.

Here's the current code, where "@Parm1" is the passed table name: BEGIN SET @stg1 = "UPDATE " + @Parm1 + " " + "SET dteLast = " + "(SELECT MAX(tblHealth.dteDateEntry) " + "FROM tblHealth " + "WHERE...

Great, thanks. Guess I treat it like any other "create" statement. Just execute the damned thing! Thanks again.

In a VB6 app, we have a module that updates the db when necessary with new/modified fields and tables. Basically, we use ADO and it works just fine. However, we will probably have to edit or add some SPs as well. How can this be done thru VB? Thanks

We distribute an app that allows users to use either Access or SQL Server as the database. From time to time, we may have to modify the database. Since "ALTER TABLE" will not work with Access, can someone give me a way to do it? BTW, the Access db is password protected. Thanks

Thanks, Angel...works like a charm.

I am trying to construct an SP that will allow me to pass a fieldname (always a boolean/bit field) as well as a value for that field. Here's what I've got: CREATE PROCEDURE write_calendar_value_boo /* @Parm1 not used */ @Parm2 varchar(50) , -- The Field Name @Parm3 bit , -- The Field Value...