Using User-defined Functions in VB.net

SemiNoviceProgramer

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

Feb 13 '07 #1

Subscribe Reply

6875

Larry Linson

a) Access MDB is for retards

b) SQL Server UDFs are great

c) if you're trying to reuse them in VB 2005 you'll have to rewrite
them _AGAIN_

MS does not support code reuse; move away from VB; consider PHP or
something
MS has demonstrated; time and time again-- that they could care less
about 7 million vb6 programmers; and they'd rather cater to a couple
hundred C# _FAGS_

On Feb 13, 5:22 am, "SemiNoviceProg ramer" <hgnov3...@gmai l.comwrote:

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

Feb 14 '07 #2

Larry Linson

either learn SQL or VB you can't skate by without one of the two
I personally said 'screw dotnet' and i've been focused on SQL for the
past 5 years; I love it

and worse comes to worse; i'll move to mySql or Oracle or someting; MS
has demonstrated a complete and utter disregard for programmers,
programmers, programmers

On Feb 13, 5:22 am, "SemiNoviceProg ramer" <hgnov3...@gmai l.comwrote:

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

Feb 14 '07 #3

RobinS

If nobody here helps you (and ignore the Larry Linson guy; he's trolling),
I recommend that you post this to the
microsoft.publi c.sqlserver.pro gramming newsgroup.

Robin S.
---------------------------
"SemiNoviceProg ramer" <hg*******@gmai l.comwrote in message
news:11******** *************@v 33g2000cwv.goog legroups.com...

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

Feb 14 '07 #4

pfc_sadr

seriously robin

time to start sticking on topic
DOTNET DOES NOT SUPPORT CODE REUSE

IT DOES NOT SUPPORT VBA
IT DOES NOT REPLACE VBA

IT DOES NOT SUPPORT VBS
IT DOES NOT REPLACE VBS

keep your access code in MS Access where it belongs

DOTNET IS DEAD
AND NO ONE CARES

IF THERE WAS A HELL
I WOULD SEND MICROSOFT THERE

On Feb 13, 10:26 pm, "RobinS" <Rob...@NoSpam. yah.nonewrote:

If nobody here helps you (and ignore the Larry Linson guy; he's trolling),
I recommend that you post this to the
microsoft.publi c.sqlserver.pro gramming newsgroup.

Robin S.
---------------------------"SemiNoviceProg ramer" <hgnov3...@gmai l.comwrote in message

news:11******** *************@v 33g2000cwv.goog legroups.com...

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- Hide quoted text -

- Show quoted text -

Feb 14 '07 #5

Branco Medeiros

SemiNoviceProgr amer wrote:

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

<snip>

There's a really long time since I coded in Access, so forgive any
mistakes.

It seems to me that the Access functions belong to the DB, and will
probably not be imported.

A (somewhat far fetched) solution would be to create (parameterized)
queries that use your functions in Access and import the queries into
VB.

HTH.

Regards,

Branco.

Feb 14 '07 #6

Larry Linson

learn how to rewrite VBA into DOTNET

_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_
_WELCOME_TO_VIS UAL_FRED_

On Feb 13, 5:22 am, "SemiNoviceProg ramer" <hgnov3...@gmai l.comwrote:

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

Feb 14 '07 #7

Larry Linson

and for the record, the mix-match of VBA and SQL is something that is
only available in MS Access

it isn't anywhere else
sorry

On Feb 13, 5:22 am, "SemiNoviceProg ramer" <hgnov3...@gmai l.comwrote:

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

Feb 14 '07 #8

RobinS

When you say you loaded the database, what did you load it into?

Robin S.
-------------------------------------
"SemiNoviceProg ramer" <hg*******@gmai l.comwrote in message
news:11******** *************@v 33g2000cwv.goog legroups.com...

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

Feb 14 '07 #9

Cor Ligthert [MVP]

Semi

There should be almost no differences. OleDB is more difficult to use with
an auto identifier because the created one is not given back. Parameters in
OleDB have to be given in sequence as the are created.

I write OleDB that is because MS-Access has no SQLClient provider. Using
edit and replace will be probably the most you have to do.

Cor

"SemiNoviceProg ramer" <hg*******@gmai l.comschreef in bericht
news:11******** *************@v 33g2000cwv.goog legroups.com...

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

Feb 14 '07 #10

Similar topics

5944

HTML Templates stored in Postgres using Perl

by: Sam | last post by:

I would like to store html templates in a database. By using perl I would like to retrive the template ask the user to fill the template and store the whole file is template + the user data in a database. How can I do this? Should I use Perl Mason to do this. Or Can I store the template in database using text field and then retrive the template from database using select command and then save the html template to a file. Then in form...

Perl

4091

Need better argument for using bound forms

by: James Fortune | last post by:

I have a lot of respect for David Fenton and Allen Browne, but I don't understand why people who know how to write code to completely replace a front end do not write something that will automate the code that implements managing unbound controls on forms given the superior performance of unbound controls in a client/server environment. I can easily understand a newbie using bound controls or someone with a tight deadline. I guess I need...

Microsoft Access / VBA

9864

Changing Password to an account that has to change password at first logon using System.DirectoryServices

by: Fabrizio | last post by:

(Sorry for the crosspost, but I really don't know which is the right newsgroup!) Hi all, I try to change the password to a user that as to change the password at first logon: try {

C# / C Sharp

2414

ADSI using Asp.net

by: YRao | last post by:

I am going to create intranet application using Windows Authentication using C# asp.net I am having following problem: 1 setting windows Authentication, it will validate for all users, user name and password from ADSI before entering into application this is working fine. Problem Is I am going to categorize users based on their Title properties value

C# / C Sharp

2068

many people logging in using same user name

by: Michelle Stone | last post by:

Hi everybody I am writing a simple asp.net application using form authentication. I store the list of all users and their passwords in an SQL Server database table. My client recently told me that he wants me to do something through which only one user can login using any given account name. I mean to say, for example, when a user called "abc" is online, another person shouldn't be

ASP.NET

3150

Using User Control from class library

by: Marcel Gelijk | last post by:

Hi, I am trying to create a User Control that is located in a seperate class library. The User Control contains a textbox and a button. The page generates an exception when it tries to access the code variable that are supposed to be linked to the contained controls. It runs fines when everything is contained in a single web form project. What do I need to do to make it work from a class library?

ASP.NET

4841

using Session with FormsAuthentication

by: Åženol Akbulak | last post by:

Hello; I use in my web application FormsAuthentication. Also I use Session state (InProc). When a user logged in, I can read Session parameters. (For example Session). Problem is that, when user close the browser window then open a new browser, FormsAuthentication reads from cookie and user logs in. Althought user logged in, session parameter is null.

ASP.NET

1753

Validate subsets of XML document using different schema?

by: Lord0 | last post by:

I *think* I need to be able to validate subsets of an XML document using different schema. The functionality I'm trying to implement is this. a) External suppliers produce an XML document containing multiple User records. The external supplier validates this entire document using schema 1. This document is then uploaded to our system. b) Our system then checks that the supplied document "looks okay", minimally, using Schema 2. Schema...

.NET Framework

3085

Using ajax in Existing ASP.net Application

by: Mukesh | last post by:

Hi i want to use AJAX.net in my Existing Application I have already installed the ajax .net ..net 3.0 and using VS 2005 in the old application i have added a new web form then script manager and then update panel and some control in it to test it. When i run the programme ir does not work . imean ajax does not works

ASP.NET

13069

How to restrict multiple login using a single account.

by: shankhar | last post by:

Hi all, In my project there is a requirement. If a user logged in at a time since he/she logged out others are not allowed to loggin using the same user name. That is to avoid multiple logins using a account. How to do this? I had got a idea and implemented. 1. When a user logs in storing the username, ip, login time to db.

PHP

8330

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8850

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8746

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

7355

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6178

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4175

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4334

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2749

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1975

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP