delphi - Using ConnectionString instead of TAdoConnection on a TAdoQuery -

delphi - Using ConnectionString instead of TAdoConnection on a TAdoQuery -

I have received my own component in Delphi from TAdoQuery. I override the DoAfterPost process Have given; And in this code I have a primary key associated with a recorded record (i.e. SELECT @@ IDENTITY for SqlServer, SELECT LAST_INSERT_ID () for the purpose of bringing it to MySQL And create queries, etc.).

In the past, I have always used TAdoConnection for database connectivity and there was no problem in the "subquery" call made within DoAfterPost because it was the only session < / Strong> (these questions continually consider the database connection to recover the last entered primary key).

I have recently made a choice where instead of using a TAdoConnection connection, I instead use ConnectionString property (multi-threading purposes ) I am establishing But this creates a problem because the sponsored subkey does not use sessions similar to the main session. So it does not return the primary key value.

My question is, is there any connection property in Tidoclue if connection string is used? Then I could do this connection / session in my subcube: Desicain . Or is it the only way to complete through a TAdoConnection?

@M Scakeel, when you set the property component, TAdoQuery database with a new session ID

Returns the last inserted identity value in the SQL Server function Current Sessions , because you use the same connection (and session) for the contained statement and query Need to do SELECT @@ IDENTITY .

As a workaround in SQL Server, you can use the function that is not restricted to a session.

The function in MySQL also works on the connection. Therefore the behavior is similar to @@ IDENTITY .

In short, you have the best option to use a unique TAdoConnection object.

Comments

Post a Comment

Popular Posts

Short URL Outbound Link Tracking in PHP and MySQL -

I have a site that reduces the link based on this topic. I decided that it would be great if users click on a small URL, like HootSuite users can track their links. I currently have a database in which the short URL is placed with the actual URL and this click count will ideally update the click count column when that small URL is accessed by an external user. In short, I am looking for a PHP / MySQL solution so that many small URLs can be clicked. . Any additional information gathered from the clicks will also be highly appreciated. I'm assuming you followed the PHP version of your tutorial. If so, look at listing for service.php under "service of small URL". In section round line 11 where it determines the position of 301, you can redirect with the database update. Something like $ query = mysql_query ("update`" $ database. "` .```_AL_DIRED`Set count = count + 1 where` small '=' ".mysql_escape_string ($ short) , $ Db); $ Line = ...

c# program list -

Some body can provide me a program list which will open up my mind and help me to get a good code. I searched it on the net but did not find any good links. Anything from a web link or anything will be highly appreciated.

php - How do I set up pagination for an image gallery with image thumbnails? -

I have two tables: gallery id | Name | Details Image ID | Title | Caption | Gallery ID By listing all thumbnails or paging through thumbnails I got the code to create a simple image gallery. However, what I need to do is here something like gallery here Only completes without javascript and ajax: I want a selection number to show below the main image as soon as the user clicks the thumbnail, the page Selected new Highlight the image and the series of thumbnails on boto goes forward one by one if its not the last image. How do I do this? Do I need a quick and dirty way to do this? I am using php and mysql for the database here - just need code to show 'paged' images below the main image. I know how to install everything i.e. Thumbnail size etc ... I do not know the number of your rows in MySQL for T-SQL As there is a ROWNUMBER () function, but to do this, it is a smart way to sequential numbering of your images in the database. From there, you ask something ...

Powered by Blogger