Datasource de un datagrid y stored procedure

Article View: chile.comp.programacion

Article #1026

Back to chile.comp.programacion Previous Next

#1026

From: gato2006chile
Date: Mon, 05 Mar 2007 04:37

13 lines
1438 bytes

Si ejecuto una sentencia SQL directa no hay problema para integrar el 
resultado a un datagrid, si uso un procedimiento almacenado da error de 
no ser bookmarkable.
�Por que?
Lo estaba ejecutando con un objeto command, como seria la sentencia para 
que se genere en la funcion open :

rsInfo.open "procalm();",adocn, �adkeyset?,�adreadonly?, 
adcmdstoredprocedure

rsInfo.open "call procalm();",adocn, �adkeyset?,�adreadonly?, adcmdtext

Mysql 5.0, myodbc 3.51.12, VB 6.0

Technical Details

Message-ID: <esfl8q$s3k$1@news.nivel5.cl>

Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news.glorb.com!news.kjsl.com!news.nivel5.cl!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1593cb,f4264ac151ec9529,start
X-Google-Attributes: gid1593cb,public
X-Google-Language: SPANISH,ASCII
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news.glorb.com!news.kjsl.com!news.nivel5.cl!not-for-mail
From: gato2006chile <gato2006chileSINESTO@gmail.com>
Newsgroups: chile.comp.programacion
Subject: Datasource de un datagrid y stored procedure
Date: Mon, 05 Mar 2007 00:37:37 -0400
Organization: Varios
Lines: 13
Message-ID: <esfl8q$s3k$1@news.nivel5.cl>
NNTP-Posting-Host: pc-22-66-44-190.cm.vtr.net
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: news.nivel5.cl 1173051483 28788 190.44.66.22 (4 Mar 2007 23:38:03 GMT)
X-Complaints-To: news@news.nivel5.cl
NNTP-Posting-Date: Sun, 4 Mar 2007 23:38:03 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.7.10) Gecko/20060419 Thunderbird/1.5.0.10 Mnenhy/0.7.5.0