Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

On 2016-03-11 17:18, Stephen Russell wrote:

Field widths shouldn't make any difference, you do you varchar(50) or nvarchar(50) or (100) already don't you for the data outside of State?

In all of my code the UI data is defined by the received data from the backend.

I'm not talking about the front end UI. I'm talking about when you guys make a field 25 characters large (for example) than it is currently. Your stored procedure parameters have to be updated to reflect the length beyond the existing setting. That's where Oracle's parameters are better than SQL Server: you can reference a field name (synonym) rather than hardcoding any width.