Sfrgttk

Why are energy weapons seen as more acceptable in children's shows than guns that fire bullets?

Is the "hot network questions" element on Stack Overflow a dark pattern?

Why Third 'Reich'? Why is 'reich' not translated when 'third' is? What is the English synonym of reich?

Discouraging missile alpha strikes

The totem pole can be grouped into

Ethernet cable only works in certain positions

What have we got?

How to write pow math?

Manager has noticed coworker's excessive breaks. Should I warn him?

Can a rabbi conduct a marriage if the bride is already pregnant from the groom?

Can you make a Spell Glyph of a spell that has the potential to target more than one creature?

Does human life have innate value over that of other animals?

Prove that a cyclic group with only one generator can have at most 2 elements

Simple Question About Conservation of Angular Momentum

Sing Baby Shark

How to announce in an ATIS message that two parallel runways are in use?

How to know if I am a 'Real Developer'

Suggestions on how to improve logo

Is it possible to detect 100% of SQLi with a simple regex?

What happens if you declare more than $10,000 at the US border?

Taking an academic pseudonym?

Is candidate anonymity at all practical?

If an area is covered in both Ball Bearings and Caltrops, does the creature need to move at half speed or quarter speed to avoid both their effects?

Badly designed reimbursement form. What does that say about the company?

VB.NET Custom ID column

create trigger which inserts rows depending on enum values?Large scale, hard to model design advice neededMySQL large databases, unique index effect on efficiency?How to install TokuDB on MAMPQuestion on MySQL insert race conditionDuplicate entry error for unique key that doesn't existSQLite table design for PK and/or UNIQUEIs it ok to have 'view count' column in the same table?Search for rows with coordinates within a PolylineMap auto increment ids on multi-row insert

-1

The code I have below works fine, although I'm worried about ID collisions, and I really don't like generating the ID in .NET - I'd much rather have the database do it, but I'm struggling.

When I insert a new row, I check the TableCounts table for the row count on the table I'm updating, add one to it, and then insert the new row with the ID that is created. It's been bothering me for a while that there's a much better way to do this and I'm missing it.

I know collisions are unlikely but any help on improving this method would be appreciated.

My ID is made of the first 4 characters are the shop id and the rest are the job id.

Query.CommandText = "SELECT `Count` FROM `TableCounts`

                         WHERE `TableName`='Refunds'

                           AND `LocationID`='" & MiscClass.LocationID & "'

                         LIMIT 1;"

tmpid = MiscClass.LocationID & "1" & (Query.ExecuteScalar() + 1).ToString

Query.CommandText = "UPDATE `TableCounts`

                        SET `Count`=`Count`+1

                        WHERE `TableName`='Refunds'

                          AND `LocationID`='" & MiscClass.LocationID & "';"

Query.ExecuteNonQuery()

The & above is like . in php - it concatenates.

The db is syncing with another remote db and changes can happen on the other db before the sync, so I'm trying to avoid overwriting rows.

mysql sqlite

share|improve this question

edited 5 mins ago

Paul White♦

52.1k14278450

asked Jun 5 '17 at 18:52

Scott MScott M

1

add a comment | 

-1

The code I have below works fine, although I'm worried about ID collisions, and I really don't like generating the ID in .NET - I'd much rather have the database do it, but I'm struggling.

When I insert a new row, I check the TableCounts table for the row count on the table I'm updating, add one to it, and then insert the new row with the ID that is created. It's been bothering me for a while that there's a much better way to do this and I'm missing it.

I know collisions are unlikely but any help on improving this method would be appreciated.

My ID is made of the first 4 characters are the shop id and the rest are the job id.

Query.CommandText = "SELECT `Count` FROM `TableCounts`

                         WHERE `TableName`='Refunds'

                           AND `LocationID`='" & MiscClass.LocationID & "'

                         LIMIT 1;"

tmpid = MiscClass.LocationID & "1" & (Query.ExecuteScalar() + 1).ToString

Query.CommandText = "UPDATE `TableCounts`

                        SET `Count`=`Count`+1

                        WHERE `TableName`='Refunds'

                          AND `LocationID`='" & MiscClass.LocationID & "';"

Query.ExecuteNonQuery()

The & above is like . in php - it concatenates.

The db is syncing with another remote db and changes can happen on the other db before the sync, so I'm trying to avoid overwriting rows.

mysql sqlite

share|improve this question

edited 5 mins ago

Paul White♦

52.1k14278450

asked Jun 5 '17 at 18:52

Scott MScott M

1

add a comment | 

The code I have below works fine, although I'm worried about ID collisions, and I really don't like generating the ID in .NET - I'd much rather have the database do it, but I'm struggling.

When I insert a new row, I check the TableCounts table for the row count on the table I'm updating, add one to it, and then insert the new row with the ID that is created. It's been bothering me for a while that there's a much better way to do this and I'm missing it.

I know collisions are unlikely but any help on improving this method would be appreciated.

My ID is made of the first 4 characters are the shop id and the rest are the job id.

Query.CommandText = "SELECT `Count` FROM `TableCounts`

                         WHERE `TableName`='Refunds'

                           AND `LocationID`='" & MiscClass.LocationID & "'

                         LIMIT 1;"

tmpid = MiscClass.LocationID & "1" & (Query.ExecuteScalar() + 1).ToString

Query.CommandText = "UPDATE `TableCounts`

                        SET `Count`=`Count`+1

                        WHERE `TableName`='Refunds'

                          AND `LocationID`='" & MiscClass.LocationID & "';"

Query.ExecuteNonQuery()

The & above is like . in php - it concatenates.

The db is syncing with another remote db and changes can happen on the other db before the sync, so I'm trying to avoid overwriting rows.

mysql sqlite

share|improve this question

edited 5 mins ago

Paul White♦

52.1k14278450

asked Jun 5 '17 at 18:52

Scott MScott M

1

Query.CommandText = "SELECT `Count` FROM `TableCounts`

                         WHERE `TableName`='Refunds'

                           AND `LocationID`='" & MiscClass.LocationID & "'

                         LIMIT 1;"

tmpid = MiscClass.LocationID & "1" & (Query.ExecuteScalar() + 1).ToString

Query.CommandText = "UPDATE `TableCounts`

                        SET `Count`=`Count`+1

                        WHERE `TableName`='Refunds'

                          AND `LocationID`='" & MiscClass.LocationID & "';"

Query.ExecuteNonQuery()

share|improve this question

edited 5 mins ago

Paul White♦

52.1k14278450

asked Jun 5 '17 at 18:52

Scott MScott M

1

share|improve this question

edited 5 mins ago

Paul White♦

52.1k14278450

asked Jun 5 '17 at 18:52

Scott MScott M

1

edited 5 mins ago

Paul White♦

52.1k14278450

edited 5 mins ago

Paul White♦

52.1k14278450

asked Jun 5 '17 at 18:52

Scott MScott M

1

asked Jun 5 '17 at 18:52

Scott MScott M

1