Thank you again for your comments. I have plugging away at SPT and have found that there seems to be a limit on the length I can pass. I have VFP 7.0 and MS-SQL2000. This gives an error while eliminating ", T1.CUSTCHAR6 " seems to work.
? SQLEXEC(gnConnHandle,"SELECT T1.ACTIVE, T1.WEB_ACTIVE, T1.DEF_VENDPO, T1.ITEMNO,;
T1.CATEGORY, T1.BRAND, T1.MODEL, T1.DESCRIPT,;
T2.LEVEL_CODE, T1.CUSTCHAR5, T1.CUSTCHAR6 ;
FROM items AS T1 LEFT OUTER JOIN Item_cust_level_detail AS T2 ON T1.ITEMNO = T2.ITEM_CODE WHERE BRAND = 'BRANDID'")
Looks like I will have to build views and just get it done unless you have a better idea.
Previous
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