Table of Contents

Property AllowUserVariables

Namespace
YndigoBlue.Velocity.Data.MySql
Assembly
YndigoBlue.Velocity.dll

AllowUserVariables

Gets or sets whether to allow user-defined variables in SQL statements.

public bool AllowUserVariables { get; set; }

Property Value

bool

Remarks

User-defined variables (prefixed with @) are used internally by Velocity during complex import operations to track state, handle batching, and coordinate multi-step loading logic. This is a MySQL-specific feature needed for reliable bulk imports.

warning

This setting MUST be set to true for import operations to work. If disabled, all Import() calls will fail because Velocity cannot execute the necessary internal SQL statements. The default value of true is correct for virtually all scenarios. Only disable if explicitly required by your MySQL security policy, but understand that disabling it makes data imports impossible in Velocity.