473,657 Members | 2,432 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

sorting table while inserting

Hi Friends,

How can we insert records in sorted order

like consider a table

No Name Phone
1 test1 12345
1 test1 23455
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594
if i add a new record like this

2 test2 34454

it should go in specific order. so that the final table should look
something like this

No Name Phone
1 test1 12345
1 test1 23455
2 test2 34454
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594

May 29 '07 #1
9 6933
Tables don't store data in a logical order. They store data in a
physical order. If you want to see data in an ordered fashion then
create a view to do that. Also, Name is a reserved word, don't use
it...

SELECT
No,
NameField,
Phone
FROM
yourTable
ORDER BY
No, NameField, Phone

Cheers,
Jason Lepack
On May 29, 12:04 pm, Oonz <arund...@gmail .comwrote:
Hi Friends,

How can we insert records in sorted order

like consider a table

No Name Phone
1 test1 12345
1 test1 23455
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594

if i add a new record like this

2 test2 34454

it should go in specific order. so that the final table should look
something like this

No Name Phone
1 test1 12345
1 test1 23455
2 test2 34454
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594

May 29 '07 #2
On May 29, 9:19 pm, Jason Lepack <jlep...@gmail. comwrote:
Tables don't store data in a logical order. They store data in a
physical order. If you want to see data in an ordered fashion then
create a view to do that. Also, Name is a reserved word, don't use
it...

SELECT
No,
NameField,
Phone
FROM
yourTable
ORDER BY
No, NameField, Phone

Cheers,
Jason Lepack
On May 29, 12:04 pm, Oonz <arund...@gmail .comwrote:
Hi Friends,
How can we insert records in sorted order
like consider a table
No Name Phone
1 test1 12345
1 test1 23455
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594
if i add a new record like this
2 test2 34454
it should go in specific order. so that the final table should look
something like this
No Name Phone
1 test1 12345
1 test1 23455
2 test2 34454
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594- Hide quoted text -

- Show quoted text -
But actually i want to do further processing with that sorted table.
Thats why i am in need of such structure

Thanks
Arunkumar.D

May 29 '07 #3
What exactly do you want to do? Maybe there is a better way of doing
it that you haven't come across.

Give a little more detail and more help can be given.

Cheers,
Jason Lepack

On May 29, 12:24 pm, Oonz <arund...@gmail .comwrote:
On May 29, 9:19 pm, Jason Lepack <jlep...@gmail. comwrote:


Tables don't store data in a logical order. They store data in a
physical order. If you want to see data in an ordered fashion then
create a view to do that. Also, Name is a reserved word, don't use
it...
SELECT
No,
NameField,
Phone
FROM
yourTable
ORDER BY
No, NameField, Phone
Cheers,
Jason Lepack
On May 29, 12:04 pm, Oonz <arund...@gmail .comwrote:
Hi Friends,
How can we insert records in sorted order
like consider a table
No Name Phone
1 test1 12345
1 test1 23455
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594
if i add a new record like this
2 test2 34454
it should go in specific order. so that the final table should look
something like this
No Name Phone
1 test1 12345
1 test1 23455
2 test2 34454
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594- Hide quoted text -
- Show quoted text -

But actually i want to do further processing with that sorted table.
Thats why i am in need of such structure

Thanks
Arunkumar.D- Hide quoted text -

- Show quoted text -

May 29 '07 #4
On May 29, 9:27 pm, Jason Lepack <jlep...@gmail. comwrote:
What exactly do you want to do? Maybe there is a better way of doing
it that you haven't come across.

Give a little more detail and more help can be given.

Cheers,
Jason Lepack

On May 29, 12:24 pm, Oonz <arund...@gmail .comwrote:
On May 29, 9:19 pm, Jason Lepack <jlep...@gmail. comwrote:
Tables don't store data in a logical order. They store data in a
physical order. If you want to see data in an ordered fashion then
create a view to do that. Also, Name is a reserved word, don't use
it...
SELECT
No,
NameField,
Phone
FROM
yourTable
ORDER BY
No, NameField, Phone
Cheers,
Jason Lepack
On May 29, 12:04 pm, Oonz <arund...@gmail .comwrote:
Hi Friends,
How can we insert records in sorted order
like consider a table
No Name Phone
1 test1 12345
1 test1 23455
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594
if i add a new record like this
2 test2 34454
it should go in specific order. so that the final table should look
something like this
No Name Phone
1 test1 12345
1 test1 23455
2 test2 34454
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594- Hide quoted text -
- Show quoted text -
But actually i want to do further processing with that sorted table.
Thats why i am in need of such structure
Thanks
Arunkumar.D- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

Actually i will combine the multiple numbers into one single record

the temporary table structure would be like this

No Name Phone FinalPhone
1 test1 12345 12345
1 test1 23455 12345<br23455
2 test2 68638 68638
2 test2 34454 68638<br34454<b r>
2 test2 45445 68638<br34454<b r45445
3 test3 67684 67684
4 test4 54808 54808
4 test4 74594 54808<br74594
and by using GROUP BY clause i would select single record having all
the
information
No Name FinalPhone
1 test1 12345<br23455
2 test2 68638<br34454<b r45445
3 test3 67684
4 test4 54808<br74594

this view would be sent to UI for display...

Thanks
Arunkumar.D

May 29 '07 #5
Jason Lepack wrote:
What exactly do you want to do? Maybe there is a better way of doing
it that you haven't come across.
More specifically, it sounds like he (like many others) is stuck on
procedural rather than functional thinking. Beware the frumious CURSOR!
Give a little more detail and more help can be given.
Agreed.
May 29 '07 #6
Oonz wrote:
Actually i will combine the multiple numbers into one single record

the temporary table structure would be like this

No Name Phone FinalPhone
1 test1 12345 12345
1 test1 23455 12345<br23455
2 test2 68638 68638
2 test2 34454 68638<br34454<b r>
2 test2 45445 68638<br34454<b r45445
3 test3 67684 67684
4 test4 54808 54808
4 test4 74594 54808<br74594
Add a DateInserted column, and use it in sorting.

If you delete the row with Phone = 34454, do you want to have to also
update the row with 45445 so that FinalPhone = 68638<br>45445? Of
course not - that would be a maintenance nightmare. Move FinalPhone
from the database to the UI layer, or at least from the table to a view.
May 29 '07 #7
I created two tables and a trigger and I have all the functionality
that you wanted, without having to create a cursor. The key is to let
the database do the work and this way, any record that validly gets
inserted into the phone_numbers table automatically gets put into the
phone_output list.

If you expect to be deleting or modifying records from the
phone_numbers table then you will need to add update and delete
triggers. (Note: for delete, use the replace function)

If you need more help, just post back.

Cheers,
Jason Lepack

Try this:

-- Begin SQL
CREATE TABLE [dbo].[phone_numbers](
[num] [int] NOT NULL,
[phone_name] [varchar](50) NOT NULL,
[phone] [varchar](50) NOT NULL
) ON [PRIMARY]
GO

CREATE UNIQUE NONCLUSTERED INDEX [nat_key] ON [dbo].[phone_numbers]
(
[num] ASC,
[phone] ASC
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[phone_output](
[num] [int] NOT NULL,
[phone_name] [nvarchar](50) NOT NULL,
[final_phone] [varchar](max) NULL
) ON [PRIMARY]
GO

CREATE TRIGGER [dbo].[update_final_ph one]
ON dbo.phone_numbe rs
AFTER INSERT
AS
BEGIN
insert into
phone_output(nu m, phone_name)
select distinct
i.num,
i.phone_name
from
inserted i
left outer join phone_output p
on i.num = p.num
where
p.num is null

update
phone_output
set
final_phone = coalesce(final_ phone + '<br>','') + phone
from
inserted i
where
phone_output.nu m = i.num
END
GO

insert into phone_numbers (num,phone_name ,phone) values
(1,'test1','123 45')
insert into phone_numbers (num,phone_name ,phone) values
(1,'test1','234 55')
insert into phone_numbers (num,phone_name ,phone) values
(2,'test2','686 38')
insert into phone_numbers (num,phone_name ,phone) values
(3,'test3','676 84')
insert into phone_numbers (num,phone_name ,phone) values
(4,'test4','548 08')
insert into phone_numbers (num,phone_name ,phone) values
(4,'test4','745 94')
go

select * from phone_numbers
select * from phone_output
-- End SQL

On May 29, 12:42 pm, Oonz <arund...@gmail .comwrote:
On May 29, 9:27 pm, Jason Lepack <jlep...@gmail. comwrote:


What exactly do you want to do? Maybe there is a better way of doing
it that you haven't come across.
Give a little more detail and more help can be given.
Cheers,
Jason Lepack
On May 29, 12:24 pm, Oonz <arund...@gmail .comwrote:
On May 29, 9:19 pm, Jason Lepack <jlep...@gmail. comwrote:
Tables don't store data in a logical order. They store data in a
physical order. If you want to see data in an ordered fashion then
create a view to do that. Also, Name is a reserved word, don't use
it...
SELECT
No,
NameField,
Phone
FROM
yourTable
ORDER BY
No, NameField, Phone
Cheers,
Jason Lepack
On May 29, 12:04 pm, Oonz <arund...@gmail .comwrote:
Hi Friends,
How can we insert records in sorted order
like consider a table
No Name Phone
1 test1 12345
1 test1 23455
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594
if i add a new record like this
2 test2 34454
it should go in specific order. so that the final table should look
something like this
No Name Phone
1 test1 12345
1 test1 23455
2 test2 34454
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594- Hide quoted text -
- Show quoted text -
But actually i want to do further processing with that sorted table.
Thats why i am in need of such structure
Thanks
Arunkumar.D- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -

Actually i will combine the multiple numbers into one single record

the temporary table structure would be like this

No Name Phone FinalPhone
1 test1 12345 12345
1 test1 23455 12345<br23455
2 test2 68638 68638
2 test2 34454 68638<br34454<b r>
2 test2 45445 68638<br34454<b r45445
3 test3 67684 67684
4 test4 54808 54808
4 test4 74594 54808<br74594

and by using GROUP BY clause i would select single record having all
the
information

No Name FinalPhone
1 test1 12345<br23455
2 test2 68638<br34454<b r45445
3 test3 67684
4 test4 54808<br74594

this view would be sent to UI for display...

Thanks
Arunkumar.D- Hide quoted text -

- Show quoted text -

May 29 '07 #8
Oonz (ar******@gmail .com) writes:
Actually i will combine the multiple numbers into one single record

the temporary table structure would be like this

No Name Phone FinalPhone
1 test1 12345 12345
1 test1 23455 12345<br23455
2 test2 68638 68638
2 test2 34454 68638<br34454<b r>
2 test2 45445 68638<br34454<b r45445
3 test3 67684 67684
4 test4 54808 54808
4 test4 74594 54808<br74594
and by using GROUP BY clause i would select single record having all the
information
No Name FinalPhone
1 test1 12345<br23455
2 test2 68638<br34454<b r45445
3 test3 67684
4 test4 54808<br74594

this view would be sent to UI for display...
GROUP BY is not your guy, in this case. See this link for some ideas on
to produce concatenated lists:
http://www.projectdmx.com/tsql/rowconcatenate.aspx
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
May 29 '07 #9
I created delete and update triggers... here's the complete ddl.

CREATE TABLE [dbo].[phone_numbers](
[num] [int] NOT NULL,
[phone_name] [varchar](50) NOT NULL,
[phone] [varchar](50) NOT NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [nat_key] ON [dbo].[phone_numbers]
(
[num] ASC,
[phone] ASC
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[phone_output](
[num] [int] NOT NULL,
[phone_name] [nvarchar](50) NOT NULL,
[final_phone] [varchar](max) NULL
) ON [PRIMARY]
GO
CREATE TRIGGER [dbo].[insert_final_ph one]
ON dbo.phone_numbe rs
AFTER INSERT
AS
BEGIN
insert into
phone_output(nu m, phone_name)
select distinct
i.num,
i.phone_name
from
inserted i
left outer join phone_output p
on i.num = p.num
where
p.num is null
update
phone_output
set
final_phone = coalesce(final_ phone + '<br>','') +
phone
from
inserted i
where
phone_output.nu m = i.num
END
GO

CREATE TRIGGER [dbo].[delete_final_ph one]
ON dbo.phone_numbe rs
AFTER DELETE
AS
BEGIN
update
phone_output
set
final_phone = replace(final_p hone, d.phone+'<br>', '')
from
deleted d
where
phone_output.nu m = d.num

update
phone_output
set
final_phone = replace(final_p hone, d.phone, '')
from
deleted d
where
phone_output.nu m = d.num

delete phone_output
where final_phone = ''
END
GO

CREATE TRIGGER [dbo].[update_final_ph one]
ON dbo.phone_numbe rs
AFTER UPDATE
AS
BEGIN
update
phone_output
set
final_phone = replace(final_p hone, d.phone+'<br>', '')
from
deleted d
where
phone_output.nu m = d.num

update
phone_output
set
final_phone = replace(final_p hone, d.phone, '')
from
deleted d
where
phone_output.nu m = d.num

delete phone_output
where final_phone = ''

insert into
phone_output(nu m, phone_name)
select distinct
i.num,
i.phone_name
from
inserted i
left outer join phone_output p
on i.num = p.num
where
p.num is null
update
phone_output
set
final_phone = coalesce(final_ phone + '<br>','') +
phone
from
inserted i
where
phone_output.nu m = i.num
END
GO

insert into phone_numbers (num,phone_name ,phone) values
(1,'test1','123 45')
insert into phone_numbers (num,phone_name ,phone) values
(1,'test1','234 55')
insert into phone_numbers (num,phone_name ,phone) values
(1,'test1','686 38')
insert into phone_numbers (num,phone_name ,phone) values
(3,'test3','676 84')
insert into phone_numbers (num,phone_name ,phone) values
(4,'test4','548 08')
insert into phone_numbers (num,phone_name ,phone) values
(4,'test4','745 94')
go

delete phone_numbers where num = 1 and phone = '23455'
delete phone_numbers where num = 3
go

update phone_numbers set num = 2 where phone = '54808'
update phone_numbers set phone = '7686' where phone = '12345'
go

On May 29, 2:01 pm, Jason Lepack <jlep...@gmail. comwrote:
I created two tables and a trigger and I have all the functionality
that you wanted, without having to create a cursor. The key is to let
the database do the work and this way, any record that validly gets
inserted into the phone_numbers table automatically gets put into the
phone_output list.

If you expect to be deleting or modifying records from the
phone_numbers table then you will need to add update and delete
triggers. (Note: for delete, use the replace function)

If you need more help, just post back.

Cheers,
Jason Lepack

Try this:

-- Begin SQL
CREATE TABLE [dbo].[phone_numbers](
[num] [int] NOT NULL,
[phone_name] [varchar](50) NOT NULL,
[phone] [varchar](50) NOT NULL
) ON [PRIMARY]
GO

CREATE UNIQUE NONCLUSTERED INDEX [nat_key] ON [dbo].[phone_numbers]
(
[num] ASC,
[phone] ASC
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[phone_output](
[num] [int] NOT NULL,
[phone_name] [nvarchar](50) NOT NULL,
[final_phone] [varchar](max) NULL
) ON [PRIMARY]
GO

CREATE TRIGGER [dbo].[update_final_ph one]
ON dbo.phone_numbe rs
AFTER INSERT
AS
BEGIN
insert into
phone_output(nu m, phone_name)
select distinct
i.num,
i.phone_name
from
inserted i
left outer join phone_output p
on i.num = p.num
where
p.num is null

update
phone_output
set
final_phone = coalesce(final_ phone + '<br>','') + phone
from
inserted i
where
phone_output.nu m = i.num
END
GO

insert into phone_numbers (num,phone_name ,phone) values
(1,'test1','123 45')
insert into phone_numbers (num,phone_name ,phone) values
(1,'test1','234 55')
insert into phone_numbers (num,phone_name ,phone) values
(2,'test2','686 38')
insert into phone_numbers (num,phone_name ,phone) values
(3,'test3','676 84')
insert into phone_numbers (num,phone_name ,phone) values
(4,'test4','548 08')
insert into phone_numbers (num,phone_name ,phone) values
(4,'test4','745 94')
go

select * from phone_numbers
select * from phone_output
-- End SQL

On May 29, 12:42 pm, Oonz <arund...@gmail .comwrote:
On May 29, 9:27 pm, Jason Lepack <jlep...@gmail. comwrote:
What exactly do you want to do? Maybe there is a better way of doing
it that you haven't come across.
Give a little more detail and more help can be given.
Cheers,
Jason Lepack
On May 29, 12:24 pm, Oonz <arund...@gmail .comwrote:
On May 29, 9:19 pm, Jason Lepack <jlep...@gmail. comwrote:
Tables don't store data in a logical order. They store data in a
physical order. If you want to see data in an ordered fashion then
create a view to do that. Also, Name is a reserved word, don't use
it...
SELECT
No,
NameField,
Phone
FROM
yourTable
ORDER BY
No, NameField, Phone
Cheers,
Jason Lepack
On May 29, 12:04 pm, Oonz <arund...@gmail .comwrote:
Hi Friends,
How can we insert records in sorted order
like consider a table
No Name Phone
1 test1 12345
1 test1 23455
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594
if i add a new record like this
2 test2 34454
it should go in specific order. so that the final table should look
something like this
No Name Phone
1 test1 12345
1 test1 23455
2 test2 34454
2 test2 68638
3 test3 67684
4 test4 54808
4 test4 74594- Hide quoted text -
- Show quoted text -
But actually i want to do further processing with that sorted table.
Thats why i am in need of such structure
Thanks
Arunkumar.D- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -
Actually i will combine the multiple numbers into one single record
the temporary table structure would be like this
No Name Phone FinalPhone
1 test1 12345 12345
1 test1 23455 12345<br23455
2 test2 68638 68638
2 test2 34454 68638<br34454<b r>
2 test2 45445 68638<br34454<b r45445
3 test3 67684 67684
4 test4 54808 54808
4 test4 74594 54808<br74594
and by using GROUP BY clause i would select single record having all
the
information
No Name FinalPhone
1 test1 12345<br23455
2 test2 68638<br34454<b r45445
3 test3 67684
4 test4 54808<br74594
this view would be sent to UI for display...
Thanks
Arunkumar.D- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -

May 30 '07 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
2378
by: pmud | last post by:
Hi, I am using teh following code for sorting the data grid but it doesnt work. I have set the auto generate columns to false. & set the sort expression for each field as the anme of that field... This grid displayes results based on users search.. public static int numberDiv; private void Page_Load(object sender, System.EventArgs e) {
4
2815
by: Gareth Gale | last post by:
I'm trying to implement a way of allowing a user to sort a HTML table via Javascript on the client. I've seen lots of samples where single column sorting (asc or desc) is shown, but I'd like nested sorting i.e. sort by col1 asc, then by col2 desc etc. Can anyone help ?
2
2818
by: Tim Marshall | last post by:
Access 2003. The situation is this: I have a "criteria selection form" in which there are a many different criteria, mostly displayed as combo and text boxes in which a user can enter stuff, click an associated button and that criteria becomes part of the where clause of a select statement. The selected criteria is stored on a hidden form and when the user is ready to run their report(s), a button action goes through the hidden form and...
4
4279
by: FBM | last post by:
Hi, I am working on a program that simulates one of the elements of ATM. The simulation stores events which occurs every some milliseconds for a certain amount of time. Every time that an event is stored in a double linked list, the whole list is sorted for the next round. My problem appears when subjecting the program to heavy load, that is, when I run the simulation for more than 10,000 miliseconds (every event occurs in...
7
4811
by: Kamal | last post by:
Hello all, I have a very simple html table with collapsible rows and sorting capabilities. The collapsible row is hidden with css rule (display:none). When one clicks in the left of the expandable row, the hidden row is made visible with css. The problem is when i sort the rows, the hidden rows get sorted as well which i don't want and want to be moved (while sorting) relative to their parent rows. The following is my complete html code...
2
1761
by: cluce | last post by:
i have a table sorting feature on my website that works everywhere else except in firefox. but the example code does work in firefox. this has me stumped. The problem is the links in the table headers wont show up so they can be clicked on to sort the colunm. here is my webpage code that displays the data in a table..... $get_list_sql = "SELECT * FROM products WHERE Category = '".$_POST."'"; $result = mysqli_query($mysqli,...
2
2256
by: Bob Laubla | last post by:
Hello I have a very complex maketable query with many records and involving multiple VB functions which call other functions. I need this table to be sorted by the first field. But no matter what I do, there is a small chance of the table coming out unsorted. I have tried sorting it with the 'make table' query. I have tried sorting it with Word during output (my current configuration runs 4 of these). I have tried reading it into an...
6
4068
by: =?Utf-8?B?RGFu?= | last post by:
I am reposting a question from about 3 weeks ago ("sorting capability"). I have an aspx page in which I get the data from a database dynamically, through C# code, by creating a dynamic table using TableHeaderCell and TableHeaderRow. The data is binded to the table by using a DataSet and Data Reader. The responses on the forum made me think that it would be easier to sort the data in the table (when clicking on the header column), by...
5
4933
by: jrod11 | last post by:
hi, I found a jquery html table sorting code i have implemented. I am trying to figure out how to edit how many colums there are, but every time i remove code that I think controls how many colums there are, it crashes. There are currently 6 columns, and I only want 4. How do I remove the last two (discount and date)? Here is a link: http://www.jaredmoore.com/tablesorter/docs/salestable.html Here is some jquery js that I think...
0
8324
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,...
1
8513
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8617
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7352
agi2029
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...
1
6176
isladogs
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...
0
4330
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2742
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
2
1970
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1733
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.