Jump to content
Sign in to follow this  
El_Pablo

Lookup equivalent in SQL Server?

Recommended Posts

Hi,

I'm creating a database in SQL Server since I cannot implement FM in my customer business.

It's been too long since the last time I went in SQL.

How do we create a lookup for a field?

Thanx

Share this post


Link to post
Share on other sites

At the risk of being scolded that this forum is for Filemaker and not for SQL, (and if I understand your question correctly) I believe the following is what you're looking for:

insert into newTable

(tableId,

tableName,

tableAddr1,

tableAddr2,

tableCode)

select

'1',

lookupName,

lookupAddr1,

lookupAddr2,

'test'

from lookupTable

where lookupId = @lookupValue

The above code, using a subselect for the insert, emulates Filemaker's "Auto-Enter Looked Up Value" feature at the field definition level. You would have to replace the constants in the select statement with the values captured from your user.

You could also accomplish the same thing with an update following your insert in your code. Do some google searches for 'insert subselect mssql' and you should find some direction. These are just two of the many ways it could be done.

Hope that Helps.

-Kevin

Share this post


Link to post
Share on other sites

I know that we are in a FM forum, but since I am too accustomized to FM I forgot how to think SQL.

For the lookup, would it be better to create an insert trigger?

Share this post


Link to post
Share on other sites

That would work, as well. In general, any time you can keep activity on the server-side, you'll improve the database performance, particularly when you're dealing with MSSQL over a network. The 'best' method is always defined by the application you're trying to create, and the environment in which you are operating.

A quick search for 'mssql insert trigger' turned up quite a few options, but the one at the top should suffice as a guide (the site has been reliable and accurate in the past).

http://www.devarticles.com/c/a/SQL-Server/Using-Triggers-In-MS-SQL-Server/

Good Luck!

-Kevin

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    jayson100077 
×

Important Information

By using this site, you agree to our Terms of Use.