Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SPT Query
Message
From
15/06/2010 18:02:07
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SPT Query
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01469087
Message ID:
01469087
Views:
103
I need help with SPT to db2 database file.

Suppose I need the status of a part number 851251-403.

Alpha codes(suffixes) are used to specifiy color. Business logic says that the part in a series with the latest datetime stamp, no matter the color, drives the part number status.

In my status database I have two records 851251-403 and 851251-403A these have a datetime stamp field and the 851251-403A has the latest datetime stamp.

What would be the SPT syntax to find the 851251-403A record while passing the 851251-403 within my where clause?
Next
Reply
Map
View

Click here to load this message in the networking platform