473,410 Members | 1,889 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,410 software developers and data experts.

Is it possible to determine the record ID when using INSERT INTO?

MLH
Suppose, in a multi-user environment, you
have append query SQL in a VBA procedure
that looks like INSERT INTO MyTable...
and the next line reads MyVar=DMax("[MyKeyField]","MyTable...

You can never be certain that MyVar will be
set to the key-field value that was created
when the Append query ran. Now, there are
other ways to do it - I know - that will ensure
you 'nab' the correct record. But I was wondering
if there was any retun value in an Append query
situation that Access will return something that
can be used to uniquely identify the record that
was appended???
Apr 12 '07 #1
10 12638
In Access 2000 and later, you can do this:

Function ShowIdentity() As Variant
Dim db As DAO.Database
Dim rs As DAO.Recordset

Set db = DBEngine(0)(0)
db.Execute "INSERT INTO MyTable ( MyField ) SELECT 'nuffin' AS Expr1;"

Set rs = db.OpenRecordset("SELECT @@IDENTITY AS LastID;")
ShowIdentity = rs!LastID
rs.Close

Set rs = Nothing
Set db = Nothing
End Function

In any version of Access, you can OpenRecorset, AddNew, and read the value
of the key field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MLH" <CR**@NorthState.netwrote in message
news:eq********************************@4ax.com...
Suppose, in a multi-user environment, you
have append query SQL in a VBA procedure
that looks like INSERT INTO MyTable...
and the next line reads MyVar=DMax("[MyKeyField]","MyTable...

You can never be certain that MyVar will be
set to the key-field value that was created
when the Append query ran. Now, there are
other ways to do it - I know - that will ensure
you 'nab' the correct record. But I was wondering
if there was any retun value in an Append query
situation that Access will return something that
can be used to uniquely identify the record that
was appended???
Apr 12 '07 #2
MLH
On Thu, 12 Apr 2007 20:45:03 +0800, "Allen Browne"
<Al*********@SeeSig.Invalidwrote:
>In any version of Access, you can OpenRecorset, AddNew, and read the value
of the key field.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I'm using A97. The OpenRecordset.AddNew will work 4 me.
Thankx Allen.
Apr 12 '07 #3
On Thu, 12 Apr 2007 20:45:03 +0800, "Allen Browne"
<Al*********@SeeSig.Invalidwrote:

If you're going to open a recordset anyway, I would use it to insert
as well.
Then rather than just reading the value of the key field, I think you
need to do this:
set rs=db.OpenRecordset("SomeTable", dbOpenTable)
rs.AddNew
....
rs.Update
rs.Move 0, rs.LastModified
ShowIdentity = rs!PK_Field

-Tom.

>In Access 2000 and later, you can do this:

Function ShowIdentity() As Variant
Dim db As DAO.Database
Dim rs As DAO.Recordset

Set db = DBEngine(0)(0)
db.Execute "INSERT INTO MyTable ( MyField ) SELECT 'nuffin' AS Expr1;"

Set rs = db.OpenRecordset("SELECT @@IDENTITY AS LastID;")
ShowIdentity = rs!LastID
rs.Close

Set rs = Nothing
Set db = Nothing
End Function

In any version of Access, you can OpenRecorset, AddNew, and read the value
of the key field.
Apr 12 '07 #4
Hi, Tom.
If you're going to open a recordset anyway, I would use it to insert
as well.
For Access 97, there's only one reliable choice in determining the
AutoNumber of a newly inserted record: AddNew, set the value of each of the
Required columns (and perhaps the rest of the columns), and then Update the
Recordset. Read the value of the AutoNumber column at any time after the
AddNew operation, but before moving to another record or closing the
Recordset.

For Access 2000 and later, that method is going to be slower than first
executing the append query via the Execute procedure and then opening the
Recordset to read the value of the AutoNumber column.

In other words, I wouldn't insert records using a Recordset unless that's my
only choice or I need a slower database application.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Tom van Stiphout" <no*************@cox.netwrote in message
news:d8********************************@4ax.com...
On Thu, 12 Apr 2007 20:45:03 +0800, "Allen Browne"
<Al*********@SeeSig.Invalidwrote:

If you're going to open a recordset anyway, I would use it to insert
as well.
Then rather than just reading the value of the key field, I think you
need to do this:
set rs=db.OpenRecordset("SomeTable", dbOpenTable)
rs.AddNew
...
rs.Update
rs.Move 0, rs.LastModified
ShowIdentity = rs!PK_Field

-Tom.

>>In Access 2000 and later, you can do this:

Function ShowIdentity() As Variant
Dim db As DAO.Database
Dim rs As DAO.Recordset

Set db = DBEngine(0)(0)
db.Execute "INSERT INTO MyTable ( MyField ) SELECT 'nuffin' AS Expr1;"

Set rs = db.OpenRecordset("SELECT @@IDENTITY AS LastID;")
ShowIdentity = rs!LastID
rs.Close

Set rs = Nothing
Set db = Nothing
End Function

In any version of Access, you can OpenRecorset, AddNew, and read the value
of the key field.

Apr 12 '07 #5
On Thu, 12 Apr 2007 09:00:09 -0700, "'69 Camaro"
<Fo**************************@Spameater.orgZERO_SP AMwrote:

>For Access 97, there's only one reliable choice in determining the
AutoNumber of a newly inserted record: AddNew, set the value of each of the
Required columns (and perhaps the rest of the columns), and then Update the
Recordset. Read the value of the AutoNumber column at any time after the
AddNew operation, but before moving to another record or closing the
Recordset.
You may want to check the help file on LastModified.
>
For Access 2000 and later, that method is going to be slower than first
executing the append query via the Execute procedure and then opening the
Recordset to read the value of the AutoNumber column.
But then you can't guarantee that another user hasn't just added a
record. That was the OP's issue.

-Tom.
>
In other words, I wouldn't insert records using a Recordset unless that's my
only choice or I need a slower database application.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Tom van Stiphout" <no*************@cox.netwrote in message
news:d8********************************@4ax.com.. .
>On Thu, 12 Apr 2007 20:45:03 +0800, "Allen Browne"
<Al*********@SeeSig.Invalidwrote:

If you're going to open a recordset anyway, I would use it to insert
as well.
Then rather than just reading the value of the key field, I think you
need to do this:
set rs=db.OpenRecordset("SomeTable", dbOpenTable)
rs.AddNew
...
rs.Update
rs.Move 0, rs.LastModified
ShowIdentity = rs!PK_Field

-Tom.

>>>In Access 2000 and later, you can do this:

Function ShowIdentity() As Variant
Dim db As DAO.Database
Dim rs As DAO.Recordset

Set db = DBEngine(0)(0)
db.Execute "INSERT INTO MyTable ( MyField ) SELECT 'nuffin' AS Expr1;"

Set rs = db.OpenRecordset("SELECT @@IDENTITY AS LastID;")
ShowIdentity = rs!LastID
rs.Close

Set rs = Nothing
Set db = Nothing
End Function

In any version of Access, you can OpenRecorset, AddNew, and read the value
of the key field.
Apr 13 '07 #6
Hi, Tom.
You may want to check the help file on LastModified.
I can't find a compelling reason to move to the last modified record when
I'm already on it, having just executed the AddNew procedure. Just read the
value of the AutoNumber column immediately after the AddNew procedure, and
there's no need to take the extra step of moving to this record using the
LastModified bookmark before reading the AutoNumber column.
>>For Access 2000 and later, that method is going to be slower than first
executing the append query via the Execute procedure and then opening the
Recordset to read the value of the AutoNumber column.
But then you can't guarantee that another user hasn't just added a
record.
Allen's method is guaranteed to give the value of the AutoNumber column of
the record you just inserted, even if thousands of new records have been
inserted by other processes between the time you added this new record and
the time you read its AutoNumber value, as long you don't close the
Recordset, nor add more records in the code of that procedure between those
two times (because it retrieves the last one you inserted).

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Tom van Stiphout" <no*************@cox.netwrote in message
news:5c********************************@4ax.com...
On Thu, 12 Apr 2007 09:00:09 -0700, "'69 Camaro"
<Fo**************************@Spameater.orgZERO_SP AMwrote:

>>For Access 97, there's only one reliable choice in determining the
AutoNumber of a newly inserted record: AddNew, set the value of each of
the
Required columns (and perhaps the rest of the columns), and then Update
the
Recordset. Read the value of the AutoNumber column at any time after the
AddNew operation, but before moving to another record or closing the
Recordset.
You may want to check the help file on LastModified.
>>
For Access 2000 and later, that method is going to be slower than first
executing the append query via the Execute procedure and then opening the
Recordset to read the value of the AutoNumber column.
But then you can't guarantee that another user hasn't just added a
record. That was the OP's issue.

-Tom.
>>
In other words, I wouldn't insert records using a Recordset unless that's
my
only choice or I need a slower database application.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Tom van Stiphout" <no*************@cox.netwrote in message
news:d8********************************@4ax.com. ..
>>On Thu, 12 Apr 2007 20:45:03 +0800, "Allen Browne"
<Al*********@SeeSig.Invalidwrote:

If you're going to open a recordset anyway, I would use it to insert
as well.
Then rather than just reading the value of the key field, I think you
need to do this:
set rs=db.OpenRecordset("SomeTable", dbOpenTable)
rs.AddNew
...
rs.Update
rs.Move 0, rs.LastModified
ShowIdentity = rs!PK_Field

-Tom.
In Access 2000 and later, you can do this:

Function ShowIdentity() As Variant
Dim db As DAO.Database
Dim rs As DAO.Recordset

Set db = DBEngine(0)(0)
db.Execute "INSERT INTO MyTable ( MyField ) SELECT 'nuffin' AS
Expr1;"

Set rs = db.OpenRecordset("SELECT @@IDENTITY AS LastID;")
ShowIdentity = rs!LastID
rs.Close

Set rs = Nothing
Set db = Nothing
End Function

In any version of Access, you can OpenRecorset, AddNew, and read the
value
of the key field.

Apr 13 '07 #7
On Thu, 12 Apr 2007 23:57:11 -0700, "'69 Camaro"
<Fo**************************@Spameater.orgZERO_SP AMwrote:

From
http://msdn.microsoft.com/archive/de...etobjects.asp:

The LastModified property of the Recordset object provides a good
illustration of how to use a bookmark. The LastModified property
returns the bookmark of the last record in the Recordset to be added
or modified. To use it, set the DAO Bookmark property equal to the
LastModified property, as follows:

rstCustomers.Bookmark = rstCustomers.LastModified

This moves the current record position to the last record that was
added or modified. This is particularly useful when adding new
records, because after you add a new record, the current record is the
one you were on before you added the record. With the LastModified
property, you can move to the newly added record if thats what your
application expects.

-Tom.

>Hi, Tom.
>You may want to check the help file on LastModified.

I can't find a compelling reason to move to the last modified record when
I'm already on it, having just executed the AddNew procedure. Just read the
value of the AutoNumber column immediately after the AddNew procedure, and
there's no need to take the extra step of moving to this record using the
LastModified bookmark before reading the AutoNumber column.
>>>For Access 2000 and later, that method is going to be slower than first
executing the append query via the Execute procedure and then opening the
Recordset to read the value of the AutoNumber column.
But then you can't guarantee that another user hasn't just added a
record.

Allen's method is guaranteed to give the value of the AutoNumber column of
the record you just inserted, even if thousands of new records have been
inserted by other processes between the time you added this new record and
the time you read its AutoNumber value, as long you don't close the
Recordset, nor add more records in the code of that procedure between those
two times (because it retrieves the last one you inserted).

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Tom van Stiphout" <no*************@cox.netwrote in message
news:5c********************************@4ax.com.. .
>On Thu, 12 Apr 2007 09:00:09 -0700, "'69 Camaro"
<Fo**************************@Spameater.orgZERO_S PAMwrote:

>>>For Access 97, there's only one reliable choice in determining the
AutoNumber of a newly inserted record: AddNew, set the value of each of
the
Required columns (and perhaps the rest of the columns), and then Update
the
Recordset. Read the value of the AutoNumber column at any time after the
AddNew operation, but before moving to another record or closing the
Recordset.
You may want to check the help file on LastModified.
>>>
For Access 2000 and later, that method is going to be slower than first
executing the append query via the Execute procedure and then opening the
Recordset to read the value of the AutoNumber column.
But then you can't guarantee that another user hasn't just added a
record. That was the OP's issue.

-Tom.
>>>
In other words, I wouldn't insert records using a Recordset unless that's
my
only choice or I need a slower database application.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Tom van Stiphout" <no*************@cox.netwrote in message
news:d8********************************@4ax.com ...
On Thu, 12 Apr 2007 20:45:03 +0800, "Allen Browne"
<Al*********@SeeSig.Invalidwrote:

If you're going to open a recordset anyway, I would use it to insert
as well.
Then rather than just reading the value of the key field, I think you
need to do this:
set rs=db.OpenRecordset("SomeTable", dbOpenTable)
rs.AddNew
...
rs.Update
rs.Move 0, rs.LastModified
ShowIdentity = rs!PK_Field

-Tom.
>In Access 2000 and later, you can do this:
>
>Function ShowIdentity() As Variant
Dim db As DAO.Database
Dim rs As DAO.Recordset
>
Set db = DBEngine(0)(0)
db.Execute "INSERT INTO MyTable ( MyField ) SELECT 'nuffin' AS
Expr1;"
>
Set rs = db.OpenRecordset("SELECT @@IDENTITY AS LastID;")
ShowIdentity = rs!LastID
rs.Close
>
Set rs = Nothing
Set db = Nothing
>End Function
>
>In any version of Access, you can OpenRecorset, AddNew, and read the
>value
>of the key field.

Apr 13 '07 #8
Tom, after adding a new record, the current record is theoretically
undefined, so setting the Bookmark to LastModified guarantees that the newly
created is the current one. That always works.

But JET assigns the AutoNumber as soon as you *begin* adding the new record,
i.e. at the point when the AddNew executes. At that point, the recordset
buffer does contain the value of the AutoNumber. Gunny's point is that you
can read the value straight from the recordset buffer before the Update, so
setting the bookmark afterwards is an unnecessary step. Again, this always
works - provided the data is in Access tables.

However, if the recordset is attached from another data source, that may not
work. SQL Server, for example, doesn't assign the identity at the point when
the edit begins.

So, setting the bookmark is slightly more effort to code, but slightly safer
if the table could be another data source. Given that setting the bookmark
is almost instantaneous, there is no real performance difference either way.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Tom van Stiphout" <no*************@cox.netwrote in message
news:fh********************************@4ax.com...
On Thu, 12 Apr 2007 23:57:11 -0700, "'69 Camaro"
<Fo**************************@Spameater.orgZERO_SP AMwrote:

From
http://msdn.microsoft.com/archive/de...etobjects.asp:

The LastModified property of the Recordset object provides a good
illustration of how to use a bookmark. The LastModified property
returns the bookmark of the last record in the Recordset to be added
or modified. To use it, set the DAO Bookmark property equal to the
LastModified property, as follows:

rstCustomers.Bookmark = rstCustomers.LastModified

This moves the current record position to the last record that was
added or modified. This is particularly useful when adding new
records, because after you add a new record, the current record is the
one you were on before you added the record. With the LastModified
property, you can move to the newly added record if thats what your
application expects.

-Tom.

>>Hi, Tom.
>>You may want to check the help file on LastModified.

I can't find a compelling reason to move to the last modified record when
I'm already on it, having just executed the AddNew procedure. Just read
the
value of the AutoNumber column immediately after the AddNew procedure, and
there's no need to take the extra step of moving to this record using the
LastModified bookmark before reading the AutoNumber column.
>>>>For Access 2000 and later, that method is going to be slower than first
executing the append query via the Execute procedure and then opening
the
Recordset to read the value of the AutoNumber column.
But then you can't guarantee that another user hasn't just added a
record.

Allen's method is guaranteed to give the value of the AutoNumber column of
the record you just inserted, even if thousands of new records have been
inserted by other processes between the time you added this new record and
the time you read its AutoNumber value, as long you don't close the
Recordset, nor add more records in the code of that procedure between
those
two times (because it retrieves the last one you inserted).

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Tom van Stiphout" <no*************@cox.netwrote in message
news:5c********************************@4ax.com. ..
>>On Thu, 12 Apr 2007 09:00:09 -0700, "'69 Camaro"
<Fo**************************@Spameater.orgZERO_ SPAMwrote:
For Access 97, there's only one reliable choice in determining the
AutoNumber of a newly inserted record: AddNew, set the value of each of
the
Required columns (and perhaps the rest of the columns), and then Update
the
Recordset. Read the value of the AutoNumber column at any time after
the
AddNew operation, but before moving to another record or closing the
Recordset.
You may want to check the help file on LastModified.
For Access 2000 and later, that method is going to be slower than first
executing the append query via the Execute procedure and then opening
the
Recordset to read the value of the AutoNumber column.
But then you can't guarantee that another user hasn't just added a
record. That was the OP's issue.

-Tom.


In other words, I wouldn't insert records using a Recordset unless
that's
my
only choice or I need a slower database application.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and
tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"Tom van Stiphout" <no*************@cox.netwrote in message
news:d8********************************@4ax.co m...
On Thu, 12 Apr 2007 20:45:03 +0800, "Allen Browne"
<Al*********@SeeSig.Invalidwrote:
>
If you're going to open a recordset anyway, I would use it to insert
as well.
Then rather than just reading the value of the key field, I think you
need to do this:
set rs=db.OpenRecordset("SomeTable", dbOpenTable)
rs.AddNew
...
rs.Update
rs.Move 0, rs.LastModified
ShowIdentity = rs!PK_Field
>
-Tom.
>
>
>>In Access 2000 and later, you can do this:
>>
>>Function ShowIdentity() As Variant
> Dim db As DAO.Database
> Dim rs As DAO.Recordset
>>
> Set db = DBEngine(0)(0)
> db.Execute "INSERT INTO MyTable ( MyField ) SELECT 'nuffin' AS
>Expr1;"
>>
> Set rs = db.OpenRecordset("SELECT @@IDENTITY AS LastID;")
> ShowIdentity = rs!LastID
> rs.Close
>>
> Set rs = Nothing
> Set db = Nothing
>>End Function
>>
>>In any version of Access, you can OpenRecorset, AddNew, and read the
>>value
>>of the key field.
Apr 13 '07 #9
"Allen Browne" <Al*********@SeeSig.Invalidwrote in
news:46***********************@per-qv1-newsreader-01.iinet.net.au:
However, if the recordset is attached from another data source,
that may not work. SQL Server, for example, doesn't assign the
identity at the point when the edit begins.
But if you're using SQL Server, couldn't you use ADO, and does not
ADO provide a property that returns the PK of the last added record?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Apr 13 '07 #10
MLH
Yup, that sounds like the ticket to me
Thx, Tom.

Kind regards, mlh
Apr 13 '07 #11

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

Similar topics

7
by: Alex Vorobiev | last post by:
hi there, i am using sql server 7. below is the stored procedure that is giving me grief. its purpose it two-fold, depending on how it is called: either to return a pageset (based on page...
2
by: aaj | last post by:
Hi all I have a small but rather annoying problem with continuos forms, and am wondering if anyone can suggest a method of getting over it. The front end is Access 2002 with the BE being SQL...
0
by: Privacy Trap | last post by:
Hi I have a slight problem in trying to set up 2 forms linked to tables. What I want to do is to inform a control on one form(Apps) as to the value of a key of a 'new' record entered via a...
3
by: naveen.panambur | last post by:
We have an "Insert into XYZ_Table(seq_nbr, abc,def) select 3, abc,def from XYZ_TABLE where abc > ### " query in our application. This query is an COBOL Stored Procedure residing on DB2 Mainframes....
0
by: kiki | last post by:
I have two datasets with the same schema,each of which has some datarows.After i merge them into one datset i found that there were some duplicate rows in these rows.then how can i remove the...
4
by: AZKing | last post by:
Hi all, I am trying to figure out how I can go about adding a text into a column of the query that I am writing. For example, I created a column in this query called "Open for discussion" and I...
2
by: pattie | last post by:
I hava been trying to add data into a table using INSERT into unsuccessfully.Doing it manually works,and all other constructs works like SELECT,UPDATE.So what might be a cause. My syntax ...
0
by: Rote Rote | last post by:
Hi Guys, I have a simple Edit,Update Gridview and i'm using ObjectDatasource with dataset generated and TableAdapters I can do an update no problem. But can't get my delete to work. When i look at...
3
kcdoell
by: kcdoell | last post by:
Hello: I have a Insert Into command that currently works: DoCmd.RunSQL "INSERT INTO TypeEorD ( EorDName, EorD ) SELECT Trim( & '_' & Trim(Category)), Trim(CatType);" "Category" is a manual...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
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,...
0
jinu1996
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...
0
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...
0
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,...
0
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...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

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.