I've created a select statement to use in spt that no matter how modified refuses to get me a return of anything other the none field with values that don't exist
Here is the select statement:
lcselectsql = 'SELECT sh.shpk, sh.ohpk, oh.ohordno, sh.shshipno, sh.shshipweek '+ ;
'FROM EckeMaster!shipmentheader as sh, eckemaster!orderheader as oh '+ ;
'WHERE oh.ohpk = sh.ohpk '+ ;
'And (EMPTY(sh.whpk) Or sh.whpk = 0) '+ ;
'AND sh.shShipWeek < ?Thisform.dstartweek +(7 * 4) '+ ;
'AND sh.shShipweek >= ?ThisForm.dstartweek '+ ;
'AND sh.shpk in (Select DISTINCT shpk '+ ;
'FROM EckeMaster!ShipmentDetail as SD '+ ;
'JOIN EckeMaster!OrderDetail as OD '+ ;
'ON OD.odpk = SD.odpk '+ ;
'WHERE OD.odqtyCommit > 0) '+ ;
'Order By sh.shshipweek'
Whe nI run directly against the vfp backend, it works exactly as expected. I'm wondering if the sub select is not possible through SPT
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only