M
Michael Vincent
Guest
I need to convert a number of queries and functions from Progress / 4GL to SQL.
Can you help me get started, please? Here is one of the 4GL statements I need to convert.
for each Part where (
Part.NonStock = false AND
Part.InActive = false AND
Part.QtyBearing = true) no-lock ,
each PartWhse outer-join where (
Part.Company = PartWhse.Company and
Part.PartNum = PartWhse.PartNum) no-lock ,
each PartCost outer-join where (
Part.Company = PartCost.Company and
Part.PartNum = PartCost.PartNum) no-lock .
Can you explain the 4GL bits and give some hints as to what the SQL would look like.
I have some SQL knowledge, but next to no 4GL knowledge.
Continue reading...
Can you help me get started, please? Here is one of the 4GL statements I need to convert.
for each Part where (
Part.NonStock = false AND
Part.InActive = false AND
Part.QtyBearing = true) no-lock ,
each PartWhse outer-join where (
Part.Company = PartWhse.Company and
Part.PartNum = PartWhse.PartNum) no-lock ,
each PartCost outer-join where (
Part.Company = PartCost.Company and
Part.PartNum = PartCost.PartNum) no-lock .
Can you explain the 4GL bits and give some hints as to what the SQL would look like.
I have some SQL knowledge, but next to no 4GL knowledge.
Continue reading...