Database

13-May-10 2:52

Hi all
I'm experiencing troubles with the code from this site.

Which parameter is exspected instead of:"master..sysdatabases" in the following sql-command:Dim mySQL As String = _
"IF EXISTS (" & _
"SELECT * " & _
"FROM master..sysdatabases " & _
"WHERE Name = 'MyDatabase')" & vbCrLf & _
"DROP DATABASE MyDatabase " & vbCrLf & _
"CREATE DATABASE MyDatabase "

Thanks,
Lucchingolo

Corporal Agarn13-May-10 4:09

Corporal Agarn

13-May-10 4:09

What database engine are you using?

luccingolo13-May-10 5:57

13-May-10 5:57

I'm using Microsoft SQL Server 2008

Corporal Agarn13-May-10 6:17

Corporal Agarn

13-May-10 6:17

Okay, by right clicking on a database in SSMS you can select "Script Database as" then select "DROP to" you can then find that you are looking for sys.databases

As this looks like .NET code you may not have access to SSMS so here is an T-SQL example:

IF  EXISTS (SELECT name FROM sys.databases WHERE name = N'MyDatabase')
DROP DATABASE [MyDatabase]

luccingolo13-May-10 6:53

13-May-10 6:53

Sorry, still get an error.
Maybe i misundertood you.
Fact is that i still get an error.

What i did is using your sql-command as string for my SQL-command.
What I mean is this:
In the Form1_Load-Event of my Application(project).

MyConnection = "Server=localhost;" & "DataBase=;" & "Integrated Security=SSPI"
'Your line of code
Dim mySQL As String = "IF EXISTS (SELECT name FROM sys.databases WHERE name = N'MyDatabase')DROP DATABASE [MyDatabase]"

Try
Dim conn As New SqlConnection(MyConnection)
Dim myCmd As New SqlCommand(mySQL, conn)

conn.Open()
myCmd.ExecuteNonQuery()
conn.Close()
.
.
.
Last but not least, don't forget that the point is not only to "drop" a Database but i'm trying so hard to create a SQL-Database. Smile | :)

thank you,
Lucchingolo

Corporal Agarn13-May-10 7:01

Corporal Agarn

13-May-10 7:01

You will need a semicolon before the drop. If you are not dropping a database I would suggest not even coding the if - drop.

I have not programmed this at the .NET end. You may need to go to the VS forum.

luccingolo13-May-10 7:14

how to write the querry for copying one image field into another image field in sql server 2000

13-May-10 7:14

Thank your, I will give it a try in the Visual Basic forum.
I could not find a VS-forum. Guess you meant the VB-forum.

WPF cascaded combo

bindum3112-May-10 20:08

bindum31

12-May-10 20:08

Hi,
I am using LINQ to SQL and MVVM pattern in my application where i am retrieving
my data by the following query:

internal ObservableCollection&lt;INVCategory&gt; GetCategoryList()
{
      DataLoadOptions dataLoadOptions = new DataLoadOptions();
      dataLoadOptions.LoadWith&lt;INVCategory&gt;(t =&gt; t.INVSubCategories);
      this.Context.LoadOptions = dataLoadOptions;
             
      var categories = from category in this.Context.INVCategories
                       orderby category.CatgeoryId descending
                       select category;
      return new   ObservableCollection&lt;INVCategory&gt;(categories.ToList());
}

And my XAML code for parent(Category) combo is:

<ComboBox Grid.Column="1" Grid.Row="0" HorizontalAlignment="Stretch"  VerticalAlignment="Stretch" Margin="0,2,10,2" TabIndex="0" x:Name="categoryComboBox" ItemsSource="{Binding CategoryList}" IsEditable="True" DisplayMemberPath="CategoryName"  SelectedValuePath="CatgeoryId" SelectedItem="{Binding CategoryList, Mode=TwoWay}" SelectedValue="{Binding Path=CurrentEntity.CategoryId, Mode=TwoWay}">
</ComboBox>

for child(Subcategory) combo i am using:

<ComboBox Grid.Column="1" Grid.Row="1" HorizontalAlignment="Stretch" VerticalAlignment="Stretch" Margin="0,2,10,2" TabIndex="1" ItemsSource="{Binding SelectedItem, ElementName=categoryComboBox, Mode=OneWay}" DisplayMemberPath="SubCategoryName" SelectedValuePath="SubCategoryId" SelectedItem="{Binding INVSubCategories, Mode=TwoWay}" >
</ComboBox>

But my child combo items is not populated during form loading as well as parent combo's
selection changed though my parent combo items are populated.
i can't figure out why my child combo is not functioning based on parent combo's
selected item ,please help me.

Re: WPF cascaded combo

Michael J. Eber13-May-10 10:39

Michael J. Eber

13-May-10 10:39

I think you are more likely to get an answer posting this on the WPF forum instead of the SQL forum.
But I experienced basically the same thing and finally wrote my own code the old-fashioned way to populate the child table. Though, looking at your XAML you've pretty much setup a logical binding between the two.

Good luck.

Re: WPF cascaded combo

Michael J. Eber13-May-10 12:07

Michael J. Eber

13-May-10 12:07

I was sitting out on my porch having lunch when I realized what your problem may be.

I remember there was a property (don't know it right now .. you'll have to search for the obvious in your XAML) which was basically binding to an event to tell the control when to rebind it's data. You need to find that property and bind it to the combobox SelectionChanged event.

developerit12-May-10 20:04

developerit

12-May-10 20:04

hi iam using sql server 2000

i have table images

brabchid nvarchar(50)

imagenew image
imageold image

at the first time iam storing image in imagenew field then by using update querry i want to copy imagenew field data into imageold field and in imagenew field iam storing new image but it is showing same images can you correct my querry

update images set imageold=imagenew ,imagenew=@imagenew where branchid=@branchid

Re: how to write the querry for copying one image field into another image field in sql server 2000

developerit14-May-10 22:28

developerit

14-May-10 22:28

hi , sir iam waiting for your reply

OS dependency with Interbase database 6.0 driver?

navneet.professional12-May-10 19:57

navneet.professional

12-May-10 19:57

Hi,

Could anybody tell me about Interbase database 6.0 driver's compatibility with different OS as (All Windows/Unix/Linux) based on practical experience,not based on information available on internet as it is not always correct.

Thanks & Regards
Navneet

Re: OS dependency with Interbase database 6.0 driver?

Henry Minute13-May-10 1:48

Henry Minute

13-May-10 1:48

I can only confirm that I currently run it on XP (SP3) but it has been on my system since the release of XP. So XP, XP (SP1), XP (SP2) are also all OK.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

How to use CLongBinary to store image of size > 64 KB with Interbase Database 6.0 driver

navneet.professional12-May-10 19:50

navneet.professional

12-May-10 19:50

Hi,

I stored/retrieved images upto size 64 KB (65535 byte) using CByteArray.But it is not able to save whole image of size 2 MB, partially it saves upto 64 KB of total size 2 MB.

How to use CLongBinary to store image of size > 64 KB (upto 2 MB) with Interbase Database 6.0 driver?

Please provide me example specific to this database driver.

Database table structure is:

Create table "TEST"
(
"Name" varchar(10),
"BlobData" BLOB
);

I tried to check BLOB limit of database table as well.I run following queries on database:
Case 1:
Create table "TEST"
(
"Name" varchar(10),
"BlobData" BLOB(65535)
);
Result: Successfully created.

Case 2:
Create table "TEST"
(
"Name" varchar(10),
"BlobData" BLOB(65536)
);
Result: Dynamic SQL Error Error code -842 shown as: unsigned short integer expected.

So please help me to resove this problem.

Thanks & Regards
Navneet

Not Equal to Question/Problem

djhankypark12-May-10 6:09

djhankypark

12-May-10 6:09

Hello

I am trying to get from a mysql tables, all records from one table that do not have a corresponding ID in another, I am using the following query but I'm missing the plot somewhere.

SELECT tbl_band_songs.id3_artist, tbl_band_songs.Artist, tbl_band_songs.id, tbl_band_songs.id3_title

FROM tbl_band_songs, tbl_song_lyrics

WHERE tbl_band_songs.id3_artist = 239 AND tbl_band_songs.id <> tbl_song_lyrics.Sng_ID

Basically I am trying to show the user songs that have no lyrics already enetered so they then have the option to enter them.

Thank you in advance for any help.

regards

Ray

J4amieC12-May-10 6:23

J4amieC

12-May-10 6:23

Never touched mysql in my life, but I think you're looking for NOT IN and a subquery.

SELECT tbl_band_songs.id3_artist, tbl_band_songs.Artist, tbl_band_songs.id, tbl_band_songs.id3_title
FROM tbl_band_songs, tbl_song_lyrics
WHERE tbl_band_songs.id3_artist = 239 
AND tbl_band_songs.id NOT IN (SELECT tbl_song_lyrics.Sng_ID FROM tbl_song_lyrics)

David Skelly12-May-10 6:24

David Skelly

12-May-10 6:24

You should do a left outer join from tbl_band_songs to tbl_band_lyrics and then select where tbl_song_lyrics.Sng_ID is null.

If you search on Google you will find plenty of examples that explain what an outer join is and how to code it to get the results you want.

PIEBALDconsult12-May-10 18:21

PIEBALDconsult

12-May-10 18:21

Yeah, that's what I do.

Chris Meech12-May-10 6:38

Chris Meech

12-May-10 6:38

My preference for these kinds of queries is to use NOT EXISTS in the where clause.

select your_field_list
  from table_one t1
 where not exists ( select t2.id
                      from table_two t2
                     where t2.id = t1.id
                  )
;

I've found this to usually be the most performant, though YMMV. Smile | :)

Chris Meech
I am Canadian. [heard in a local bar]

In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]