VBasic & SQL

VBasic & SQL

Post by Guilherme Del Fi » Sat, 29 Apr 1995 04:00:00

Caros colegas,

        Estou tentando usar as funcoes SQL Dsum() e Dcount() numa aplicacao
        em VBasic que acessa tabelas FoxPro. Usei a seguinte sintaxe
        nesta funcao:
        x=Dsum("nome do campo","nome da tabela","criterio"), onde "nome do
         campo" e o campo a ser somado, "nome da tabela" o nome de um
         recordset aberto pelo comando set tabela=db.opentable("XXXXXX")
        e "criterio" um intervalo de datas tipo SQL sem a clausula WHERE
        (como diz o help do Vbasic). O resultado final e que o vbasic nao
        reconhece a funcao ('indefined function or array'). E possivel usa-la
        com recordsets definidos em variaveis objeto ? Ou o problema e outro.

___ Blue Wave/QWK v2.12


1. VBasic & Jet 3.0 Security Question

Help! I am an Access programmer moving over to VB4PE. All is going
well, except I cannot get a handle on accessing a secured database
with VB4. Each time I attempt to read the SYSTEM.MDW for logging on, I
get a "missing system database error." I reference the path and name
of the mdw file in my application.ini file. I have tested the app and
it does read the ini file on initialization. The only way I can
successfully log on is to log on as Admin with an empty password. Any
help is greatly appreciated!


2. SQL 6.5 enterprise edition

3. Problems with Q&E Driver with VBasic and Informix

4. Java servlets+database

5. VBasic 3.0 & Access

6. sql7 on win 2000 sqlmail question

7. VBasic 6.0 and SQL 6.5

8. Notice: DCA-SUG Meeting 11/7/96

9. Error message SQL-VBASIC-ODBC

10. T-SQL vs VBasic Performance ?