主题：[求助]SQLTABLE查询一个例子的两个问题

1、

http://www.foxtable.com/help/topics/1611.htm

 

Tables("收货主表查询_1_Table1").Fill("Select * From {Bill_Shou}","SQL2000",True)

DataTables("收货主表查询_1_Table1").DataCols("SysTime").SetDateTimeFormat(DateTimeFormatEnum.DateTime)

 

 

2、

http://www.foxtable.com/help/topics/1275.htm

 

Tables("收货主表查询_1_Table1").Fill("Select * From {Bill_Shou}","SQL2000",True)

with DataTables("收货主表查询_1_Table1")

    .DataCols("SysTime").SetDateTimeFormat(DateTimeFormatEnum.DateTime)

    .DataCols("Kehu").Caption = "客户"

    .DtaCols("Pinming").Caption = "品名"

    .BuildHeader()

End With

 

3、你应该有答案了。

 

 

看看：

 

 

http://www.foxtable.com/help/topics/1375.htm

http://www.foxtable.com/help/topics/1786.htm

http://www.foxtable.com/help/topics/1787.htm