=> VB SQL QUERY PROBLEM

Article View: alt.lang.basic

Article #706

#706

From: Editions Doc
Date: Fri, 25 Aug 2000 00:00

21 lines
1657 bytes

Hello,

I'm currently looking for a way to have my SQL query (inside VB6) display
decimals after the request in a msflexgrid (linked to a DATA control).
For example, I have two prices : 12,30 and 42,00 (stored in a database). My
SQL query searches for prices higher than 10. So, my two prices are OK, and
are diplayed inside the MsFlexGrid, but My two decimals from the 42,00
price, aren't shown (42 is displayed, and not 42,00).

Here is the SQL query I use (on a command button click) :

MsFlexGrid1.Datasource = Data1
' Table name : prices
' Field in table prices : price
Data1.RecordSource = "SELECT price FROM prices"
Data1.Refresh

Thank you for your help !

Bye ;-)
Alex.

Technical Details

Message-ID: <8o65l3$3js$1@wanadoo.fr>

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: 110e3b,b2e738639b6deede,start
X-Google-Attributes: gid110e3b,public
X-Google-Thread: f7646,b2e738639b6deede,start
X-Google-Attributes: gidf7646,public
X-Google-Thread: f645d,b2e738639b6deede,start
X-Google-Attributes: gidf645d,public
X-Google-Thread: 10ab99,b2e738639b6deede,start
X-Google-Attributes: gid10ab99,public
From: "Editions Doc" <editions.doc@wanadoo.fr>
Subject: => VB SQL QUERY PROBLEM
Date: 2000/08/25
Message-ID: <8o65l3$3js$1@wanadoo.fr>
X-Deja-AN: 662411008
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
X-Complaints-To: abuse@wanadoo.fr
X-Trace: wanadoo.fr 967219683 3708 193.250.66.112 (25 Aug 2000 16:08:03 GMT)
Organization: Wanadoo, l'internet avec France Telecom
X-MSMail-Priority: Normal
NNTP-Posting-Date: 25 Aug 2000 16:08:03 GMT
Newsgroups: alt.lang.basic,comp.lang.basic.visual,comp.lang.basic.visual.misc,fr.comp.lang.basic