EDN Admin
Well-known member
I posted this at StackOverflow but decided to post it here so the "microsoft people" might have a chance to see it. I havent gotten any replies yet at SO.
<span style=" <span style="text-align:left; line-height:18px; border-collapse:collapse; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif; font-size:14px
<p style="background-color:transparent; margin:0px 0px 1em; word-wrap:break-word; clear:both; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px
<strong style="background-color:transparent; margin:0px; font-size:14px; vertical-align:baseline; font-weight:bold; border-width:0px; padding:0px In Short: <span> Im using VB.NET 2008 to connect to a Visual Foxpro 6 Database using the
vfpoledb.1 driver. When I attempt to fill an OleDbDataAdapter with a dataset table that contains one of the numeric columns, I get the following error message:<span> <em style="background-color:transparent; font-style:italic; margin:0px; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px "The
provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet set a new Decimal value."[/i]<span> Id like to retrieve this column from
VB.NET 2008 and keep it in a numeric format.
<p style="background-color:transparent; margin:0px 0px 1em; word-wrap:break-word; clear:both; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px
<strong style="background-color:transparent; margin:0px; font-size:14px; vertical-align:baseline; font-weight:bold; border-width:0px; padding:0px The Long Version:
<p style="background-color:transparent; margin:0px 0px 1em; word-wrap:break-word; clear:both; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px
Im using VB.NET to connect to a Visual Foxpro 6 database. Several of the columns in the table are intended for numeric data type of up to 8 digits. Im not sure how Visual Foxpro data types work but it appears that this field allows someone to enter any of
the following example values:
<span style=" <span style="text-align:left; line-height:18px; border-collapse:collapse; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif; font-size:14px
<pre style="overflow-x:auto; overflow-y:auto; background-color:#eeeeee; margin:0px 0px 10px; width:auto; font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif; max-height:600px; font-size:14px; vertical-align:baseline; border-width:0px; padding:5px <code style="background-color:#eeeeee; margin:0px; font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px 99999999<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px 99999.99<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px 9.99<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px 9.00<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px {<span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px nothing<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px }[/code][/code]
<span style=" <span style="text-align:left; line-height:18px; border-collapse:collapse; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif; font-size:14px
<p style="background-color:transparent; margin:0px 0px 1em; word-wrap:break-word; clear:both; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px
From Visual Foxpro: I have access to small program called Foxwin that allows me to browse the VFP tables in a native VFP environment. This is what Im using to access the data to obtain my examples for what I posted above. From here I can see that some rows
contain no values at all in this field although they appear to be filled with spaces when there is no data. Ive tried to run update queries to fill in every row with valid data but my update queries finish without updating any rows. Ive tried ISNULL(bal_qty)
and bal_qty IS NULL and neither one works.
<p style="background-color:transparent; margin:0px 0px 1em; word-wrap:break-word; clear:both; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px
From MS Access 2007: Using the same driver that Im using in VB.NET and I can load the ADO recordset and bind it to a form without a problem. The decimal values appear to be stripped off, probably because all of them are ".00". I prefer to build this small
program in VB.NET so Im using MS Access only for testing.
<p style="background-color:transparent; margin:0px 0px 1em; word-wrap:break-word; clear:both; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px
From VB.NET: My SQL statement works if I convert bal_qty to String but this causes sort problems. Ive tried VAL(STR(bal_qty)) and it fails with the same error message Ive posted above. Heres the code Im using:
<span style=" <span style="text-align:left; line-height:18px; border-collapse:collapse; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif; font-size:14px
<pre style="overflow-x:auto; overflow-y:auto; background-color:#eeeeee; margin:0px 0px 10px; width:auto; font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif; max-height:600px; font-size:14px; vertical-align:baseline; border-width:0px; padding:5px <code style="background-color:#eeeeee; margin:0px; font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Imports<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px System<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Data<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px OleDb<br/><br/><span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Public<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Class<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Form1<br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Dim<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px sConString <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px String<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px "Provider=vfpoledb.1;Data Source=C:MyDatabase.dbc;Mode=3;"<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Dim<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px con <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px OleDbConnection <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px New<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px OleDbConnection<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px (<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px sConString<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px )<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Private<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Function<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px FetchData<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ()<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><br/> con<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Open<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ()<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Dim<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ds <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px DataSet <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px New<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px DataSet<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ()<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Dim<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px sSQL <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px String<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:gray; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px This SQL statement works but the data doesnt sort properly.<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:gray; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px sSQL = "SELECT item_cd, item_desc, STR(bal_qty) FROM invent;"<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><br/> sSQL <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px "SELECT item_cd, item_desc, bal_qty FROM invent;"<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Dim<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px cmd <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px OleDbCommand <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px New<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px OleDbCommand<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px (<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px sSQL<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ,<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px con<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px )<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Dim<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px daInv <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px OleDbDataAdapter <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px New<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px OleDbDataAdapter<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px (<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px cmd<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px )<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Dim<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px iRecCount <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Integer<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> iRecCount <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px daInv<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Fill<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px (<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ds<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ,<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px "invent"<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px )<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:gray; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px The error occurs here.<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Me<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px DataGridView1<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px DataSource <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ds<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Tables<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px (<span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px "invent"<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ).<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px DefaultView<br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px End<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Function<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Private<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Sub<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px btnFetchData_Click<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px (<span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ByVal<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px sender <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Object<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ,<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ByVal<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px e <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px System<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px EventArgs<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px )<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Handles<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px btnFetchData<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Click<br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Call<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px FetchData<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ()<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px End<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Sub<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Private<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Sub<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Form1_FormClosing<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px (<span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ByVal<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px sender <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Object<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ,<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ByVal<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px e <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px System<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Windows<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Forms<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px FormClosingEventArgs<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px )<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Handles<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Me<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px FormClosing<br/> con<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Close<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ()<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> con <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Nothing<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px End<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Sub<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px End<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Class[/code][/code]
Purely as a side note, I want to add that I always have a difficult time finding MSs discussion forums, especially when Im looking for a new one that I havent used yet. My frustration was exacerbated tonight when I couldnt log into my Live account using
Google chrome due to some website/browser glitch.
View the full article
<span style=" <span style="text-align:left; line-height:18px; border-collapse:collapse; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif; font-size:14px
<p style="background-color:transparent; margin:0px 0px 1em; word-wrap:break-word; clear:both; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px
<strong style="background-color:transparent; margin:0px; font-size:14px; vertical-align:baseline; font-weight:bold; border-width:0px; padding:0px In Short: <span> Im using VB.NET 2008 to connect to a Visual Foxpro 6 Database using the
vfpoledb.1 driver. When I attempt to fill an OleDbDataAdapter with a dataset table that contains one of the numeric columns, I get the following error message:<span> <em style="background-color:transparent; font-style:italic; margin:0px; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px "The
provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet set a new Decimal value."[/i]<span> Id like to retrieve this column from
VB.NET 2008 and keep it in a numeric format.
<p style="background-color:transparent; margin:0px 0px 1em; word-wrap:break-word; clear:both; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px
<strong style="background-color:transparent; margin:0px; font-size:14px; vertical-align:baseline; font-weight:bold; border-width:0px; padding:0px The Long Version:
<p style="background-color:transparent; margin:0px 0px 1em; word-wrap:break-word; clear:both; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px
Im using VB.NET to connect to a Visual Foxpro 6 database. Several of the columns in the table are intended for numeric data type of up to 8 digits. Im not sure how Visual Foxpro data types work but it appears that this field allows someone to enter any of
the following example values:
<span style=" <span style="text-align:left; line-height:18px; border-collapse:collapse; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif; font-size:14px
<pre style="overflow-x:auto; overflow-y:auto; background-color:#eeeeee; margin:0px 0px 10px; width:auto; font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif; max-height:600px; font-size:14px; vertical-align:baseline; border-width:0px; padding:5px <code style="background-color:#eeeeee; margin:0px; font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px 99999999<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px 99999.99<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px 9.99<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px 9.00<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px {<span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px nothing<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px }[/code][/code]
<span style=" <span style="text-align:left; line-height:18px; border-collapse:collapse; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif; font-size:14px
<p style="background-color:transparent; margin:0px 0px 1em; word-wrap:break-word; clear:both; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px
From Visual Foxpro: I have access to small program called Foxwin that allows me to browse the VFP tables in a native VFP environment. This is what Im using to access the data to obtain my examples for what I posted above. From here I can see that some rows
contain no values at all in this field although they appear to be filled with spaces when there is no data. Ive tried to run update queries to fill in every row with valid data but my update queries finish without updating any rows. Ive tried ISNULL(bal_qty)
and bal_qty IS NULL and neither one works.
<p style="background-color:transparent; margin:0px 0px 1em; word-wrap:break-word; clear:both; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px
From MS Access 2007: Using the same driver that Im using in VB.NET and I can load the ADO recordset and bind it to a form without a problem. The decimal values appear to be stripped off, probably because all of them are ".00". I prefer to build this small
program in VB.NET so Im using MS Access only for testing.
<p style="background-color:transparent; margin:0px 0px 1em; word-wrap:break-word; clear:both; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px
From VB.NET: My SQL statement works if I convert bal_qty to String but this causes sort problems. Ive tried VAL(STR(bal_qty)) and it fails with the same error message Ive posted above. Heres the code Im using:
<span style=" <span style="text-align:left; line-height:18px; border-collapse:collapse; font-family:Arial,Liberation Sans,DejaVu Sans,sans-serif; font-size:14px
<pre style="overflow-x:auto; overflow-y:auto; background-color:#eeeeee; margin:0px 0px 10px; width:auto; font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif; max-height:600px; font-size:14px; vertical-align:baseline; border-width:0px; padding:5px <code style="background-color:#eeeeee; margin:0px; font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Imports<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px System<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Data<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px OleDb<br/><br/><span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Public<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Class<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Form1<br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Dim<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px sConString <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px String<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px "Provider=vfpoledb.1;Data Source=C:MyDatabase.dbc;Mode=3;"<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Dim<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px con <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px OleDbConnection <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px New<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px OleDbConnection<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px (<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px sConString<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px )<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Private<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Function<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px FetchData<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ()<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><br/> con<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Open<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ()<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Dim<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ds <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px DataSet <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px New<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px DataSet<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ()<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Dim<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px sSQL <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px String<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:gray; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px This SQL statement works but the data doesnt sort properly.<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:gray; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px sSQL = "SELECT item_cd, item_desc, STR(bal_qty) FROM invent;"<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><br/> sSQL <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px "SELECT item_cd, item_desc, bal_qty FROM invent;"<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Dim<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px cmd <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px OleDbCommand <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px New<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px OleDbCommand<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px (<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px sSQL<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ,<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px con<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px )<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Dim<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px daInv <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px OleDbDataAdapter <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px New<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px OleDbDataAdapter<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px (<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px cmd<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px )<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Dim<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px iRecCount <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Integer<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> iRecCount <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px daInv<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Fill<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px (<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ds<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ,<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px "invent"<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px )<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:gray; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px The error occurs here.<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Me<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px DataGridView1<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px DataSource <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ds<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Tables<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px (<span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px "invent"<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ).<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px DefaultView<br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px End<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Function<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Private<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Sub<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px btnFetchData_Click<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px (<span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ByVal<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px sender <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Object<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ,<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ByVal<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px e <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px System<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px EventArgs<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px )<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Handles<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px btnFetchData<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Click<br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Call<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px FetchData<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ()<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px End<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Sub<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Private<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Sub<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Form1_FormClosing<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px (<span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ByVal<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px sender <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Object<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ,<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ByVal<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px e <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px As<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px System<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Windows<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Forms<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px FormClosingEventArgs<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px )<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Handles<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Me<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px FormClosing<br/> con<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px .<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Close<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px ()<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> con <span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px =<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:maroon; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Nothing<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/> <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px End<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Sub<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <br/><span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px End<span style="background-color:transparent; margin:0px; color:#000000; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px <span style="background-color:transparent; margin:0px; color:#00008b; font-size:14px; vertical-align:baseline; border-width:0px; padding:0px Class[/code][/code]
Purely as a side note, I want to add that I always have a difficult time finding MSs discussion forums, especially when Im looking for a new one that I havent used yet. My frustration was exacerbated tonight when I couldnt log into my Live account using
Google chrome due to some website/browser glitch.
View the full article