Can anyone tell me if there is a file containing the object id's or point to a list of them?
thanks
Object_ID
Débuté par
nitewolf10
, mars 09 2010 08:35
#1
Posté 09 mars 2010 - 08:35
#2
Posté 09 mars 2010 - 04:15
that's certainly a index in the database, so to get a list of them you need to know MSSQL syntax
#3
Posté 09 mars 2010 - 11:11
This is using Access and a connection to the SQL database.
SELECT dbo_t_Item.NameStringID, dbo_t_StringText.Text AS Name, dbo_t_StringText_1.Text AS Description
FROM dbo_t_StringText AS dbo_t_StringText_1 INNER JOIN (dbo_t_StringText RIGHT JOIN dbo_t_Item ON dbo_t_StringText.StringID = dbo_t_Item.NameStringID) ON dbo_t_StringText_1.StringID = dbo_t_Item.DescriptionStringID;
Hope this helps.
SELECT dbo_t_Item.NameStringID, dbo_t_StringText.Text AS Name, dbo_t_StringText_1.Text AS Description
FROM dbo_t_StringText AS dbo_t_StringText_1 INNER JOIN (dbo_t_StringText RIGHT JOIN dbo_t_Item ON dbo_t_StringText.StringID = dbo_t_Item.NameStringID) ON dbo_t_StringText_1.StringID = dbo_t_Item.DescriptionStringID;
Hope this helps.





Retour en haut






