Discussion Locked

Storing URLs in your database

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

This week's SQL Server e-newsletter describes how to store URLs in your database.

Are you an Access developer upsizing an app to SQL? Even if you aren't, do you still find this tip useful? Please let us know.

If you aren't subscribed to the free SQL Server e-newsletter, click the following link to automatically sign up:
http://nl.com.com/MiniFormHandler?brand=builder&subs_channel=bldr_front_door&list_id=e046&tag=fb

2 replies

by kcollins

The author forgot to include the declaration for the constant SW_SHOWNORMAL. For the example code to work, you will need to include the following declaration:

Private Const SW_SHOWNORMAL = 1

Also, since the example uses another method to wrap the ShellExecute function, it might make more sense to declare ShellExecute as private.

by quadrance

This is one of things you don't think about when upsizing from Access to SQL - not all the datatypes in Access have matching counterparts in SQL and vice versa.

This discussion is closed to new replies.