Database

FirstPrevNext

Re: Calling Stored SQL Functions from Visual Basic pmarfleet7-Sep-07 0:22 pmarfleet 7-Sep-07 0:22  My statement is still correct. A function cannot be called directly. The call must be made from either a stored procedure or inline SQL statement. Paul Re: Calling Stored SQL Functions from Visual Basic Paddy Boyd7-Sep-07 0:25 Paddy Boyd 7-Sep-07 0:25  Yes, but what benefit is gained from wrapping the function in a stored procedure? It's just another level of code to go wrong... Re: Calling Stored SQL Functions from Visual Basic pmarfleet7-Sep-07 0:36 pmarfleet 7-Sep-07 0:36  I never use inline SQL statements. They may be quicker to code, but the advantages of using stored procedures (maintainability, robustness, security) more than outweigh the extra code overhead. Re: Calling Stored SQL Functions from Visual Basic Paddy Boyd7-Sep-07 0:44 Paddy Boyd 7-Sep-07 0:44  I've been through this discussion a few times with different people and I think that it's more of a religious type decision than anything else. We may just have to agree to differ. Re: Calling Stored SQL Functions from Visual Basic Mark Cabbage8-Sep-07 14:45 Mark Cabbage 8-Sep-07 14:45  Thanks Paddy. I need to return some values and use them so I think the function would be best, but there seems to be some debate here if it can be achieved. Excuse my ignorance but my previous coding was for MSAcess so I"m trying to learn SQL server issues, and move from VBA to VB.NET. I have put in the SELECT statement you sugessted but the compiler tells me "Select CASE must end with a matching END SELECT", and hovering over FROM in the statement gives me "name not declared" . Obviously I need more code to setup the SQL statement - could you kindly give me an example please. Many thanks Mark Re: Calling Stored SQL Functions from Visual Basic Paddy Boyd9-Sep-07 21:19 Paddy Boyd 9-Sep-07 21:19  Do you have a case statement in your sql somewhere? Re: Calling Stored SQL Functions from Visual Basic Mark Cabbage9-Sep-07 21:35 Mark Cabbage 9-Sep-07 21:35  No, and I don't want to either. It issues these errors when I hover over the "select fontname, fontsize....." In the old VBA I used to call the functions like: Dim Fontsize as integer fontsize = GetFontSize(strCurrentUser) ---- Function GetFontSize(CurentUser as string) as Integer ...... ...... ----- This meant I was able to use a single like to get my values and use them in lots of places easily. When I read I should store these server-side I was very happy. I just need to call the function and return it to my current sub easily without having to do too much coding to setup and call the function otherwise it defeats the purpose FYI I spent all weekend playing with the new error provider - very nice but it took me the longest time to work it out nicely....MS documentation is horrible....I found Google far better than MS own doccu... Mark How can access mdb ? manuo56-Sep-07 22:36 manuo5 6-Sep-07 22:36  HI , We have one webapplication which using this mdb file and this mdb file reside in website folder,we donot know physical path of website and we are creating another window based aplication and want to use this mdb in my window aplication .How it is possible ? Please give me some Suggestion .Its urgent Manu Sharma Re: How can access mdb ? pmarfleet6-Sep-07 23:07 pmarfleet 6-Sep-07 23:07  Is this an Access database? Paul Re: How can access mdb ? manuo56-Sep-07 23:22 manuo5 6-Sep-07 23:22  yes this an Access database . Re: How can access mdb ? pmarfleet6-Sep-07 23:25 pmarfleet 6-Sep-07 23:25  A connection string for an Access database requires the physical path to the database file to be specified. Paul Re: How can access mdb ? manuo56-Sep-07 23:28 manuo5 6-Sep-07 23:28  Problem is that website host in another server .so we donot know physical path of mdb . Re: How can access mdb ? pmarfleet6-Sep-07 23:32 pmarfleet 6-Sep-07 23:32  I don't think there is an easy solution to your problem. You should probably consider migrating your database to SQL Server or something similar. Paul Re: How can access mdb ? manuo56-Sep-07 23:45 manuo5 6-Sep-07 23:45  Thanks but web Aplication running now so it is not possible . Manu Re: How can access mdb ? Paddy Boyd7-Sep-07 0:28 Paddy Boyd 7-Sep-07 0:28  How come you don't know the physical path to the webserver? Is it not on your network? Do you need access to all the data in this database file? If you only need a small subset, you could create a couple of webservices to return the data you require, although this becomes very cumbersome for more than a couple of queries. Re: How can access mdb ? manuo57-Sep-07 1:50 manuo5 7-Sep-07 1:50  Thanks for reply it is not on your network ,it is another server not on my network.I know Ip of this server only and name of mdb file . we want to fetch subset of all tables userwise data . Re: How can access mdb ? Paddy Boyd7-Sep-07 2:21 Paddy Boyd 7-Sep-07 2:21  So it's on another network that you don't have direct access to? I don't think you will be able to directly access this database. Re: How can access mdb ? manuo57-Sep-07 2:52 manuo5 7-Sep-07 2:52  They also provide one usename with full access on this mdb then it is possible to access or not ? Manu Re: How can access mdb ? Paddy Boyd7-Sep-07 3:01 Paddy Boyd 7-Sep-07 3:01  Yes, but if you can't actually access the network to get to the mdb file to try and login to the DB with the provided username, it's not really going to help you, is it? How to copy database from other database C#Coudou6-Sep-07 21:19 C#Coudou 6-Sep-07 21:19  Dudes, I have a new project using SQL database. Here`s my scenario. I have two database. Database Name: PCON_A Database Used: 2006/01 to 2006/12 Database Name: PCON_B Database Used: 2007/01 to 2007/08 I want to copy the database PCON_A to PCON_B using sql script. How to do that? Thanks in advance, Jeof;) ****************************** I just want to know everything Re: How to copy database from other database pmarfleet6-Sep-07 21:57 pmarfleet 6-Sep-07 21:57  Have a look at this article. Paul Re: How to copy database from other database C#Coudou6-Sep-07 22:12 C#Coudou 6-Sep-07 22:12  link doesn`t work. ****************************** I just want to know everything Re: How to copy database from other database pmarfleet6-Sep-07 22:17 pmarfleet 6-Sep-07 22:17  Oops. Copy-and-paste error. This link should work. Paul Re: How to copy database from other database C#Coudou6-Sep-07 22:32 C#Coudou 6-Sep-07 22:32  got it. this is very helpful. thanks so much. ****************************** I just want to know everything Re: How to copy database from other database Frank Kerrigan7-Sep-07 5:06 Frank Kerrigan 7-Sep-07 5:06  <br /> <br /> INSERT PCON_B.dbo.TABLE1<br /> select * from PCON_A.dbo.TABLE1<br /> <br /> or even <br /> <br /> truncate table PCON_A.dbo.TABLE1<br /> <br /> INSERT PCON_B.dbo.TABLE1<br /> select * from PCON_A.dbo.TABLE1<br /> <br /> Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http://www.frankkerrigan.com/[^]

Last Visit: 31-Dec-99 18:00     Last Update: 6-Jun-24 8:21 Refresh ᐊ Prev1...1423142414251426142714281429143014311432 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.