Using User-defined Functions in VB.net

Hi Every body
>
I used access succefully for years and I created many scientefic
databases with it
>
Now I want to use VB.net2005 environmment with access database
>
I succesfuly loaded my database BUT all the custom functions in the
modules had not been imported
>
So I created a module in VB.net and put all my custom functions as
Public Functions,
But this fails too!
>
What Can I Do to make the SQL engine read functions as it was in
access?
>
Thanks in advance

Hi Every body
>
I used access succefully for years and I created many scientefic
databases with it
>
Now I want to use VB.net2005 environmment with access database
>
I succesfuly loaded my database BUT all the custom functions in the
modules had not been imported
>
So I created a module in VB.net and put all my custom functions as
Public Functions,
But this fails too!
>
What Can I Do to make the SQL engine read functions as it was in
access?
>
Thanks in advance

Hi Every body
>
I used access succefully for years and I created many scientefic
databases with it
>
Now I want to use VB.net2005 environmment with access database
>
I succesfuly loaded my database BUT all the custom functions in the
modules had not been imported
>
So I created a module in VB.net and put all my custom functions as
Public Functions,
But this fails too!
>
What Can I Do to make the SQL engine read functions as it was in
access?
>
Thanks in advance
>

If nobody here helps you (and ignore the Larry Linson guy; he's trolling),
I recommend that you post this to the
microsoft.public.sqlserver.programming newsgroup.
>
Robin S.
---------------------------"SemiNoviceProgramer" <hgnov3...@gmail.comwrote in message
>
news:1171372940.970806.48060@v33g2000cwv.googlegro ups.com...
>
>
>>>>>>>>
- Show quoted text -

I used access succefully for years and I created many scientefic
databases with it
>
Now I want to use VB.net2005 environmment with access database
>
I succesfuly loaded my database BUT all the custom functions in the
modules had not been imported

Hi Every body
>
I used access succefully for years and I created many scientefic
databases with it
>
Now I want to use VB.net2005 environmment with access database
>
I succesfuly loaded my database BUT all the custom functions in the
modules had not been imported
>
So I created a module in VB.net and put all my custom functions as
Public Functions,
But this fails too!
>
What Can I Do to make the SQL engine read functions as it was in
access?
>
Thanks in advance

Hi Every body
>
I used access succefully for years and I created many scientefic
databases with it
>
Now I want to use VB.net2005 environmment with access database
>
I succesfuly loaded my database BUT all the custom functions in the
modules had not been imported
>
So I created a module in VB.net and put all my custom functions as
Public Functions,
But this fails too!
>
What Can I Do to make the SQL engine read functions as it was in
access?
>
Thanks in advance

Hi Every body
>
I used access succefully for years and I created many scientefic
databases with it
>
Now I want to use VB.net2005 environmment with access database
>
I succesfuly loaded my database BUT all the custom functions in the
modules had not been imported
>
So I created a module in VB.net and put all my custom functions as
Public Functions,
But this fails too!
>
What Can I Do to make the SQL engine read functions as it was in
access?
>
Thanks in advance
>

Hi Every body
>
I used access succefully for years and I created many scientefic
databases with it
>
Now I want to use VB.net2005 environmment with access database
>
I succesfuly loaded my database BUT all the custom functions in the
modules had not been imported
>
So I created a module in VB.net and put all my custom functions as
Public Functions,
But this fails too!
>
What Can I Do to make the SQL engine read functions as it was in
access?
>
Thanks in advance
>

Thanks Every body for reply
>
To Robins
I loaded the tabels and queries only to VB2005
The code and parameters' queries did not load
>
I have no problem to rewrite code in VB.net syntax
>
BUT the problem is that VB.net is unable to link its code to the
database
>
for example it loaded a table, say emploee table, a query should be
built to geather those having 3 years or more and to raise there
salary according to specific function NewSalary(DateOfStart,
BasicSalary, PositionID)
This was done in Access by simply definig Public function in a
module and every thing ok
When I defined a public function in VB.net, the query can not
identify that function and returns an error.
In SQL server the stored procedures fixed the problem but in access
database no stored procedures.
>
Is there any possible solution?

Thanks Every body for reply
>
To Robins
I loaded the tabels and queries only to VB2005
The code and parameters' queries did not load
>
I have no problem to rewrite code in VB.net syntax
>
BUT the problem is that VB.net is unable to link its code to the
database
>
for example it loaded a table, say emploee table, a query should be
built to geather those having 3 years or more and to raise there
salary according to specific function NewSalary(DateOfStart,
BasicSalary, PositionID)
This was done in Access by simply definig Public function in a module
and every thing ok
When I defined a public function in VB.net, the query can not identify
that function and returns an error.
In SQL server the stored procedures fixed the problem but in access
database no stored procedures.
>
Is there any possible solution?

"SemiNoviceProgramer" <hgnov3...@gmail.comschrieb
>
>
>>>>>>>
Modules <Database
>
means: In VB.Net, you are doing database programming, not Access
programming. Access uses the same database enginge (Jet) as VB.Net does, but
VB.Net does not use Access. You do not even have to have Access installed on
a machine running your application, only the Jet is necessary. Modules (like
Reports) belong to Access. The Jet does not know any of your code in VB.Net.
That's database programming.
>
If you want to do more than SQL can offer, write the code in VB.Net. Or, if
you like to have it in the database (I don't), SQL server (express) using
it's stored procedures may be an alternative.
>
Armin

Access MDB can do this; and I think that ColdFusion can do this?? i
don't know why I say that I just think that is true about coldfusion.
>
but no, visual basic .NET doesn't support _ANYTHING_ considered
practical like this.
>
you can't bind a sql statement to a form; nothign like this.
>
sorry; I hate vb.net and this is one of those reasons
>
but you've just got to do it programmatically
and because the forms and all classes and they're all optimized for a
MDI: i don't even think that you can refer to the form name.
>
instead of DoCmd.OpenForm
>
you've got to do this:
>
Dim StartupForm1 as new StartupForm
StartupForm1.Show
>
and then when you're living on the Detail form, in order to refer to a
control on the StartupForm; you need to make sure that you use the
StartupForm1.txtUsername instead of StartupForm.txtUsername
>
these people are going to flame me; but I believe that I'm on the
right track here.
I just think that VB dotnet is not competitive with MS Access in 10%
of the functionalty; I would reccomend avoiding VB.net and maybe it
will be a decent product with the next release (i know; I've been
saying that for 5 years but the damn IDE crashes every day and it's
thus unusable)
>
>
>
On Feb 16, 11:22 pm, "SemiNoviceProgramer" <hgnov3...@gmail.com>
wrote:>
>