vfp：切换窗口

[xiaoxu7806]

我最近用VFP开发一个小小的图书软件，碰到个问题，请各位大哥指教。看到好多软件开多个窗口，开哪个窗口，就在菜单的窗口出现这个窗口的标题，然后点击它就会把这个窗口置为当前窗口。各位大哥VFP能实现吗。（不想用表单集）

[xiaoxu7806]

十三豆，是这样，打一个表单，这个表单的标题就自动添加到一个下拉菜单，然后点击下拉菜刚添加的选项，就把这个表单置为当前表单。VFP能搞吗，谢谢了。如果代码最好了。

[十豆三]

当然可以。

不用模式表单就行

[十豆三]

即表单的 WindowType 属性设为0，同时处理好关闭其中一个表单时不要关闭了其他表单也在使用的表。

[十豆三]

[Quote=引用 3 楼 xiaoxu7806 的回复:]
十三豆，是这样，打一个表单，这个表单的标题就自动添加到一个下拉菜单，然后点击下拉菜刚添加的选项，就把这个表单置为当前表单。VFP能搞吗，谢谢了。如果代码最好了。
[/Quote]

可以，不过现在手头没有VFP（在别人电脑上网），以后有机会再帮你吧。

[xiaoxu7806]

哦，谢谢了

[xiaoxu7806]

十三豆大哥，现在很忙吗，我的问题还没解决呀，我烦哦。

[十豆三]

[Quote=引用 6 楼 xiaoxu7806 的回复:]
十三豆大哥，现在很忙吗，我的问题还没解决呀，我烦哦。
[/Quote]

我这一段时间都比较忙。大家可能已经发现最近我很少回帖的。

[jack_wang0823]

似乎把系统菜单中WINDOWS 这项加到你的主菜单里就可以了

[xiaoxu7806]

没人回答哦

[xiaoxu7806]

SQLEXEC(hdl_conn,"select goods.price,goods.type_zidingyi,xs1.goodscode,xs1.quantity,xs1.discount,xs1.providerdiscount from BAS_TB_Goods as goods,(select xsmx.goodscode,xsmx.quantity,xsmx.discount,xsmx.providerdiscount from sal_tb_retaildetail as xsmx where lastupdatedate>='2008-10-01'and lastupdatedate <='2008-10-02') as xs1 where goods.goodscode=xs1.goodscode","xs_temp1")

提示：语句中有不识别的命令
select goods.price,goods.type_zidingyi,xs1.goodscode,xs1.quantity,xs1.discount,xs1.providerdiscount from BAS_TB_Goods as goods,(select xsmx.goodscode,xsmx.quantity,xsmx.discount,xsmx.providerdiscount from sal_tb_retaildetail as xsmx where lastupdatedate>='2008-10-01'and lastupdatedate <='2008-10-02') as xs1 where goods.goodscode=xs1.goodscode
可是这个SQL语句在查询分析器能够执行。怎么办呢？
没人帮我解决呀

[十豆三]

"select goods.price,goods.type_zidingyi,xs1.goodscode,xs1.quantity,xs1.discount,xs1.providerdiscount from BAS_TB_Goods as goods,(select xsmx.goodscode,xsmx.quantity,xsmx.discount,xsmx.providerdiscount from sal_tb_retaildetail as xsmx where lastupdatedate>='2008-10-01'and lastupdatedate <='2008-10-02') as xs1 where goods.goodscode=xs1.goodscode"

这个字符串超长度了，不能大于254。这是VFP的字符串限制，改为多个字符串连接相加即可，如改为：

"select goods.price,goods.type_zidingyi,xs1.goodscode,xs1.quantity,xs1.discount,xs1.providerdiscount from BAS_TB_Goods as goods,"+"(select xsmx.goodscode,xsmx.quantity,xsmx.discount,xsmx.providerdiscount from sal_tb_retaildetail as xsmx"+" where lastupdatedate>='2008-10-01'and lastupdatedate <='2008-10-02') as xs1 where goods.goodscode=xs1.goodscode"

[xiaoxu7806]

SQLEXEC(hdl_conn,"select goods.price,goods.type_zidingyi,xs1.goodscode,xs1.quantity,xs1.discount,xs1.providerdiscount from BAS_TB_Goods as goods,(select xsmx.goodscode,xsmx.quantity,xsmx.discount,xsmx.providerdiscount from sal_tb_retaildetail as xsmx where lastupdatedate>='2008-10-01'and lastupdatedate<='2008-10-02') as xs1 where goods.goodscode=xs1.goodscode","xs_temp1")

提示：语句中有不识别的命令
select goods.price,goods.type_zidingyi,xs1.goodscode,xs1.quantity,xs1.discount,xs1.providerdiscount from BAS_TB_Goods as goods,(select xsmx.goodscode,xsmx.quantity,xsmx.discount,xsmx.providerdiscount from sal_tb_retaildetail as xsmx where lastupdatedate>='2008-10-01'and lastupdatedate<='2008-10-02') as xs1 where goods.goodscode=xs1.goodscode
可是这个SQL语句在查询分析器能够执行。怎么办呢？