delp请进，如何用MODEM进行远程访问，相互传输文件（类似BBS） (300分)

Y

ycxy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #1

能有例子就最好了

 

Y

yueer

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #2

试试用2002-9-2

 

C

cxz9

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #3

'09/02/2002'
'2002-09-02'

 

Y

ycxy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #4

to yueer:
2002-9-2不行，具体提示错误为
[Microsoft][ODBC SQL Server Driver]对于造型说明无效的字符值

 

S

smallbs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #5

'2002-09-02'

 

Y

ycxy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-05

• #6

注意，是在SQL查询分析器中的T-SQL调试器，不需要引号

 

Y

ycxy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-07

• #7

no answer

 

S

seeme0526

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-07

• #8

'2002-09-02'

 

P

pengjinlongex

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-07

• #9

'2002-09-02'试试
要不行，用FLOAT型数据试试

 

F

fshrq1

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-07

• #10

要看你windows的时间设置格式，在控制面板

 

W

wellknow

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-08

• #11

我的这样试过,OK的:
procedure TdlgSelectBill.SelectBill;
begin
with M do
begin
SQL.Clear;
SQL.Add('SELECT ID, Code, BillDate, Amount, OperatorID, EmpID, Closed, Memo');
SQL.Add(' FROM ' + sTableName);
//无论如何，都要查询单据号码
SQL.Add(' WHERE Code LIKE :Code');
SQL.Add(' AND (BillDate BETWEEN :StartDate AND :EndDate)');
Parameters[0].Value := TRIM(edtCode.Text) + '%';
Parameters[1].Value := FormatDateTime('yyyy/mm/dd', StartDate.Date);
Parameters[2].Value := FormatDateTime('yyyy/mm/dd', EndDate.Date);
case rgClosed.ItemIndex of
0, 1:
begin
SQL.Add(' AND (Closed = :Closed)');
Parameters[3].Value := rgClosed.ItemIndex;
end;
end;
SQL.Add('ORDER BY BillDate DESC');
Open;
Caption := '单据查询结果: 共有 ' + IntToStr(RecordCount) + ' 条';
end;//with M do
end;
懒得修改了,就整个贴上来,你只要参考关键部份就行了.

 

Y

ycxy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-20

• #12

to wellknow:
在Delphi中的调用我没有问题，我说的是SQL Server 2000的T-SQL 调试器中

 

U

uangshui

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-21

• #13

用'yyyymmdd'

 

Y

ycxy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-14

• #14

应该是 2002－09－02

版主，请退分给我

 

P

pengjinlongex

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-14

• #15

用float类型数据可以的，我试过

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-14

• #16

把你提的问题改一下不就得了。再提其他的问题

 

Y

ycxy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-14

• #17

版主：
如何修改问题呢？请指教.

 

Y

ycxy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-17

• #18

请斑竹退回分数

 

贝

贝贝11

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-18

• #19

你的标题哪应该有个 编辑

点 编辑 就能改了！

 

A

antic_ant

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-18

• #20

学习