🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #933

Grid & Sql Object

#933
From: Paolo Bombaci
Date: Tue, 07 Jul 1998 00:00
19 lines
985 bytes
I do a normal SQL instruction that visualize some data in a GRID
When I change SQL instruction I do this sequence of VDB instruction:

form.query1.sql = "SELECT  ...."
form.query1.requery()
form.grid1.refresh()

the Grid is grid1 and the SQLQuery is query1

form.grid1.rowset is equal to form.query1.rowset.

Sometimes the Grid was blank, but the SQL return a valid set of rowset

Why this occur ? I do a wrong procedure to change a SQL instruction in a
Grid ?

Please help me as soon a possible.

Thank you for your help.
Technical Details
Message-ID: <35A23C37.26CC@mlsys.it>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,ddbeabf250b273ea,start
X-Google-Attributes: gidff5a1,public
From: Paolo Bombaci <mlsys@mlsys.it>
Subject: Grid & Sql Object
Date: 1998/07/07
Message-ID: <35A23C37.26CC@mlsys.it>
X-Deja-AN: 369248714
Content-Transfer-Encoding: 7bit
Organization: Microlab Sistemi
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql