计数功能 [英] count function

问题描述

您好！


任何人都可以帮助我吗？


i开发了一个简单的程序，用于查询程序及其使用的表格。现在，问题是关于如何显示特定程序使用的正确表格总数..


我用过COUNT FUNCTION但是显示屏总是零..


请检查我的代码是否正确：

Dim sqlcount

sqlcount =" select count（table_name）from table其中prog_name like''" &安培; txtprogram_name.Text& " ％''"

Program.lbltotal.Caption = Val（sqlcount）

请帮助我解决这个困境..


请...


非常感谢你！。

解决方案

你好！


有人可以帮助我吗？


i已经开发了一个简单的程序来查询程序和他们使用的表格。现在，问题是关于如何显示特定程序使用的正确表格总数。


我使用了COUNT FUNCTION但显示屏总是零..


请检查我的代码是否正确：

Dim sqlcount

sqlcount =" select table（table_name）from table其中prog_name类似''" &安培; txtprogram_name.Text& " ％''"

Program.lbltotal.Caption = Val（sqlcount）

请帮助我解决这个困境..


请...


非常感谢你！

首先你需要从表格中选择。

之后你必须写下编码是

展开 | 选择 | Wrap | 行号

首先你必须从表中选择。

之后你必须编写编码是

展开 | 选择 | 换行 | 行号

< blockquote>

同样的问题。但我希望在文本框中显示特定的列记录数。

为此您必须使用以下编码

展开 | 选择 | 换行 | 行号

Hello!.

can anyone help me?

i have develop a simple program for quering programs and the tables they use.

now, the problem is about how to display the correct total number of tables a specific program is using..

i''ve used the COUNT FUNCTION but the display is always ZERO..

please check if my codes are correct:

Dim sqlcount

sqlcount = "select count(table_name) from table where prog_name like '' " & txtprogram_name.Text & " %'' "

Program.lbltotal.Caption = Val(sqlcount)

please help me with this dilema..

PLEASE..

THANK YOU SO MUCH!.

解决方案

Hello!.

can anyone help me?

i have develop a simple program for quering programs and the tables they use.

now, the problem is about how to display the correct total number of tables a specific program is using..

i''ve used the COUNT FUNCTION but the display is always ZERO..

please check if my codes are correct:

Dim sqlcount

sqlcount = "select count(table_name) from table where prog_name like '' " & txtprogram_name.Text & " %'' "

Program.lbltotal.Caption = Val(sqlcount)

please help me with this dilema..

PLEASE..

THANK YOU SO MUCH!.

First You have to select from the table.
After that you have to write the coding is

Expand|Select|Wrap|Line Numbers

First You have to select from the table.
After that you have to write the coding is

Expand|Select|Wrap|Line Numbers

same problem. but i want a particular column recordcount to be displayed in a textbox.

For that you have to use the following codings

Expand|Select|Wrap|Line Numbers

这篇关于计数功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！