View Issue Details

IDProjectCategoryView StatusLast Update
0007554ADK-VNETFeature Requestpublic2016-03-15 07:42
ReporterThomas Görtler Assigned ToIvan Smahin  
PrioritynormalSeverityfeatureReproducibilityN/A
Status resolvedResolutionfixed 
PlatformALLOSALLOS VersionALL
Product Version6.2.x 
Fixed in Version6.3.x 
Summary0007554: Add "last_inserted_recid_of_table" to database object for ADK.NET
DescriptionPlease add a way to get the "last_inserted_recid_of_table" to the database object for ADK.NET. Currently we've only an awkward way to determine the last inserted record id when using .SQLQuery(). Please also have a look at this discussion on the forum:
http://valentina-db.com/de/discussions/asynchronous-database-inserting-and-linking
TagsNo tags attached.

Activities

Ivan Smahin

Ivan Smahin

2016-03-15 07:41

manager   ~0008883

Actually I talked of VQueryResult field which exists in vKernel but missed in V4NET object.
Now you can get last inserted recID this way:
VQueryResult res = db.SqlQuery( "INSERT INTO t1 VAlUES(1)" );
res.LastRecID;

Issue History

Date Modified Username Field Change
2016-03-14 11:58 Thomas Görtler New Issue
2016-03-14 13:22 Ivan Smahin Assigned To => Ivan Smahin
2016-03-14 13:22 Ivan Smahin Status new => assigned
2016-03-15 07:41 Ivan Smahin Note Added: 0008883
2016-03-15 07:42 Ivan Smahin Status assigned => resolved
2016-03-15 07:42 Ivan Smahin Fixed in Version => 6.3.x
2016-03-15 07:42 Ivan Smahin Resolution open => fixed