水晶报告和vb6命名问题 [英] crystal report and vb6 naming problem

问题描述

请帮帮我。



i有这个文件

1）Payments.mdb - 第一笔付款，第二笔付款等... 。

2）Payments.rpt

3）vb6项目。



水晶报告，我设置数据库位置为First Payments。



但是在vb6 adodc中。我收到一个错误，如表或查询'第一'没有正确拼写。



但当我将名称更改为FirstPayments（作为一个完整的单词）没有更多的错误在vb6但水晶报告无法打开文件。我尝试在rpt文件中重新找到数据库，但我注意到的是文件名仍然是First Payments，虽然在mdb中我已经将其更改为FirstPayments。



now在我的mdb文件中是FirstPayments，SecondPayments等....



现在我的问题出在水晶报告中。

a msgbox说。

文件无法打开：FirstPayment，位于文件位置First Payments。



我该怎么办????? ????

please help me.

i have this files
1) Payments.mdb - First Payments, Second Payments, etc....
2) Payments.rpt
3) the vb6 project.

in crystal report, i set the database location to First Payments.

but in vb6 adodc. i received an error like the table or query 'First' is not correctly spelled.

but when i changed the name to FirstPayments (as one whole word) no more error in vb6 but crystal report couldn't open the file. i try to re-locate the database in rpt file but something i noticed is the file name is still First Payments though in mdb i already changed it to FirstPayments.

now in my mdb file are FirstPayments, SecondPayments, etc....

now my problem is in crystal report.
a msgbox says.
File could not be opened: "FirstPayment", at file location "First Payments".

what should i do?????????

推荐答案

我相信最好的建议是不要使用VB6。它很久以前就退休了。来自维基百科：

I believe that the best advice would be not to use VB6. It has retired long long ago. From Wikipedia:

Microsoft Visual Basic 6.0的主流支持于2005年3月31日结束。扩展支持于2008年3月结束。

Mainstream Support for Microsoft Visual Basic 6.0 ended on March 31, 2005. Extended support ended in March 2008.

相反，您可以从 Visual Studio Express <下载Visual Studio的免费Express版本/ a> [ ^ ]并开始使用Visual Basic .NET（如果你愿意，可以使用C＃）。



Crystal Reports有哪些，你可以从SAP [ ^ ] site。

Instead you can download the free Express version for Visual Studio from Visual Studio Express[^] and start using Visual Basic .NET (or C# if you like).

What comes to Crystal Reports, you can download it from SAP[^] site.

一般来说，在表名（或字段或da）中包含空格并不是一个好主意tabases）。



如果您要坚持使用FirstPayments这个名称，那么您需要确保在任何地方都进行了更改 - 您的第二个错误听起来就好像你还没有更新RPT文件。



你可以通过用方括号括起表名来克服你的第一个错误[]即

In general it is not a good idea to have spaces in table names (or fields, or databases).

If you are going to stick with the name "FirstPayments" then you need to make sure that you have changed it everywhere - your second error sounds as if you have not updated the RPT file.

The first error you had can be overcome by surrounding the table name with square brackets [] i.e.

[First Payments]

这篇关于水晶报告和vb6命名问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！