Functions, Views or Stored Procedures

[Drew]

I have upsized a database, and now I need to change 1 thing in every query.
Problem is, functions don't seem to be editable (at least not in SQL).

How can I change 1 table to a different table in a function?

Thanks,
Drew

 

[Sylvain Lafontaine]

Unless you are using an old version of ADP (2000?) or that you have a
permission problem or that you have some mixe-up with dbo. or another user
name; functions are editable under DAP.

You should provide us with more information.

 

[Drew]

I am working upsizing a Staff Training database, which uses linked tables to
link to the Staff Core database. I already have the Staff Core database on
SQL Server and now all I need to do is remove all the links to the old Staff
Core MDB and make them link to the new Staff Core SQL database.

With the functions, there is no SQL statement to edit, so I am unsure of how
to accomplish this task.

Thanks,
Drew

 

[Sylvain Lafontaine]

Click on the SQL button available on the Function Design toolbar. Don't mix
it with the Verify SQL Syntax button.

 

[Drew]

BEAUTIFUL! Thanks so much... I was starting to worry!

I was looking for the SQL view in the place that it usually is!

Thanks,
Drew