Awesome! I'm voting to have that language construct in VB 10:
---
ForEach X in Y
...
HcaeRof
---
On Sep 1, 8:51 pm, Peter Smith wrote:
> Sure
> Tables = AllTables(database)
> ForEach table in Tables
> ForEach field in table
> update table set field = replace(field, ‘bug’, ‘’
On Tue, Sep 1, 2009 at 2:34 AM, Cerebrus wrote:
>
> I know that... but can you "debug a database" ???
>
Sure
Tables = AllTables(database)
ForEach table in Tables
ForEach field in table
update table set field = replace(field, ‘bug’, ‘’);
HcaeRof
HcaeRof
'database' is now de-'bug'ged.
I know that... but can you "debug a database" ???
On Aug 31, 11:55 pm, AstroDrabb wrote:
> You can debug the stored procedures and SQL. At least in SQL Server since
> 2000. However SQL Server 2005 moved it out to Visual Studio.
>
> As for the original Q, show the code you are using to populate
But we're still not sure what kind of dropdown, or where this dropdown
is, are we? This might not even be a code issue.
∞ Andy Badera
∞ This email is: [ ] bloggable [x] ask first [ ] private
∞ Google me: http://www.google.com/search?q=(andrew+badera)+OR+(andy+badera)
On Mon, Aug 31, 2009 at 4:
It would if you didn't care if the combo got populated. That is whey the
else { } block is there. The origianl Q? was that the drop down didn't get
filled.
So something in his query is not pulling back data. Normally when I run a
code to pull back data, I expect data so I check for it. If ther
But you can skip the if check if you are simply going to iterate
without any intermediary logic. "while (OdbcDR.Read())" alone would
have the same effect in this code -- as it is written now.
∞ Andy Badera
∞ This email is: [ ] bloggable [x] ask first [ ] private
∞ Google me: http://www.google.com
You should check your DataReader to see if it "HasRows". The HasRows
property returns true or false. If you don't have rows, you won't get any
items in your combo.
if (OdbcDR.HasRows)
{
while (OdbcDr.Read())
{
..
}
}
else
{
// hey no data!
}
On Mon, Aug 31, 2009 at 3:54 PM, VIKAS GA
while (OdbcDr.Read())
{
// Getting the data off DataReader in a string...
string DRData = (string)OdbcDr[0];//Here
OdbcDr is DataReader's object
//Adding the data to the combobox
C
Oh, P.S. you need VS Pro or greater to do this.
On Mon, Aug 31, 2009 at 2:55 PM, AstroDrabb wrote:
> You can debug the stored procedures and SQL. At least in SQL Server since
> 2000. However SQL Server 2005 moved it out to Visual Studio.
>
>
> As for the original Q, show the code you are using
You can debug the stored procedures and SQL. At least in SQL Server since
2000. However SQL Server 2005 moved it out to Visual Studio.
As for the original Q, show the code you are using to populate the drop
down.
On Mon, Aug 31, 2009 at 2:00 PM, Cerebrus wrote:
> (I don't know how anyone can
yes any additional information you could provide would be beneficial?
On Mon, Aug 31, 2009 at 1:00 PM, Cerebrus wrote:
>
> First, please be clear whether you are creating a database or
> debugging it (I don't know how anyone can debug a database). Secondly,
> no database can fill into a drop dow
First, please be clear whether you are creating a database or
debugging it (I don't know how anyone can debug a database). Secondly,
no database can fill into a drop down.
On Aug 31, 6:15 pm, mlk wrote:
> guys i am debuging a database using visual basic.net it does not fill
> in the drop down
>
12 matches
Mail list logo
